This is a reposting of an article Marian Verzosa originally wrote on my Developing for Dynamics GP blog.
I wanted to share with you a recent support incident that I worked on. The cause of the issue was one of those weird issues that took a while to track down.
The problem is that the Current Trx Amount (CURTRXAM) field in the RM30702 reprint table is not populated when printing the normal RM Statements. For some reason, only the Multi Currency (MC) statement is populating that field. Which means that you must use the MC statements if you want to reprint with the Current Trx Amount.
If you asked to keep the reprint info, the reprint tables, RM30701 and RM30702, are updated from the statement report’s temporary tables when the original statement is printed. As the standard (non-multi currency) report does not populate the Current Trx Amount field, it remains as zero in the reprint tables.
The reprint process then uses the RM30701 and RM30702 tables to re-populate the temporary tables to generate the same report as before.
To print the same details in the RM Statement report as the original statement during the reprint statement process, we need to use the multi currency versions of the statement reports.
The CURTRXAM field is populated in the original MC Statement report’s temporary tables and so is copied to the reprint tables. So, the value in the RM30702 table tracks the current transaction amount as at the time the original statement is printed for the customer.
When reprinting, the now populated value is copied from the reprint table to the temporary tables used to generate the report and so is available to be added to the report.
To print the amount remaining, we can modify the MC Statement report and drag the Current Transaction Amount field from the RM Statements Transaction Temp table.
Once done, all statements need to be printed using this form to populate the CURTRXAM field with the same amount remaining value as the original statement printed.
This article was originally posted on the Developing for Dynamics GP Blog and has been reposted on http://www.winthropdc.com/blog.