How to view cash recepts detail appl on posted tx

[pro356]

Is it possible to view the detail on a posted cash receipt? I need to be able to see which invoices I applied the cash to on a tx already posted. I can look at unposted OK but need to look at the history to make sure I didn't duplicate, etc.

 

[stef315]

When you pull up the cash receipt (one place is Inquiry-Sales-Trx by Customer), you can zoom on the Document (click the blue underlined "Document Number" after clicking on the line with the receipt. From there you can click the Apply button and see which invoices the receipt was applied to.

This is the same window you'd get to if you zoomed on "Amount Remaining" instead of document number.

Stefanie

 

[Luvsql]

If you want to view the apply information externally (via excel, crystal, access etc.), the tables are the following:

RM20201 (APTODCNM is invoice number and APFRDCNM is the payment number). Once a routine called Paid Transaction Removal has been performed, all completely applied data moves into a history table (RM30201 with the same fields).