Integrating Sage 100 with Sage Supply Chain Intelligence(formerly Anvyl) provides powerful purchase order management. You can use Sage Supply Chain Intelligence to create custom purchase order workflows and set up an order approval process that includes internal approval.
Note Sage Supply Chain Intelligence is abbreviated SSCI.
Before you get started, learn terminology differences and other integration facts.
Concept FAQs
What are terminology differences between Sage 100 and Sage Supply Chain Intelligence?
The following table lists terms in the Sage 100 user interface and their equivalents in Sage Supply Chain Intelligence.
Sage 100 and SSCI terminology comparison Sage 100 Term Sage Supply Chain Intelligence Term company
team
company name team name vendor
supplier
vendor contact
supplier contact
vendor main address (Vendor Maintenance) supplier main address
Note When adding an order in SSCI, this address can be selected in the Supplier Ship from field.
item part item vendor part supplier special item other item purchase address (A/P Purchase Address Maintenance) supplier factory address
Note When adding an order in SSCI, this address can be selected in the Supplier Ship from field.
ship-to address (P/O Ship-To Address Maintenance)
ship-to location
Note When adding an order in SSCI, this address can be selected in the Ship-to field. Edit the address in Company Settings > Team Settings > Ship-To Locations.
comment on P/O detail line (/C) purchase order note terms code payment term unit of measure units
Note Edit the units in Company Settings > Team settings > Orders > Other order settings > Supported units of measure.
About Purchase Order types
In Sage 100, you can create the following types of purchase orders: Standard Order, Drop Ship, Master Order, Repeating Order, Material Requisition, and Quote.
There are no purchase order types in Sage Supply Chain Intelligence. Instead, order statuses describe the different states of a purchase order in Sage Supply Chain Intelligence.
About Purchase Order statuses
Sage 100 uses the following purchase order statuses to describe the state of an order:
- New: The order is new.
- Open: When a new order is printed, the order status changes to Open.
- Change: When an existing order or back order is being modified and a change order must be printed for the vendor, select the Change status.
- Received: An order is automatically assigned this status when the order is completely received in Receipt of Goods Entry.
- Back Order: If one or more lines on the order have a back-ordered quantity of greater than zero, the order status changes to Back Order.
- Completed: When an order in Received status is invoiced and the Daily Receipt Registers/Update process is run, the order status changes from Received to Completed.
Sage Supply Chain Intelligence uses the following purchase order statuses to describe the state of an order:
- Draft: The order is new.
- Active: After an order is issued, the order is emailed to supplier contacts and others defined in the workflow, and the order status changes to Active.
- Canceled: This status cancels an active order.
- Completed: All workflow steps are done.
Sage Supply Chain Intelligence auto-generates purchase order numbers with the following default settings:
- Static text prefix: A
- Dynamic element: Auto-incrementing number
Minimum digits: 6
Next number: 1
Order number example: A000001
Data sync FAQs
The Sage 100 service user performing data syncs must be assigned a role with the following tasks permission.
Minimum tasks permission (view) required for Sage 100 tasks L/M Company Maintenance
C/I Miscellaneous Item Maintenance
A/P Vendor Maintenance
P/O Ship-To Address Maintenance
A/P Terms Code Maintenance S/O Sales Order Entry (if the Sales Order module is installed)
Maximum tasks permission (create, modify, remove, view) required for Sage 100 task P/O Purchase Order Entry
First-Time sync from Sage 100 to Sage Supply Chain Intelligence
Purchase orders created in Sage 100 must meet specific criteria to sync to Sage Supply Chain Intelligence.
In a first-time sync, Sage 100 standard and drop-ship purchase orders that have an order status other than Received or Completed are uploaded and assigned the Draft order status in Sage Supply Chain Intelligence.
Sage 100 master orders, repeating orders, and material requisitions do not sync to Sage Supply Chain Intelligence.
Note You can use the following options to set additional requirements that determine if standard and drop-ship purchase orders sync from Sage 100 to Sage Supply Chain Intelligence.
- Use the Allow Sync for Sage Supply Chain Intelligence check box in Vendor Maintenance to determine if purchase orders for a specific vendor sync from Sage 100 to Sage Supply Chain Intelligence.
- Use the Sync to Sage Supply Chain Intelligence check box in Purchase Order Entry to determine if a specific purchase order syncs from Sage 100 to Sage Supply Chain Intelligence. If this check box is selected and the purchase order syncs to Sage Supply Chain Intelligence and then the check box is cleared, the purchase order in SSCI will be canceled upon the next scheduled sync or when the Sync Now button is clicked in the Sage Supply Chain Intelligence Setup app.
The following table details first-time sync scenarios.
First-Time Sync Scenarios: Sage 100 to SSCI Sage 100 PO Order Status Sage 100 PO Order Type Will Sage 100 PO sync to SSCI? SSCI Order Status New Standard, Drop Ship Yes Draft Open Standard, Drop Ship Yes Draft Back Order Standard, Drop Ship Yes Draft Change Standard, Drop Ship Yes Draft Received Standard, Drop Ship No - Complete Standard, Drop Ship No - Any Master Order No - Any Repeating Order No - Any Material Requisition No - Subsequent syncs from Sage 100 to Sage Supply Chain Intelligence
The following table details subsequent sync scenarios. These scenarios assume the purchase order has synced with Sage Supply Chain Intelligence before.
Subsequent Sync Scenarios: Sage 100 to SSCI Sage 100 PO Order Status Sage 100 PO Order Type Will Sage 100 PO sync to SSCI? SSCI Order Status New Standard, Drop Ship Yes Any, except Canceled Open Standard, Drop Ship Yes Any, except Canceled Back Order Standard, Drop Ship Yes Any, except Canceled Change Standard, Drop Ship Yes Any, except Canceled Received Standard, Drop Ship Yes Any, except Canceled Complete Standard, Drop Ship Yes Any, except Canceled
Orders must meet specific criteria to sync from Sage Supply Chain Intelligence to Sage 100. For example, an order created in Sage Supply Chain Intelligence that is in Draft status will not sync to Sage 100.
The following table details sync scenarios from Sage Supply Chain Intelligence to Sage 100.
SSCI to Sage 100 Sync Scenarios SSCI Order Status Has PO synced with Sage 100 before? Will PO sync to Sage 100? Sage 100 PO Order Type Sage 100 PO Order Status Draft No No - - Active No Yes Standard New Complete No Yes Standard New Canceled No No - - Draft Yes Yes Any Any Active Yes Yes Any Any Complete Yes Yes Any Any Canceled Yes Yes Any Any, except Change Deleted Draft Yes Yes Any Any, except Change Note 1 If an order line is being edited in Sage Supply Chain Intelligence when a data sync occurs, the change will not sync to Sage 100.
Note 2 If a good is received in Sage Supply Chain Intelligence, the change will not sync to Sage 100.
The following Sage 100 information is not synced:
- inactive vendors
- inactive items
- discount
- freight
- taxes
- invalid miscellaneous items, charges, or comments that cannot be used on Sage 100 purchase orders
- If the Allow Sync for Sage Supply Chain Intelligence check box is cleared in Vendor Maintenance, purchase orders for the selected vendor are not synced.
- If the Sync to Sage Supply Chain Intelligence check box is cleared in Purchase Order Entry, the selected purchase order is not synced.
The vendor contact must have an email address to sync to Sage Supply Chain Intelligence.
Special items display in the Other items section on the Order detail in Sage Supply Chain Intelligence.
