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


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved