This module is used to maintain projects and sub-projects (unlimited levels), allow transaction entries and reports by the project.
First, go to Tools > Then, go to Program Control > Next, move to Module Setting
After that, check the checkbox of Project to enable it.
First, go to General Maintenance > Then, move to Project Maintenance
After that, click on the New Top Level Project to add a main project.
Then, click to highlight a main project, and click on New Sub-Project to add a sub-project to it.
Note: A Top Level Project (parent project) that carries Sub-Projects (child projects) must not have transaction entries. All entries must be assigned to child projects; all entries in child projects will be summarised to their parent project in reports.
You may further highlight a sub-project (e.g. P1A) and click on New Sub-Project to create a sub sub-project (e.g. P1A-001), in which sub-project P1A will be the parent project to P1A-001; this can go on to as many levels as you wish.
First, go to Tools > Then, click on Options > Next, go to General > and last, go to Miscellaneous
Now, click on the drop-down button of the Default Project to select default project for this account book. As the result, you will notice that only those projects that have no child/sub-project are listed for selection; because a project carries sub-project(s) is a parent project, and a parent project must not have any direct transaction entries.
Default Project by User
First, go to General Maintenance >Then, go to User Maintenance
Then, click on Edit User
Now, click on Default Value tab,
Lastly, assign default project for this user, and then click on Save.
Transaction / Billing
You will notice that ‘Project’ field/column appears in all types of transaction; and ‘default project’ is automatically assigned (amendable).
A/R Invoice Entry
Reports Filtered By Project
Most of the reports can be filtered by projects.
For financial reports, several report formats related to project are made available.
To view financial reports of project for a period more than 12 months, go to Tools > Then, go to Manage Fiscal Year and change the End Date of most current fiscal year.
Opening Balance of Projects
First, go to G/L > Then, go to Opening Balance Maintenance
Those opening balances I have keyed in earlier (before projects are maintained) or were not assigned with any project are classified as opening balance for Default Null Project.
To key in or edit opening balances for a project (restricted to project that has no child project attached to it), including Default Null Project, click to highlight a project, then click on Edit Detail Opening Balance.
To maintain Year-To-Date opening balance, go to G/L > Year-To-Date Balance Maintenance
Click on the … button of project to select a project, click on Inquiry to key in or edit balances.
G/L Posting Options
First, go to Tools > Then, go to Options > Next, go to G/L > and then, go to G/L Posting
There are 3 options that will affect G/L entries:
Allow Not Balance By Project and Department In Journal Entry: this is to allow the system to save a Journal Entry that involves more than one project (and it is ‘not balanced’ by project). If this option is not checked, the following message will be prompted and the journal entry is not allowed to save (when individual project is not balanced).
Post By Project and Department In Payment, Contra, Refund: to post entries according to project assigned during (AR/AP) Payment, Contra or Refund, instead of according to project(s) of the bills to be knocked off. If this checkbox is unchecked, the posting will be in accordance with the project(s) of the bills to be knocked off. When this checkbox is not checked, and a partial payment is made to knocked off an Invoice consists of several items with different projects, the knock off will take place from one item to another in sequence order.
Post By Project and Department In CN: to post entries according to project assigned during (AR/AP) CN, instead of according to project(s) of the bill to be knocked off. If this checkbox is unchecked, the posting will be in accordance with the project(s) of the bills to be knocked off.
First, go to Tools > Then, go to Options > Next, go to Invoicing > After that, go to Customize Invoicing 2
Enable ‘Post Reallocate Purchase By Project’ in Invoice, Cash Sale, D/N and Stock Issue: this means when stock is issued with these documents by project, the items involved (which when purchased was assigned with another project or null project) will be reallocated according to the project(s) of these documents. A journal entry will be created to reallocate (move) the related amount of purchases from one project (e.g. null) to the newly transacted project.
Budget by Projects
First, go to G/L > Then, click on Budget Maintenance
Then, Click on New/Edit, (you may maintain as many sets of budget as you wish)
Next, click on the … button next to Project field,
And then click on Inquiry,
(Note: each selected project must be followed by a click on Inquiry to refresh.)
Project Profit Margin Report
Then go to G/L > Then, go to Project / Department Profit Margin Report
Now, define filter options and click on Inquiry.