Many of our customers will have large numbers of credit memos for various reasons. When they pay their invoices they include these credit memos and reduce the actual payment amount by the total of the credit memos.
For example the remittance advice will look like this :
| credit memo 123 |
(100.00) |
| credit memo 345 |
(150.00) |
| credit memo 678 |
(75.00) |
| invoice 901 |
300.00 |
| invoice 902 |
475.00 |
| Net Payment |
450.00 |
This is a relatively small example as there may be as many as 40 - 50 credit memos and an additional 30 - 40 invoices on each check. The invoice amount shown is the full amount without any credits applied.
We want to be able to trace the credit memo back to the customers check that the customer took the credit memo on, preferably in GP and not on a spreadsheet. This also applies to the invoice, even if tracing the invoice back to the check involves first locating the credit memo that was applied to it.
We also want to be certain that as the user is applying cash they are easily able to reconcile what they are posting to the actual check amount.
We are relatively new to GP and are not sure of the best approach. Any advice on the best way to handle this situation would be greatly appreciated.
Thanks!
*This post is locked for comments
I have the same question (0)
