Skip to Content
0
Former Member
Mar 23, 2009 at 04:31 AM

Print 3 or more decimal places in PLD

196 Views

Hi,

I have added a UDF (U_servPce) to Sales Order and AR Invoice.

When I print the invoice I want this field to print the inputted number of decimal places.

In my example the user inputs 0.375.

This displays on the Sales Order (RDR1) as 0.38

When added to the AR Invoice PLD, it prints as 0.38.

If I run the query below the correct decimal places is calculated.

Query:

SELECT T0.[DocEntry], T0.[U_ServPce], CAST(T0.[U_ServPce] AS VARCHAR(10)) FROM INV1 T0 WHERE T0.[DocEntry] =690

Result: 0.375

1. How can I create a fomula field to print 0.375 on the PLD's?

2. Can I get the Sales and AR Invoice form to display the correct decimal places?

Kind Regards,

Eric Walker