Monthly Archives: April 2013


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…


1 Comment

Posted by on April 28, 2013 in Accpac Hot Fix


Tags: , ,

#20 Understanding Project and Job Costing Life Cycle

Date: 21 April 2012

In Sage 300 PJC the work flow starts by building a contract in the system. Contract represents an agreement with the customer to do certain work for a give price in a certain period of time. Contract records various projects that define the work that needs to be done for the costumer and in turn are also the revenue stream. Further the cost incurred to accomplish the projects is recorded in categories and Resources under project.
Contract maintenance form is used to assign project to a contract and to assign categories and resources to each project in the contract. In Sage 300 PJC contract, projects and category terminology can be setup as per the company and industry where PJC implemented.


Contract, Project and category (or Resources) need to be identified for each cost detail. Sage PJC will consolidate the cost at the project and contract level and further match the coat with revenue to get the profitability.
The PJC process starts with setting up contract in the system. This involves setting up contract, Projects and categories. Here we can put estimates and approve it to open the contract at each project level. As we can see in the dataflow diagram below how transactions are flowing to complete the PJC life cycle. It also explains the various transactions involve at each step.


Cost Transaction is processed against each category and resources under project and contract, PJC match revenues to the cost that generate them. Contract of each project is the point where it is specified where to recognised revenue, how to bill to the customers.
To be Continue…



1 Comment

Posted by on April 21, 2013 in ERP, Sage 300 ERP, Sage 300 ERP PJC


Tags: , , ,

#19 Sage 300 Project and Job costing

Date: 2 April 2013

Sage ERP Project and job costing (PJC) module is a project management module to assist organizations in developing plans, estimates, assigning resources to tasks, tracking progress, managing budget, costing, billing and analyzing workload so that Work can be delivered on time and be in budget only to be more profitable.
If in an organization where project managers are spending too much time on tracking there projects and related activities then it will be a wise choice to go for Sage ERP 300 PJC Module. Benefit will not only that all project managers will able to track and maintain their projects at a central place but also get lot of added advantage in term of budgeting, estimating, allocate resources, cost and billing to be name few. Not only it will eliminate the time spend by project managers to track projects they are working on but also it will help to consolidate all the project company is working, so consolidated reporting can be generated, hence provide an eagle eye to the decision makes so that better decision making can be done.
Sage PJC assist to maintain categories that are easily customized to meet virtually any specification needed, it’s flexible enough to manage large or small projects for any business environment. Featuring streamlined integration with key Sage ERP 300 modules and extensive custom reporting capabilities, Project and Job Costing puts you in control of project costs with better tracking, enhanced efficiency, and greater accuracy.
With PJC you can:

• Keep track of committed against actual costs with Purchase Order integration.
• Set up, track, and maintain jobs at multiple levels of detail.
• Quickly assign staff, material, subcontractors, equipment, miscellaneous items, and overheads to each project within each job.
• Track and bill inventory items by contract, project, or category as well as by cost types.
• Track and bill equipment usage by contract, project, or category.
• Empower employees to easily manage their own time and billing records using an Internet browser anywhere.
• Manage and track time spend by people on various projects
• Mix and match accounting methods to fit any job or project from very complex to very simple.
• Automatically generate invoices based on the transactions that are due to be billed.
• Easily review contract or project changes and instantly update revenue and cost estimates.
• And Much More!!!

PJC Module integrates seamlessly with other key Sage ERP system modules like Purchase order, Account Receivable and General Ledger. This will insure that you can control your job revenue and cost with PJC more effectively and efficiently.

In nut sell you can keep your eye on the bottom line with extensive, robust analytical capabilities. With Project and Job Costing, you can track retainage, calculate overhead, gauge profitability, and access numerous analytical reports. At the micro-level, you’ll be able to spot errors, inconsistencies,
or overages before you’ve sent the final bill. And at the macro-level, you’ll be able to understand what kinds of jobs tend to earn you the highest margin, which kinds of jobs are draining your resources, and why.

To be continue …



Posted by on April 9, 2013 in ERP


Tags: ,

%d bloggers like this: