Payment terms report

This thread is now closed to new comments.
Some of the links provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
Highlighted
Contributing Cover User JulieHen62
8 Posts
Contributing Cover User
Australia
JulieHen62
Contributing Cover User

8Posts

0Kudos

0Solutions

Solved: Go to Solution

Payment terms report

I need to do a check of all suppliers and how their payment terms are set up. Is there a report or list for this? I know I can run the supplier detail report but I have a lot of suppliers and I only want to look at the name and payment terms.

6 REPLIES 6
Ultimate Cover User TonyLane
1,255 Posts
Ultimate Cover User
Australia
TonyLane
Ultimate Cover User

2847Posts

1408Kudos

480Solutions

Accepted Solution Solved

Re: Payment terms report

Hi @JulieHen62

 

Such a report does not exist.

 

You could however export the information from your Supplier Cards; I suggest you export the values for the following fields:-

  1. Co./Last Name
  2. First Name
  3. Terms - Payment is Due (consists of a sigle 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
  4. - % Discount
  5. - Discount Days
  6. - Balance Due Days
  7. Volume Discount %
Best Regards

Tony Lane - Penguin - Tasmania

Experienced Cover User jhp
30 Posts
Experienced Cover User
Australia
jhp
Experienced Cover User

54Posts

17Kudos

0Solutions

Re: Payment terms report

Hi TonyLane,

 

I too need to print off a report showing supplier payment terms. I have hundreds of suppliers with different trading terms and it would be extremely time consuming to go through each supplier...has this report been adjusted since this post or is it unlikely to be ?

Ultimate Cover User TonyLane
1,255 Posts
Ultimate Cover User
Australia
TonyLane
Ultimate Cover User

2847Posts

1408Kudos

480Solutions

Re: Payment terms report

Hi @jhp

 

It is not a report as such; the information to which I referred is exported from the Supplier Cards in a company file thru the Import/Export Assistant which is an option on the File drop down list (or shortcut keys Alt+F+I).  When exported you can then open its output in Excel; attached is an example file exported from the sample Clearwater file.

 

In my earlier post I suggest what fields to export; they remain constant, however in the attached file I've included Credit Limit.  You may want to chose others; checkout the info available on this link Supplier Cards - Available Fields.

Best Regards

Tony Lane - Penguin - Tasmania

Experienced Cover User jhp
30 Posts
Experienced Cover User
Australia
jhp
Experienced Cover User

54Posts

17Kudos

0Solutions

Re: Payment terms report

Apologies the exported fields is what I meant......ok so no way around it, thanks

Experienced Cover User jhp
30 Posts
Experienced Cover User
Australia
jhp
Experienced Cover User

54Posts

17Kudos

0Solutions

Re: Payment terms report

 

FYI - I wanted to find out which suppliers had 14 day terms and which had 7 days. As your options only provide a code (#2) and not the number of trading terms entered then I presume there is no way to extract this information.

Ultimate Cover User TonyLane
1,255 Posts
Ultimate Cover User
Australia
TonyLane
Ultimate Cover User

2847Posts

1408Kudos

480Solutions

Re: Payment terms report

@jhp

 

It's quite simple; for example:-

if Terms - Payment is Due value = 2 and Balance Due Days value = 14

Then that Supplier has 14 day terms

if Terms - Payment is Due value = 2 and Balance Due Days value = 7

Then that Supplier has 7 day terms

 

Are you OK with that concept?

Best Regards

Tony Lane - Penguin - Tasmania

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post