Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Return to MYOB Purchase Order Integration
Article Index
Table of Contents |
---|
Integrated Fields
The integration of MYOB Purchase Orders to Framework ECM is of MYOB Purchase Orders to Framework ECM is fixed in the content that is exchanged between the systems. There are no user-configurable integrated fields available for this type of integration.
Database Models
The following database model(s) displays the manner in which data is integrated between the third party application and Framework and Framework Integration.
...
Integration Process
The following information is a low level account of the integration process including criteria, decisions, and outcomes. This information is technical in nature and is provided "as-is" for a detailed analysis of the integration process for system administrators.
Read profile keys to determine which actions to process.
Process Cost Centres
Check “CostCentreCodeSource” profile key to decide if “CostCentres” or “Accounts” are used for Cost Centre integration
Read all eligible records from Framework table int_cCentre where
Int_cCentre.l_link_sys_gl_id = -2273 (MYOB)
Int_cCentre.l_context_id = ‘Context’ (profile key)
Int_cCentre.l_Int_cCentre_id <> 0
or each record get matching MYOB record where, depending on what was established in item i,
CostCentres.CostCentreID = Int_cCentre.s_link_cCentre or
Accounts. AccountNumber = Int_cCentre.s_link_cCentre
Update the Int_cCentre.s_link_name field
Process Suppliers
Read all eligible records from Framework table int_entity where
Int_entity.l_int_entity_id <> 0
For each record get matching MYOB record in table Suppliers where Suppliers.CardRecordID = int_entity.s_link_entity
Update int_entity.s_link_name and int_entity.s_link_reference fields
If modified, update Entity/Address/Telephone details for the Supplier
Process Purchase Orders
Get eligible Framework jobs from v_sched_dbJobOrders where
Job.s_link_boq <> ‘N/A’
Job.l_context_id = ‘Context’ (profile key, if 0 all contexts)
Job.l_wfl_stgMajor_id = -4 (Construction) or job.l_wfl_stgMajor_id = -3 (Administration) and job.l_wfl_stgMinor_id = -18 (Maintenance) or job.l_wfl_stgMinor_id = -19 (Service)
and apply order criteria where OrderCriteria is
2 – Construction Manager • Cst.l_mgr_e_id = ‘OrderCriteriaID’
3 – Supervisor • Cst.l_super_e_id = ‘OrderCriteriaID’
4 – Single Job • job.s_job_num = ‘OrderCriteriaID’
For each job get orders and items from MYOB tables Purchases, PurchaseLines, Suppliers, CostCentres, Accounts, ItemPurchaseLines and Items where
PurchaseLines.JobID = job.s_job_num (job.s_link_boq is used instead if not empty)
Purchases.PurchaseStatusID = 'OR'
Purchases.OrderStatusID <> 'T'
Purchases.PurchaseDate >= ‘StartIntegrationDate’ – 7 days
Purchases.PurchaseDate <= ‘EndIntegrationDate’ or now if endIntegrationDate is none.
Once we have the MYOB Order, see if it exists in po_order table where
Po_order.s_jobNo = PurchaseLines.JobID
Po_order.CostCentreID = CostCentres.CostCentreID (or Accounts. AccountID)
iv. And we check each MYOB Order Item, by seeing if it exists in po_item table where
Po_item.l_link_item = PurchaseLines.PurchaseLineID
Orders and items are updated or added.
After all items have been processed, a list of unmatched purchase orders is produced, aimed at their manual deletion in MYOB. This mostly applies to potential superseded work orders, which do not exist in Framework any more.
At the end of integration MYOB orders are checked to see if there are any missing (manually removed from MYOB), which need to be cancelled in Framework.