Dear NAV community,
Our customer wants a report and it has been very confusing for us on how to design the report. Below is the format that they want.
- They want all purchase orders to be represented in the report (i.e. Open, Pending Approval, Released), as well as the purchase orders that have already been invoiced (and deleted from purchase header table)
- If the purchase order has not been invoiced or paid, then the last five columns will be blank.
- If there is more than one payment for an invoice, then they want each payment on a separate row of tabular report.
Does anybody have any ideas about the technical design for this report? I would greatly appreciate any help.
| PO Date |
PO No. |
Vendor No. |
Vendor Name |
Currency Code |
Invoice Date |
Invoice Amount |
Vendor Invoice No. |
Payment Date |
Payment Amount |
| 9/27/2015 |
POR1000012 |
VND10000 |
Summit Sample |
MMK |
10/18/2015 |
3,000,000 |
PIN199992 |
10/31/2015 |
3,000,000 |
| 9/27/2015 |
POR1000012 |
VND10000 |
Summit Sample |
MMK |
10/27/2015 |
6,500,000 |
PIN199997 |
11/27/2015 |
6,500,000 |
| 9/30/2015 |
POR1000013 |
VND20000 |
Design Pattern Ltd. |
MMK |
|
|
|
|
|
*This post is locked for comments
I have the same question (0)
