Configure Grouping - projects360 Features Manual

Parameter Setup

On projects360 parameters from, in the Invoicing tab, Invoice enhancements group has been introduced to control this feature.

The fields available in parameters pertaining to the invoice grouping feature are as follows:

Activate invoice enhancements: Selecting this check box will activate invoicing feature.
Default invoice group: The user can pick up the invoicing group that has to be defaulted onto the funding sources in the project contract form. All Invoice groups defined in the invoice group form will be available for selection in this drop-down.
Rounding type: The user can set the rounding type options which will be applied while posting the invoice proposal. There are 3 options ‘General rounding’, ‘Rounding by project’, ‘None’. When ‘General rounding’ option is selected, fee rounding journal will get posted for the first project in the hierarchy. When ‘Rounding by project’ option is selected, fee rounding journal will get posted for the project for which rounding is raised. When ‘None’ option is selected, user will be stopped from posting.
Non-printing fee category: Fee categories, which are not of the type deferred, will be displayed in this lookup. The fee category chosen in this field would be used to create a fee journal to capture the rounding difference that may arise after grouping transactions based on the Invoice grouping. The fee journal created out of such rounding differences should not be included in the Invoice format/printing.

Note – When Fee category is selected in Non-printing fee category, make sure the ‘Resource’ field on the category is set to ‘Never’ as this journal is automatically created and posted for rounding difference.

Go to Project management and accounting > Setups > projects360 Parameters > Invoicing tab
Go to Project billing > Setups > Billing parameters > General tab

Setting up Invoice Groups

Copy invoicing group

The user would be able to copy the existing invoicing group to the new invoicing group which copies all the details from the existing invoicing group.

Go to Project management and accounting > Setup > projects360 Setup > Project invoicing group.
Go to Project billing > Setup > Project invoicing group

Header Section

The user would be able to group transaction types based on some fixed options/attributes. The settings defined in the group, would determine the way the invoice lines would be grouped to form the Invoice lines (Body section of the Invoice). Define the invoicing groups and the attributes that must be grouped on the invoices in the Project invoicing group form.

The fields available in this form are as follows:

Group name: The user can enter the name of this invoicing group.
Description: The user can enter the description of the invoicing group in this field.
Invoicing group separator: The fields in this group are:

Separator: There are several separator signs available the user can select one. This will be used to separate the description of the line, in case more than one attribute is chosen for description. For example, if the description is category and resource, then the same will be displayed as: Category, Resource name, etc.. The options of characters available are as displayed in the screenshot below:
Show Prepayment: When this check box is selected and user posts any on account or milestone transactions, then the invoice grouping interface will show records transaction type as prepayment or invoice grouping interface shows Milestone for on-account and milestone records.

Project Parent level grouping: The check boxes below this group bring in the highest level of totalling on the invoice, which is the totals at the parent project level.

Parent project heading: Marking of this check box signifies that the user would be able to group the transactions on the invoice based on each parent project separately. This can be with further grouping based on transactions and sub groups based on the setup.
Parent project total: This check box will be enabled only when the parent project grouping check box is marked. This check box when selected will total up the transactions for each parent project.
Grouping caption: The value mentioned in this field will be added as a prefix to the parent project or project while grouping.

Project level grouping: The check boxes below this group bring in the totalling on the invoice, which is, the totals at the project level.

Project grouping: Marking of this check box signifies that the user would be able to group the transactions on the invoice based on each project separately. This can be with further grouping based on transactions and sub groups based on the setup.
Project total: This check box will be enabled only when the project grouping check box is marked. This check box when selected will total up the transactions for each project.

Note – When parent project heading is marked, project grouping will be automatically turned off and vice versa.

Sub project level 1 grouping: The check boxes below this group bring in the totalling on the invoice, which is the totals at the sub project level 1.

Subproject grouping: Marking of this check box signifies that the user would be able to group the transactions on the invoice based on each sub project level 1 project separately. This can be with further grouping based on transactions and sub groups based on the setup.
Subproject total: This check box will be enabled only when the subproject grouping check box is marked. This check box when selected will total up the transactions for each subproject.

Transaction level grouping: The check boxes below this group bring in the next level of totaling on the invoice, which is, the totals at the transaction level.

Transaction type: When this check box is selected then the user interface of this form changes to transaction level, as shown in the preceding screenshot. Marking of this check box signifies that the user would be able to group the transactions on the invoice based on the transaction types such as hours, expenses, etc. Depending on this check box the attributes available for grouping changes.
Transaction total: This check box will be enabled only when the transaction type check box is selected. This check box, when selected, will total up transactions for each transaction type.
Activity roll-up: When this option is turned on then the grouping will rollup transactions to a higher activity level. When this option is turned on, then the Level field is enabled. Example: Activities are at level 2, 2.1, 2.3 and 2.4 and when this parameter is turned on with the level field set to 1, then the transactions at the lower level will all be rolled up to 2 in the above example.
Level: Level field indicates as to which level should the transactions should be rolled up to.
Cost plus rate: When this option is turned on, Cost plus rate information will be displayed on the Invoice lines and Invoice report.
Show expense quantity: When this option is turned on, expense quantity will be displayed on the Invoice lines and Invoice report.
Main project details: When this option is turned on, a line will be added with main project ID and main project description.
Progress details: When this option is turned on, new section will be printed on the invoice report for each existing main project related with the project contract invoiced.
Billing limit details: When this option is turned on, a line will be added after project group totals with details of Contract value, total invoiced value and remaining value to date.

When the transaction type check box is cleared, then the user interface changes and implies that the level of grouping transactions on the invoice is irrespective of the transaction type that it belongs to. Thus, there is a change in the options of attributes available and there is only one Fast Tab All.

Attributes

Attributes: Attributes is the basis of grouping the transactions on the invoice, it could be a category, or an activity, or a resource, based on which the transactions are being grouped. What attributes are available for grouping is decided based on the check box: Transaction type at the header level of the Invoicing group form. Either split based on transaction types or all transactions. Depending on this choice the number of Fast Tabs change.

When transaction type check box is selected, then there are Fast Tabs for each transaction type with the attributes by which the invoice can be grouped. They are below:

Hour Tab