Product: Sage 100

Article Link: https://help.truecommerce.com/en/articles/6915766-sage-100-consolidating-advance-ship-notices

If your Trading Partner is requesting that you consolidate your Advance Ship Notices (856) you'll need to configure your Shipping Entries within Sage 100 so that the integration can know which entries qualify for consolidation before being sent over to Transaction Manager.

You can set the ASN Consolidation option within the TrueCommerce tab within a Sales Order, Shipping Entry, or the Customer Maintenance Entry to default all incoming orders.

In order for your Advance Ship Notice to come over consolidated - you'll need to set the ASN Consolidation option on your Sales Order/Shipping Entry. You'll be provided with a handful of options that allow you to control how the system consolidates based on the criteria provided within the options.

Note: Since your Shipping Entry is created from your Sales Order, setting your Sales Order ASN Consolidation option prior to creating the Shipping Entry will result in the setting being carried over during creation.

DC + BOL: Distribution Center + Bill of Lading

DC: Distribution Center only

CUST+DC+BOL: Customer No. + Distribution Center + Bill of Lading

CUST+DC: Customer No. + Distribution Center

If your ASN Consolidation setting includes an option featuring the CUST keyword - the system will require that the Customer No. matches all Shipping Data Entries you wish to consolidate.

If your ASN Consolidation setting includes the DC keyword - then the TrueCommerce → DC Code field must must for all Shipping Data Entries you wish to consolidate.

If your ASN Consolidation setting include the BOL option - then the TrueCommerce → Bill of Lading field must match for all Shipping Data Entries you wish to consolidate

If you've received a new Sale Order from your Trading Partner and do not have your Customer Maintenance Entry setup with a default ASN Consolidation setting you'll need to set the Sale Order manually prior to creating the Shipping Entry in order to have your Shipping Entries properly configured upon creation.

Navigate: Accounts Receivable → Sales Order Entry → TrueCommerce tab

Set: ASN Consolidated

If you've already created your Shipping Entry prior to updating your Customer Maintenance or your Sales Order to have the proper ASN Consolidation setting - you can update it within the TrueCommerce tab of your Shipping Entry.

Navigate: Accounts Receivable → Shipping Data Entry → TrueCommerce Tab

Set: ASN Consolidation

If you wish to default a specific setting for all incoming Sales Orders which in turn will automatically populate your Shipping Entry you can set this within the Customer Maintenance Entry under the TrueCommerce tab.

Navigate: Accounts Receivable → Customer Maintenance

Set: ASN Consolidation

Note: Setting the consolidation option within the Customer Maintenance screen will not update existing Sales Orders/Shipping Entries. Only new Sales Orders will receive this default.

rev 1/23/2023