Hello Acumatica Community, Looking for some help building a generic inquiry that will track all customer discrepancies. Basically, I want to group a report together by customer that will list out all the customers who have a value in the discrepancy field on the Customer Details screen. As you notice, Acumatica only displays this by clicking into each customer, looking for a list of all customers with discrepancies. Here is my issue… The Balance Discrepancy is being displayed by a “Filter” table which as far as I know cannot be used on a GI. My second thought was to use the detail of the report to calculate the discrepancy. The Balance Discrepancy is calculated by the following formula; Balance by Document - Current Balance. The problem with this is that since I can’t use the “Filter” table to pull directly into my GI I need to calculate the Balance by Document and Current Balance before I can create the discrepancy formula. The problem is that the Current Balance calculation inclu
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
