You’re offline. This is a read only version of the page.
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.
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 |
| VND00001 |
| VND00001 |
*This post is locked for comments
Kindly verify answers.
Thank you.
Hi,
This report is available in following databases.
1) Switzerland
2) German
3) Austria)
I understand that. It seems that the Vendor Payment List report is not in any of the databases in which I have looked. I am wondering which local database has this report.
Dear Jonathan,
Could you let me know which database has this report. I checked the North America and Australia databases and report 11507 is not present in either.
Regards,
Ted
you need 2 base dataitems: purchase header (for the orders) and Purch. Inv. Header (for the posted invoices).
for the payments use table Vendor Ledger Entry. for details check out report 11507 (part of german and austrian localised cronus databases).
#1
Sohail Ahmed
2
#1
mmv
2
#1
Amol Salvi
2
Share
Report
All responses (
Answers (
