vendor trial balance report total amount different about vendor-detail trial balance why

Business Central/NAV Developers Forum
1

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

and

what is adj opening balance Notes all vendor in two reports are same in amount or ending balance except this vendor

2

I using one currency when i treating to customers and vendors in program why this value come in adj opening balance in detail vendor ledger entry report

thanks

3

suppose i need total(ending balance) from detail vendor ledger entry table are i take all exception application entry type