RM Summary HATB Modification

[klewis10367]

I am trying to modify the Summary Historical Aged Trial balance Report to just show 6 columns. 1 being the Customer Number and the 5 remaining the Aging Buckets. Basically what i want to try and do is make the report a data dump to a text file so i can import it into sql. I have tried removing all sections except for the Customer footer with no luck. The format is good but the data is duplicating.

 

[slantsix]

It sounds like you are doing it right,

1. Put the customer number from the RM Cust MSTR in the Customer Footer
2. Get rid of all report sections except the Customer Footer and the Report Header
3. Put the Legends in the Report Header.
4. Get rid of all other fields and lines except
Customer Number
Current TRX Amount1
Current TRX Amount2
Current TRX Amount3
Current TRX Amount4

This should be good. What is being duplicated?

Kind regards,

Leslie

 

[slantsix]

I also wanted to mention that there are 7 aging buckets in AR, make sure you only are using 4 of them or you might not capture all of your outstanding receivables.