 |
| CUSTOMER RESOURCES - Accounting Integration Guide |
|
Accounting Software |
Version |
SBM Version |
Integration |
Intuit QuickBooks Premiere or Enterprise1,2 |
2005 |
2.5 or later |
Full integration |
|
2006 |
2.5 or later |
Full integration |
|
2007 |
2.5 or later |
Full integration |
|
2008 |
2.5 or later |
Full integration |
| |
20098 |
2.5 or later |
Full integration |
| |
20108 |
4.0 or later |
Full integration |
| |
20118,11 |
4.0 or later |
Full integration |
| Intuit QuickBooks CA (Canadian verion) |
2010CA R38 |
4.0 or later |
Full integration |
Microsoft Office Accounting Pro |
2007 |
2.5 or later |
Full integration |
|
2008 |
2.5 or later |
Full integration |
| |
20099 |
|
|
Sage Accpac ERP |
5.4 |
3.0 or later |
Full integration |
|
5.5 |
3.0 or later |
Full integration |
| |
5.6 |
4.2 or later |
Full integration |
| |
6.0 |
4.2 or later |
Full integration |
Sage Peachtree10 |
20065 |
2.5 or 2.8 |
Subledger file import |
|
20075 |
2.5 or 2.8 |
Subledger file import |
|
20085 |
2.5 or 2.8 |
Subledger file import |
|
2009 |
3.0 or later |
Full integration6,7 |
| |
2010 |
4.0 or later |
Full integration6,7 |
| |
2011 |
4.2 or later |
Full integration6 |
Sage Simply |
2006 |
2.5 or later |
Subledger file import |
|
2007 |
2.5 or later |
Subledger file import |
|
20084 |
3.0 or later |
Full integration7 |
|
20094 |
3.0 or later |
Full integration7 |
| |
20104 |
3.0 or later |
Full integration7 |
| |
20114 |
3.0 or later |
Full integration7 |
Softrak Adagio3 |
V8.0 |
2.5 or later |
Subledger file import |
|
Notes
1.U.S. Version only
2.All editions
3.Adagio V8.1 and V9.0 have not been tested with SBM
4.Simply Premium or above
5.Support for Peachtree versions prior to 2009 are obsoleted in SBM 3.0 and later
6.Peachtree 2009 and later is supported via subledger file import in SBM 2.8 and with full integration in SBM 3.0 and later
7.SLT integration is not supported
8.Requires SBM 4.0 and later to support QuickBooks 2009 Multi-currency capabilities
9.Not yet tested with SBM
10. Includes Peachtree Quantum
11. Does not support site specification when using QuickBooks 2011 Enterprise with the Advanced Accounting Option installed and turned on.
|
|
|
Intuit
QuickBooks |
Microsoft
Office Accounting |
Sage
Accpac ERP |
|
Sage
Peachtree
Accounting |
Ability to enable/disable General Ledger, Inventory Control, and PO Invoicing functionality |
|
|
|
|
|
Read/import GL accounts from accounting |
|
|
|
|
|
Export GL accounts to accounting |
|
|
|
|
|
Export sub-ledger entries to accounting |
|
|
|
|
|
Read/import items from accounting |
|
|
|
|
|
Export items to accounting |
|
|
|
|
|
Read accounting item inventory levels |
5 |
5 |
6 |
5 |
7 |
Read/import vendors from accounting |
|
|
|
|
|
Export vendors to accounting |
|
|
|
|
|
Transfer items to/from accounting13 |
2 |
2 |
1,2 |
1 |
1 |
Export/reference SBM jobs in accounting |
3 |
3 |
|
4 |
|
Supports multiple locations in accounting |
|
|
|
|
|
Process sales orders creation of work orders and manufacturing orders |
9 |
9 |
8 |
8 |
9 |
Manufacturing orders and work orders linking to sales orders |
9 |
9 |
8 |
8 |
9 |
Direct Sales Transfers of Items and Kits linking to Sales Orders |
9,15 |
9,15 |
8,15 |
8,15 |
9,15 |
Master Production Schedule inclusion of sales inventory, sales orders, estimates/quotes, and creating pegged orders |
9 |
9 |
8 |
8 |
9 |
Schedule batch retrieve sales forecasts for sales orders and/or sales estimates/quotes |
|
|
|
|
|
Drilldown to sales order in accounting |
|
|
|
|
|
Drilldown to sales estimate/quote in accounting |
|
|
|
|
|
Create accounting invoices from SBM purchase orders |
|
|
11 |
|
12 |
Serial/lot tracking integration with accounting |
10 |
10 |
17,18 |
|
19,20 |
Multi-currency integration with accounting |
16 |
|
|
|
|
Synchronize accounting taxes |
|
|
|
|
|
Synchronize accounting currencies and rates |
16 |
|
|
|
|
Import of company databases from MISys SAE |
|
|
14 |
|
|
Notes:
- Via Inventory Adjustment
- Via Receipt/Return
- Creates Classes for corresponding Jobs. Note that Classes are created, if there is a job reference, for Period End, Sales Transfers, and PO Invoices.
- Creates Projects for corresponding Jobs. Note that Projects are created, if there is a job reference, for Period End, Sales Transfers, and PO Invoices.
- Can determine accounting item quantities on hand, on sales order, reorder level use as level for Sales Range Transfers or Replenish Sales Inventory
- Can determine accounting item quantities on hand, on sales order, projected, min, max and reorder levels use as level for Sales Range Transfers or Replenish Sales Inventory
- Can determine accounting item quantities on hand, on sales order, and min levels use as level for Sales Range Transfers or Replenish Sales Inventory
- Supports Sales Order line specific reference
- Supports Sales Order aggregate quantities only (accounting has no line references)
- Via comments on Bills/Invoices; accounting doesn’t have own SLT capability
- Cannot auto-create vendors in accounting
- Cannot associate SBM Job for the PO with a Job in Peachtree (not supported by Peachtree) on the Invoice
- Transfer to Sales includes:
- Direct Transfer to Sales of Single Items
- Direct Transfer to Sales of Kits
- Direct Transfer to Sales of Range of Items
- Work Order Transfer to Sales of line items
- Mfg. Order Transfer to Sales of completed items
- Process Sales Orders Transfer to Sales of Sales Order Items
- Flush Mfg. Inventory
- Replenish Sales Inventory
- Batch Transfer to Sales of Specific Items (added in SBM 4.2)
- Supports import from MISys SAE 5.3, 5.4, 5.5, 5.6 and 6.0 and conversion to a MISys SBM 4.2 or later company database
- Linked Sales Order references for Direct Sales Transfers only appear in Item History and used for Serial/Lot tracking update of the Sales Order
- Multi-currency capabilities requires U.S. QuickBooks 2009, or 2010 or QuickBooks CA 2010 R3.
- SBM 4.2 supports Accpac ERP SN5.3A, LT5.3, 5.6, and 6.0 Serial/Lot Tracking
- Capability added in SBM 4.0
- Capability added in SBM 4.2
- Serialized Items only; Peachtree does not support Lot Tracked Items
|
|
|
 |