Outstanding Balances of Vendors

(0) Share

Report

Posted on by Community Member

Hello Members ,

I wanted to clarify on how to check for outstanding balances of Vendors .

I have already found a column name "Outstanding Amount" from Purchase Line table. Does it alone indicate the total "outstanding amount " from a vendor ?

It will be great if i can get to know all the tables in Navision ,that can be involved to calculate outstanding balances for a particular vendor ?

Regards,

Deepthi

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Community Member on at

Like (0)

Report

RE: Outstanding Balances of Vendors

Hello Everyone

Thanks for the help . I was able to calculate the outstanding amounts per vendor by summing up the amounts in Detailed Vendor Ledger entry .

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Outstanding Balances of Vendors

Thanks for your reply

I don't have access to reports . But do you have any idea on how it is calculated in the report ?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report

RE: Outstanding Balances of Vendors

On Vendor card there is field called Balance where it will show outstanding amount

The field you are talking about may be customized field for WHT purpose.

You can check following link

msdn.microsoft.com/.../hh897279(v=nav.90).aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Outstanding Balances of Vendors

Thanks for your reply.

I am very new to navision . i wanted to further clarify if that vendor card you referred in your reply is the vendor number from vendor ledger entry ?

Is the field "Rem_ Amt for WHT" is the one to refer for remaining balance amount from Vendor ?

Though i din't much get the point on how the prepayment can balance the posted invoice , i wanted to ask which field in the vendor ledger entry that we have to use to filter invoices .

I have "No Series" which has got a particular series for "purchase invoices". Is this the correct one to filter invoices ?

If i have to obtain the total outstanding amount, is it just summing up the values present in the field "Rem_ Amt for WHT"??

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (1)

Report

RE: Outstanding Balances of Vendors

You can look at the standard report Aged account Receivable report.

As well as you can check on vendor card 'Balance' Field

Was this reply helpful? Yes No
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: Outstanding Balances of Vendors

First of all you need to refer to Vendor Ledger Entries:

msdn.microsoft.com/.../hh179260(v=nav.90).aspx

In the Vendor card there is a "Balance" field that shows the total balance.

However there might be the case when there is a posted invoice for one work and the prepayment you had made for the other work; in this case, the total balance might be zero but the real debt from the vendor still exist.

You can drill down to the Balance field in the Vendor card, and filter out the vendor ledger entries by "invoice" type, or "Payment" type, and refer to the "Remaining Amount" field. This field contains the remaining outstanding amount. Export that list to Excel and check needed totals.

Alternatively, you can also refer to standard reports, e.g. Vendor - Balance Report:

msdn.microsoft.com/.../dn267804(v=nav.90).aspx

Was this reply helpful? Yes No