RE: [Axapta-Knowledge-Village] Need some Help/thoughts

Thu, 25 Aug 2005 17:13:59 -0700

Title: Message
Just check there is nothing in the validupdate or update triggers of the table (i.e. does it update any other table or do any other change to any other fields).
 
Also I suggest you write out a log file in case and also for any audit purpose...directly changing values on posted trans is a no no to auditors
 
Also if it is only ledtrans then okay but if things like credtrans etc be careful as usually they have thigns like credsettlement actions etc on the update triggers...I dont know are you planning to fix these (there are a lot of places using AmountCur and AmountMst...including inventtrans....) as I think otherwise you will not be able to do settlements because your invoice is 4 decimals but you can only do a payment or any new transaction with 2 so can never settle!!!!
 
All the best, I guess lesson learnt the hard way this time
James
 
-----Original Message-----
From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Subrahmanyam, Mamidi
Sent: 26 August 2005 05:50
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Need some Help/thoughts

Hi Guys,
 
I am in real shit. I am trying to see if  any one has any experiences on changing the AmountCur and AmountMst to 4 decimals.
 
Here is my scenario.
 
My Europe customer  wanted to see 4 digits on Discounts and Qty on Sales Order module.
Initially we changed AMountCur and  AmountMST, QTy EDTs to 4 decimals and curreny to 4 decimals in the exchange section. Then everything is started shon up to 4 digits and finance people wanted not to see 4 digits. Yes, it true they don;t want .
 
What we did was, we created an extended data type inheriting from AmountCur and AmountMST  && changing the currency Decimals to 4 digits 0.0001 and fullfilled their needs.
 
  As time went on, we now have problems in ledgerSettlements , Journals, and invoices etc etc  duw to the last 2 digits out of 4 digits.
 
Since all these use LedgerTrans Table in one or other way, LedgerTrans now contains 2 dgits or 4 digits Amounts and they are not tallying due to 3rd  and 4th decimals.
 
We have a lot of tickets logged in and we really need to act very fast.
Since we have this problem for finance transactions , I am going to round off of the amounts in AmoutCur and AmountMST fields in LedgerTrans table  to 2 decimals.
 
1. Is that advisable?
2. did u face this kind of problems? or how did you tackle kind of problems?.
 
 
Any help will be highly appreciated.
 
Thanks,
subbu
 
 
 
 
 
 

Start your day with Yahoo! - make it your home page

Sharing the knowledge on Axapta.


YAHOO! GROUPS LINKS



Reply via email to