Progressus Project Journal
Use the Progressus Project Journal page to create and edit Project transaction batches. Alternatively, you can use the Time Journal to create time entries against a Project, or the Expense Journal to create expense entries against a Project. Those journals are specific to time or expense entry, whereas the Project Journal lets you create entries (i.e., General Ledger entries) that are not related to time or expense. You can also import expense or time entries into the Expense or Time Journal from an Excel file.
To create a new Project journal batch manually
Use the Search icon and type Progressus Project Journal. Select the related link.
- Select a Journal Template from the list, then select the type of journal batch to create (i.e., Adjustment, Project, WIP).
To create a manual Project Journal Entry, complete the following fields:
| Field Name | Description |
|---|---|
| Posting Date |
Specifies the Date the entry will be posted to the Project Ledger or General Ledger. |
| Document Date | Specifies the date when the related document was created. |
| Applies-to Entry: | Specifies, if the Project Journal line has Type = Item and the Usage of the Item will be applied to an already-posted Item Ledger Entry, then input the Entry Number to which the Usage will be applied. |
| Applies-to ID: | Specifies the ID number of the Applied To Entry. |
| Document Number | Specifies an identifying number assigned to all journal lines in the Batch. |
| Project No. | Specifies a unique identifier for the Project. |
| Project Task No. | Specifies an identifier for distinctive work that is done for a Project. |
Caution
When formatting the Project Task No. field in Excel (in preparation for importing), you cannot use a leading zero or a trailing zero if the Task Number is formatted to two decimal places. For example, if your Task Number is 100.10, and you try to run the import, the file will fail to import, and you will receive an error message "The field Job Task No. of table Job Journal contains a value (100.1) that cannot be found in the related table (Job Task).". To resolve this, be sure to format the field as Text in Excel by placing an apostrophe at the beginning of the number (i.e., '100.80) so the leading or trailing zero is not deleted by Excel and the file can import successfully.
| Type |
Specifies if the entry is a Resource, Item, or G/L Account. |
| Attach To Project Entry No. | -- |
| Amount Type | Options: |
| - Original Project Entry | |
| - WIP Capitalization | |
| - WIP Capitalization Posted | |
| - WIP Recognition | |
| - WIP Recognition Posted | |
| - Currency Adjustment | |
| - Price Adjustment | |
| - Qty Adjustment | |
| - Applying Entry | |
| - Adjustment | |
| - Inv. Suggestion | |
| No. | Specifies either the Item No., Resource No., or the G/L Account No., depending on the selection made for the Type field. |
| Source Type | Specifies the Source Typeof the transaction, either Customer or Vendor |
| Source No | Specifies the Customer No., or the Vendor No., depending on which option was selected in Source Type. |
| Project Manager Code | Specifies the number, code of the Resource assigned to oversee the job. |
| 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. |
| Description | Specifies information for the Resource, Item, or General Ledger Account to which this entry applies. The information is the Description field on the Resource, Item, or General ledger Account Card. You can change the Description. |
| Description 2 | Specifies additional information for the Resource, Item, or General Ledger Account to which this entry applies. |
| Expense Date | Specifies the date on which the Expense transaction occurred. |
| Deferral Code | Specifies the code of the Deferral Template to be used to defer revenue for this line. |
| Credit Card Code | Specifies the Type of Credit Card used for the expense. For more information see: Credit Card Setup |
| Purpose | Specifies the Purpose of the Expense and why it is being charged. |
| Payment Code | Specifies the Payment Code to use for the transaction. |
| Location Code | Specifies the Code for the Inventory Location where the Item on the journal line will be registered. |
| Work Type Code | Specifies alpha or numeric combination to filter on Work Type Code for viewing or adding data, or for determining cost and/or price. |
| Hour Bank No. | Specifies the Hour Bank to which this time entry will apply. |
| Unit of Measure Code | Specifies a standard of measurement of a quantity, i.e. hours, pieces, days. By default, the value in the Base Unit of Measure field on the Item, Expense, or Resource Card is inserted. |
| Time Pay Type | Specifies Pay Type value for the entry to determine cost and price (i.e., Regular, Overtime, etc.) |
| Pay Type Cost Factor | Specifies the multiplier for calculating a hourly cost for labor that qualifies as overtime. |
| Quantity | Specifies the number of units of the Type. |
| Currency Code | Specifies the Currency Code to be use, if other than the Local Currency. |
| Direct Unit Cost ($) | Specifies the direct cost, in Local Currency, of a single Unit of the Type. |
| Unit Cost ($) | Specifies the amount of Expense the company incurs, in Local Currency, for a for a single Unit of the Type. |
| Unit Cost Incl. Tax | Specifies the amount of Expense the company incurs, in Project Currency, of a single Unit, including tax. |
| Unit Cost | Specifies the amount of Expense the company incurs for a single Unit of the Type, in Project Currency. |
| Total Cost($) | Specifies the sum of the Cost Amount, Unit Cost times Quantity, in Local Currency. |
| Total Cost | Specifies the sum of the Cost Amount, Unit Cost times Quantity, in Project Currency. |
| Total Cost Incl. Tax | Specifies the sum of the Cost Amount, Unit Cost times Quantity, including tax, in Project Currency. |
| Cost Amount Includes Tax | Specifies, if selected, the Cost Amount includes tax. |
| Profit % | Specifies the Profit Percentage for the journal line. |
| Pay Type Price Factor | Specifies the multiplier for calculating an hourly price for labor that qualifies as overtime. |
| Unit Price | Specifies the amount to be billed to the customer, in Project Currency, for a quantity of one. |
| Line Amount | Specifies the total Amount that will be posted to the Project Ledger and charged to the customer. |
| Line Discount % | Specifies the Percentage used to reduce the amount charged to the customer. |
| Line Discount Amount | Specifies the reduction Amount for the line charges to the customer. |
| Total Price | Specifies the total amount to be billed to the customer in Project Currency. |
| Chargeable | Specifies, if selected, that the line will be included in billing to the customer. |
| Unit Price ($) | Specifies the amount billed to be billed to the customer for a single Unit, in Local Currency. |
| Line Amount ($) | Specifies the total Amount in Local Currency, that will be posted to the Project Ledger and charged to the customer. |
| Total Price ($) | Specifies the total amount billed to the customer in Local Currency. |
| Bal. Account Type | Specifies the Balance Account Type of G/L, Bank, or Vendor. |
| Bal. Account No. | Specifies the Balancing Account Number for the transaction line. |
| Cost Type | Specifies the Cost Type to be used with this expense. Example: Overhead, Revenue, Labor. For more information see: Setting up Cost Types |
| Expense Vendor No. | Specifies the Vendor No. Code to use for the expense. |
| Credit Card Adj. LCY | Specifies the amount related to credit card adjustments in Local Currency. |
| Exp. Amt LCY | Specifies the expense amount in Local Currency. |
| Attachments | Add attachments to this line in PDF, JPEG, and other formats: |
| - Click on No. | |
| - The Attached Documents page opens. | |
| - Select the Attach File(s) link. | |
| - On the Attach a document page, follow directions to “drop a file” or “click to browse”. | |
| - If browsing, navigate to the location where the file is saved. Select the file and Open. The file will populate the Attachment field on the Attached Documents page. | |
| - Select Close to finish attaching the document to the line. The No in the line will change to Yes to indicate there is an attachment on that line. | |
| Expense Resource No. | Specifies the Resource Number associated with the expense line. |
| Expense Document No. | Specifies a reference number associated with the expense document. |
Important
Location Code and Bin Code fields are available to be added to enter an Item with a Location/Bin No. in the Project Journal. Use Personalization to make these fields visible for use. Location Code specifies the code for the Inventory Location where the Item on the journal line will be registered. Bin Code specifies the Bin where the Items are picked or put away.
Important
Lot No. and Serial Number fields are available to be added to enter an item with a lot and/or serial number in the Project Journal. Use Design to make these fields visible for use. For more general information about setting up and using lot or serial tracking in Dynamics D365 Business Central, see: Track Items with Serial, Lot, and Package Numbers
Create a new Project Journal Batch by Importing Values
Prepare an Excel file with one line in Excel for each transaction line to import into the Progressus Project Journal, using the appropriate values based on above field descriptions.
Use the Search feature to search for Progressus Project Journal and select the related link.
Select Import Expenses from the ribbon.
In the Import Project Journal page that opens, complete the following:
Field Name Description Project Task No. Specifies the value of the Project Task Number for the import. This value will be applied to any lines with a blank Project Task Number. Project Journal Template Specifies the Project Journal Template to use for the lines to be imported. Use the lookup to select the template. Project Journal Batch Specifies the value of the Project Journal Batch. Use the lookup to select the batch. Type Specifies the value of the Type field. Use the dropdown to select: Resource, Item, or G/L Account. Chargeable Specifies, if selected, that all entries should be imported as Chargeable. Select File Select the ellipsis and then either browse to the file you wish to import, select it and click “Open” or drag and drop a file into the box to upload it. Select OK to begin import.
A message is displayed upon successful completion of import "Import Completed".
Click OK.
Review the imported file and select Post to post the batch, or Post/Printpost the entries and and print a PDF of the batch.
A confirmation is shown when the posting is completed. Click OK.
For more information see: