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

[Maurice Cohen]

We did something similar for purchase orders where purchase prices per unit were up to 4 decimals ($2.5435). We had to system use the 4 decimal precision to calculate the extended price and then rounded it. You should not have some postings at 2 and some at 4 decimals in ledgertrans or you are going to have the problem you are describing. I think your only option is to round the amounts at this point.   Maurice Cohen Senior consultant Advanced Systems Integration, Inc. 26449 Rancho Parkway South Lake Forest, CA 92630 ph:    949-597-2170 fax:   949-597-0720 cell:  949-533-5966 From: Axapta-Knowledge-Village@yahoogroups.com [mailto:Axapta-Knowledge-Village@yahoogroups.com] On Behalf Of Subrahmanyam, Mamidi Sent: Thursday, August 25, 2005 1:50 PM 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. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools YAHOO! GROUPS LINKS  Visit your group "Axapta-Knowledge-Village" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.