extra values come as total in adj opening balance in detaile vendor ledger entry why this come

Business Central/NAV Developers Forum
1

Hi guys i have problem in vendor-detaile trial balance report as linking below

www.mediafire.com/…/

i see value found in adj opening balance as 99360 as picture above when i write in date filter 01-09-12…30-09-12 and vendor name ram-ssy i go to the table detail vendor ledger entry i found some extra entries as following found in table detail vendor ledger entry but not found in report as above

: entry type document no document type source code amount date

initialentry RA-PPCM-000001 credit memo purchase 49680 30-09-12

application RA-PPCM-000001 credit memo purchase 49680 30-09-12

application RA-PPCM-000001 credit memo purchase -49,680.00 30-09-12

Initial entry RA-PPCM-000002 credit memo purchase 49680 30-09-12

application JE-PUJ-12-09-0043 purchase -38,520.00 30-09-12

application JE-PUJ-12-09-0043 purchase 63,310.00 30-09-12

application JE-PUJ-12-09-0043 purchase -24,790.00 30-09-12

I make total to this entries i found it as value 99360 why it come like this.

1- why this total as 99360 come like this and how i solve this problem

the report is detail vendor trial balance as standard no any customization

please help me

thanks

2

Are application entry is problem in detail vendor ledger entry or what

3

I think there is some problem during transaction application .

Look at the first entry… Credit Memo applied with Credit Memo…

4

I f i want to take total from detaile vendor ledger entry take only initial entry total or what

i dont know

5

First of All I would suggest lets do diagnosis why such entries created in table …

6

Really i dont know what i notice is the entries above come as total in dj opening balance as 99360 in report to

specified vendors

what you expect why this proplem come

7

Mr amole you can trace AND summarize proplem from here

To show you all transactiones in table detail vendor ledger entry in link below as following :

http://www.mediafire.com/view/?qh4luck7tkdodal

this link above show all transaction in table detail vendor ledger entry

from 01-09-12…30-09-12 in date filter to specified vendor 00028 found in table

the result show in report in this link

http://www.mediafire.com/view/?6jw96pgjg9g4185

based on same date from 01-09-12…30-09-12 to same customer

if you need any detailes also i can give you

the entries above in first thread is different between all transactions from 01-09-12…30-09-12

to this vendor 000028

Between table detail vendor ledger entry and report detail trial balance

I take different transaction and make total to it give me 99360 in adj opening balance why

this is my proplem

and no customization in report

thanks

8

I notice there are application entries outside date filter 30-09-12 i make total to application outside this period(1-09-12…30-09-12)that related to vendor ledger entry inside period

i found total is 102975 why this come in adj opening balance in standard report 304 it show 99360

why this different come 3615

are credit memo related to proplem i think i have another vendor has same proplem in adj opening balance has also credit memo are this effect

thanks

thanks

9

Thank you guys
I solved my proplem the proplem because more inital entries entry type and has document type credit memo i found it found in detaile vendor ledger entry with vendor name and same entry in vendor ledger entry without vendor name as following
vendor ledger entry
No vendorName
1000108 empty vendor name
detaile vendor ledger entry
VendorledgerNo vednor name
1000108 rab-tv-000028
meaning some entries not have source in vendor ledger entry
i think may be happen because we make integration between branches by dataport
I have two entries 49680+49680=99360 and has entry type intial entry because in my report i prevent any application from show and after this i deleted it and run report i dont found this in adj opening balance in standard or my report i found it 0
thank you very much
thanks