When using the Shipping Add-On to import shipment information from Big Business Server, you can also have the shipping system automatically update the Sales Order with Shipment Infomation. Here are descriptions of the Fields in the SHIPINFO table.

UID - a unique identifier that is automatically set; Do not map to this field; it will be overwritten.

ShipmentDescription - the Description in the Shipment Information on the Sales Order. Map Service (Overnight, Ground, etc.) level, etc., as needed for reference.

ShipmentID - the Tracking Number in the Shipment Information on the Sales Order. Map the (Lead) Tracking Number.

SO_Number - the Sales Order Number to be updated. Map the Sales Order Number, or the posted data will be lost.

SO_ReplaceOtherChgs - use this field to overwrite the Other Charges (i.e. Freight) Field on the Sales Order. Map the value that you want to carry forward to the invoice.

SO_AddOtherChgs - an alternative to "Replace" above, this field _adds_ the value that you map to the current Other Charges.


When using the Shipping Add-On to import shipment information from Big Business Server, you can also have the shipping system automatically update the Sales Order with Shipment Infomation. Here are descriptions of the Fields in the SHIPINFO table.

SO_AddPrintedCmts - adds to the Printed Comments on the Sales Order. Map the Tracking Number or other information that you want to appear on the printed invoice.

SO_AddPrivateCmts - adds to the Private Comments on the Sales Order. Map Charges or other information that you need for reference when invoicing.

SOUID - for linking to the Sales Order; Do not map to this field; it will be overwritten.

AutoDate - the current Date on the Server is automatically inserted; Do not map.

AutoTime - the current Time on the Server is automatically inserted; Do not map.

Void - mapping a Void Indicator which posts "Y" will skip the updates to the Sales Order.

When using the Shipping Add-On to import shipment information from Big Business Server, you can also have the shipping system automatically update Big Business with Shipment Infomation. Here are descriptions of new Fields added to the SHIPINFO table for Big Business 8.7.

Invoice_Number - finds an Invoice to be updated. Links to Invoice's Sales Order.

Invoice_AddPrintedCmts - adds to the Printed Comments on the Invoice.
Map Tracking, ETD, etc. to appear on a printed invoice.

Invoice_AddPrivateCmts - adds to the Private Comments on the Invoice.
Map Charges, etc., for reference when invoicing.

InvUID - for linking to the Invoice; Do not map to this field.

SO_DropDate - replace the Drop Date on the Sales Order.
Works with SO_Number or Invoice_Number.

Cust_UDDate -replace the Custom Date on the Customer Card.
See Customer Prefs,Custom Field Labels, D for User-Defined-Date.

Cust_ReplaceCmt - replace the Comment on the Customer Card.

Related: