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

Thu, 25 Aug 2005 17:17:57 -0700

Hi Maurice,
 
Can you please explain me more eloboratley?.
 
1. Did you guys extend AmountMST and AmountCur EDTs to 4 decimals?
 
    ( We didn;t tocuh them . Rather, we inherited them and attached to where we needed in sales module  / purchasemodule )
 
2. When you say, We had to system use the 4 decimal precision to calculate the extended price and then rounded it. , is that, GL - SetUp - Exchange Rates  - Decimal round off? We changed to 0.0001 for sales , general, purchase and price ?.
 can you please tell me what exactly you did here?
 
 
I just don;t want to reonvent the already existing functionality.
 
Can you please tell me more?.
 
Thanks & Regards,
subbu
 
 

Maurice Cohen <[EMAIL PROTECTED]> wrote:

We did something simce,ilar 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

Yahoo! Mail
Stay connected, organized, and protected. Take the tour

Sharing the knowledge on Axapta.


YAHOO! GROUPS LINKS



Reply via email to