Dynamics Community Forum Thread Details

Showing correct Customer Revenue in report from RM Tables

Hi,

I am working on a report for GP dynamics and I need to show revenue per customer, there are other modules involved Like Project Accounting. But we don't need to go into detail just for this purpose.
- My only question is:   If I am using tables (RM20201 and RM30201) to find out the documents that have been applied to invoices from table RM20101. And since there are different type of documents can be applied and not all of them can be treated as Revenue:
   So, for example if you look at the list below: To my understanding IF DOC TYPE: '9' has been applied to invoice ONLY then it can treat is Revenue. IS THIS CORRECT STATEMENT-?
Unless you have other reasons why other applied doc types can be treated as revenue, please explain.

RMDTYPAL – RM Document Types:
0 – Reserved for balance carried forward records
1 – Sale / Invoice
2 – Reserved for scheduled payments
3 – Debit Memo
4 – Finance Charge
5 – Service Repair
6 – Warranty
7 – Credit Memo
8 – Return
9 – Payment

Thank you
Harry

Quick Links

Leaderboard