How to run a list of vendors and payment terms in a report

(0) Share

Report

Posted on by Community Member

How can i run a report in AP module that will give me a list of vendors and their payment terms ? Then my next question is if i wanted to change the payment term on a specific vendor posting group , how can i do that ? (instead of going through every single vendors in that group? Thanks.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

1) You need to create a custom report with dataitem = Vendor that for every Vendor shows its "Payment Terms Code" field. This code is related to Payment Terms table. It's really simple (just like a Vendor list).

2) You need to create a custom codeunit that performs the massive update, no need via user interface.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

Hi Nasankar,

I think you got the information from Vendor List page, show more columns as below picture.

To mass update information, you can use our Universal Excel Import Export tool:

- Export information from NAV to Excel.

- Edit information in Excel (filter on Vendor Posting Group).

- Import information from Excel back to NAV.

Was this reply helpful? Yes No
Sher30k 5 on at

Like (0)

Report

How come there isn't an option in Choose Columns on the vendor list page for a Payment Terms column? I need to run a report so I can search by vendors that pay by check and I can't find anything.

Was this reply helpful? Yes No