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.
Project Journal Menu Options
| Name | Description |
|---|---|
| Manage |
|
| Delete: Click to Delete the information from the highlighted row in the journal batch. |
|
| Home | |
| Post: Finalize the document or journal by posting the amounts and quantities to the related accounts. | |
| Preview Posting: Use Preview Posting to simulate the impact of a journal entry before committing it to the General Ledger. | |
| Post and Print: Select Post and Print to finalize and prepare to print the document or journal. The values and quantities are posted to the related accounts. A report request window opens to specify what to include on the print-out. | |
| Reconcile: Select Reconcile to view what has been reconciled to the Project. The window shows the quantity entered on the Project Journal Lines, totalled by **Unit of Measure and by Work Type. | |
| Renumber Document Numbers: Select Renumber Document Numbers to edit the numbers in the Document No. field to avoid posting errors because the document numbers are not in sequence. Entry applications and line groupings are preserved. | |
| Prepare | |
| Suggest Lines from Time Sheets...: Select to fill the journal with lines from time sheets. | |
| Calc. Remaining Usage...: Click to calculate the remaining usage for the project. The batch job calculates, for each Project Task, the difference between scheduled usage of Items, Resources, and Expenses and actual usage posted in Project Ledger Entries. The remaining usage is then displayed in the Project Journal from where it can be posted. | |
| Line | |
| Item Tracking Lines: View or edit serial, lot and package numbers that are assigned to the Item on the document or journal. | |
| Dimensions: View or edit dimensions, such as area, project, or department, that can be assigned to sales and purchase documents to distribute costs and analyze transaction history. | |
| View Availability by: Event, Period, Variant, Unit of Measure, Location, Lot, or BOM Level. | |
| Page | |
| Show Lines with Issues: View a list of journal lines that have issues before posting the journal. | |
| Actions | |
| Posting > Test Report: View a test report to find and correct any errors before performing the actual posting of the journal or document. | |
| Other: Reconcile, Post, Preview Posting, Post and Print | |
| Related | |
| Project > Card: Click to open the Project Card for the Project specified on the highlighted journal line. | |
| Project Ledger Entries: Click to view the history of transactions for the selected record. |
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 Type of 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 an 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 used, 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 single Unit of the Type. |
| Unit Cost Incl. Tax | Specifies the amount of Expense the company incurs, in Project Currency, for 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 dollars, e.g., USD or CAD. |
| Total Cost | Specifies the sum of the Cost Amount, Unit Cost times Quantity. |
| Total Cost Incl. Tax | Specifies the sum of the Cost Amount, Unit Cost times Quantity, including tax. |
| 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 unit of measure. |
| 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 sum of the price charges, Unit Price times Quantity, for the posted entry, in the currency of the Project. |
| Chargeable | Specifies, if selected, that the line will be included in billing to the customer. |
| Unit Price ($) | Specifies the amount 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 sum of the price charges, Unit Price times *Quantity, in dollars, e.g., USD or CAD. |
| 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 find the 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 Completed".
Click OK.
Review the imported file and select Post to post the batch, or Post/Print to post the entries and print a PDF of the batch. Use the Preview Posting to display a preview of the entries prior to posting.
A confirmation is shown when the posting is completed. Click OK.
For more information see: