Performing Invoicing group

*This section explains how the transactions can be grouped based different invoice grouping formats setup.

Invoice Proposal Form

There have been several modifications done to the Project Invoice proposal form for this feature.

Go to Project management and accounting > > Project invoices > Project invoice proposals.
Go to Project billing > All invoices > Invoice proposals.

Fields modified/added in this form are as follows:

Invoicing group – This is a new field in the General Fast Tab of the Project invoice proposal form. In this field, the invoicing group defined at the funding source will default, but the user is able to choose another invoicing group. This group determines the way transactions are grouped in the Project invoicing – split screen on this form as well as on the Invoice format.

Note – When the user changes any setup on the invoicing group that is already selected in the invoice proposal, then the invoicing group should be re-selected on the invoice proposal for the changes to reflect.

Invoice format: There is a new option added to the Invoice format drop down in the project invoice proposal form. The new option is Invoicing grouping invoice format, and will default as soon as the user selects a value in the Invoicing group field. Only when this format is selected the invoice will be displayed in the way it has been grouped with the other modifications done to the invoice format.

Invoice footer text: There is a new option added in the project invoice proposal form. The new option is ‘Invoice footer text’ where user can update the footer text and will be displayed on the invoice report.

Project invoicing: This is new fast tab on the Project Invoice proposal called “Invoice proposal transactions” which has been introduced for the users to view the invoice lines grouped based on the invoicing group setup. The content in this pane will be the same as what would be printed in the invoice. The data in this screen can be reconciled with the data that is present in the invoice proposals transactions Fast Tab.

The fields that are present in this new fast tab are as below:

• Description: Displays the description based on the definition of group by, description and order by in the invoicing group.
• Quantity: The quantity of the invoice line is displayed in this column. Quantity field is updated only for hours and item transactions.
• Sales price: Sales price of the line is displayed in this column.
• Line amount: Line amount of the invoice lines is displayed in this column.
• Note: User can enter the invoice line notes to view on the invoice report.
  

Based on the parameters selected on the invoicing group form, Main project details, grouping caption and billing details will be displayed.

All the Lines of the invoice will be displayed in the Invoice lines tab and based on the transaction type of the transactions in the invoice, new tabs will appear next to the Invoices lines tab, similar to standard behavior. The transaction types tabs could be Hour, Expenses, Items, Fees and On Account.

The add lines, create fees and view other transactions button will be available on the transaction type tabs. Also, below the transactions types, Remove, View details and Indirect components buttons will be available.

Fee Journal for rounding off amount: Due to grouping of transactions and aggregating of sales price, quantity, line amount, there are chances that there could be rounding issues. But these are not part of the invoice, so to address such rounding issues, a new fee journal would be created by the feature automatically, when there is a difference between the Invoice proposal total and the Invoicing group total. This difference is recorded in a fee journal with the fee category that is defined at the Invoicing enhancements parameter, in the field, non-printing fee category. This journal will not be part of the invoice that is printed nor part of the invoicing group display.

1. Rounding will be calculated only after the invoice body is recalculated.
2. The first check for rounding difference will calculate the absolute value of the rounding difference translated to the accounting currency.
3. Check if the rounding difference is greater than the GL rounding parameter setting.
   1. If greater, the error is:
      1. Error message: Invoice rounding of xxxx {Invoice currency} (xxxx {Accounting currency}) is greater than the General ledger rounding parameter of xxxx {Accounting currency}”. In case of error user do not post rounding fees and leave the invoice as is and tries to print or post, they will get the error.
         1. Error Message: “The Invoice document subtotal of xxxx {Invoice currency} does not tie to the Invoice subtotal of xxxx {Invoice currency}”.
   2. Check if the rounding difference is less than the GL rounding parameter setting.
      1. When using Invoicing group format that the totals tie before posting or printing. Throw an error if the totals are different.

Note – Any modifications on hour, expense and other transaction tabs automatically reflect on invoice lines tab but could take some time to recalculate invoicing groups depending upon the number of records available in the invoice proposal. We suggest users to utilize “Refresh invoice lines” button if number of proposal lines are huge out of which few of them are modified and users want these changes to be reflected on the invoice lines tab immediately. * The two types of invoice formats available in standard “format invoice proposal” feature will help users group lines in the same invoice proposal differently. * The lines added in the Summary group will show before all other lines and description will only have the Line description from the standard “format invoice proposal”. Project level and transaction level grouping is still honored. * The lines in the detail group will still behave as before with Line description in the Standard form as an extra attribute.

New button “Split advance amount” is added on the “On account” tab on invoice proposal form. When the “Split customer advance” button is clicked a new dialog form will open where user can split the customer advance amount. Once user defined the required split advance amount, defined split amount record will be created on the invoice proposal and the remaining amount will be available for further invoice proposals.

Based on the parameter “Enhanced invoice header/footer text”, new fields “Invoice header text”, “Formatted invoice footer text” and “Invoice footer text” on the project invoice proposal will be displayed.

Invoice Report

There have been several modifications done to the Project Invoice format to reflect the changes done to the invoice proposal in this feature.

Go to Project management and accounting > Project invoices > Project invoice proposals> Print preview.

Below are details of the information printed on each sections of the report.

When the ‘Progress’ parameter is marked on the project invoicing group form, new section will be printed with the details of Contract value, % progress, Earned value, Pending billing and Current billing.

When the Billing limit details parameter is marked, below fields will get displayed on the report where when there is customer retainage amount is applied for the project, these amount will not be considered in the billing limit details and on the “Earned” value of the report.

Limit – Contract value
To date – Displays invoiced amount till date
Remaining – Displays remaining amount to be invoiced comparing the contract value.