alifikhwan
31st December 2008, 06:00
Dear Support,

We having an issue about decimal point in our invoice. We have created 6 decimal point for our sales order line but when we print the acknowledgement the system round up the pricing to 4 decimal point.

Same thing goes to our invoicing, the system printout the invoice with 4 decimal point although we set the decimal point for invoicing 6 as per sales order price.

That's is the caused why we having an issues with the decimal point in invoicing.

We really need the system to print out with 6 decimal point for us to match back with th supplier contract.

Please advise how for us to overcome the issues.

Thanks in advance

sukesh75
3rd January 2009, 09:52
..We have created 6 decimal point for our sales order line..How & where did you do this?
Did you change only the form field display format or did you update the domain behind that field and the display format on the acknowledgement/invoice reports along with that?

sk

alifikhwan
6th January 2009, 02:39
thanks for your reply, to describe detail about the issues please refer to attachment as sample of the data created by users.

Thanks

sukesh75
6th January 2009, 12:25
The best way to find out if the changes (from 4 to 6 decimals) has actually taken place is to go to the tables (sls) and check what is entered as the price and amount. Check the "domains" of both the price & amount and see if both are set to display & accept 6 decimals. Then you may want to check your reports for the usage of any variables (to hold price & amount) in the script of the report and what datatype or how many decimals are used for those variables. I would also check the display formats on both the forms and reports for the price and amount field..

hth
sk