Problem in Vendor Balance (LCY)

(0) Share

Report

Posted on by Community Member

Hello everyone,

We have few vendors with balance giving wrong amount.

When I get the details of their transactions from the vendor ledger entry, Amount(LCY) is equal to 0, but when I check the vendor card Balance (LCY) it shows a amount which is not zero.

Since Balance (LCY) is taken from the Detailed Vendor Ledg. Entry table, I opened it and checked all the related entries and I found several entries that create this problem.

These entries does not captured in the Balance (LCY) in the vendor card.

Entry type is : Correction of Remaining Amount

1. What I want to know is why these entry amounts are not captured when showing the Balance (LCY) in the vendor card?

2. Why these entries are been posted? (I know it happen due to different currencies, but would be glad if I get more details)

3. What should I do to correct the Balance (LCY) in the vendor card?

Thank You in advance.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (2)

Community Member on at

Like (0)

Report

Hi

Just checked the vendor table (23) where Balance LCY is a flowfield and there is no filter on the flowfield for Entry Type on the detailed vendor ledger entry table (380). At least not on the GB version.

So have you checked the properties for the Balance LCY flowfield on table 23 to see what filters are being applied?

Neil

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

Which localization you are using?

Best Regards,

MMV

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am using W1

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

In the W1, there is no filter on the "Entry Type" in the "Balance (LCY)" field on the "Vendor Card". Please check whether this is a customization.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In the vendor ledger entry table Amount (LCY) has a filter of Entry Type. In that "Correction of Remaining Amount" is missing and that cause the problem. Does anyone know why Microsoft has omit that entry type from the filter???

Even in 2013 is the same. Only in 2015 they have removed entry type filter.

Need support from experts.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

Hi,

In the standard NAV 2009 W1, there is no filter of "Correction of Remaining Amount" in the "Amount (LCY)" in the Vendor Ledger Entry". The filter is as below:

Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'.

Please check whether this is customized.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

I think you have miss read my post. What I mention was when Microsoft given the filter you have posted in here, they have omitted the "Correction of Remaining Amount" entry type. So any entry that is been posted in that type will NOT be picked in calculating the balance. Why is that??

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

I think you should add the Correction of Remaining Amount to the filter. It will resolve your issue. If you did not add that to the filter your subledger (vendor card) balance and control account balance will have a difference.

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

Reason for that is correction of remaining amount posted to GL as a separate entry and this adjustment will only affect in the detailed vendor ledger entry table. So if you do not have that in the Amount (LCY) filed in the vendor ledger entry your balance in the vendor and control account will have a different.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you very much. This resolve my question.

Was this reply helpful? Yes No