Solved

Decimal/Number formatting in a GI to excel

  • 5 April 2021
  • 2 replies
  • 21 views

Userlevel 1
Badge

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

 

icon

Best answer by Neil Cantral 5 April 2021, 19:46

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.

 

View original

2 replies

Badge +1

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.

 

Userlevel 1
Badge

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

Reply


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 — 2020  Acumatica, Inc. All rights reserved