Easy Import Sage 50 CSV export templates

The following attributes (i.e., pre-defined report columns) are included in Sage 50 CSV export templates.

Premium accounting

  • Vendor ID

  • Vendor Name

  • Invoice/CM #

  • Apply to Invoice Number

  • Credit Memo

  • Date

  • Drop Ship

  • Customer SO #

  • Waiting on Bill

  • Customer ID

  • Customer Invoice #

  • Ship to Name

  • Ship to Address-Line One

  • Ship to Address-Line Two

  • Ship to City

  • Ship to State

  • Ship to Zip code

  • Ship to Countr

  • Date Due

  • Discount Date

  • Discount Amount

  • Accounts Payable Account

  • Accounts Payable Amount

  • Ship Via

  • P.O. Note

  • Note Prints After Line Items

  • Beginning Balance Transaction

  • AP Date Cleared in Bank Rec

  • Applied To Purchase Order

  • Number of Distributions

  • Invoice/CM Distribution

  • Apply to Invoice Distribution

  • PO Number

  • PO Distribution

  • Quantity

  • Item ID

  • Serial Number

  • Description

  • G/L Account

  • GL Date Cleared in Bank Rec

  • Unit Price

  • UPC / SKU

  • Weight

  • Amount

  • Job ID

  • Used for Reimbursable Expense

  • Transaction Period

  • Transaction Number

  • Displayed Terms

  • Return Authorization

  • Recur Number

  • Recur Frequency

Quantum accounting

  • Vendor ID

  • Vendor Name

  • Invoice/CM #

  • Apply to Invoice Number

  • Credit Memo

  • Date

  • Drop Ship

  • Customer SO #

  • Waiting on Bill

  • Customer ID

  • Customer Invoice #

  • Ship to Name

  • Ship to Address-Line One

  • Ship to Address-Line Two

  • Ship to City

  • Ship to State

  • Ship to Zip code

  • Ship to Country

  • Date Due

  • Discount Date

  • Discount Amount

  • Accounts Payable Account

  • Accounts Payable Amount

  • Ship Via

  • P.O. Note

  • Note Prints After Line Items

  • Beginning Balance Transaction

  • AP Date Cleared in Bank Rec

  • Applied To Purchase Order

  • Number of Distributions

  • Invoice/CM Distribution

  • Apply to Invoice Distribution

  • PO Number

  • PO Distribution

  • Quantity

  • Stocking Quantity

  • Item ID

  • Serial Number

  • U/M ID

  • U/M No. of Stocking Units

  • Description

  • G/L Account

  • GL Date Cleared in Bank Rec

  • Unit Price

  • Stocking Unit Price

  • UPC / SKU

  • Weight

  • Amount

  • Job ID

  • Used for Reimbursable Expense

  • Transaction Period

  • Transaction Number

  • Displayed Terms

  • Return Authorization

  • Row Type

  • Recur Number

  • Recur Frequency