Microsoft Dynamics NAV (Archived)

extra entries come in detaile vendor ledger entry as adjopening balance proplem

(0) Share

Report

Posted on by ahmed barbary

4,548

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

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

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 in adj opening balance like this and how i solve this problem

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

please help me

thanks

Previous | Next

Page 1 of 1 (1 items) | Get this RSS feed |

How to use Microsoft Dynamics?

How to customize Microsoft Dynamics?

Resources

Marketplace

About

*This post is locked for comments

All responses (7)

Answers (0)

ahmed barbary 4,548 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

Thanks for interest I see again to transactions i found that some transaction have applications outside date i write in filter(from 1-09-12..30-09-12) i see some transactions in 2013.

ex i write in date filter of standard report after i export it from Cronus

01-09-12..30-09-12 then i see in adj opening balance . i see it 99360 as report before exactly

but i make total to all entries outside this date(01-09-12..30-09-12)to application entry type

i see it is 102559

Are this what you need or i don't understand yet?and why application outside this date it total as 99360.

thanks
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

Hi all,

we've been trying to get to the bottom of it, and I think we have it now. This is all standard NAV behaviour, no migration or malformed entries. There are entries after the reporting period of 01/09/12..30/09/12, and these cause the adjustment of opening balance. Here is the answer I sent via PM:

-------------------------

Hi Ahmed,

now we're talking... maybe it's not a problem. There are some specialties regarding applications when it comes to date filters. What you need to know about the amount fields in V/L entries:

Original amount: always only the initial detailed entry

Amount: All detailed entries except for application, application rounding, and correction of remaining amount. For your example this would be only the initial detailed entries.

Remaining Amount: All detailed entries.

The Detail Trial Balance for a given period needs to show the balance at a given time. It goes over the amount field and needs to take into consideration all effects resulting from applications with entries outside the period. Therefore this strangely sounding "Adjustment of Opening Balance". It is the resulting effect of all detailed entries in the date filter minus application, application rounding and correction of remaining amount. Why? Because the other part of the application can affect entries outside the date filter, but the application entry itself would be inside the date filter and distorting your balance.

Please try the following: Run the report again, with date filter 01/09/12..

There shouldn't be an adjustment of opening balance then. So, it all depends on how your entries are applied if you get an adj. of opening balance or not. And this has to be, otherwise the report would show a wrong result.

You might take a look into report 304, DataItem "Vendor". That#s where the calculation is done.

------------------------

with best regards

Jens
Suggested answer

Neville Foyn 4,320 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

Hi

Unfortunately i cant help with this over the web, a problem like this requires sitting in front of NAV and tracing transactions, use the navigate to figure out where the original transaction comes from, check every part of it against a posting made manually in an un-customized cronos system and look for differences

I have found many problems relating to journals in the past and all of them had to be resolved by tracing transactions, some of the things that i found,

Currency, you mentioned that you do not use currencies, however make sure that there are not some transactions with a blank currency code and some with the local currency, even though both mean local they are still different currencies

Migration, this is the biggest, how were the go live entries created, were they brought in via a journal, what journal was used, were they manually typed in or data/xml port, were any of the posting code units modified, the answers to these questions could mean that not all the financial rules were applied and then you end up with a recon nightmare

Applications, have all applications been done using NAV forms or is there any kind of automation / integration

New records, same as above

The common theme of this is that NAV standard works really well, when there is a strange problem it is normally as a result of a Automated migration of data / development / customization, for this reason the first place you should look is at customization, and try the transactions in a standard system with manually created transactions and look for differences and as a separate exersize always avoid customizing anything that has an impact on posting

Hope this helps you get to the bottom of the problem

Cheers

Nev
ahmed barbary 4,548 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

To summarize my proplem as following :

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

www.mediafire.com/view

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

www.mediafire.com/view

based on same date from 01-09-12..30-09-12 to same vendor

if you need any detailes also i can give you

the entries you show it writing manually by hand 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
ahmed barbary 4,548 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

Thank you for reply

1- i think you told me before it is from currency problem.I never used exchange rate or another currency with customer's and vendors with local currency

2- i make as you told me compare between report vendor-detail trial balance found in link above and table detail vendor ledger entry i found the extra values stored in adj opening balance

that i give it name extra meaning it found in table and not found in report so that

all entries in table detail vendor ledger entry = what in report (link above) + values i write above

I m sorry all guys to write values more but i write because if any one know the problem give me solutions .

thanks
Suggested answer

Aleksandar Totovic 16,765 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

Some extra entries, if you think about "application entries" are applied entries and they are created when you post application. I don't know what problem is here. Eventually, we need all items if you see some other problem.
ahmed barbary 4,548 on at

Like (0)

Report

RE: extra entries come in detaile vendor ledger entry as adjopening balance proplem

can any one told me why this come like this i don't know why it come as total in adj opening balance