net change lcy in vendor table

ahmedba

what is net change (lcy) found in vendor table represent because it found in vendor-detaile trial balance as adjust opeing balance
i dont understand this
can any one clear net change lcy wht represent
thanks

jglathe

Hi Ahmed,

this is the net change as the sum of all detailed vendor ledger entries for this vendor, in LCY. It contains all postings to this vendor, including application and exchange rate adjustments. It is a typical "internal use" field, and can be used as the opening balance for the "Vendor - Detail Trial Balance" report. The amount of this field should be the contribution of this vendor to the account payable.

with best regards

Jens

ahmedba

Ok thanks but
how i can do sum to exchange rate also this is not transaction found in detail vendor ledger entry

ahmedba

In dynamic nav 2009 r2

i have two reports

vendor trial balance

and

vendor-detail trial balance

in vendor trial balance report i write vendor no and in date filter from 01-8-12..31-12-12

it give me 128,000 ending balance

in vendor detailed trial balance report i write vendor no and in date filter from 01-8-12..31-12-12

it give me 78,974.60 (different between debit and credit)

adj opening balance is 194,040.00 the two reports no customization why this different in amount come total amount (debit -credit)

in vendor ledger entry table total amount (debit - credit) is 228.014.60

why different in two reports come

Notes
all vendor in two reports are same in amount or ending balance except this vendor
I make total to application entry type in detail.vendor ledger entry i found it 49,680 what the remains come