Vendor Balance Difference with Ledger Entries

SaravananA

Hi All,

We are having difference in Vendor Balances. Means Balance(LCY) field in particular vendor card and addition of amount field in that particular vendor ledger entries are having different values.

If anyone knows kindly guide us.

Regards,
Saravanan

damir

Do you have ledger entries in different currencies? Try summing up field Amount (LCY).

Damir

SaravananA

Hi Damir,

Thanks for your reply.

No, we are not having different currencies in vendor ledger entries. We have sum the amount(LCY) field also, but again same problem.

Regards,
Saravanan.

ssingla

If you are using SQL database try rebuilding SIFT indexes.

Duketown

Is "Direct Posting" allowed on those specific ledger accounts?

Alex_Chow

Are you using version 5.0? If so, there is a fix in version 5.0SP1 that addresses this issue.

SaravananA

Hi Duketown,

Yes Direct Posting allowed for the ledger accounts.

Regards,
Saravanan.

SaravananA

Hi ssingla,

Yes, we are using SQL Database. We are new to Navision and SQL, if you could tell me how to rebuilt the SIFT index in SQL, it is helpful for us.

Regards,
Saravanan.