Diagnosing Out-Of-Balance with GTEST Command using the Calculator function
Within Sage ERP X3, if you are trying to diagnose an out of balance situation while posting a transaction in financials (AR, AP, Inventory Accounting Interface or WIP accounting interface), you can view the debits and credits to see where the out of balance is occurring.
For example, below is an invoice that has not been posted. To view the debits/credits when you post, use the Diagnostic help/Calculator tool and enter the command below.
At the Calculator prompt, type sigma(GTEST=0,1,0) and press enter . To turn off GTEST, type sigma(GTEST=0,-1,0). You can also exit X3 to turn off the parameter. Setting this parameter is specific to the user logged in and will not affect other users.
After activating this parameter, you will see several pop-up messages that reference source code. Continue to say OK and you’ll eventually see the debits/credits appear. Below is an example:
Note: Be careful using this on the Accounting or WIP Interface. It is wise to ensure the only thing you are dealing with is the out of balance situation. Run the Accounting or WIP Interface prior to setting the GTEST parameter, otherwise, you will see debits/credits for each transaction that has yet to post.
Contact Our Sage ERP X3 Team
Want to learn more about Sage ERP X3? For additional information please contact us at 877-979-5462, or click here to contact us.
Source: Sage ERP X3 Support Desk