Supplier payment terms report
Hi, how can I run a report including exporting to excel on supplier payment terms. Want to check which supplier have terms and which do not etc. Have tried multiple options but cannot get the informa...
Forum Discussion
Hi Clancy, I tried to run the report however could not see payment terms as an option?
Thanks
Darren
Hello NinnessD
If you are having trouble running a report which contains the information you need .
You could export the information from your Supplier Cards; I suggest you export the values for the following fields:-
- Co./Last Name
- First Name
- Terms - Payment is Due (consists of a single digit code between 0 and 5):-
- 0 = C.O.D.
- 1 = Prepaid
- 2 = In a Given # of Days
- 3 = On a Day of the Month
- 4 = # of Days after EOM
- 5 = Day of Month after EOM
- - % Discount
- - Discount Days
- - Balance Due Days
- Volume Discount %
This information exported should give you a rundown of the credit terms for your suppliers which is easy to view together.
Thanks Chris, however I cannot see an option to export except pdf or xps. I must be doing something wrong.
