Submissions: Exporting To Sage 100 Sales Order, SO Invoice, AR Invoice

See this article for general information on exporting to Sage 100.

The following is a list of the fields available in each of the Sage 100 entries currently supported by Sync & Save. Please contact us if you need additional Sage 100 entries.

Sales Order Fields


Order Number
  • If no Order Number is entered, the next Order Number will be used.
Order Date
Order Type
Division Number *
Customer Number *
Customer PO
Expire Date
Warehouse
Tax Schedule
Tax Exempt Number
Terms Code
Ship To Code
Ship Via
FOB
Confirm To
Email Address
Batch Email
Fax Number
Batch Fax
Comment
Salesperson Division
  • Generally the Salesperson Division should be the same as the customer Division Number.
Salesperson Code
Print Order
Print Pick Sheets
Bill To Name
Bill To Address 1
Bill To Address 2
Bill To Address 3
Bill To Address Zip
Bill To City
Bill To State
Bill To Country
Ship To Name
Ship To Address 1
Ship To Address 2
Ship To Address 3
Ship To Zip
Ship To City
Ship To State
Ship To Country
Residential Address
Discount Rate
Discount Amount
Ship Zone
Ship Weight
Freight Amount
Payment Type
  • The Payment Type can be NONE, CHECK, CASH.
Check Payment Reference
  • If the Payment Type is CHECK then the check number should be entered here.
Other Payment Reference
  • If the Payment Type is CASH then any payment reference should be entered here.
Payment Amount
Commission Rate
RMA Number
Job Number
Line: Item Code *
Line: Item Description
Line: Quantity Ordered *
Line: Quantity Shipped
Line: Quantity Back Ordered
  • If both Quantity Shipped and Quantity Back Ordered are entered, they must add up to Quantity Ordered.
Line: Unit Price
Line: Extension
  • If the Extension is entered, the Unit Price will be calculated, and vise versa.
Line: Unit Cost
Line: Comment
Line: Warehouse
Line: Unit of Measure
Line: Price Level
Line: Tax Class
Line: Discountable
Line: Discount Percent
Line: Drop Ship
Line: Commissionable
Line: Subject To Exempt
Line: Warranty Code
Line: Promise Date

Sales Order Invoice Fields


Batch
  • If batches are enabled, but a batch number is not entered, the same batch number (next available) will be used for all submissions received in a single job run.
Invoice Number
  • If no Invoice Number is entered, the next Invoice Number will be used.
Invoice Type
Division Number *
Customer Number *
Invoice Date
PO Number
Ship Date
Warehouse
Tax Schedule
Ship To Code
Terms Code
Ship Via
FOB
Confirm To
Email Address
Batch Email
Fax Number
Batch Fax
Comment
Salesperson Division
  • Normally the Salesperson Division should be the same as the customer Division Number.
Salesperson Code
Print Invoice
Bill To Name
Bill To Address 1
Bill To Address 2
Bill To Address 3
Bill To Zip
Bill To City
Bill To State
Bill To Country
Ship To Name
Ship To Address 1
Ship To Address 2
Ship To Address 3
Ship To Zip
Ship To City
Ship To State
Ship To Country
Residential Address
Discount Rate
Discount Amount
Retention Amount
Ship Zone
Weight
Freight Amount
Payment Type
Check Payment Reference
Other Payment Reference
Payment Amount
Commission Rate
Commission Amount
Job Number
RMA Number
Line: Item Code *
Line: Quantity Ordered *
Line: Quantity Shipped
Line: Quantity Back Ordered
  • If both Quantity Shipped and Quantity Ordered are entered, then they must add up to Quantity Ordered.
Line: Unit Price
Line: Extension
  • If Extension is entered, then Unit Price will be calculated, and vise versa.
Line: Comment
Line: Item Description
Line: Warehouse
Line: Unit of Measure
Line: Price Level
Line: Tax Class
Line: Discountable
Line: Discount Percent
Line: Drop Ship
Line: Commissionable
Line: Subject to Exemption
Line: Unit Cost
Line: Warranty Code
Line: Expiration Date

Accounts Receivable Invoice Fields


Batch
  • If batches are enabled, but a batch number is not entered, the same batch number (next available) will be used for all submissions received in a single job run.
Invoice Number
Invoice Type
Division Number *
Customer Number *
PO Number
Invoice Date
Comment
Tax Schedule
Terms Code
Ship Method
Salesperson Division
  • Normally the Salesperson Division should be the same as the customer Division Number.
Salesperson Code
Print Invoice
Fax Number
Batch Fax
Email
Job Number
Freight Amount
Commission Rate
Commission Amount
Retention Amount
Line: Item Code *
Line: Item Code Description
Line: Unit of Measure
Line: Subject To Exemption
Line: Commissionable
Line: Comment
Line: Quantity *
Line: Price
Line: Extension
  • If Extension is entered, then Price will be calculated, and vise versa.
Line: Cost
Line: Tax Class

Feedback and Knowledge Base