Skip to main content

HI, I am trying to do 2 things in a Generic Inquiry for sold Kitted items - getting the quantity of the components.

I am trying to have a calculation of sold components be exportable to excel as a numberic field from a GI. The formula is: =((ARTran.Qty] * INKitSpecStkDet.DfltCompQty])

It comes through as a text field, left justified. 
We would like the result to be a numberic field, Right justified.

We would also like to have this display with only 2 decimals

 

Define a schema field value to copy the formatting of another field. Just be sure to enter a caption value to name the field. 

Since we use USD and two decimals, CuryUnitPrice is typically my go-to.

 


Thank you! That worked. It set the decimals to 4 but I am guessing that is from the companies Price/Cost Decimal settings
 


Reply