Hi All,
A bit of an esoteric question but I am hoping someone can assist.
I'm using MS Word to create a modified Customer Reconciliation Statement that can be opened via Accounts receivable > Inquiries and reports > Customers > Customer Account Statement. I took the Reconciliation model, made the changes and got 90% of the way there. However I am stuck when a Customer has more than 1 open transaction as the statement only displays the earliest one (see screenshot below):
The report mapping is as follows:
I know I can do this in MS Excel but the business wants the statement in a Word format due to formatting issues.
Any help is appreciated.
cheers,