• Perhaps the Customer does not have any Ship-To Addresses. This can be tested by creating a new Ship-To Address to see if it shows up in the Location Code List lookup. If the new address does show up, then there likely was no other pre-existing address for that customer.

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking ARDivisionNo and/or CustomerNo field values)
• Use the Rebuild Key Files utility to rebuild the AR_Customer file for the affected company code

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking valid ARDivisionNo, CustomerNo, and/or ShipToCode field values)
• Use the Rebuild Key Files utility to rebuild the SO_ShipToAddress file for the affected company code

1. For Custom lookups: On the Location Code List task window, check for a drop-down View other than "STANDARD", such as one with an asterisk. If there is, try using "STANDARD" instead.
2. For custom Filters: On the Location Code List task window, check if the Filters button is displayed in red. If red, that means there is a filter in effect. Click the Filters button and click Reset.
   • Note: If a Reset button is not available, the filter may be due to the Custom lookup. Delete the Custom lookup.

1. Open Library Master, Main menu, User Lookup Wizard
2. For Lookup, select SO_ShipToAddress Customer Ship to Address List
3. Delete any customized lookups that affect the user (or all users) and company code (or all company codes).

The Advanced Lookup Engine (ALE) query files may be corrupted:

One or more Sales Order program files may be corrupted:

The Sage 100 ERP (formerly Sage MAS 90 or 200) install may be an earlier release of the retired/obsolete version 4.40 prior to Product Update 9 or 10:

• If on Sage 100 ERP (formerly Sage MAS 90 or 200) version 4.40, Product Update 9 or 10, then this section should no longer apply.
• If on a previous version, because Sage 100 ERP version 4.40 was officially retired on September 30, 2014, it may not be possible to obtain program fixes. Consider upgrading to a currently supported version of Sage 100 ERP.

Note: If none of the above resolves the issue, consider testing in one of the demonstration companies that come with Sage 100 ERP, such as the ABC Distribution and Service Corp (ABC company code). If it does not occur there, the issue may be data-related, or specific to a company code. If the issue does occur there, the issue may be with programs or ALE query files affecting more than one company. It is also possible (and in a few cases, has been found to be true) that there is an issue with a third-party program enhancement.

• Perhaps the Customer does not have any Ship-To Addresses. This can be tested by creating a new Ship-To Address to see if it shows up in the Location Code List lookup. If the new address does show up, then there likely was no other pre-existing address for that customer.

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking ARDivisionNo and/or CustomerNo field values)
• Use the Rebuild Key Files utility to rebuild the AR_Customer file for the affected company code

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking valid ARDivisionNo, CustomerNo, and/or ShipToCode field values)
• Use the Rebuild Key Files utility to rebuild the SO_ShipToAddress file for the affected company code

1. For Custom lookups: On the Location Code List task window, check for a drop-down View other than "STANDARD", such as one with an asterisk. If there is, try using "STANDARD" instead.
2. For custom Filters: On the Location Code List task window, check if the Filters button is displayed in red. If red, that means there is a filter in effect. Click the Filters button and click Reset.
   • Note: If a Reset button is not available, the filter may be due to the Custom lookup. Delete the Custom lookup.

1. Open Library Master, Main menu, User Lookup Wizard
2. For Lookup, select SO_ShipToAddress Customer Ship to Address List
3. Delete any customized lookups that affect the user (or all users) and company code (or all company codes).

The Advanced Lookup Engine (ALE) query files may be corrupted:

One or more Sales Order program files may be corrupted:

The Sage 100 ERP (formerly Sage MAS 90 or 200) install may be an earlier release of the retired/obsolete version 4.40 prior to Product Update 9 or 10:

• If on Sage 100 ERP (formerly Sage MAS 90 or 200) version 4.40, Product Update 9 or 10, then this section should no longer apply.
• If on a previous version, because Sage 100 ERP version 4.40 was officially retired on September 30, 2014, it may not be possible to obtain program fixes. Consider upgrading to a currently supported version of Sage 100 ERP.

Note: If none of the above resolves the issue, consider testing in one of the demonstration companies that come with Sage 100 ERP, such as the ABC Distribution and Service Corp (ABC company code). If it does not occur there, the issue may be data-related, or specific to a company code. If the issue does occur there, the issue may be with programs or ALE query files affecting more than one company. It is also possible (and in a few cases, has been found to be true) that there is an issue with a third-party program enhancement.

• Perhaps the Customer does not have any Ship-To Addresses. This can be tested by creating a new Ship-To Address to see if it shows up in the Location Code List lookup. If the new address does show up, then there likely was no other pre-existing address for that customer.

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking ARDivisionNo and/or CustomerNo field values)
• Use the Rebuild Key Files utility to rebuild the AR_Customer file for the affected company code

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking valid ARDivisionNo, CustomerNo, and/or ShipToCode field values)
• Use the Rebuild Key Files utility to rebuild the SO_ShipToAddress file for the affected company code

1. For Custom lookups: On the Location Code List task window, check for a drop-down View other than "STANDARD", such as one with an asterisk. If there is, try using "STANDARD" instead.
2. For custom Filters: On the Location Code List task window, check if the Filters button is displayed in red. If red, that means there is a filter in effect. Click the Filters button and click Reset.
   • Note: If a Reset button is not available, the filter may be due to the Custom lookup. Delete the Custom lookup.

1. Open Library Master, Main menu, User Lookup Wizard
2. For Lookup, select SO_ShipToAddress Customer Ship to Address List
3. Delete any customized lookups that affect the user (or all users) and company code (or all company codes).

The Advanced Lookup Engine (ALE) query files may be corrupted:

One or more Sales Order program files may be corrupted:

The Sage 100 ERP (formerly Sage MAS 90 or 200) install may be an earlier release of the retired/obsolete version 4.40 prior to Product Update 9 or 10:

• If on Sage 100 ERP (formerly Sage MAS 90 or 200) version 4.40, Product Update 9 or 10, then this section should no longer apply.
• If on a previous version, because Sage 100 ERP version 4.40 was officially retired on September 30, 2014, it may not be possible to obtain program fixes. Consider upgrading to a currently supported version of Sage 100 ERP.

Note: If none of the above resolves the issue, consider testing in one of the demonstration companies that come with Sage 100 ERP, such as the ABC Distribution and Service Corp (ABC company code). If it does not occur there, the issue may be data-related, or specific to a company code. If the issue does occur there, the issue may be with programs or ALE query files affecting more than one company. It is also possible (and in a few cases, has been found to be true) that there is an issue with a third-party program enhancement.

• Perhaps the Customer does not have any Ship-To Addresses. This can be tested by creating a new Ship-To Address to see if it shows up in the Location Code List lookup. If the new address does show up, then there likely was no other pre-existing address for that customer.

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking ARDivisionNo and/or CustomerNo field values)
• Use the Rebuild Key Files utility to rebuild the AR_Customer file for the affected company code

• Use the Data File Display and Maintenance utility to check for a record with a blank key. Delete any records where the key is truly blank or corrupted (i.e. lacking valid ARDivisionNo, CustomerNo, and/or ShipToCode field values)
• Use the Rebuild Key Files utility to rebuild the SO_ShipToAddress file for the affected company code

1. For Custom lookups: On the Location Code List task window, check for a drop-down View other than "STANDARD", such as one with an asterisk. If there is, try using "STANDARD" instead.
2. For custom Filters: On the Location Code List task window, check if the Filters button is displayed in red. If red, that means there is a filter in effect. Click the Filters button and click Reset.
   • Note: If a Reset button is not available, the filter may be due to the Custom lookup. Delete the Custom lookup.

1. Open Library Master, Main menu, User Lookup Wizard
2. For Lookup, select SO_ShipToAddress Customer Ship to Address List
3. Delete any customized lookups that affect the user (or all users) and company code (or all company codes).

The Advanced Lookup Engine (ALE) query files may be corrupted:

One or more Sales Order program files may be corrupted:

The Sage 100 ERP (formerly Sage MAS 90 or 200) install may be an earlier release of the retired/obsolete version 4.40 prior to Product Update 9 or 10:

• If on Sage 100 ERP (formerly Sage MAS 90 or 200) version 4.40, Product Update 9 or 10, then this section should no longer apply.
• If on a previous version, because Sage 100 ERP version 4.40 was officially retired on September 30, 2014, it may not be possible to obtain program fixes. Consider upgrading to a currently supported version of Sage 100 ERP.

Note: If none of the above resolves the issue, consider testing in one of the demonstration companies that come with Sage 100 ERP, such as the ABC Distribution and Service Corp (ABC company code). If it does not occur there, the issue may be data-related, or specific to a company code. If the issue does occur there, the issue may be with programs or ALE query files affecting more than one company. It is also possible (and in a few cases, has been found to be true) that there is an issue with a third-party program enhancement.