Project Ledger Entries
Project Ledger Entries are created throughout the system in by various processes, such as like 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.
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 that you set up in General Ledger Setup. | |
| Global Dimension 2 | Specifies the code for Global Dimension 2, which is one of two Global Dimension Codes that you set up 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. | |
| 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 to defer Revenue for this entry. | |
| 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 how the Expense was paid when Type is G/L Account. | |
| Expense Code | Specifies a unique identifier for the Expense. | |
| 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. | |
| 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. | |
| Unit Cost ($) | Specifies the base value of the unit in local currency (LCY). | |
| Total Cost ($) | Specifies the cost times the quantity in local currency (LCY). | |
| 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 local currency (LCY). | |
| Total Price ($) | Specifies the value of the unit times the quantity, charged to the customer in local currency (LCY). | |
| 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 being used to reduce the value charged to the customer. | |
| Line Discount Amount | Specifies the value reduction charged to the customer. | |
| Line Amount | Specifies the total value less any reduction, to be charged to the customer. | |
| % of Split Billing | Specifies the percent of the total billing being charged for this entry, on a sales document, when there is more than one customer being invoiced. | |
| Retention Entry | Specifies, if true, that an amount has been deducted from the sales invoice to be billed at a later date. This field is active only on a sales entry type line. | |
| Expense Resource | Specifies the person submitting the amounts when the line is for expense. | |
| Attachments | Specifies, if true, that there is additional information that can be viewed for the entry. |
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 (Job) 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 project number of the project to which the transaction will be moved. |
| Move To Project Task Code | Specifies the project task code of the project to which the transaction will be moved. |
| With Audit Trail | Specifies, if true, that the transactions are to be reversed under the old Project and created under the new Project, with an audit trail. 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 with no audit trail. |
| 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. For expense transactions, only price will be recalculated. |
| 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