Date: 29 April 2013
Sage 300 ERP Project and Job Costing (PJC) module seamlessly integrates with the other financial and operational modules of Sage 300 ERP.
To Run PJC the mandatory modules required are System Manager, Accounts Receivable and Accounts Payable. In addition to these mandatory modules PJC integrates with General Ledger, Inventory control, Order Entry and Purchase Order module of Sage 300 ERP. PJC also integrates with US and Canadian payroll module to pass the time card entries from PJC to payroll module and calculates employee’s wages from there.
PJC Integration with Sage 300 AP and AR Module
When a billing worksheet is posted in PJC, it creates Invoice batches in Accounts Receivable; here we can edit and post the batches. We can also enter job related invoices, and credit and debit notes in Account Receivable and Accounts Payable that will update the contract in the PJC module. The customers in Accounts Receivable are stored in the PJC Contract and also Vendor from Accounts Payable is used to create a sub-contract in PJC Module.
What happens when you post job related Batch in AP or AR?
When Job Related Batch get posted in Accounts Receivable or Accounts Payable, the respective program creates a journal entry to update receivable or payable control account and also billing and Work in Progress (WIP) Accounts depending on the type of transaction. The batch will also update the project, category and/or resource (for slandered contract) in the PJC Module. Accounts Payable and Accounts Receivable also update the respective contract in PJC when job related receipt, Payment or refund is posted.
Accounts Payable also post the Retainage amount to the relevant PJC contract as commitment if tax is reported in retainage of Accounts Payable.
PJC Integration with Sage 300 ERP GL Module
PJC can directly create batches in the GL Module when we post a batch in PJC. We can choose to create the GL batch at the time of posting the batch in PJC or at later stage by “Create GL batches” function available in PJC “Periodic Processing ”. We can also select what information needs to be send when creating GL batch from PJC. GL batches can be created consolidated or with full details.
Integration with Sage 300 ERP Inventory Control Module
If Inventory Control module is in use then the WIP and Inventory Control Account will be updated for the material usage and material return transactions. Also the cost of the item used is calculated. This all will be done automatically when Day End process of Inventory Controls runs.
Integration with Sage 300 ERP Purchase Order Module
Purchase Order and receipts will update the committed and actual quantities and cost in the respective Contract, Project, category and resources in PJC Module.
Integration with Sage 300 ERP Order Entry Module
While creating the Quote in Order Entry we can also create a corresponding contract in PJC and the Quote in Order Entry will update the contract estimates in PJC. Once we post the order it will change the status of the contract from active to open. The contract will be updated for every job related shipment done. It will also do the billing for all Shipment that use project invoicing.
Cost and billing amount in Order entry will be calculated on the basis of the default method that has been set in the project maintenance form in PJC.
To Be Continue…
- #19 Sage 300 Project and Job costing (accpactips.wordpress.com)
- #20 Understanding Project and Job Costing Life Cycle (accpactips.wordpress.com)