Skip to main content
Solved

Combining fields in a GI column

  • 16 February 2022
  • 9 replies
  • 882 views

Forum|alt.badge.img

I am building a GI and want to create a formula to add two fields as one.  I am trying to crete output of the vendor ID with the PO Number.  I would also like to add a space between the two records.

 

I am using the POOrder Object.  I have placed the following in the Data Field =Concat([POOrder.VendorID],[POOrder.OrderNbr])

This returns the following error where 21-200379 is the PO.OrderNbr

 

Not sure where to go from here.  Any assistance would be appreciated.

Best answer by Naveen Boga

@KempOdell68  Please use the below formula to get the VendorCD instead of VendorID.

 

= [Vendor.AcctCD] + ' - ' + [POOrder.OrderNbr]

 

 

View original
Did this topic help you find an answer to your question?

9 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • February 17, 2022

Hi, @KempOdell68  Please use the below formula to combine fields.

 

= Cstr([POOrder.VendorID]) + ‘ - ’ + [POOrder.OrderNbr])


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • February 17, 2022

@Naveen B Thank you for the response.  I am receiving the following validation error using this formula.

I have tried moving the parentheses as well, but still receive the same message.

 

 

Where is the best resource for the formulas used in GIs?

Thanks,

Kemp


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • February 17, 2022

Hi @KempOdell68  Both formulas are working for me.

 

=Concat(  CStr ([POOrder.VendorID]) ,' - ' , [POOrder.OrderNbr] )

= CStr( [POOrder.VendorID]) + '-' + [POOrder.OrderNbr]

 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • February 17, 2022
KempOdell68 wrote:

@Naveen B Thank you for the response.  I am receiving the following validation error using this formula.

I have tried moving the parentheses as well, but still receive the same message.

 

 

Where is the best resource for the formulas used in GIs?

Thanks,

Kemp

There is a parenthesis issue on the above formula, hence you got that issue. 

You might be copy-pasted the formula, hence single quotes work differently. Can you please provide manually and verify


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • February 17, 2022

@Naveen B Thanks for the quick reply.  Both of these formulas work for me now.  But, I am getting a numeric value for the Vendor ID.  I am trying to get the alphanumeric Vendor ID that is displayed in Acumatica.

 

Thanks,

Kemp


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • February 17, 2022
Naveen B wrote:
KempOdell68 wrote:

@Naveen B Thank you for the response.  I am receiving the following validation error using this formula.

I have tried moving the parentheses as well, but still receive the same message.

 

 

Where is the best resource for the formulas used in GIs?

Thanks,

Kemp

There is a parenthesis issue on the above formula, hence you got that issue. 

You might be copy-pasted the formula, hence single quotes work differently. Can you please provide manually and verify

 

@Naveen B Typing in the formula did resolve the validation issue.  I still get the numeric value for the vendor id instead of the displayed vendor id. 

Example: 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • Answer
  • February 17, 2022

@KempOdell68  Please use the below formula to get the VendorCD instead of VendorID.

 

= [Vendor.AcctCD] + ' - ' + [POOrder.OrderNbr]

 

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 24 replies
  • February 17, 2022
Naveen B wrote:

@KempOdell68  Please use the below formula to get the VendorCD instead of VendorID.

 

= [Vendor.AcctCD] + ' - ' + [POOrder.OrderNbr]

 

 

Thanks @Naveen B .  I did not think about using the field from the vendor file.

 

Thanks,

Kemp


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3377 replies
  • February 17, 2022

@KempOdell68  Understood. POOrder table will SAVE only the ID values, if we wanted to get the CD value, we need to fetch it from the respective main table. Here it is Vendor  ;) 

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings