Invoicing Projects
During the life of a Project, Project costs from Resource Usage, materials, and Project-related purchases can accumulate. As the Project progresses, these transactions get posted to the Project Journal. It is important that all costs get recorded in the Project Journal before you invoice the customer.
You can also purchase external Resources unrelated to a Project, for example, to invoice a Vendor for work delivered. You would need to set up a Vendor as an External Resource, For more information on setting up an external resource, see Record Purchases.
You can create invoices on the Project from the Project Plan page, from the Invoice Suggestions page for Fixed Price or T&M contract type Projects, or from the Sales Invoice page. Invoicing can be done after the Project is finished or at certain intervals during the Project's progress based on a billing schedule or on a Percent Complete basis.
Note
If you select Billable in the Project Line Type field on the purchase documents for Project-related purchases, the system creates Project transaction lines that are ready to be invoiced to the customer.
Sell-To, Bill-to and Ship-to Addresses
For information on the Project Card Bill-to defaults and where they are used, see:
Bill-to and Ship-to Address Defaults
Video: Project Card Bill-to & Sell-to Functionality in Progressus
Billing Method Options
There are many ways that customers can set up billing options with Progressus. You can define billing methods for each Project, or even at the Task level. Options include Fixed Price, T&M (Time & Materials), and Percent Complete.
In the Project Plan > Project Subform tab, there is an option to create Tasks with a Contract Type of either Fixed or T&M (and a Project can be mixed - some Tasks as Fixed and some Tasks as T&M.
In the Project Card the invoicing Type can be set for Resources, Items, or Expenses to invoice using Fixed, Time & Material or Percent Complete. For Fixed and Time & Material Projects, invoices can be created using Create Project Invoices see: How to create Project Invoices, Sales Invoices see: Direct Invoicing - Sales Invoice or Invoice Suggestion, and for Percent Complete, invoices can be created using the Percent Complete Billing page (see: Percent Complete).
As budgets are created for these Tasks on Projects, amounts increment in in the Total Budget Cost (LCY) field of the Project sub-form. As you post Usage amounts against a Task, amounts increment in the Total Usage Cost field in the Project sub-form. The difference between the budgeted amounts and Usage costs displays in the Difference field. When invoices are created, there are factors in the Project configuration to determine what method is used for determining when it is time to invoice the Project.
Create AIA compliant billing with Progress Billing
Billings can be generated for construction Projects in a format similar to that approved by the American Institute of Architects (AIA). Based on forms 702G and 703G, Progress Billing provides the ability to enter the details for a construction billing into the first request for payment. Subsequent requests for payment for the same Project only require the maintenance of the line-item completion percentage, quantity completed, and stored material amount. For more information on creating AIA billings see: AIA Billing
Fixed Price
Defines all Expense entries as not-chargeable entries and invoices the payments entered. Non-chargeable entries always can be changed to chargeable in the Timesheet Entry page and the Project Journal or just before creating invoices.
Milestones
With Fixed Price billing, Milestones can be set up to invoice the Project for predetermined amounts when certain Tasks are completed that are tied to Milestones in the Project. Note that the Milestones can prevent a Scheduled Billing from being created if the Status is not completed.
Once a Task is completed, the associated Milestone can be manually set to the status of Finished. This allows payment to be posted (generate an invoice) with Scheduled Billings for the associated Milestone.
To Create a Milestone
Navigate to the Project Card > Project > Milestones.
Click New to create a new Milestone.
Field Name Description Milestones Specifies the Milestone Code used for the line item for this Milestone entry. Description Specifies the Description used for this Milestone entry. Date Specifies a Date used for this Milestone. Creation Date Specifies the date the Milestone entry was created. Created By Specifies the User that created the Milestone entry. Modification date Specifies the date the Milestone entry was most recently modified. Modified By Specifies the User that most recently modified the Milestone entry. Cancel Specifies, if selected/true, that the Milestone entry is canceled. Cancel Date Specifies the date the Milestone entry was canceled. Cancelled By Specifies the User that canceled the Milestone entry. Finished Specifies, if selected/true, that the Milestone entry is finished. Finished Date Specifies the date the Milestone entry was finished. Finished By Specifies the User that finished the Milestone entry. Postponed Specifies, if selected/true, that the Milestone entry is postponed. Postponed Date Specifies the date the Milestone entry was postponed. Postponed By Specifies the User that postponed the Milestone entry. Percent Complete Value Specifies the completed portion of the Milestone, relative to the total of all Milestones for the Project, as determined by the user. The total value of the column cannot exceed 100%. Overall Completion % Calculates the Overall Percent Complete for the line. Allow Billing Before Completion Specifies if related Scheduled Billings are allowed to be posted without this Milestone entry needing to be finished. If Finished is selected, the percent complete is changed to 100%. Click Close
Milestone Completion Percent FactBox
| Field Name | Description |
|---|---|
| Description |
Specifies information about the Milestone. |
| Percent Complete Value | User entry, displays the completed portion of the Milestone relative to the total of all Milestones for the Project. |
| Overall Completion % | Calculates the Overall % Complete of all the lines, based on the calculation example shown below. |
| Total Percent Complete | Displays the total of the Percent Complete Value entries. The amount cannot exceed 100%. |
Example calculation for WIP Calculation Based On set to Milestone:
| Milestone | Weighted Value | % Complete |
|---|---|---|
| Milestone 1 |
0 |
100 |
| Milestone 2 | 20 | 100 |
| Milestone 3 | 50 | 30 |
| Milestone 4 | 30 | 10 |
| Milestone 5 | 0 | 0 |
Total % Complete Calculation:
| Milestone | Weighted Value x % Complete | % Calc. % Complete |
|---|---|---|
| Milestone 1 |
0 x 1.00 |
0% |
| Milestone 2 | 20 x 1.00 | 20% |
| Milestone 3 | 50 x .30 | 15% |
| Milestone 4 | 30 x .10 | 3% |
| Milestone 5 | 0 x 0 | 0% |
Total % Complete Calculated = 38%
Allocations
To Finish a Milestone
Navigate to the Project > Actions > Setup > Milestones
Select the Finished checkbox on the Milestone you wish to finish.
Click Yes to the message "Finish Milestone?"
Click Close
Note
After the Milestone is finished, the system updates the Finished checkbox to selected, updates the Finished Date with the date the Milestone entry was finished, and updates the Finished By field with the user that finished the Milestone entry.
Scheduled Billing
Scheduled Billings gives the opportunity to set up invoice scheduling. It is only used if Fixed is chosen for either Resource, Item or Expense on the Invoicing Fast Tab of the Project Card. Scheduled Billings can be set up to be tied to Project Milestones (or Tasks/phases of a Project) so that once a Task/Milestone is completed, the Scheduled Billing will create an Invoice Suggestion to generate an invoice.
Set up Scheduled Billings
Navigate in the Project to Actions > Setup >Scheduled Billings.
Create a unique Code for each Scheduled Billing cycle.
Select the Payment Type - either Task or Proforma.
If the Payment Type is Task, the Scheduled Billing is associated with completion of a Task.
If the Payment Type is Pro forma the customer is invoiced when the date defined in the Budget Date field is reached.
Cost Amount: Cost amount can be used if salespeople receive commission on their sales.
Amount: The value of the Payment Amount that will be used for the Scheduled Billing.
Budget Date is a required field to run the Update Budget process.
Update Budget from the Scheduled Billing
When all Payment lines are set up, choose Update Budget. This automatically transfers the payment plan to the Project Task lines and updates the Scheduled Billing Budget - Price (LCY) field in the Budget if a Task line was chosen. The total Payment for the Project can be seen in Statistics.
Click OK once you receive a message "Budget updated". The Payment Budget - Price (LCY) field for each Task in the Project Plan updates with the amounts created in Scheduled Billings.
- Once a Milestone is finished and the Scheduled Billings process is run to Post Scheduled Billing, it sends an update to the Invoice Suggestion process, which creates an entry allowing that Scheduled Billing to be invoiced. For more information on Invoice Suggestion functionality see Invoice Suggestion
Important
A Scheduled Billing cannot be posted for payment until the associated Milestone is set to Finished
Time & Material (T&M)
Resources will be billed based on Time/Material Usage entries, such as Timesheet entries, Items, and Expense Sheet entries.
Percent Complete
The system calculates the Percent Complete by Project or Task and has a field that sums up the entries by Resource, Items, and Expenses. The system generates the Percent Complete preview invoice and final invoice from the Percent Complete Billing page found on the Role Center > Processing > Billing > Percent Complete Billing.
Setting up a Project with Percent Complete billing
When creating a Project, either manually, or with the Create Project Wizard. to bill the Project or Task(s) with the Percent Complete method, select the Resource Invoice Type, and/or Item Invoice Type and/or Expense Invoice Type as Percent Complete. These options can also be edited later in the Project Card or Task Card in the Invoicing FastTab.
On the Project Card and/or Task Card, for % Complete Billing set the options to enable or disable:
| Field Name | Description |
|---|---|
| Resources % Complete |
If enabled, Resource Usage is included in Percent Complete calculation for billing. |
| Item % Complete | If enabled, Item Usage is included in the Percent Complete calculation for billing. |
| Expenses % Complete | If enabled, Expense Usage is included in the Percent Complete calculation for billing. |
| NOTE: An example would be Resource and Item costs billed using Percent Complete and Expenses billed based on Time and Material. Percent Complete calculation can be made based on cost, or quantity and can include select or all cost types (Time/Expenses/Items). | |
| % Complete Override | If enabled, the user can override the calculated Percent Complete for billing. |
| % Complete Based on | Select either cost or quantity that the Project uses when calculating Percent Complete. |
| % Complete Billing Level | Select the billing level for Percent Complete billing. |
| Project Summary | Requires you to specify a Percent Complete Task and allows a Contract Amount to be specified. If Contract Amount is not specified, the Budget Entry prices are used to calculate the Contract Amount. |
| Project Detail | Requires a Percent Complete Task be entered and Budget Entries are required to calculate the Contract Amount. |
| Task Summary | Specifies a Contract Amount that can be entered for each Task, otherwise, if left blank, the Budget Entry prices are used to calculate the Contract Amount. |
| Task Detail | Requires Budget Entries to calculate the Contract Amount for each Task. |
| Not Applicable | Specifies, if selected, that Percent Complete billing should be turned off for this Project. The Project will be excluded from the calculation if the billing process is run. |
| % Complete Task | Identifies the Task to use when Percent Complete is calculated at the Project Level. Only editable if % Complete Billing level is Project-Summary or Project-Detail, otherwise it is blank and not editable. |
| Contract Amount | Specifies the Contract Amount or price for the Project. Contract Amount can only be specified for Project summary billing level. If not specified, Budget Entries are used to calculate the Contract Amount. Contract Amount for each Task can be specified on the Task Card when Task Summary is selected. |
| Contract Invoicing Account | Specifies the required G/L Account to use when billing level is Project Summary and is only available if a Contract Amount has been entered. |
Percent Complete Billing page overview
Use the Percent Complete Billing page to calculate and load Percent Complete billing amounts with filters. This page also shows current and past calculation and the amount to be billed.
The Percent Complete Billing Page can be accessed from the Role Center > Processing > Billing > Percent Complete Billing. This gives the opportunity to review Percent Complete billings for all Projects. To review for one Project, use a filter to specify one Project. Another way to review Percent Complete billings for one specific Project is to select the Project from the Projects List, then navigate to Billing > Percent Complete Billing.
Important
The Calculation Date cannot be greater than the current date.
To Calculate the Percent Complete
Click Calculate % Complete.
An Options page opens. Enter the date to use for the calculation of Percentage Complete. The date cannot be greater than the current date. When opening from the Project menu, the Project No. will default on the calculate page. Other filters may be added, such as Task Code, Customer No., Project Manager and Billing Level.
Click OK.
Click OK to message "Percent Complete Billing is Calculated".
Review the calculation:
Field Name Description Project No. Specifies the Project to be used for this Percent Complete billing. Task Specifies the Task Code to be used for this Percent Complete billing. Calculation Date Specifies the date used for calculations. Change Order Identifies this Task as a Change Order. Project Description Specifies Task number information for this line. % Compl. Billing Level Specifies the Percent Complete billing level for this line. % Complete Based On Specifies the calculation value on which Percent Complete is based, either Cost or Quantity. Type Specifies the Type of entry. For Summary billing levels, this value will be All. For Detail billing levels, this value will be Resource, Item or Expense. No. to Invoice Specifies the Resource, Item or Expense Code related to this entry. No. to Invoice 2 Specifies the Resource Group related to this entry. This field is only filled when the Type is Resource Sub Group. Detail Description Specifies information about the Code in the No. to Invoice 1 field, i.e., Resource name, Item description, Expense Type. This will be filled only for Project detail or Task detail billing levels. Budget Qty Specifies the Budget Quantity for this line. This value is used to calculate the Percent Complete if the Project has the Percent Complete based on Quantity. Actual Qty Specifies the actual Quantity for this line. This value is used to calculate the Percent Complete if the Project has the Percent Complete based on quantity. Budget Total (LCY) Specifies the total budget, in local currency, for the Task associated with the Percent Complete billing line (based on resource/expense/item Percent Complete selection on the Task). The budget total represents the total budget amount. This value is used to calculate the Percent Complete if the Project has the Percent Complete based on cost. Actual Total (LCY) Specifies the actual total usage, in local currency, for the Task associated with the Percent Complete billing line (based on resource/expense/item Percent Complete selection on the Task). The actual total represents the total usage cost. This value is used to calculate the Percent Complete if the Project has the Percent Complete based on cost. Contract Amount (LCY) If the Project billing level is Project summary, this specifies the Contract Amount, in local currency, assigned to the Project. If the billing level is Task summary, this specifies the Contract Amount assigned to the Task. For Project detail and Task detail billing levels, the Contract Amount is set to the budget total price. % Complete Total Specifies the calculated complete percentage for the billing line as actual total cost/budget total cost or actual quantity/budget quantity, depending on the Percent Complete basis, cost or quantity, for the Project. Total (LCY) Specifies the % Complete Total value times the Contract Amount. % Complete Prior Specifies the total Percent Complete for this line that was previously billed. Total Percent Complete Override Specifies the Percent Complete used as a manual override for the calculated Percent Complete. Prior Invoiced (LCY) Specifies the total dollar amount previously billed for this line. % Completed this Invoice Specifies the difference between the Percent Complete total and the Percent Complete prior. Percent Complete Overridden Indicates that the Percent Completed field for this invoice has been manually changed. To be invoiced (LCY) Specifies the current amount to be invoiced based on the percent completed this invoice. Retention % Specifies the Retention Percentage, if any, from the Project/Task billing line. Retention Amount (LCY) Shows the calculated Retention Amount for the current billing. Created Document No. Specifies the Invoice Number created when the Generate % Complete Invoice process is run. Note
If the % Complete Override option was enabled on the Project or Task Card, the Percentage Complete amount that is calculated can be edited.|
Go to Project No. field and click on the ellipsis. Select More. Mark all the lines to be included on the invoice.
Note
If Task Detail is the Percent Complete billing Level and a line is selected for a Task, then all lines with that Task No. must be included.
Use the Generate Percent Complete Invoice option to create the invoice, including Retention calculations.
Click OK to the message "Percent Complete Invoice process has successfully finished".
Click Show Document to display the Percent Complete Sales Invoice. The Created Document No. is now populated with the Sales Invoice No.. The Quantity will always be 1 with no Group/PM Lines. If changes need to be made, delete the invoice, and start over the calculation process from the beginning.
Select Preview to see the invoice that is sent to the customer accompanied by the Summary Invoice.
Post the Sales Invoice using regular posting procedures.
Tip
Calculations are based on a fixed Contract Amount on the Project/Task Card or on a Budget price.
Training Videos - Percent Complete
For more information on setting up and processing Percent Complete invoices, see:
Percent Complete Billing - Part 1 - Overview, Setup & Configuration
Percent Complete Billing - Part 2 - Calculating and Printing Percent Complete Invoices
How transactions are marked as available for billing
| Field Name | Description |
|---|---|
| Chargeable |
Transactions in the system are available for invoicing based on the Chargeable field on the transaction line in the Project Ledger, the Invoice Suggestion page, or the Sales Invoices page. If selected, the transaction will be included in billing (both Fixed Price and Time and Material Projects). If Chargeable is deselected, it is not included for billing. This field can be modified during invoicing process, if necessary, to appropriately handle a specific transaction. |
| Open | Each transaction has an Open field. This field is not visible in Invoice Suggestions or Sales Invoices but can be viewed in the Project Ledger. If this checkbox is selected, the transaction is available for billing. Once a transaction line is fully billed the Open field is automatically deselected by the invoicing process. |
| Remaining Amount | Each transaction has a Remaining Amount field. This field is not visible in Invoice Suggestions or Sales Invoices but can be viewed in the Project Ledger. This amount indicates the amount that has not been invoiced yet. If there is a partial invoice of a transaction line, the Remaining Amount contains the portion that has not been invoiced. |
Invoice Setup Template
The Invoice Setup Template selected on a Project defines the format that is used when creating Sales and Project invoices and how content will be displayed on the invoice when printed. It defines this information based on the type of billing record such as Items, Expenses, Scheduled Billings, Resources, and Resource Groups. It is also possible to define a fixed heading or text between invoice lines by using the type of Heading. Each Project that is invoiced is required to select an Invoice Setup. The setup can be done by manually entering Invoice Setup Lines, creating the setup from a template, or importing an Invoice Setup Template.
It is important to set up this Invoice Setup Template on the Project - otherwise it is not possible to get Project Ledger Entries for sales invoicing
Invoice Setup - Template Lines
For information on how to setup Invoice Setup Templates for Project or Contract invoicing, see: Create Invoice Setup Templates.
How to create Project Invoices
There are a several different ways to create Project invoices. Billing options can be accessed through the Role Center > Processing > Billing, or from a specific Project by navigating to the Project Plan > Billing.
Options:
- Role Center > Invoicing > Sales Invoice
- Role Center > Invoicing > Subscription Orders
- Role Center > Contracts > Contracts > Billing
- Role Center > Processing > Billing > Scheduled Billings
- Role Center > Activities > Retention Invoicing
- Role Center > Invoicing (Tile) > Invoice Suggestions
Create Project Invoices page
Use Create Project Invoices to manually create Project invoices. Create Project Invoices is available from the Role Center > Processing > Billing > Create Project Invoices or the Invoice Suggestion page. It is also available from the Projects List, the Project Plan, or the Project Card > Billing > Create Project Invoices.
The Create Project Invoices page allows additional filters to be added to generate the invoice as required. Invoices can be split based on Usage Type and Customer. The Invoice creation can also be filtered by date, Project, Customer, etc. If a filter is not selected, invoices for all Projects are created.
| Field Name | Description |
|---|---|
| Usage |
The Usage section designates which Usage lines to be included on the invoice. If you have designated on the Task to use for 'Use posted currency' of the transaction, this process may result in multiple invoices if transactions originate in different currencies. For instance, if one transaction line is USD and another transaction line is CAD, then USD and CAD invoices will be created separately. Select the following to select specific Types to include. All is the default. If All is deselected, the user can select or deselect Entry Types. If deselected, the Entry Type will not be included on the invoice. |
| All: Specifies, if selected (true) to include all entries in the invoice. | |
| Scheduled Billings: Specifies, if selected (true) to include Scheduled Billings Invoice entries in the invoice. | |
| Resource: Specifies, if selected (true) to include Resource entries in the invoice. | |
| Items: Specifies, if selected (true) to include Items entries in the invoice. | |
| Expenses: Specifies, if selected (true) to include Expense entries in the invoice. | |
| Charge Specified Customer | The Charge Specified Customer section can be used to invoice the Usage entries to each customer connected to the Project Entries, and not the customer that owns the Project. For example, if there are two posted Project Entries to two different Customers, the system will create two invoices – one to each Customer. |
| Scheduled Billings: Specifies, if selected (true) to include Scheduled Billings Invoice entries in the invoice. | |
| Resource: Specifies, if selected (true) to include Resource entries in the invoice. | |
| Items: Specifies, if selected (true) to include Items entries in the invoice. | |
| Expenses: Specifies, if selected (true) to include Expense entries in the invoice. | |
| Miscellaneous | The Miscellaneous section allows additional options for filtering which Project invoices are included when using Create Project Invoices to generate invoices: |
Tip
For more information on Invoice Resource Specifications report and setup, see: Invoice Resource Specifications Setup
| Headings with resource specifications: If selected (true), specifies that Headings with Resource Specifications will be included in the invoice. |
|
| Use Invoice Suggestion: If set to true, Project application method, must be Manual. If true, the invoice will use adjusted prices in Project entries. |
|
| Add to existing document if exist?: If selected, and if a document for Project Bill-to Customer already exists, then the entries to invoice will be added to that document. | |
| Only one invoice per customer?: If selected, if more than one Project to same Bill-to Customer, then all Project entries will be invoiced in the same document. |
The lines on the Sales Invoice created by the Create Project Invoice process will be grouped and formatted according to the Invoice Setup specified on the Project.
Change Sales Invoice Lines: Transaction lines that flow to the Invoice can be modified or removed prior to posting the invoice. If a line is deleted from the Invoice, it becomes available in Invoice Suggestions for the next invoice. A transaction line may also be partially billed from the Invoice page. For example, if the quantity is 5 on the invoice, the line can be modified to have a quantity of 3. The remaining 2 units will be available in the Invoice Suggestions page for the next invoicing cycle. The remaining 2 units can be closed if the 'Apply and Close (Job)' box is checked for that transaction line resulting in the 3 units being billed the remaining 2 will not be billed unless reopened.
Also, the invoice can be deleted prior to posting. If deleted all the Invoice Suggestion Lines are made available and the invoice can be recreated. This is valuable if the Invoice lines format does not match the format required. The unposted Invoice can be deleted, the Invoice Setup modified, and the Invoice Creation process can be re-run, as needed.
Change PM Sales Invoice Lines: If an invoice is created from a Project where the Invoice Setup contains compression (example - date compression), the Sales Invoice contains entries of type PM. This indicates that there are underlying individual entries.
The line can be modified by highlighting it and selecting Line > PM Line Entries. The sales line entries can then be modified.
Note
The sales entry closes the Project Ledger Entry only if the sales price is higher than or equal to the remaining amount on the Project Ledger Entry. It can, however, be closed if the price is not higher to or equal to the remaining amount by clicking Apply and Close (Job).
After leaving the form, the values in the PM Sales Invoice lines are updated.
Invoice Suggestion
Invoice lines are usually reviewed on the Invoice Suggestion List page. The Invoice Suggestion page can be used to review all Projects at the top-level Projects menu:
Navigate to the Role Center > Processing > Billing Invoice Suggestion List.
Invoice Suggestions can also be accessed in each individual Project. To access Invoice Suggestions from a specific Project:
Navigate to the Projects List and select the desired Project.
Navigate to Billing >Invoice Suggestion List
Transactions are listed in this page if the Open box is selected, the Chargeable box is selected and there is a value in Remaining Balance.
Each transaction has an Approved check box. Project Managers can approve the transactions lines individually in the Invoice Suggestion Lines FastTab. Project Managers can also designate the entire Invoice as approved by setting the Approved Boolean value to on/true in the General Fast Tab.
Invoice Suggestion – General FastTab
- The General FastTab in Invoice Suggestion provides general information about the Project being viewed:
Note
The following 2 fields (Global Dimension 1, or Global Dimension 2) are only displayed if Progressus Multi-Company is activated. For more information, see: MEM and Progressus Multi-Company Integration Documentation
| Field Name | Description |
|---|---|
| Global Dimension 1 |
Specifies the code for Global Dimension 1. |
| Bill-to Customer No. | Specifies the billing Customer Number for the Project. |
| Bill-to Name | Specifies the customer's name associated with the Bill-to Customer No. for the Project. |
| Project Manager | Specifies the Project Manager of the Project. |
| Invoice Setup Created | Specifies, if yes/true, that the Invoice Setup for the Project is created. |
| Approved | Specifies, if yes/true the entire invoice as Approved. |
Invoice Suggestion – Invoice Suggestion Lines FastTab
Transaction lines available for invoicing are listed in the Invoice Suggestion Lines FastTab. Transactions are listed in this FastTab if the Open checkbox is selected, the Chargeable checkbox is selected and there is a value in Remaining Amount.
Once the items are selected to determine the amount to invoice, to create the invoice from the suggested lines, select Process > Create Invoice. In the Create Project Invoices options page, select additional options to exclude or include types (such as Resources, Items, Expenses, etc.) in Usage, Charge Specified Customer or Miscellaneous.
| Field Name | Description |
|---|---|
| Type |
Specifies the type of Project Ledger entry this will be Resource, Expense, Payment, or Item. |
| Project Task No. | Specifies the number of the Project Task associated with the Project Ledger entry. |
| No. | Specifies the value related to the type for the Project Ledger entry line. This will be either a Resource, Expense, Payment, or Item. |
| Posting Date | Specifies the posting date of the Project Ledger entry. |
| Created Document No. | Specifies the Invoice Number of non-posted invoices for these lines. If invoice is created, the line is not editable. |
| Postpone to Date | Specifies the postpone to date of the Project Ledger entry. Field is not directly editable but can be updated by using the Postponed tab > Postpone functionality. For more information, see: Postponed. Setting a Postpone to Date equal and greater than the Posting Date filter will result in the billing line not being available to bill until the Postpone to Date. |
| Description | Specifies a free-form text information about the transaction. |
| Lot No. | Specifies the Lot Number for an Item Usage posted to the Project Ledger where the Item has Lot Number tracking enabled. |
| Serial No. | Specifies the Serial Number for an item usage posted to the Project Ledger where the item has Serial Number tracking enabled. |
| Chargeable | Specifies, if true, that the entry will be charged to the customer. |
| Approved | Specifies, if true, that the entry has been approved for invoicing to the customer. |
| Hide in Spec | Specifies that this line will not be printed in the Invoice Resource Specification. |
| Close Line | Specifies, if selected, that any remaining balance should be written off and applied and the line closed. |
| Quantity | Specifies the quantity from Project Ledger entry. |
| Quantity to Invoice | Specifies the quantity that will go to Sales Invoice. |
| Qty. Posted Invoice | Specifies the quantity posted to invoice. |
| Qty. Unposted Order/Invoice | Specifies the quantity unposted to invoice. |
| Quantity Unposted Credit Memo | Specifies the quantity unposted to credit memo. |
| Remaining Quantity | Specifies the remaining quantity, from the Project Ledger, to be billed. |
| Unit Price to Invoice | Specifies the unit price that flows to Sales Invoice. |
| Unit Price (LCY) to Invoice | Specifies the Unit Price (LCY) that flows to Sales Invoice. |
| Total Price to Invoice | Specifies the total price that flows to Sales Invoice. |
| Total Price to Inv. (LCY) | Specifies the Total Price (LCY) that flows to the Sales Invoice. |
| Remaining Amount | Specifies the Remaining Amount, from the Project Ledger entry, to be billed. |
| Remaining Amount (LCY) | Specifies the Remaining Amount (LCY), from the Project Ledger entry, to be billed. Calculated as the Total Price less what has been billed. |
| Invoices Exist | Specifies, if true, that the user can click the link in the field, and the system will display the posted Sales Invoice/Credit Memo for the line. |
Important
If Only one invoice per customer option is selected in the Create Project Invoices options page, and Invoice Suggestion is configured to create multiple invoices and if there is more than one Project and more than one Invoice Setup exists, the setup that is used for the created invoices is the setup for the first Project alphabetically.
Invoice Suggestion Line - Tabs
The tabs in the Invoice Suggestion Line section provide a quick way to do mass updates to Invoice Suggestion Lines, such as setting them to closed, or setting the Chargeable or Approved Status on multiple lines at one time.
Chargeable
| Field Name | Description |
|---|---|
| Chargeable tab > Chargeable |
Use the Chargeable tab > Chargeable box to enable the Chargeable field on all selected lines in the Invoice Suggestion Lines grid. If an entry is selected in the line and the Chargeable box is unselected, the entry is set to non-chargeable and removed from the Invoice Suggestion Line grid. It can be viewed by navigating to the Related Information >Non-Chargeable Entries page. |
Approved
| Field Name | Description |
|---|---|
| Approved tab > Approved |
Use this field to select the Approved field on all selected lines in the Invoice Suggestion Lines grid. Once entries that require approval are marked as Approved, they can be included in invoices when the Process > Create Invoice is run. |
| Approved tab > Unselect Approved | Use this field to deselect the Approved field on all selected lines in the Invoice Suggestion Lines grid. Once entries that require approval have the Approved box deselected, they will not be included in invoices when the Process > Create Invoice is run. |
Hide in Spec
Hide in Spec specifies that any selected lines will not be printed in the Invoice Resource Specification.
| Field Name | Description |
|---|---|
| Hide in Spec > Select Hide in Spec | Use this field to select the Hide in Spec box on any selected lines. |
| Hide in Spec > Unselect Hide in Spec | Use thus field to deselect the Hide in Spec box on any selected lines. |
Close Line
| Field Name | Description |
|---|---|
| Close line | This feature allows the user to close Project entries and write off balances in either Invoice Suggestions or the Project Ledger. Partial invoicing does not close a line - a line is closed when fully invoiced (the last invoice). Use the Close Line feature to close these partially invoiced lines. Once the Close Line process is run, the Close Date and Close Entry number fields are populated in the Project Ledger Entries. |
Scenarios that will close a Project entry are:
Full invoicing of a transaction.
Partial invoicing using Close Line in Invoice Suggestions.
Uncheck Chargeable.
Use Move Entries with Audit.
Options are selected in Project Setup > Management FastTab > Apply and Close When field. -Qty to Invoice changed.
- Remaining Quantity is zero or below.
- Remaining Quantity or amount is zero or below.
- For more information on the Apply and Close When settings, see: Project Setup - Management FastTab
Important
The Close Invoice Line can only be used on Project entries where the Entry Type is Usage, the Chargeable field is selected (true), the Open field is selected (true), the Unit Price field is not zero, and if the Create Document No. is not populated.
Invoice Suggestions
Option 1:
Invoice Suggestions > Actions > Close Invoice Lines. Select the transaction lines from the Invoice Suggestion Lines section of the page by placing the cursor on the line to be invoiced, or for more than one entry by clicking on the ellipsis and choosing Select More, then click on the circle next to each line to be closed.
From the ribbon, select Actions > Close Invoice Lines.
Select Yes to the message "Are you sure you want to close the selected lines?"
Option 2:
Use the Invoice Suggestions process to write off partial quantities. Multiple lines can be closed at the same time, whether or not an invoice is being created for any remaining lines.
Invoice Suggestions > Invoice Suggestion Lines > Close Line > Select Close Line to check the Close Line box on selected lines.
Use the Close Line > Unselect Close Line to uncheck the Close Line box on selected lines.
Once the Invoice Suggestion process is run, a Write-off transaction is created in the Project Ledger. The write-off entries and original usage/sales entries are applied and closed. If the line is not being invoiced (just closed), after selecting Close Line, choose Process > Close Invoice Lines.
Option 3:
If the line is not being invoiced (just closed), after selecting Close Line, choose Process > Close Invoice Lines.
Project Ledger Entries
To close lines in Project Ledger Entries, select the transaction lines to close by placing the cursor on the line to close, or for more than one entry by clicking on the ellipsis and choosing Select More, then clicking on the circle next to each line to be closed.
From the ribbon, select Close Invoice Lines.
Select Yes to the message "Are you sure you want to close the selected lines?"
Note
The Open checkbox is not selected for each line closed.
To see the Write-off transaction, highlight the entry that was closed and then select More Options > Related > Navigate > Show Detailed Ledger Entries. A negative quantity displays in the Value to Invoice field and negative Total Price and Line Amounts. The quantity will be the same, the Line Amount will be the write-off amount.
Note
Once a line is closed, it cannot be reopened. An adjustment would need to be created.
Tip
Close Line is not allowed on Scheduled Billing lines. For these transactions, a negative line must be created in Scheduled Billing so that WIP can calculate correctly on the full amount.
Close by Date
If a line is closed due to the full invoice of a transaction, the Close Line process will be the Invoice Date from the Sales Invoice when it was fully invoiced.
If the line being closed is for a partial invoice the Close Line process will be the Posting Date from the Sales Invoice as the Close by Date.
If the Invoice Suggestions or Project Ledger Entries > Close Invoice Lines process is run for full quantity on a Project entry line, the Close Date will use the Work date.
If a partial invoice is closed using the Invoice Suggestions or Project Ledger Entries > Close Invoice Lines, the Close Date will be the Work date for the adjustment entry that is created.
If the Chargeable field is unchecked, the Close Date will be the Work date.
If the Move Entries with Audit process is run, the Close Date is populated as follows:
If the original transaction is non-chargeable, the new entry will also be non-chargeable. The Move Entry process has 2 options for Date Selection: Original Posting Date or New Posting Date (user-entered date) – for the Closed by Date on the original Project Ledger entry. The Closed by Date on the new entry is not populated.
If the transaction is chargeable, the new entry will also be chargeable. The Move Entry process has 2 options for Date Selection: Original Posting Date or New Posting Date (user-entered date) – for the Closed by Date on the original Project Ledger entry. The Closed by Date on the new entry is not populated. The date chosen on the Move Entry will be used for the Posting Date.
Closed by Entry No.: Specifies posted Invoice Entry Number that closed the original transaction.
For information on using the Close Line with WIP functions, see: WIP Processing - Close Date and Close Entry No.
Postponed
Use the Postponed tab to postpone a billing line to a specified date you choose. When the Postponed tab > Postpone is selected, the Postpone Project Ledger Entries pages opens.
| Field Name | Description |
|---|---|
| Postpone to Date |
Specifies the date to postpone the billing of these usage entries. |
| Postpone Formula | Specifies the formula for the number of days or months to postpone the billing of this item. For example, to postpone all selected usage entries to 1 month from their current Postpone to Date, enter +1M. |
Tip
Either use the Postpone to Date or the Postpone Formula, but not both, to set a value in the Postpone to Date field in the Invoice Suggestion Lines. If both fields are used, the system will use the Postpone to Date field.|
Important
The Postpone to Date cannot be set to earlier than the usage line's Posting Date.| |Filter: (Project (Job) Ledger Entry| Filters can be added to further narrow the scope of the results that are included in the Postpone action.|
Click OK to set a value in the Postpone to Date field for any selected lines.
| Field Name | Description |
|---|---|
| Revert Postpone Date |
Use the Postponed tab > Revert Postpone Date to change the current Postpone to Date values back to their original Postpone to Date values for any selected lines. |
Actions
| Field Name | Description |
|---|---|
| Comments |
Use the Comments field to add notations to billing lines. |
| Attachments | Use the Attachments field to add attachments to billing lines. |
Ribbon options
Process
| Field Name | Description |
|---|---|
| Create Invoice |
Use Create Invoice to generate invoices from the selected billing lines in the Invoice Suggestion Lines FastTab. |
| Close Lines | Use Close Lines to close selected billing lines from the Invoice Suggestion Lines FastTab. |
Resource Prices
For information on Resource Prices, see: Set up Resource Prices
Resource Costs
For information on Resource Costs, see: Set up Resource Costs
Expense Prices
For information on Expenses Prices, see: Project Expense Prices
Invoice Setup
For information on Invoice Setup, see: Invoice Setup Template
Project Statistics
The Project Statistics page provides an overview of costs and invoices on a specific Project. It also provides a summary of approved and unapproved amounts on the Project. The page also includes a comparison between Usage Cost, Budget Cost and Balance Remaining.
| Field Name | Description |
|---|---|
| Cost |
provides summary amounts for Resource Usage Cost, Item Usage cost, Expense Usage Cost and Total Usage Cost – and is broken out by usage cost and budget cost, as well as transactions balances. |
| Usage Cost: | |
| Resource Usage Cost: Specifies the summary amount for Resource Cost - Usage and Budget transactions. | |
| Item Usage Cost: Specifies the summary amount for Item Cost - Usage and Budget transactions. | |
| Expense Usage Cost: Specifies the summary amount for Expense Cost - Usage and Budget transactions. | |
| Total Usage Cost" Specifies the summary amount for Total Cost - Usage and Budget transactions. |
Invoice provides a summary of Payments, Items, Resources, Expenses and Totals, broken down by:
| Field Name | Description |
|---|---|
| Project Turnover |
Specifies the summary amount for lines which are usage transactions that have the Chargeable box checked. |
| Invoiced | Specifies the summary amount for previously billed records. |
| Suggestion | Specifies the summary amount for Invoice Suggestion lines included on this page that are open and chargeable. |
| Rem. Amount | Specifies the remaining amount to be invoiced. |
| Retention Amount | Specifies the retention amount for the invoice. The amount withheld from an invoice until a Project, Task or Milestone is completed. |
| Approved | provides a summary of Approved and Not Approved Amounts in the Invoice Suggestions Lines FastTab. |
| Approved Amount | Specifies amount approved in Invoice Suggestion Lines FastTab. |
| Not Approved Amount | Specifies amount not approved in Invoice Suggestion Lines FastTab. |
Non-Chargeable Entries
The Non-Chargeable Entries page contains all transactions that are no longer marked as chargeable. If a transaction is displayed in Invoice Suggestion and the Chargeable box is unselected, that transaction will move to the Non-Chargeable Entries page. The transaction can be moved back to the Invoice Suggestion Lines FastTab by selecting the Chargeable field.
Invoiced Entries
To view invoiced entries, select Related Information from the ribbon > Invoiced Entries.
Project Billing FactBox
The Project Billing FactBox is accessible from the Invoice Suggestion page by clicking the Expand FactBox Pane icon 
The Project Billing FactBox provides a summary of how much is being invoiced, broken down by Resources, Expenses, Items, Schedule Billing, and Retention.
Direct Invoicing - Sales Invoice page
Invoices may be created for Projects manually from the Sales Invoices page.
Navigate to the Role Center > Invoicing > Sales Invoices.
Select New to create a new Sales Invoice.
Populate the Customer Name and the Project No. fields in the General FastTab.
Populate any other fields in the General FastTab information as appropriate.
Navigate to Actions > >Functions > Get Project Usage.
In the Get Project Usage page, select which options and filters to use to retrieve Project Usage based on what should be invoiced (i.e., Payments, Resource, Items, Expenses). To retrieve Usage for a specific Project, be sure to expand the Filter: Project section and add a Project Number.
Select OK and the Project postings will import into the sales lines.
Important
If Use Customer Split (located in the Project Card > Invoicing FastTab) is selected for the Project, Create Project Invoices must be used to create invoices. For more information on Customer Split Billing, see: How to create a Project Card, Customer Split Billing.
Calculate Sales Retention
Sales Retention is an amount that is calculated as a percentage of a Sales Invoice transaction line that the customer may withhold from their payment. This is often done to ensure the customer's satisfaction with a Project or Task before they make final payment.
Sales retention can be specified on the Customer page > Invoicing FastTab > Project Retention %. A Retention percentage can also be added on the fly during Sales Invoice creation by specifying a value in the Retention % field on each line on the Sales Invoice.
To create Sales Retention on a Sales Invoice:
Navigate to Sales Invoices and create a Sales Invoice.
Enter a percentage to retain in the Retention % field.
Once the invoice lines are entered, select Actions > Functions > Calculate Retention.
A new line with a description of "Retention For:..." is added to the Sales Invoice for the retention percentage entered and appears as a negative or offset to the original invoice amount.
Once the Sales Invoice is posted, the retention line will appear on the Sales Retention report.
Retention Invoicing
The retention amounts that were withheld when the original Sales Invoice was created can be billed by using the Retention Invoicing page. Retention Invoicing is accessed from the Role Center > Approvals & Activities > Retention Invoicing.
Important
It is important to note that there are two different kinds of retention. This article covers Sales Retention, which are amounts withheld from a customer's invoice and billed later. Subcontractor Retention are amounts that can be withheld from payments to subcontract vendors. For more information on Subcontractor Retention, see: Setting up Subcontract Retention
Create Retention Invoice
Open Retention Invoicing from the Role Center.
General: Select filters to narrow the displayed results.
- Customer No.
- Project No.
- Start Date
- End Date
Sales Retention Lines: Select the transaction lines from the bottom section of the page by placing your cursor on the line to be invoiced, or for more than one entry by clicking on the ellipsis and choosing Select More, then click on the circle next to each line to be billed.
Field Name Description Posting Date Specifies the date the billing transaction was posted. Created Document No. Specifies the Sales Invoice number for the Retention prior to posting. Project No. Specifies a unique identifier for the Project. Type Specifies the Posting Type as G/L Account. Customer No. Specifies the number of the Customer on the transaction. No. Specifies the Sales Retention G/L Account number for posting. Project Task No. Specifies a unique identifier for the Task. Description Specifies information about the Sales Retention line. This line is generated during system Sales Invoice creation by using Actions > Functions > Calculate Sales Retention. Quantity Specifies the quantity. Line Amount Specifies the amount of the Retention billing line.
Select Create Invoice from the menu.
The Edit page will open, review the information for accuracy.
Click Close.
On the View - Created Sales Documents page, click Show Document to view or post the Sales Invoice.
After taking action on the Sales Invoice, return to the Retention Invoicing page. The page may be filtered. Exit and reopen to see all Retention lines.
Invoicing Contracts
If several Projects are linked to a Contract, the system can generate one invoice that includes data from all the linked Projects. For more information on Contracts, see: Contracts module
This process should be initiated from the Contracts > Contracts > Billing Create Invoice menu. The Contract Invoice Setup Template must be completed before the Contract Invoice can be created.
Important
For more information on Contract Invoice Setup Templates, see: Invoice Setup Templates for Projects and Contracts
Similar filter options are available as with the Create Project Invoices page. The functionality is the same as invoicing from an individual Project with respect to compression, etc. Invoices can be generated using the normal Project invoicing page if desired rather than using the Contract. If the normal Project invoicing is used, then each Project linked to the Contract will create its own invoice. This functionality is beneficial if the purpose for using the Contract is related to tracking budgets and costs instead of billing Projects together.
Create a Sales Credit Memo from a Posted Sales Invoice
- Navigate to the Role Center > Invoicing > Sales Credit Memos.
- Click New from the menu to create a new Sales Credit Memo.
- Enter a Customer No for the Sales Credit Memo.
- Click Prepare > Get Posted Document Lines to Reverse. This feature will copy one or more posted sales documents to reverse the original order.
- The Posted Sales Document lines page opens. the top of the page includes filters for narrowing results.
Posted Sales Document Lines
Options - use fields to filter results returned when searching for posted sales documents from which to create the Sales Credit Memo.
| Field Name | Description |
|---|---|
| Show Reversible Lines Only |
Specifies if only lines with quantities that are available to be reversed are shown. For example, on a posted Sales Invoice with an original quantity of 20, and 15 of the items have already been returned, the quantity that is available to be reversed on the posted Sales Invoice is 5. |
| Return Original Quantity | Specifies whether to use the original quantity to receive quantities associated with specific shipments. For example, on a posted Sales Invoice with an original quantity of 20, you can match the 20 items with a specific shipment. |
| Document Type Filter | Select from Posted Shipments, Posted Invoices, Posted Return Receipts, or Posted Credit Memos. |
Highlight one or more lines from the results pane and click OK.
The selected lines are copied into the Sales Credit Memo.
Select Home > Post > Post to post the Sales Credit Memo.
Tip
For more information on processing sales returns, see: Process Sales Return Orders
Create a Sales Credit memo
If the customer wishes to return items or get a credit for Resource hours a Sales Credit Memo can be created. The Sales Credit Memo is also used to record a fee or correct an invalid invoice.
The Sales Credit Memo is created like a Sales Quote, a Sales Order, or a Sales Invoice.
From the Role Center, navigate to Invoicing > Sales Credit Memo.
Select New to create a new Sales Credit Memo.
General FastTab
| Field Name | Description |
|---|---|
| Customer No. |
Specifies the number of the Customer on the Sales Credit Memo. |
| Customer Name | Specifies the Name associated with the Customer Number for the Project. |
Sell-to
| Field Name | Description |
|---|---|
| Address |
Specifies the Customer where the Sales Credit Memo will be sent. |
| Address 2 | Specifies additional address information. |
| City | Specifies the city of the Customer on the sales document. |
| State | Specifies the State, Province, or County of the Customer on the sales document. |
| Zip Code | Specifies the Postal Code of the Customer on the sales document. |
| Country/Region | Specifies the Country/Region Code of the Customer on the sales document. |
| Contact No. | Specifies a unique identifier for the contact person to whom the sales document will be sent. |
| Phone No. | Specifies the telephone number of the contact person to whom the sales document will be sent. |
| Mobile Phone No. | Specifies the mobile telephone number of the contact person to whom the sales document will be sent. |
| Specifies the email address of the contact person to whom the sales document will be sent. | |
| Your Reference | Specifies the Customer's reference. The content will be printed on sales documents. |
| Posting Date | Specifies the date when the posting of the sales document will be recorded. |
| Document Date | Specifies the date when the related document was created. |
| Due Date | Specifies when the related Sales Invoice must be paid. |
| External Document No. | Specifies a document number that refers to the Customer's or Vendor's numbering system. |
| External Project No. | Specifies information about an external related Project. |
| Salesperson Code | Specifies a code for the Salesperson who normally handles the Customer's account and contract. |
| Campaign No. | Specifies the number of the Campaign to which the document is linked. |
| Responsibility Center | Specifies the code of the Responsibility Center, such as a distribution hub, which is associated with the involved User, Company, Customer, or Vendor. |
| Assigned User ID | Specifies the ID of the User who is responsible for the document. |
| Status | Specifies whether the document is open, waiting to be approved, has been invoiced for prepayment, or has been released to the next stage of processing. |
| Project No. | Specifies a unique identifier for the Project associated with the Sales Credit Memo. |
| Project Manager Code | Specifies the Resource Number of the person in charge of the Project. Must be a Project Executive or Project Manager. |
| Applies-to Doc. Type | Specifies the type of the posted document that this document or journal line will be applied to when posted. |
| Applies-to Doc. No. | Specifies the number of the posted Document that this document or journal line will be applied to when posted. |
| Applies-to ID | Specifies the ID of entries that will be applied to when choosing the Apply Entries action. |
| Work Description | Allows free form text entry of information about the work. |
Lines Subform
| Field Name | Description |
|---|---|
| Manage tab |
|
| Insert Ext. Text | Select to insert the Extended Item Description that is setup for the Item that is being processed on the line. |
| Dimensions | View or edit Dimensions, such as Area, Project, or Department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history. This governs how revenue made with this sales document is deferred to different accounting periods when the document is posted. |
| Functions tab | |
| Get Return Receipt Lines... | Select a posted return receipt for the item to which you want to assign the Item charge. For example, if you received an invoice for the item charge after you posted the original return receipt. |
| Line tab | |
| Item Availability by | Allows you to view the availability of an Item by Event, Period, Variant, Location, Lot, or BOM Level. For more information, see: View the Availability of Items |
| Comments | Add or view comments for the record. |
| Item Charge Assignment | Record additional direct costs, for example, for freight. This action is available only for Charge (Item) line types. |
| Item Tracking Lines | View or edit serial and lot numbers for the selected Item. This action is available only for lines that contain an Item. |
| PM Line Entries | Displays a detail of the sales line information. |
| Attachments | Add a file as an attachment. You can attach images as well as documents. |
Fields in the Lines Subform
| Field Name | Description |
|---|---|
| PM Group |
If selected (true), specifies that Items, Expenses or Resources are being grouped. For more information, see: Create Invoice Setup Templates. |
| Type | Specifies the type of transaction that will be posted with the document line. If you select Comment, then you can enter any text in the Description field, such as a message to a customer. |
| No. | Specifies an identifier, such as name or number, for the Type. |
| Item Reference No. | Specifies a Customer's or Vendor's alternate identification number for the Type = Item (for example, the Vendor's part number). |
| Description | Specifies a description of the entry, which is based on the contents of the Type and No. fields. |
| Location Code | Specifies the inventory Location from which the Items sold should be picked and where the inventory decrease is registered. |
| Quantity | Specifies how many units are being credited. |
| Unit of Measure Code | Specifies how each unit of the item or resource is measured, such as in pieces or hours. By default, the value in the Base Unit of Measure field on the Item or Resource Card is inserted. |
| Unit Price Excl. Tax | Specifies the price for one unit on the sales line. |
| Tax Area Code | Specifies the Tax Area that is used to calculate and post sales tax. |
| Tax Group Code | Specifies the Tax Group that is used to calculate and post sales tax. |
| Line Amount Excl. Tax | Specifies the net amount, excluding any invoice discount amount, which must be paid for products on the line. |
| % of Split Billing | Specifies percent of the split billing on the Sales Invoice line. |
| Amount Including Tax | Specifies the sum of the amounts in the Amount Including Tax fields on the associated sales lines. |
| Line Discount % | Specifies the discount percentage that is granted for the Item on the line. |
| Qty. to Assign | Specifies how many units of the Item charge will be assigned to the line. |
| Qty. Assigned | Specifies the quantity of the Item charge that was assigned to a specified Item when you posted this sales line. |
| Project No. | Specifies the number of the Project. |
| Project Task No. | Specifies the number of the related Project Task. |
| Expense Code | Specifies the specific Expense being charged. |
| Expense Resource No. | Specifies the Resource for which the expenses are incurred. |
| Expense Date | Specifies the Resource for which the expenses are incurred. |
| Use Payment | Specifies, if true, there was a previously invoiced payment. |
| Payment | Specifies the Scheduled Billing associated with the Use Payment option on the line. If the Credit Memo is created based on previously invoiced payment you MUST check the Use Payment field and choose the payment in the drop down. If this is not done the return of the Payment will not update correctly. |
| Hour Bank No. | Specifies the number of any Hour Bank associated with the line. |
| Apply and Close (Project) | Specifies, if selected (true), to close the Project Ledger Entry that results from the Sales Credit Memo line. |
| IMPORTANT: The Project Ledger Entry will close the only if the sales price is higher than or equal to the remaining amount on the Project Ledger entry. It can, however, be closed if the price is not higher to or equal to the remaining amount by clicking the Apply and Close Project checkbox. For more information on Apply and Close, see: Project Setup - Management FastTab. | |
| Retention % | Specifies the percentage to withhold from an invoice amount until a specific Project, Task or Milestone is completed. Once the percentage is entered, any invoice generated would retain that percentage until the Retention is manually released. |
| Work Type Code | Specifies the Work Type to be used. |
| Shortcut Dimension 1 | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in General Ledger Setup. |
| Shortcut Dimension 2 | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in General Ledger Setup. |
If the Credit Memo is created based on previously invoiced payment you MUST check the Use Payment field and choose the payment in the drop down. If this is not done the return of the Payment will not update correctly.
Note
Sales Credit Memos are generated by Invoice Suggestion when the total of all transaction lines included in the Invoice Suggestion Lines is negative. If the total of all the transaction lines in the Invoice Suggestion Lines is positive, an invoice is created.
This entry will also be available to flow back through to invoicing if it is not applied and closed.
Posting the Credit Memo will generate a G/L entry. The Project Plan is also updated in the Invoice Price column to reflect the return. The transaction will show on the Project as a Sale Entry Type.
Currency Hierarchy in Progressus Invoicing
When creating invoices using different currencies, it's important to understand the hierarchy of where and how Progressus pulls the currency to use on the invoice. For more information on the Progressus currency hierarchy, see: Progressus Currency Hierarchy
How to post Sales invoices
When the Sales invoice is posted, the Usage line is closed with a corresponding sales line. Additionally, the invoice lines move from the Invoice Suggestion FastTab to the Non-Open Entries FastTab and the remaining amount is reduced to zero.
To post the Sales Invoice after it is created, select Posting > Post and then select Yes to the message "Do you want to post the invoice?". The posted invoice can be viewed in the next window by clicking Yes to the message "The invoice is posted as number "xxxxxx and moved to the Posted Sales Invoice window. Do you want to open the posted invoice?"
Calculate and post WIP entries
When you have completed all activities for a Project, including Usage posting and invoicing, the Project must be updated to have a Status of Completed, then, clear any WIP that has been posted to the General Ledger. For information on WIP methods, see: Understanding WIP Methods
Hour Bank Billing
The Hours Bank FastTab in Project Setup is used to set up a Number Series and Liability Account Number to allow entry of an amount or block of time against a Project for future use. An example would be a Project where a customer pre-purchases a block of support time. As Project usage occurs, Timesheets are posted against the Hour Bank. This reduces the prepaid amount in the Liability account and books it to a Revenue account.
Video
Progressus Hour Bank Overview - This video provides an overview of Hour Banks, along with the configuration, setup, and processing of Hour Bank transactions.
Set up the Hour Banks feature
Navigate to the Role Center > Actions > Setup > Project Setup > Project Setup.
Expand Hour Bank FastTab.
| Field Name | Description |
|---|---|
| Hour Bank Nos |
Specifies the numbering sequence to use for Hour Banks. |
| Hour Bank Prepaid Account No | Specifies the prepaid account to which Hour Bank entries are posted after running the Hour Bank Post GL process. This account is reduced as time is consumed against the Hour Bank via posted Timesheet Entry or Time Journal entries. |
Setup a Resource for use with the Hour Bank
For more information about setting up a Resource for use with the Hour Bank, see: Set Up Resources
Create an Hour Bank for a Customer Project
- Use the
icon to navigate to the Hour Bank List.
Hour Bank General FastTab
| Field Name | Description |
|---|---|
| Description |
Specifies information about the Hour Bank. |
| Description 2 | Specifies additional information about the Hour Bank. |
| Hour Bank Type | Specifies if the banked value should be in hours or an amount. |
| Allow Non Chargeable | Specifies, if true, that non chargeable time can be posted to the Hour Bank. |
| Search Description | Specifies text to find a specific Hour Bank in a search. |
| Salesperson Code | Specifies the Salesperson Code related to this Hour Bank. |
| Last Date Modified | Specifies the last date changes were made to the Hour Bank. |
| Blocked | Specifies, if true, that the Hour Bank will be blocked from transaction posting. |
| Remaining Quantity | Specifies the quantity not used from the invoices posted to the Hour Bank. |
| Remaining Discount | Specifies the discount amount remaining to be applied from posted invoices. |
| Remaining Balance | Specifies the remaining balance before discounts, of invoices posted to the Hour Bank. |
| Net Remaining | Specifies the net amount remaining to be applied from posted invoices. |
| Remaining Discount (LCY) | Specifies the discount amount in local currency remaining to be applied from posted invoices. |
| Remaining Balance (LCY) | Specifies the remaining balance in local currency, before discounts, of invoices posted to the Hour Bank. |
| Net Remaining (LCY) | Specifies the net amount remaining, in local currency, to be applied from posted invoices. |
Posting FastTab
| Field Name | Description |
|---|---|
| Customer No. |
Specifies the Customer Number for the Project to which the Hour Bank is connected. |
| Customer Name | Specifies the name of the Customer Number for the Project to which the Hour Bank is connected. |
Related Information
To determine which of these Customer's existing Projects are included in the banked hours, select Related Information > Valid Projects. there is not a limitation on using the hours on just one Project, as the hours banked can be used on multiple Projects.
Hour Bank Valid Projects
Click New to add a Project to Hour Bank Valid Projects.
| Field Name | Description |
|---|---|
| Project No. |
Click the ellipsis to select the Project(s) included in the banked hours, amount |
| Description | Specifies a short description of the Project and defaults from the Project Card Description field. |
| Use Hour Bank No. Default | Specifies, if true, that the Hour Bank No. field in Timesheet Entry |
Create a Sales Invoice to add Amount or Hours to an Hour Bank
Navigate to the Role Center and from the top menu, select Invoicing > Sales Invoices.
Click New to create a new Sales Invoice.
Enter or lookup the Customer Name for the Project connected to the Hour Bank.
In the Lines grid, change Type to Resource.
Select the Resource assigned to the Hour Bank from the No. list.
Enter the Quantity of hours being booked for the Hour Bank. If the Hour Bank is based on total hours, when Resource time is posted to the Hour Bank, the system will adjust the amount per hour based on the Sales Invoice.
Tip
Example: The Sales Invoice is for hours and the amount per hour is 200 USD. When the Resource Timesheet Entries are posted to the Hour Bank, the per hour rate will be 200 USD, regardless of the regular price charged for the Resource. If the Sales Invoice is for amount, then the Resource Price does not have to be adjusted. When the total charges of the time entries reach the total value of the Hour Bank, the system will prevent time entries from being submitted or posted.
Field Name Description Project No. Specifies the number of the related Project. Task No. Specifies the number of the related Project Task. Navigate to the Hour Banks field and select the Hour Bank from the list.
Post the invoice by selecting Posting > Post from the ribbon.
To view the update to the Hour Bank for the Sales Invoice, navigate to Hour Bank List, and select the Hour Bank used in the Sales Invoice. The General FastTab displays the remaining quantity and balances. The Hour Bank Fact Box also displays the original hours banked and the remaining quantity.
Hour Bank Post GL: To post the Hour Bank transaction to GL, see: Hour Bank Post GL
To view the update to the Hour Bank for the Sales Invoice, navigate to Hour Bank list, select the Hour Bank used in the Sales Invoice. The General FastTab displays remaining quantity and balances. The Hour Bank Fact Box also displays original hours banked, and remaining quantity.
Using Quantity or Amount from an Hour Bank
Navigate to Timesheet Entry in the Role Center.
Tip
You can also use the Time Journal to enter hours against an Hour Bank, using the Hour Bank No. field to decrease the value of the Hour Bank.
Create a Timesheet, select the Hour Bank No. for the Customer and valid Project to which Usage will be charged.
Enter either a quantity or amount to deduct from the Hour Bank, depending on how you set up the Hour Bank Type.
Submit, approve, and post the Timesheet and resulting Project Ledger Entries, based on Project Setup.
Hour Bank Post GL
Each time a Sales Invoice or Timesheet is posted, the final step is to run the Hour Bank Post G/L process. To do this:
From the Role Center, select Actions > Processing > Billing > Hour Bank Post GL.
Select the appropriate Hour Bank from Hour Bank No..
Optionally select a Posting Date.
Select OK to complete processing against the Hour Bank.
To view the update, navigate to Hour Bank List, select the Hour Bank used. The General FastTab displays the remaining quantity and balances. The Hour Bank FactBox also displays the original hours banked, and the remaining hours or amount.
Hour Banks and Contracts
Hour Banks are only available to be used directly with Projects, not with Contracts. If an Hour Bank is intended for use with a Contract, associate the Hour Bank with the Projects that will be added to the Contract by using Related Information. The Hour Bank Sales Invoice that is created for the Project will include the Hour Bank Number.