Right now our A/R statements show the invoice Original Amount and the Outstanding Amount. What I need is for the Original Amount to reflect the invoice amount after any debit notes or credit notes have been applied to that invoice (i.e., the invoice amount adjusted for applied debit/credit notes), rather than only the original invoice value. We are currently using Specification field D015 in the Designer, but it only shows the original invoice amount and does not include applied debit or credit notes. I can’t figure out which Specification field—or combination of fields—will produce the adjusted invoice balance that nets the original invoice with any applied debit/credit notes. Please advise.

Thanks
Jean

Hello Jean B,

Original Amount is never altered by applied transactions. You need to use the specification for Current Amount: D05.

There are several sample specifications in the sample data including 2 "!ALL" specifications for the 2 types of Statements: with and without Matching details.

D05 behaves differently depending on how the specification has been set up. I suggest that you look at the sample data specifications for: Detail Line - Without Matching Details. For example: Age by Due Date, Dets No Match