Using GP2010, in an invoice report (SOP Blank Invoice Form) I'm attempting to add a comma between the city and state. I've followed mbs.microsoft.com/.../MSD_GPModifySOPBlankInvoiceForm which makes sense but it gives me errors.
Here's an example Bill To address line as it currently works (we have 5 lines total):
Bill To Address Line 3
Expression Type: Calculated
FUNCTION_SCRIPT( rw_SelectAddrLine 3 "" RM_Customer_MSTR_ADDR.Address 1 RM_Customer_MSTR_ADDR.Address 2 RM_Customer_MSTR_ADDR.Address 3 "" RM_Customer_MSTR_ADDR.City RM_Customer_MSTR_ADDR.State RM_Customer_MSTR_ADDR.Zip Bill To Country (final))
Bill To Country (final) is a field that omits the country field for US-based addresses.
This field works fine.
If I edit it to read:
FUNCTION_SCRIPT( rw_SelectAddrLine 3 "" RM_Customer_MSTR_ADDR.Address 1 RM_Customer_MSTR_ADDR.Address 2 RM_Customer_MSTR_ADDR.Address 3 "" RM_Customer_MSTR_ADDR.City # ", " # RM_Customer_MSTR_ADDR.State RM_Customer_MSTR_ADDR.Zip Bill To Country (final))
I get an error. I've tried both with and without the string concatenate operator (#) and am at a loss as to what to do next.
*This post is locked for comments
I have the same question (0)
