RE: [development-axapta] Re: Year end closing/opening

2009-03-02 Thread James Flavell
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. (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 correctlybut 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]



Re: [development-axapta] Re: Year end closing/opening

2009-02-26 Thread Topár Tamás
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...@gmail.com wrote:

 From: psmpvr subbu.man...@gmail.com
 Subject: [development-axapta] Re: Year end closing/opening
 To: development-axapta@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-axapta@yahoogroups.com, James
 Flavell 
 djf1...@... 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-axapta@yahoogroups.com
  [mailto:development-axa...@yahoogroups.com] On Behalf
 Of psmpvr
  Sent: 24 February 2009 21:22
  To: development-axapta@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]