Overview
The Sugar-Sage Integration comes with standard syncs and predefined field mappings to ease the setup process. This article describes these syncs and mappings in detail, helping you to troubleshoot any issues you might experience.
Depending on your configuration, not all fields will be mapped as shown in this section. These are just out-of-the-box mappings.
Table of Contents
1. Sage Customer to Sugar Accounts
2. Sage Customer to Sugar Accounts (Active)
3. Sugar Accounts to Sage Customers
4. Sage Contacts to Sugar Contacts
5. Sage Warehouses to Sugar Warehouses
6. Sage Inventory to Sugar Product Catalog
7. Sage Price Code to Sugar Pricing
8. Sage ShipTo Addresses to Sugar Contacts
9. Sugar Quotes to Sage Sales Orders
10. Sugar Quotes to SO Invoices
11. Sugar Sage Quote Update
12. Sage Invoice History to Sugar Invoice History
13. Sage Customer Sales to Sugar Sales History
14. Sage Sales by Category to Sugar Sales by Product Category
15. Sage Sales by Customer / Item to Sugar
16. Sage Sales by Product Line to Sugar Sales by Product Line
17. Sage Open Invoice to Sugar Open Invoices
18. Sage Cash Receipts to Sugar Cash Receipts History
19. Sage Product Sales History by Period to Sugar Sales History by Product by Period
20. Sugar Line Item Prices to Sage Customer Price Level
1. Sage Customers to Sugar Accounts
2. Sugar Accounts to Sage Customers
3. Sage Contacts to Sugar Contacts
4. Sage Warehouses to Sugar Warehouses
5. Sugar Quotes to Sage Sales Orders
6. Sugar Quotes to Sage SO Invoices
7. Sage Sales Order to Sugar QuoteUpdate
8. Sage Sales by Category to Sugar Sales by Product CategoryField
9. Sage ShipTo Addresses to SugarContacts
10. Sage Price Code to SugarPricing
11. Sage Inventory to SugarProduct Catalog
12. Sage Invoice History to Sugar Invoice History
13. Sage Customer Sales to Sugar Sage Sales History
14. Sage Sales by Customer/Item to Sugar Product Sales History
15. Sage Sales by Product Line to Sugar Sales by Product Line
16. Sage Open Invoices to Sugar Open Invoices
A. Sage Open Invoices to Sugar Open Invoices Headers
B. Sage Open Invoices to Sugar Open Invoices Details
17. Sage Cash Receipts to Sugar Cash Receipts History
18. Sage Product Sales History by Period to Sugar Sales History by Product by Period
19. Sugar Line Item Prices to Sage Customer Price Level
A. Standard Available Syncs
1. Sage Customer to Sugar Accounts
This will sync the contact and billing info from Sage Customers (both inactive and active customers) to Sugar Accounts.
This sync can create and update Sugar Accounts from Sage and Accounts can be assigned by the Sage Salesperson but you will first need to sync the Sage Salespersons to Sugar and then map them to the correct Sugar User before syncing the Customers.
2. Sage Customer to Sugar Accounts (Active)
This will sync the contact and billing info from Sage Customers (for Active customers Only) to Sugar Accounts.
This sync can create and update Sugar Accounts from Sage and Accounts can be assigned by the Sage Salesperson but you will first need to sync the Sage Salespersons to Sugar and then map them to the correct Sugar User before syncing the Customers.
3. Sugar Accounts to Sage Customers
This will sync Sugar Account information to Sage Customers. This sync can create and update Sage Customers from Sugar.
4. Sage Contacts to Sugar Contacts
This will sync Sage Contacts to Sugar Contacts. This sync can create and update Sugar Contacts from Sage.
5. Sage Warehouses to Sugar Warehouses
This will sync the Sage Warehouses to Sugar Warehouses. The Sage Warehouses module is used to track inventory quantities per warehouse in Sugar as well as specify the warehouse for Quoted Line Items.
6. Sage Inventory to Sugar Product Catalog
This syncs ONLY active inventory items from Sage to the Sugar Product Catalog. This sync includes pricing and quantity information per the warehouse. To sync all items please file a request with Faye to customize your Configuration file.
7. Sage Price Code to Sugar Pricing
This syncs Customer-specific pricing per item from Sage to Sugar. These Customer-specific prices will be used when generating quotes in Sugar.
8. Sage ShipTo Addresses to Sugar Contacts
This syncs Ship To addresses from Sage to the Contacts module in Sugar. This is intended to allow adding Ship To addresses to a quote by selecting the billing or shipping Contact. Please contact Faye if you intend to enable this sync.
9. Sugar Quotes to Sage Sales Orders
This syncs Sugar Quotes to Sage Sales Orders. Sales Orders can only be created and will not be updated. The Quotes are sent to Sage when the Quotes Stage is set to Closed Accepted.
10. Sugar Quotes to SO Invoices
This syncs Sugar Quotes to Sage Invoices. Invoices can only be created and will not be updated. The Quotes are sent to Sage when the Quotes Stage is set to Closed Accepted.
11. Sugar Sage Quote Update
This syncs the Sage Sales Order status to Sugar Quotes. This will allow the status of the Sage Sales Order to be visible in Sugar. This is to be used with the Sugar Quotes to Sage sync.
12. Sage Invoice History to Sugar Invoice History
This syncs Sage Invoice History headers and detail to Sugar. This data is visible in the Invoice History subpanel when viewing an Account and can be used for reporting. The period for this sync is configurable in the Integration Options and the data in Sugar is cumulative.
For the default mapping please see Sage Invoice History to Sugar Invoice History mapping here.
13. Sage Customer Sales to Sugar Sales History
This syncs Customer sales data and credit info per period to Sugar. This data is visible in the Sage Sales History subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Customer Sales to Sugar Sales History mapping here.
14. Sage Sales by Category to Sugar Sales by Product Category
This syncs the Product Category sales data per Customer to Sugar. This data is visible in the Sales History by Category subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Sales by Category to Sugar Sales by Product Category mapping here.
15. Sage Sales by Customer / Item to Sugar
This syncs the Sage Inventory sales data per Customer to Sugar. This data is visible in the Sales History by Product subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Sales by Customer/Item to Sugar Product Sales History mapping here.
16. Sage Sales by Product Line to Sugar Sales by Product Line
This syncs the Sage Inventory sales data grouped by Product Line per Customer to Sugar. This data is visible in the Sales History by Product subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Sales by Product Line to Sugar Sales by Product Line mapping here.
17. Sage Open Invoice to Sugar Open Invoices
This syncs Open Invoices from Sage to Sugar. This data is visible in the Open Invoices subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Open Invoice to Sugar Open Invoices mapping here.
18. Sage Cash Receipts to Sugar Cash Receipts History
This syncs Cash Receipt History data from Sage to Sugar. This data is visible in the Cash Receipts History subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Cash Receipts to Sugar Cash Receipts History mapping here.
19. Sage Product Sales History by Period to Sugar Sales History by Product by Period
This syncs the Sage Inventory sales data per Customer, per period to Sugar. This data is visible in the Sales History by Product by Period subpanel when viewing an Account and can be used for reporting.
For the default mapping please see Sage Product Sales History by Period to Sugar Sales History by Product by Period here.
20. Sugar Line Item Prices to Sage Customer Price Level
This sync will update the price for an inventory item in Sage based on the last used price on a Quote in Sugar. This is a specific case sync and not intended for general use.
For the default mapping please see Sugar Line Item Prices to Sage Customer Price Level mapping here.
Note: For the default mapping of points 1 through 20, please see section B below.
B. Default Field Mappings
1. Sage Customers to Sugar Accounts
| Sage Field | Sugar Field |
|---|---|
| id (Sugar Accounts) | id |
| ARDIVISIONNO (Sage Customers) | mas90_division_number |
| CUSTOMERNO (Sage Customers) | mas90_customer_number |
| CUSTOMERNAME (Sage Customers) | name |
| CREDITLIMIT (Sage Customers) | credit_limit |
| OPENORDERAMT (Sage Customers) | open_sales_orders |
| CITY (Sage Customers) | billing_address_city |
| STATE (Sage Customers) | billing_address_state |
| ZIPCODE (Sage Customers) | billing_address_postalcode |
| COUNTRYCODE (Sage Customers) | billing_address_country |
| TELEPHONENO (Sage Customers) | phone_office |
| EMAILADDRESS (Sage Customers) | email1 |
| FAXNO (Sage Customers) | phone_fax |
| ADDRESSLINE1 (Sage Customers) | billing_address_street |
| ADDRESSLINE2 (Sage Customers) | billing_address_street_2 |
| ADDRESSLINE3 (Sage Customers) | billing_address_street_3 |
| CONTACTCODE (Sage Customers) | contact_code |
| CUSTOMERDISCOUNTRATE (Sage Customers) | customerdiscountrate |
| CUSTOMERTYPE (Sage Customers) | customertype |
| DEFAULTITEMCODE (Sage Customers) | defaultitemcode |
| DEFAULTPAYMENTTYPE (Sage Customers) | defaultpaymenttype |
| PRICELEVEL (Sage Customers) | pricelevel |
| PRIMARYSHIPTOCODE (Sage Customers) | primaryshiptocode |
| SERVICECHARGERATE (Sage Customers) | servicechargerate |
| SHIPMETHOD (Sage Customers) | ship_method |
| SORTFIELD (Sage Customers) | sort_field |
| STATEMENTCYCLE (Sage Customers) | statementcycle |
| TAXEXEMPTNO (Sage Customers) | tax_exempt_no |
| {CompanyCode} {TAXSCHEDULE} (Sage Customers) | tax_schedule |
| {CompanyCode} {TERMSCODE} (Sage Customers) | terms_code |
| CompanyCode (Sage Customers) | mas90_company_code |
| SALESPERSONDIVISIONNO (Sage Customers) | salesperson_division |
| SALESPERSONNO (Sage Customers) | salesperson_number |
| AGINGCATEGORY1 (Sage Customers) | aging_1 |
| AGINGCATEGORY2 (Sage Customers) | aging_2 |
| AGINGCATEGORY3 (Sage Customers) | aging_3 |
| AGINGCATEGORY4 (Sage Customers) | aging_4 |
| CURRENTBALANCE (Sage Customers) | mas_current_balance |
| {CompanyCode} {SALESPERSONDIVISIONNO} {SALESPERSONNO} (Sage Customers) |
mas_salesperson |
| CREDITHOLD (Sage Customers) | credit_hold |
| OPENITEMCUSTOMER (Sage Customers) | open_item_customer |
| TEMPORARYCUSTOMER (Sage Customers) | temporary_customer |
| COMMENT (Sage Customers) | mas_comment_c |
| user_id (Sugar Salesperson Source) | assigned_user_id |
| 1 (Default Value) | mas_account |
2. Sugar Accounts to Sage Customers
| Sugar Field | Sage Field |
|---|---|
| mas90_division_number (Sugar Accounts Import) | ARDivisionNo |
| mas90_customer_number (Sugar Accounts Import) | CustomerNo |
| name (Sugar Accounts Import) | CompanyName |
| billing_address_street (Sugar Accounts Import) | AddressLine1 |
| billing_address_street (Sugar Accounts Import) | AddressLine2 |
| billing_address_street (Sugar Accounts Import) | AddressLine3 |
| billing_address_city (Sugar Accounts Import) | City |
| billing_address_state (Sugar Accounts Import) | State |
| billing_address_postalcode (Sugar Accounts Import) | Zip |
| billing_address_country (Sugar Accounts Import) | Country |
| email1 (Sugar Accounts Import) | EmailAddress |
| phone_office (Sugar Accounts Import) | TelephoneNo |
| phone_fax (Sugar Accounts Import) | FaxNo |
| mas_salesperson (Sugar Accounts Import) | SalespersonNo |
| tax_schedule (Sugar Accounts Import) | SalesTaxSchedule |
| terms_code (Sugar Accounts Import) | TermsCode |
| ship_method (Sugar Accounts Import) | ShippingMethod |
| id (Sugar Accounts Import) | PassThrough |
| mas90_company_code (Sugar Accounts Import) | CompanyCode |
3. Sage Contacts to Sugar Contacts
| Sage Field | Sugar Field |
|---|---|
| id (Sugar Contacts) | id |
| id (Sugar Accounts) | agdsf |
| ADDRESSLINE1 (Sage Contacts) | primary_address_street |
| ADDRESSLINE2 (Sage Contacts) | primary_address_street_2 |
| ADDRESSLINE3 (Sage Contacts) | primary_address_street_3 |
| CITY (Sage Contacts) | primary_address_city |
| CompanyCode (Sage Contacts) | mas90_company_code |
| ARDIVISIONNO (Sage Contacts) | mas90_division_number |
| CONTACTCODE (Sage Contacts) | mas90_contact_code |
| CUSTOMERNO (Sage Contacts) | mas90_customer_number |
| LastName (Sage Contacts) | last_name |
| CONTACTNOTES (Sage Contacts) | description |
| COUNTRYCODE (Sage Contacts) | primary_address_country |
| EMAILADDRESS (Sage Contacts) | email1 |
| FAXNO (Sage Contacts) | phone_fax |
| STATE (Sage Contacts) | primary_address_state |
| TELEPHONENO1 (Sage Contacts) | phone_work |
| TELEPHONENO2 (Sage Contacts) | phone_other |
| ZIPCODE (Sage Contacts) | primary_address_postalcode |
| FirstName (Sage Contacts) | first_name |
4. Sage Warehouses to Sugar Warehouses
| Sage Field | Sugar Field |
|---|---|
| WarehouseCode (Sage Warehouses) | warehouse_code |
| WarehouseName (Sage Warehouses) | name |
| id (Sugar Warehouses) | id |
| CompanyCode (Sage Warehouses) | mas90_company_code |
5. Sugar Quotes to Sage Sales Orders
| Sage Field | Sugar Field |
|---|---|
| Quote Number (Sugar Quote Headers) | QuoteNumber(SalesOrderNo) |
| date_entered (Sugar Quote Headers) | QuoteDateCreated |
| date_modified (Sugar Quote Headers) | QuoteDateModified |
| date_quote_expected_closed (Sugar Quote Headers) | ExpirationDate |
| quote_stage (Sugar Quote Headers) | QuoteStage |
| opportunity_name (Sugar Quote Headers) | OpportunityName |
| purchase_order_num (Sugar Quote Headers) | PONumber |
| name (Sugar Quote Headers) | QuoteSubject |
| {mas90_division_number}-{mas90_customer_number}(Sugar Accounts) | MAS90CustomerNumber |
| assigned_user_name (Sugar Quote Headers) | AssignedTo |
| shipping_account_name (Sugar Quote Headers) | ShipToAccount |
| shipping_contact_name (Sugar Quote Headers) | ShipToStreet1 |
| shipping_address_street (Sugar Quote Headers) | ShipToStreet2 |
| shipping_address_street(Sugar Quote Headers) | ShipToStreet3 |
| shipping_address_city (Sugar Quote Headers) | ShipToCity |
| shipping_address_state (Sugar Quote Headers) | ShipToState |
| shipping_address_postalcode (Sugar Quote Headers) | ShipToZip |
| shipping_address_country (Sugar Quote Headers) | ShipToCountry |
| billing_account_name (Sugar Quote Headers) | BillToAccount |
| billing_address_street (Sugar Quote Headers) | BillToStreet1 |
| billing_address_street (Sugar Quote Headers) | BillToStreet2 |
| billing_address_street (Sugar Quote Headers) | BillToStreet3 |
| billing_address_city (Sugar Quote Headers) | BillToCity |
| billing_address_state (Sugar Quote Headers) | BillToState |
| billing_address_postalcode (Sugar Quote Headers) | BillToZip |
| billing_address_country (Sugar Quote Headers) | BillToCountry |
| mft_part_num (Sugar Quote Lines Custom) | ProductCode |
| name (Sugar Quote Lines Custom) | ProductName |
| quantity (Sugar Quote Lines Custom) | Quantity |
| discount_usdollar (Sugar Quote Lines Custom) | UnitPrice |
| shipping (Sugar Quote Headers) | Shipping |
| total_discount (Sugar Quote Lines Custom) | Discount |
| payment_terms (Sugar Quote Headers) | TermsCode |
| shipper_name (Sugar Quote Headers) | ShipVia |
| description (Sugar Quote Lines Custom) | Comment |
| tax_class (Sugar Quote Lines Custom) | TaxClass |
| uom (Sugar Quote Lines Custom) | UnitOfMeasure |
| mas90_company_code (Sugar Accounts) | CompanyCode |
| id (Sugar Quote Headers) | QuoteId |
| {salesperson_division}-{salesperson_number} (Sugar Salesperson Source) | SalespersonCode |
| warehouse_code (Sugar Warehouses) | WarehouseCode |
| id (Sugar Quote Lines Custom) | LinePassThrough |
| fbsg_line_index (Sugar Quote Lines Custom) | fbsg_line_index |
6. Sugar Quotes to Sage SO Invoices
| Sage Field | Sugar Field |
|---|---|
| mas90_order_number (Sugar Quote Headers Invoice) | QuoteNumber |
| fbsg_line_key (Sugar Quote Lines Custom Invoice) | SalesOrderLineKey |
| id (Sugar Quote Lines Custom Invoice) | LinePassThrough |
| mft_part_num (Sugar Quote Lines Custom Invoice) | ItemCode |
| quantity (Sugar Quote Lines Custom Invoice) | QuantityShipped |
| uom (Sugar Quote Lines Custom Invoice) | UnitOfMeasure |
| description (Sugar Quote Lines Custom Invoice) | Comment |
| mas90_company_code (Sugar Accounts) | CompanyCode |
| id (Sugar Quote Headers Invoice) | QuoteIdSage |
7. Sage Sales Order to Sugar QuoteUpdate
| Sage Field | Sugar Field |
|---|---|
| OrderDate (Sage SO Update Source) | date_closed |
| OrderStatus (Sage SO Update Source) | sage_order_status |
| id (Sugar Sage Quote Source) | id |
8. Sage Sales by Category to Sugar Sales by Product CategoryField
| Field | Outgoing Fieldname |
|---|---|
| id (Sugar Accounts) | account_id |
| id (Sugar Sales History by Category1) | id |
| category_1 (Sage Sales by Category1) | category |
| CompanyCode (Sage Sales by Category1) | mas90_company_code |
| division_number (Sage Sales by Category1) | mas90_division_number |
| Sage_customer_number (Sage Sales by Category1) | mas90_customer_number |
| sales_period_to_date (Sage Sales by Category1) | sales_ptd |
| sales_year_to_date (Sage Sales by Category1) | sales_ytd |
| category_1 (Sage Sales by Category1) | name |
| sales_ly (Sage Sales by Category1) | sales_ly |
9. Sage ShipTo Addresses to SugarContacts
| Sage Field | Sugar Field |
|---|---|
| id (Sugar ShipTo Codes) | id |
| ST Code# {ShipToCode} (Sage Ship To Codes) | first_name |
| ShipToName (Sage Ship To Codes) | last_name |
| ShipToAddress1 (Sage Ship To Codes) | primary_address_street |
| ShipToAddress2 (Sage Ship To Codes) | primary_address_street_2 |
| ShipToAddress3 (Sage Ship To Codes) | primary_address_street_3 |
| ShipToCity (Sage Ship To Codes) | primary_address_city |
| ShipToState (Sage Ship To Codes) | primary_address_state |
| ShipToZipCode (Sage Ship To Codes) | primary_address_postalcod |
| ShipToCountryCode (Sage Ship To Codes) | primary_address_country |
| TelephoneNo (Sage Ship To Codes) | phone_work |
| FaxNo (Sage Ship To Codes) | phone_fax |
| EmailAddress (Sage Ship To Codes) | email1 |
| SalespersonDivisionNo (Sage Ship To Codes) | ship_to_salesperson_div |
| SalespersonNo (Sage Ship To Codes) | ship_to_salesperson_no |
| WarehouseCode (Sage Ship To Codes) | ship_to_warehouse_code |
| TaxSchedule (Sage Ship To Codes) | ship_to_tax_schedule |
| ResidentialAddress (Sage Ship To Codes) | ship_to_residential_address1 |
| 1 (Default Value) | ship_to_record |
| CompanyCode (Sage Ship To Codes) | mas90_company_code |
| ContactCode (Sage Ship To Codes) | mas90_contact_code |
| CustomerNo (Sage Ship To Codes) | mas90_customer_number |
| ARDivisionNo (Sage Ship To Codes) | mas90_division_number |
| id (Sugar Accounts) | account_id |
10. Sage Price Code to SugarPricing
| Sage Field | Sugar Field |
|---|---|
| PriceCode (Sage Pricecode Source) | price_code |
| PriceCodeDesc (Sage Pricecode Source) | price_code_desc |
| ARDivisionNo (Sage Pricecode Source) | ardivisionno |
| BreakQuantity1 (Sage Pricecode Source) | break_quantity_1 |
| BreakQuantity2 (Sage Pricecode Source) | break_quantity_2 |
| BreakQuantity3 (Sage Pricecode Source) | break_quantity_3 |
| BreakQuantity4 (Sage Pricecode Source) | break_quantity_4 |
| BreakQuantity5 (Sage Pricecode Source) | break_quantity_5 |
| CompanyCode (Sage Pricecode Source) | company_code |
| CustomerNo (Sage Pricecode Source) | customerno |
| CustomerPriceLevel (Sage Pricecode Source) | customer_price_level |
| DiscountMarkup1 (Sage Pricecode Source) | discount_markup_price_rate_1 |
| DiscountMarkup2 (Sage Pricecode Source) | discount_markup_price_rate_2 |
| DiscountMarkup3 (Sage Pricecode Source) | discount_markup_price_rate_3 |
| DiscountMarkup4 (Sage Pricecode Source) | discount_markup_price_rate_4 |
| DiscountMarkup5 (Sage Pricecode Source) | discount_markup_price_rate_5 |
| ItemCode (Sage Pricecode Source) | item_code |
| PriceCodeRecord (Sage Pricecode Source) | price_code_record |
| PricingMethod (Sage Pricecode Source) | pricing_method |
| ProductLine (Sage Pricecode Source) | product_line |
| id (Sugar Pricecode Source) | id |
| id (Sugar Accounts) | account_id |
| id (Sugar Product Catalog) | product_template_id |
11. Sage Inventory to SugarProduct Catalog
| Sage Field | Sugar Field |
|---|---|
| TAXCLASS (Sage Inventory) | tax_class |
| ITEMCODE (Sage Inventory) | mft_part_num |
| ITEMCODEDESC (Sage Inventory) | name |
| EXTENDEDITEMDESCRIPTION (Sage Inventory) | description |
| PRODUCTLINE (Sage Inventory) | category_name |
| PRODUCTTYPE (Sage Inventory) | producttype |
| SUGGESTEDRETAILPRICE (Sage Inventory) | list_price |
| STANDARDUNITCOST (Sage Inventory) | cost_price |
| id (Sugar Product Catalog) | id |
| BACKORDERSALLOWED (Sage Inventory) | backordersallowed |
| CATEGORY1 (Sage Inventory) | category1 |
| CATEGORY2 (Sage Inventory) | category1 |
| CATEGORY3 (Sage Inventory) | category1 |
| CATEGORY4 (Sage Inventory) | category1 |
| COMMISSIONRATE (Sage Inventory) | commissionrate |
| DEFAULTWAREHOUSECODE (Sage Inventory) | defaultwarehousecode |
| EXPLODEKITITEMS (Sage Inventory) | explodekititems |
| IMAGEFILE (Sage Inventory) | imagefile |
| PURCHASEUNITOFMEASURE (Sage Inventory) | purchaseuom |
| SALESUNITOFMEASURE (Sage Inventory) | salesunitofmeasure |
| STANDARDUNITOFMEASURE (Sage Inventory) | standarduom |
| VALUATION (Sage Inventory) | valuation |
| VOLUME (Sage Inventory) | volume |
| PRICECODE (Sage Inventory) | price_code |
| CompanyCode (Sage Inventory) | mas90_company_code |
| SALESUMCONVFCTR (Sage Inventory) | sales_uom_factor |
| OnHand (Sage Warehouse Availability) | qty_in_stock |
12. Sage Invoice History to Sugar Invoice History
| Field | Outgoing Fieldname |
|---|---|
|
Sage Invoice History to Sugar fbsg_InvoiceHistory module |
|
| id (Sugar Invoice History Headers) | id |
| id (Sugar Accounts) | account_id |
| FreightAmt (Sage Invoice History Header Source) | freight_amount |
| Comment (Sage Invoice History Header Source) | description |
| HeaderSeqNo (Sage Invoice History Header Source) | headerseqno |
| InvoiceDate (Sage Invoice History Header Source) | invoice_date |
| OrderDate (Sage Invoice History Header Source) | so_date |
| ShipDate (Sage Invoice History Header Source) | ship_date |
| InvoiceDueDate (Sage Invoice History Header Source) | invoice_due_date |
| InvoiceNo (Sage Invoice History Header Source) | invoice_number |
| SalesOrderNo (Sage Invoice History Header Source) | so_number |
| InvoiceType (Sage Invoice History Header Source) | invoice_type |
| CustomerNo (Sage Invoice History Header Source) | mas90_customer_number |
| ARDivisionNo (Sage Invoice History Header Source) | mas90_division_number |
| SalespersonNo (Sage Invoice History Header Source) | salesperson_number |
| TermsCode (Sage Invoice History Header Source) | terms_code |
| CustomerPONo (Sage Invoice History Header Source) | customer_po_number |
| NonTaxableSalesAmt (Sage Invoice History Header Source) | nontaxable_amount |
| TaxableSalesAmt (Sage Invoice History Header Source) | taxable_amount |
| SalespersonDivisionNo (Sage Invoice History Header Source) | salesperson_division |
| CompanyCode (Sage Invoice History Header Source) | mas90_company_code |
| BillToName (Sage Invoice History Header Source) | bill_to_name |
| BillToAddress1 (Sage Invoice History Header Source) | bill_to_address_1 |
| BillToAddress2 (Sage Invoice History Header Source) | bill_to_address_2 |
| BillToCity (Sage Invoice History Header Source) | bill_to_city |
| BillToState (Sage Invoice History Header Source) | bill_to_state |
| BillToZipCode (Sage Invoice History Header Source) | bill_to_zip |
| BillToCountryCode (Sage Invoice History Header Source) | bill_to_country_code |
| ShipToName (Sage Invoice History Header Source) | ship_to_name |
| ShipToAddress1 (Sage Invoice History Header Source) | ship_to_address_1 |
| ShipToAddress2 (Sage Invoice History Header Source) | ship_to_address_2 |
| ShipToCity (Sage Invoice History Header Source) | ship_to_city |
| ShipToState (Sage Invoice History Header Source) | ship_to_state |
| ShipToZipCode (Sage Invoice History Header Source) | ship_to_zip |
| ShipToCountryCode (Sage Invoice History Header Source) | ship_to_country_code |
| FOB (Sage Invoice History Header Source) | fob |
| ConfirmTo (Sage Invoice History Header Source) | confirm_to |
| DiscountAmt (Sage Invoice History Header Source) | discount_amount |
| SalesTaxAmt (Sage Invoice History Header Source) | sales_tax_amount |
13. Sage Customer Sales to Sugar Sage Sales History
| Field | Outgoing Fieldname |
|---|---|
| aging_1 (Sage Sales History and Credit Info) | aging_1 |
| aging_2 (Sage Sales History and Credit Info) | aging_2 |
| aging_3 (Sage Sales History and Credit Info) | aging_3 |
| aging_4 (Sage Sales History and Credit Info) | aging_4 |
| available_credit (Sage Sales History and Credit Info) | available_credit |
| average_days_overdue (Sage Sales History and Credit Info) | average_days_overdue |
| average_days_to_pay (Sage Sales History and Credit Info) | average_days_to_pay |
| balance (Sage Sales History and Credit Info) | balance |
| cash_received_ly (Sage Sales History and Credit Info) | cash_received_ly |
| cash_received_ptd (Sage Sales History and Credit Info) | cash_received_ptd |
| cash_received_ytd (Sage Sales History and Credit Info) | cash_received_ytd |
| credit_hold (Sage Sales History and Credit Info) | credit_hold |
| credit_limit (Sage Sales History and Credit Info) | credit_limit |
| current_period (Sage Sales History and Credit Info) | current_period |
| current_year (Sage Sales History and Credit Info) | current_year |
| date_established (Sage Sales History and Credit Info) | date_established |
| date_of_last_activity (Sage Sales History and Credit Info) | date_of_last_activity |
| last_paid_amount (Sage Sales History and Credit Info) | last_paid_amount |
| last_payment_date (Sage Sales History and Credit Info) | last_payment_date |
| mas90_customer_number (Sage Sales History and Credit Info) | mas90_customer_number |
| mas90_division_number (Sage Sales History and Credit Info) | mas90_division_number |
| name (Sage Sales History and Credit Info) | name |
| no_of_invoices_last_year (Sage Sales History and Credit Info) | no_of_invoices_last_year |
| no_of_invoices_to_date (Sage Sales History and Credit Info) | no_of_invoices_to_date |
| open_sales_orders (Sage Sales History and Credit Info) | open_sales_orders |
| profit_percent_ly (Sage Sales History and Credit Info) | profit_percent_ly |
| profit_percent_ptd (Sage Sales History and Credit Info) | profit_percent_ptd |
| profit_percent_ytd (Sage Sales History and Credit Info) | profit_percent_ytd |
| sales_ly (Sage Sales History and Credit Info) | sales_ly |
| sales_ptd (Sage Sales History and Credit Info) | sales_ptd |
| sales_ytd (Sage Sales History and Credit Info) | sales_ytd |
| id (Sugar Sales History) | id |
| id (Sugar Accounts) | account_id |
| CompanyCode (Sage Sales History and Credit Info) | mas90_company_code |
14. Sage Sales by Customer/Item to Sugar Product Sales History
| Field | Outgoing Fieldname |
|---|---|
| mas90_customer_number (Sage Inventory Customer Sales) | mas90_customer_number |
| CompanyCode (Sage Inventory Customer Sales) | mas90_company_code |
| mas90_division_number (Sage Inventory Customer Sales) | mas90_division_number |
| mft_part_num (Sage Inventory Customer Sales) | mft_part_num |
| ly_dollars (Sage Inventory Customer Sales) | ly_dollars |
| ly_quantity (Sage Inventory Customer Sales) | ly_quantity |
| ly_returned (Sage Inventory Customer Sales) | ly_returned |
| ytd_dollars (Sage Inventory Customer Sales) | ytd_dollars |
| ytd_quantity (Sage Inventory Customer Sales) | ytd_quantity |
| ytd_returned (Sage Inventory Customer Sales) | ytd_returned |
| id (Sugar Accounts) | account_id |
| id (Sugar Sales History by Product) | id |
| mft_part_num (Sage Inventory Customer Sales) | name |
| LastPurchaseDate (Sage Customer Last Purchase) | last_purchase_date |
| LastUnitPrice (Sage Customer Last Purchase) | last_purchase_price |
| last_invoice_date (Sage Inventory Customer Sales) | last_invoice_date |
| last_invoice_quantity (Sage Inventory Customer Sales) | last_invoice_quantity |
| last_invoice_price (Sage Inventory Customer Sales) | last_invoice_price |
| last_order_date (Sage Inventory Customer Sales) | last_order_date |
| last_order_quantity (Sage Inventory Customer Sales) | last_order_quantity |
| last_order_price (Sage Inventory Customer Sales) | last_order_price |
| last_quote_price (Sage Inventory Customer Sales) | last_quote_date |
| last_quote_quantity (Sage Inventory Customer Sales) | last_quote_quantity |
| last_quote_price (Sage Inventory Customer Sales) | last_quote_price |
15. Sage Sales by Product Line to Sugar Sales by Product Line
| Field | Outgoing Fieldname |
|---|---|
| id (Sugar Sales History by Line) | id |
| id (Sugar Accounts) | account_id |
| CompanyCode (Sage Sales by Line) | mas90_company_code |
| Sage_customer_number (Sage Sales by Line) | mas90_customer_number |
| division_number (Sage Sales by Line) | mas90_division_number |
| product_line (Sage Sales by Line) | product_line |
| sales_period_to_date (Sage Sales by Line) | sales_ptd |
| sales_year_to_date (Sage Sales by Line) | sales_ytd |
| product_line (Sage Sales by Line) | name |
| ly_sales (Sage Sales by Line) | sales_ly |
| ProductLineDesc (Sage Product Lines) | description |
16. Sage Open Invoices to Sugar Open Invoices
A. Sage Open Invoices to Sugar Open Invoices Headers
| Field | Outgoing Fieldname |
|---|---|
| ARDIVISIONNO (Sage Open Invoices Headers) | mas90_division_number |
| CUSTOMERNO (Sage Open Invoices Headers) | mas90_customer_number |
| TAXABLEAMT (Sage Open Invoices Headers) | taxable_amount |
| FREIGHTAMT (Sage Open Invoices Headers) | freight_amount |
| INVOICEDATE (Sage Open Invoices Headers) | invoice_date |
| INVOICEDUEDATE (Sage Open Invoices Headers) | invoice_due_date |
| INVOICENO (Sage Open Invoices Headers) | invoice_number |
| BALANCE (Sage Open Invoices Headers) | balance_due |
| SALESPERSONNO (Sage Open Invoices Headers) | saleperson_number |
| id (Sugar Open Invoice Headers) | id |
| id (Sugar Accounts) | account_id |
| TERMSCODE (Sage Open Invoices Headers) | terms_code |
| INVOICETYPE (Sage Open Invoices Headers) | invoice_type |
| NONTAXABLEAMT (Sage Open Invoices Headers) | nontaxable_amount |
| INVOICENO (Sage Open Invoices Headers) | name |
| COMMENT (Sage Open Invoices Headers) | description |
| INVOICEHISTORYHEADERSEQNO (Sage Open Invoices Headers) | headerseqno |
| SALESPERSONDIVISIONNO (Sage Open Invoices Headers) | salesperson_division |
| CompanyCode (Sage Open Invoices Headers) | mas90_companycode |
B. Sage Open Invoices to Sugar Open Invoices Details
| Field | Outgoing Fieldname |
|---|---|
| DROPSHIP (Sage Open Invoices Details) | drop_ship |
| EXTENSIONAMT (Sage Open Invoices Details) | extended_price |
| INVOICENO (Sage Open Invoices Details) | invoice_number |
| ITEMCODE (Sage Open Invoices Details) | item_number |
| UNITOFMEASURE (Sage Open Invoices Details) | unit_of_measure |
| UNITPRICE (Sage Open Invoices Details) | unit_price |
| id (Sugar Open Invoice Headers) | invoice_id |
| id (Sugar Open Invoice Detail) | id |
| DETAILSEQNO (Sage Open Invoices Details) | detailseqno |
| HEADERSEQNO (Sage Open Invoices Details) | headerseqno |
| CompanyCode (Sage Open Invoices Details) | mas90_company_code |
| QUANTITYSHIPPED (Sage Open Invoices Details) | quantity_shipped |
17. Sage Cash Receipts to Sugar Cash Receipts History
| Field | Outgoing Fieldname |
|---|---|
| id(Sugar Cash Receipts) | Id |
| id(Sugar Accounts) | account_id |
| BankCode (Sage Cash Receipts Source) | bank_code |
| CheckNo (Sage Cash Receipts Source) | check_number |
| CompanyCode (Sage Cash Receipts Source) | mas90_comapany_code |
| CustomerNo (Sage Cash Receipts Source) | mas90_customer_code |
| DepositDate (Sage Cash Receipts Source) | deposit_date |
| DepositNo (Sage Cash Receipts Source) | deposit_number |
| DepositType (Sage Cash Receipts Source) | deposit_type |
| SequenceNo (Sage Cash Receipts Source) | sequence_number |
| ARDivisionNo (Sage Cash Receipts Source) | mas90_division_number |
| InvoiceBalance (Sage Cash Receipts Source) | invoice_balance |
| InvoiceNo (Sage Cash Receipts Source) | invoice_number |
| CashAmountApplied (Sage Cash Receipts Source) | cash_amount_applied |
18. Sage Product Sales History by Period to Sugar Sales History by Product by Period
| Field | Outgoing Fieldname |
|---|---|
| id (Sage Product Sales History by Period) | id |
| id(Sugar Accounts) | account_id |
| ARDivisionNo(Sage Product Sales History by Period) | mas90_division_number |
| CompanyCode (Sage Product Sales History by Period) | mas90_company_code |
| CustomerNo (Sage Cash Receipts Source) | mas90_customer_code |
| ShipToCode(Sage Product Sales History by Period) | ship_to_code |
| ItemCode(Sage Product Sales History by Period) | item_code |
| FiscalCalPeriod(Sage Product Sales History by Period) | fiscal_cal_year |
| CostOfGoodsSold(Sage Product Sales History by Period) | cost_of_goods_sold |
| DollarsSold(Sage Product Sales History by Period) | dollars_sold |
| QuantityReturned(Sage Product Sales History by Period) | quantity_returned |
| QuantitySold(Sage Product Sales History by Period) | quantity_sold |
| {FiscalCalYear} -{FiscalCalPeriod} -{ItemCode}(Sage Product Sales History by Period) | name |
19. Sugar Line Item Prices to Sage Customer Price Level
| Field | Outgoing Fieldname |
|---|---|
| mft_part_num (Sugar Product Catalog) | ItemCode |
| quantity (Sugar Products) | Quantity |
| discount_price (Sugar Products) | Price |
| mas90_customer_number (Sugar Accounts) | CustomerNumber |
| mas90_company_code (Sugar Accounts) | CompanyCode |
| id (Sugar Products) | product_id |
Comments
0 comments
Please sign in to leave a comment.