Printing the same Current Amount value on the RM Statement Reprint as on the original RM Statement


Marian Verzosa - Click for blog homepageHi everyone.

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

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.

The Cause

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.

 

The Resolution

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.

 

Regards,

Marian

Comments (3)

  1. David Musgrave says:

    Posting from Mark Polino at DynamicAccounting.net

    msdynamicsgp.blogspot.com/…/printing-same-current-amount-value-on.html

  2. Mary Lynn says:

    I have a similar situation that needs help. The originating invoices were issued in Canadian$ the Statements are printing in US$. I tried activating the Multicurrency option. It too prints in US$

    Any suggestions?

  3. David Musgrave says:

    Hi Mary

    Can I suggest asking on the Community Forum (links on the right hand pane)? Or if it is urgent logging a support incident.

    If this is a modified report, have you tested the original report.

    David

Skip to main content