Project Ledger Entries
Project Ledger Entries are created throughout the system by various processes, such as the Project Journal, Purchase Invoices, Sales Invoices, Timesheet Entry and Expense Sheet Entry, when transactions are posted.
To view Project Ledger Entries for all Projects, use the search tool and search on Project Ledger Entries, then select related link.
To view Project Ledger Entries for a specific Project, navigate to Project List > highlight a project > Project > Project Ledger Entries.
You can also navigate to specific Project's Ledger Entries by using these options:
- Project Card > Project > Project Ledger Entries.
- Project Plan > Project > Project Ledger Entries.
Menu
| Field Name | Description |
|---|---|
| Postpone |
Use Postpone to change the Postpone to Date on posted transactions to be billed. For more information, see: Postpone |
| Move Entries | Use Move Entries to move entries from the current Project/Task to a different Project/Task. For more information, see: Move Entries |
| Close Invoice Lines | Close Invoice Lines is used to specify that any remaining balance for the selected transaction should be written off and applied and the line closed. For more information, see: Close Invoice Lines |
| Undo Close Invoice Lines | Select the entries to reopen and then choose Undo Close Invoice lines. When Undo Close Invoice lines is performed, the system automatically creates reversing close entry adjustments to reopen the affected lines. For more information, see: Undo Close Invoice lines |
| Actions | Functions > Transfer to Planning Lines: When selected, the Project Transfer to Planning lines page opens. Select Budget, Billable, or Both Budget and Billable and click OK to transfer the selected line to Planning Lines. |
| Other > Postpone | |
| Other > Move Entries | |
| Other > Close Invoice lines | |
| Other > Undo Close Invoice lines |
The Project Ledger Entry page displays the following information on posted Project Ledger Entries:
| Field Name | Description | |
|---|---|---|
| NOTE: The following two fields, Global Dimension 1 and Global Dimension 2 are only displayed if Progressus Multi-Company is activated. For more information, see: MEM and Progressus Multi-Company Integration Documentation | ||
| Global Dimension 1 |
Specifies the code for Global Dimension 1, which is one of two Global Dimension Codes in General Ledger Setup. | |
| Global Dimension 2 | Specifies the code for Global Dimension 2, which is one of two Global Dimension Codes in General Ledger Setup . | |
| Posting Date | Specifies the Posting Date, from the originating document, assigned to the ledger entry. | |
| Entry Type | Specifies if the entry is Usage or Sales. | |
| Document No. | Specifies a Document Number from the originating document. | |
| Project No. | Specifies a unique identifier for the Project. | |
| Project Task No. | Specifies the number of the related Project Task. | |
| Type | Specifies if the entry is an Item, Resource, or G/L Account (Expense). | |
| No. | Specifies a number for the Type used in the transaction. | |
| Description | Specifies information about the No. field. | |
| Contract Type | Specifies if the Contract Type is Time and Material or Fixed. | |
| Invoice Zero Prices | Specifies that this zero amount Usage entry will be invoiced. This field is set when the Usage entry is posted, and the Project has Invoice Chargeable Zero Prices selected. Once an invoice has been posted which contains this Usage, this field will be cleared. | |
| Chargeable | Specifies, if true, that the entry is billable. | |
| Open | Specifies, if true, that the entry is open, has not been applied against another entry. | |
| Deferral Code | Specifies the code of the Template used for this entry if revenue is deferred. | |
| Recognized Revenue | Specifies amount of Revenue that has been recognized as of the recognition date filter. The recognition date filter defaults to the current Work Date. | |
| Expense Payment Type | Specifies the type of expense payment: AP, GL, Purchase Journal, or Employee Journal. | |
| Expense Code | Specifies the unique identifier for information used in the application for expenses. | |
| Currency Code | Specifies, if populated, the non-local currency (LCY) identifier used for calculations. | |
| Quantity | Specifies the number of units on the entry. | |
| Remaining Qty. | Specifies the value in the Quantity field that remains to be processed. | |
| Unit of Measure Code | Specifies how the quantity is measured i.e., hours, pcs. | |
| Reversed Entry No. PGS | Specifies a unique number assigned to an entry at the time it is reversed by reopening the Timesheet and posting new data for the entry. | |
| Unit Cost ($) | Specifies the amount of expense the company incurs, in dollars, e.g. USD or CAD, for a single unit of the Type including fixed and variable costs. | |
| Total Cost ($) | Specifies the cost times the quantity in dollars, e.g. USD or CAD. | |
| Total Cost | Specifies the cost times the quantity in the transaction currency which may be local (LCY) or non-local currency. | |
| Unit Price ($) | Specifies the value of the unit charged to the customer in in dollars, e.g. USD or CAD. | |
| Total Price ($) | Specifies the value of the unit times the quantity, charged to the customer in in dollars, e.g. USD or CAD. | |
| Total Price | Specifies the value of the unit times the quantity, in transaction currency, which may be charged to the customer in local (LCY) or non-local currency. | |
| Line Discount % | Specifies the percentage that will be applied to the entry to determine a deduction amount. | |
| Line Discount Amount | Specifies the deduction amount for the line. | |
| Line Amount | Specifies the amount that will be posted to the project ledger. | |
| % of Split Billing | Specifies the percent of the total billing being charged for this entry, on a sales document, when more than one customer is being invoiced. | |
| Retention Entry | Specifies, if true, that an amount has been deducted from a Sales Invoice to be billed at a later date, or a Purchase Invoice to be paid at a later date. | |
| Expense Resource | Specifies the person who incurred the amount when the line is for an expense. | |
| Attachments | Specifies, if true, that there is additional information that can be viewed for the entry. | |
| Register No. | Specifies the project register number to which this ledger entry is tied. | |
| Allocation | Specifies if this transaction has been allocated, or if it was created by Allocator. | |
| Allocation Source Entry No. | Specifies the project ledger entry number on which this entry is based. |
Postpone
Use Postpone menu item to change the Postpone to Date on posted transactions to be billed. The Postpone to Date can be found in Invoice Suggestion > Invoice Suggestion Lines FastTab.
| 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 entry. Example: 1M will postpone the billing of the entry by one month from the current billing date. |
| NOTE: Use either the Postpone to Date or the Postpone Formula but not both. | |
| Filter: Project Ledger Entry | Specifies filters that you can add to the Postpone to Date process to narrow results. Options are: |
| - Project No. | |
| - Entry No. | |
| - Posting Date | |
| - Type | |
| - No. | |
| - Project Task No. | |
| Filter totals by | Select + Filter to add additional filters and further narrow results. |
Select OK to process the change in the Postpone to date.
Move Entries
Use Move Entries menu item to move entries from the current Project/Task to a different Project/Task.
Note
Fully or partially invoiced transactions cannot be moved to a new Project/Task.
| Field Name | Description |
|---|---|
| Move To Project No. |
Specifies the number of the Project to which the transaction will be moved. |
| Move To Project Task Code | Specifies the Task code of the Project to which the transaction will be moved. |
| With Audit Trail | Specifies, if true, that a negative entry is created under the original Project/Task, and a new entry is created under the new Project/Task. If this option is set to false, the transaction is moved and the original entry is deleted. |
| Update Dimensions | Specifies, if true, to change the dimensions of the transaction based on the settings for the new Project and Task. |
| Update Costs\Prices | Specifies, if true, to recalculate the cost and price of the transaction based on the settings for the new Project and Task. |
| Date Selection | Options: 'Original Posting Date' or 'New Posting Date'. If you select 'New Posting Date', the Posting Date field is enabled. |
| Posting Date | Specifies the new posting date to use for the moved transactions. |
Close Invoice Lines
Close Invoice Lines is used to specify that any remaining balance for the selected transaction should be written off and applied and the line closed. For more information on Close Invoice Lines, see: Close Line
Undo Close Invoice lines
Use the Undo Close Invoice lines button to undo the inadvertent closing of transactions that were closed using Close Entries functionality. When Undo Close Invoice lines is performed, the system automatically creates reversing close entry adjustments to reopen the affected lines. Select the entries to reopen and then choose Undo Close Invoice lines.