Sales Order Report: BILL TO ADDRESS LINE 3 NOT SHOWING

(0) Share

Report

Posted on by Community Member

Hi,

We are currently using he sales order report (customized) as our proforma invoice report.

In BILL TO ADDRESS, ADDRESS LINES 1-2 only shows, ADDRESS LINE 3 can't be displayed in the report. I already checked the properties of this ADDRES LINE 3 field, Visibility = Visible.

Does anyone knows or can share any solution about this?

Thanks,

Rotchine

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Almas Mahfooz 11,009 User Group Leader on at

Like (0)

Report

Bill To Address line 3 is a calculated field, do you have city state zip fields values in your bill to address information?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Rotchine,

You will have to modify all of the Bill To Address Lines and add ADDRESS LINE 3, then create a new Bill To Address Line 4 with the same information. See example below. In Each of the calculated fields, the "Address Line" number will increment (look for the number 4 in the example below). Once you have the first 3 modified, and the 4th line created, drag it to the designer surface and set it like the others. Save it, set security to the modified report if you haven't already and run it. You should see the new address line field display.

FUNCTION_SCRIPT(rw_SelectAddrLine 4 "" RM_Customer_MSTR_ADDR.Address1 RM_Customer_MSTR_ADDR.Address2 RM_Customer_MSTR_ADDR.Address3 "" RM_Customer_MSTRADDR.City RM_Customer_MSTR_ADDR.State RM_Customer_MSTR_ADDR.Zip"")

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yes, it is a calculated field Almas. City, State, Zip Code are not included in the report.

CONTACT, ADDRESS LINES 1-3 and Country Code only needs to be shown in the report. :)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Aaron,

Thanks for that! Did you mean delete those BILL TO ADDRESS LINES 1-3? Then create another BILL TO ADDRESS LINE 4? So, in my final report there would be BILL TO ADDRESS LINES 1-4?

Thanks,

Rotchine

Was this reply helpful? Yes No
RRC@BIOS 50 on at

Like (1)

Report

If your bill to address line 3 is calculated field and it is not showing even though the property is visible then there is a problem with one of the database fields you are combining. It might have a null vales and unreadable by the report. try to divide and conquer, though its tedious but try to add individually the fields you wanted to combine. Because even if you create another calculated field with the same database fields you wanted to combine then the results will be the same.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi Rotchine,

No you do not have to delete the existing Bill To Address Lines 1-3, but they do need to be modified to add the additional information as shown in my example above.

Aaron

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Aaron,

So, retain BILL TO ADDRESS LINES 1-3, then add BILL TO ADDRESS LINE 4 with below function?

FUNCTION_SCRIPT(rw_SelectAddrLine 4 "" RM_Customer_MSTR_ADDR.Address1 RM_Customer_MSTR_ADDR.Address2 RM_Customer_MSTR_ADDR.Address3 "" RM_Customer_MSTRADDR.City RM_Customer_MSTR_ADDR.State RM_Customer_MSTR_ADDR.Zip"")

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Yes, that is correct. You will, however, need to modify Bill To Address Lines 1-3 to add the "Address Line 3" field to the calculation. At the end of your customization, address lines 1-4 should look like my example above, with the exception that the "SelectAddrLine" switch should increment from 1 to 4 for each address line respectively.

aaron

Was this reply helpful? Yes No