In SQL try to sum the amount MST field for all ledgertrans for the period op/01/07 to CL/12/07 If the amount is not 0.00000000000000000000 (you get the point :) ) then I guess there is some problem with the data The problem with export/import is I believe the export or import might round the SQL data into however many decimals AX uses and so the problem is not seen this new company _____
From: development-axapta@yahoogroups.com [mailto:development-axa...@yahoogroups.com] On Behalf Of psmpvr Sent: 27 February 2009 12:23 To: development-axapta@yahoogroups.com Subject: [development-axapta] Re: Year end closing/opening I run the consistency check in axapta..... path is \Basic\Periodic\Consistency check for the type of "Check" and "fix error" I don't hav idea on how to check on SQL the fin. year closing year after year i.e for 07-08 there is no difference...i run the related reports... In the \Classes\LedgerTransferOpening\insertOpeningTrans -- method ledgertrans.insert(this is for inserting the closing year balances to next year as opening balances) ..is there but...through debug it is showing that records are inserted..but...after debugging...it is not displaying the records in the table which are showing in debug.... and i import the same data in other environment...it is inserting values correctly....but in live environment..it is not.... any one hav idea..... PLs reply ASAP.... --- In development- <mailto:development-axapta%40yahoogroups.com> axa...@yahoogroups.com, Topár Tamás <toparta...@...> wrote: > > Hi. Off topic, sorry, I'm just interested what kind of consistency check had you run? SQL? Does it exist in AX as well? Thx T > > ps.: just two idea: > - did you run fin. year closing year after year? in 3.0 you have to. > - have you checked if there is a real difference? > > --- On Thu, 2/26/09, psmpvr <subbu.man...@...> wrote: > > > From: psmpvr <subbu.man...@...> > > Subject: [development-axapta] Re: Year end closing/opening > > To: development- <mailto:development-axapta%40yahoogroups.com> axa...@yahoogroups.com > > Date: Thursday, February 26, 2009, 9:51 AM > > I run that consistency check for both check & > > fix-error.... > > there is no errors...... > > > > I didn't import any any ledgertrans or ledgerbalance > > records > > > > the user made some necessary adjustment transactions in > > legertaccounts. > > > > Pls tell me ant remedy is ther? > > > > > > Thanks & regards, > > Subbu > > > > > > > > --- In development- <mailto:development-axapta%40yahoogroups.com> axa...@yahoogroups.com, "James > > Flavell" > > <djf1994@> wrote: > > > > > > Use the consistency check on the Ledger module > > > > > > Did you import any ledgertrans or ledgerbalance > > records? Maybe > > there was > > > some amounts not rounding correctly? > > > > > > Also have you run the currency conversion script on > > your AX? Not > > sure if > > > vaguely I remember similiar issue appeared due to that > > > > > > James > > > > > > > > > _____ > > > > > > From: development- <mailto:development-axapta%40yahoogroups.com> axa...@yahoogroups.com > > > [mailto:development- <mailto:development-axapta%40yahoogroups.com> axa...@yahoogroups.com] On Behalf > > Of psmpvr > > > Sent: 24 February 2009 21:22 > > > To: development- <mailto:development-axapta%40yahoogroups.com> axa...@yahoogroups.com > > > Subject: [development-axapta] Year end closing/opening > > > > > > > > > > > > I am trying to perform Fiscal Year End > Opening > > transactions and > > got > > > the following error: > > > > > > Total of the transactions in the year is not 0.00. > > > Total is 9,924,189.00. > > > > > > This is a serious error. Run > > \"Check\" on ledger transactions. > > > > > > For this what can i do....... > > > > > > didi any one had know abt this error > > > > > > > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > [Non-text portions of this message have been removed]
