Page 1020 "Job G/L Journal"
Base Application · Microsoft.Projects.Project.Journal
Across versions
- BC23present
- BC24declaration changed
- BC25-26unchanged
- BC27declaration changed
- BC28-30unchanged
Neighbourhood 12 connected objects and pages
Base Application · Microsoft.Projects.Project.Journal · captioned “Project G/L Journals” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Project G/L Journals |
| SourceTable | Gen. Journal Line |
| PageType | Worksheet |
| UsageCategory | Tasks |
| ApplicationArea | Jobs |
Fields on this page
Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).
| Group | Control | Shows | ToolTip |
|---|---|---|---|
| Content | Batch Name | CurrentJnlBatchName |
Specifies the name of the journal batch, a personalized journal layout, that the journal is based on. |
| Control1 | Posting Date | Posting Date | Specifies the posting date for the entry. |
| Document Date | Document Date | Specifies the date when the related document was created. | |
| Document Type | Document Type | Specifies the type of document that the entry on the journal line is. | |
| Document No. | Document No. | Specifies a document number for the journal line. | |
| External Document No. | External Document No. | Specifies a document number that refers to the customer’s or vendor’s numbering system. | |
| Account Type | Account Type | Specifies the type of account that the entry on the journal line will be posted to. | |
| Account No. | Account No. | Specifies the account number that the entry on the journal line will be posted to. | |
| Description | Description | Specifies a description of the entry. | |
| Business Unit Code | Business Unit Code | Specifies the code for the business unit that the project entry is linked to. | |
| Salespers./Purch. Code | Salespers./Purch. Code | Specifies the salesperson or purchaser who is linked to the journal line. | |
| Campaign No. | Campaign No. | Specifies the number of the campaign that the journal line is linked to. | |
| Currency Code | Currency Code | Specifies the code of the currency for the amounts on the journal line. | |
| Gen. Posting Type | Gen. Posting Type | Specifies the type of transaction. | |
| Gen. Bus. Posting Group | Gen. Bus. Posting Group | Specifies the vendor’s or customer’s trade type to link transactions made for this business partner with the appropriate general ledger account according to the general posting setup. | |
| Gen. Prod. Posting Group | Gen. Prod. Posting Group | Specifies the item’s product type to link transactions made for this item with the appropriate general ledger account according to the general posting setup. | |
| VAT Bus. Posting Group | VAT Bus. Posting Group | Specifies the VAT specification of the involved customer or vendor to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | |
| VAT Prod. Posting Group | VAT Prod. Posting Group | Specifies the VAT specification of the involved item or resource to link transactions made for this record with the appropriate general ledger account according to the VAT posting setup. | |
| VAT % | VAT % | Specifies the relevant VAT rate for the particular combination of VAT business posting group and VAT product posting group. Do not enter the percent sign, only the number. For example, if the VAT rate is 25 %, enter 25 in this field. | |
| Amount | Amount | Specifies the total amount (including VAT) that the journal line consists of. | |
| Amount (LCY) | Amount (LCY) | Specifies the total amount in local currency (including VAT) that the journal line consists of. | |
| Debit Amount | Debit Amount | Specifies the total of the ledger entries that represent debits. | |
| Credit Amount | Credit Amount | Specifies the total of the ledger entries that represent credits. | |
| VAT Amount | VAT Amount | Specifies the amount of VAT that is included in the total amount. | |
| VAT Difference | VAT Difference | Specifies the difference between the calculated VAT amount and a VAT amount that you have entered manually. | |
| Bal. VAT Amount | Bal. VAT Amount | Specifies the amount of Bal. VAT included in the total amount. | |
| Bal. VAT Difference | Bal. VAT Difference | Specifies the difference between the calculate VAT amount and the VAT amount that you have entered manually. | |
| Bal. Account Type | Bal. Account Type | Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account. | |
| Bal. Account No. | Bal. Account No. | Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases. | |
| Bal. Gen. Posting Type | Bal. Gen. Posting Type | Specifies the general posting type associated with the balancing account that will be used when you post the entry on the journal line. | |
| Bal. Gen. Bus. Posting Group | Bal. Gen. Bus. Posting Group | Specifies the general business posting group code associated with the balancing account that will be used when you post the entry. | |
| Bal. Gen. Prod. Posting Group | Bal. Gen. Prod. Posting Group | Specifies the general product posting group code associated with the balancing account that will be used when you post the entry. | |
| Bal. VAT Bus. Posting Group | Bal. VAT Bus. Posting Group | Specifies the code of the VAT business posting group that will be used when you post the entry on the journal line. | |
| Bal. VAT Prod. Posting Group | Bal. VAT Prod. Posting Group | Specifies the code of the VAT product posting group that will be used when you post the entry on the journal line. | |
| Bill-to/Pay-to No. | Bill-to/Pay-to No. | Specifies the number of the bill-to customer or pay-to vendor that the entry is linked to. | |
| Ship-to/Order Address Code | Ship-to/Order Address Code | Specifies the address code of the ship-to customer or order-from vendor that the entry is linked to. | |
| Payment Terms Code | Payment Terms Code | Specifies a formula that calculates the payment due date, payment discount date, and payment discount amount. | |
| Applies-to Doc. Type | Applies-to Doc. Type | Specifies the type of the posted document that this document or journal line will be applied to when you post, for example to register payment. | |
| Applies-to Doc. No. | Applies-to Doc. No. | Specifies the number of the posted document that this document or journal line will be applied to when you post, for example to register payment. | |
| Applies-to ID | Applies-to ID | Specifies the ID of entries that will be applied to when you choose the Apply Entries action. | |
| On Hold | On Hold | Specifies if the journal line has been invoiced, and you execute the payment suggestions batch job, or you create a finance charge memo or reminder. | |
| Bank Payment Type | Bank Payment Type | Specifies the code for the payment type to be used for the entry on the journal line. | |
| Reason Code | Reason Code | Specifies the reason code, a supplementary source code that enables you to trace the entry. | |
| Job No. | Job No. | Specifies the number of the related project. | |
| Job Task No. | Job Task No. | Specifies the number of the related project task. | |
| Job Planning Line No. | Job Planning Line No. | Specifies the project planning line number that the usage should be linked to when the project journal is posted. You can only link to project planning lines that have the Apply Usage Link option enabled. | |
| Job Line Type | Job Line Type | Specifies the type of planning line to create when a project ledger entry is posted. If the field is empty, no planning lines are created. | |
| Job Unit Of Measure Code | Job Unit Of Measure Code | Specifies the unit of measure code that is used to determine the unit price. This code specifies how the quantity is measured, for example, by the box or by the piece. The application retrieves this code from the corresponding item or resource card. | |
| Job Quantity | Job Quantity | Specifies the quantity for the project ledger entry that is derived from posting the journal line. If the Project Quantity is 0, the total amount on the project ledger entry will also be 0. | |
| Job Unit Cost | Job Unit Cost | Specifies the project cost of one unit of the item or resource on the journal line. The value is calculated as follows: Project Total Cost (LCY) / Project Quantity. | |
| Job Unit Cost (LCY) | Job Unit Cost (LCY) | Specifies the project cost of one unit of the item or resource on the journal line, in the local currency. The value is calculated as follows: Project Total Cost (LCY) / Project Quantity. | |
| Job Total Cost | Job Total Cost | Specifies if you have assigned a project number and a project task number to the journal line. It shows the amount excluding VAT divided by the project quantity for the journal line. The amount is shown in the currency specified for the project. The value field is calculated as follows: (Amount - VA… | |
| Job Total Cost (LCY) | Job Total Cost (LCY) | Specifies the project total cost if you have assigned a project number and a project task number to the journal line. It shows the Amount (LCY) excluding VAT Amount (LCY)for the journal line. | |
| Job Unit Price | Job Unit Price | Specifies the unit price for the selected account type and account number on the journal line. | |
| Job Unit Price (LCY) | Job Unit Price (LCY) | Specifies the unit price, in the local currency, for the selected account type and account number on the journal line. | |
| Job Line Amount | Job Line Amount | Specifies the line amount of the project ledger entry. | |
| Job Line Amount (LCY) | Job Line Amount (LCY) | Specifies the line amount of the project ledger entry. | |
| Job Line Discount Amount | Job Line Discount Amount | Specifies the line discount amount of the project ledger entry. | |
| Job Line Discount % | Job Line Discount % | Specifies the line discount percentage of the project ledger entry that is related to the purchase line. | |
| Job Total Price | Job Total Price | Specifies the total price for the journal line. The value is calculated as follows: Quantity x Unit Price (LCY). | |
| Job Total Price (LCY) | Job Total Price (LCY) | Specifies the total price for the journal line, in the local currency. The value is calculated as follows: Quantity x Unit Price (LCY). | |
| Job Remaining Qty. | Job Remaining Qty. | Specifies the quantity that remains to complete a project. | |
| Job Queue Status | Job Queue Status | Specifies the status of a job queue entry or task that handles the posting of general journals. | |
| Correction | Correction | Specifies the entry as a corrective entry. You can use the field if you need to post a corrective entry to an account. | |
| Shortcut Dimension 1 Code | Shortcut Dimension 1 Code | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | |
| Shortcut Dimension 2 Code | Shortcut Dimension 2 Code | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | |
| ShortcutDimCode3 | ShortcutDimCode[3] |
— | |
| ShortcutDimCode4 | ShortcutDimCode[4] |
— | |
| ShortcutDimCode5 | ShortcutDimCode[5] |
— | |
| ShortcutDimCode6 | ShortcutDimCode[6] |
— | |
| ShortcutDimCode7 | ShortcutDimCode[7] |
— | |
| ShortcutDimCode8 | ShortcutDimCode[8] |
— | |
| Account Name | AccName | AccName |
— |
| Bal. Account Name | Bal. Account Name | BalAccName |
Specifies the name of the balancing account that has been entered on the journal line. |
| Balance | Balance | Balance |
Specifies the balance that has accumulated in the journal on the line that you selected. |
| Total Balance | Total Balance | TotalBalance |
Specifies the total balance in the journal. |
| FactBoxes | JournalErrorsFactBox | part Page 9121 “Journal Errors Factbox” | — |
| JournalLineDetails | part Page 9120 “Journal Line Details FactBox” | — | |
| IncomingDocAttachFactBox | part Page 193 “Incoming Doc. Attach. FactBox” | — |
Actions
| Group | Action | ToolTip | Runs |
|---|---|---|---|
| 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. | |
| Account | Card | View or change detailed information about the record on the document or journal line. | Codeunit 15 “Gen. Jnl.-Show Card” |
| Ledger Entries | View the history of transactions that have been posted for the selected record. | Codeunit 14 “Gen. Jnl.-Show Entries” | |
| Functions | Renumber Document Numbers | Resort the numbers in the Document No. column to avoid posting errors because the document numbers are not in sequence. Entry applications and line groupings are preserved. | |
| Posting | Reconcile | View what has been reconciled for the project. The window shows the quantity entered on the project journal lines, totaled by unit of measure and by work type. | |
| Test Report | View a test report so that you can find and correct any errors before you perform the actual posting of the journal or document. | ||
| Post | Finalize the document or journal by posting the amounts and quantities to the related accounts in your company books. | ||
| Preview Posting | Review the different types of entries that will be created when you post the document or journal. | ||
| Post and Print | Finalize and prepare to print the document or journal. The values and quantities are posted to the related accounts. A report request window where you can specify what to include on the print-out. | ||
| Remove From Job Queue | Remove the scheduled processing of this record from the job queue. | ||
| Page | Edit in Excel | Send the data in the journal to an Excel file for analysis or editing. | |
| Errors | Show Lines with Issues | View a list of journal lines that have issues before you post the journal. | |
| Show All Lines | View all journal lines, including lines with and without issues. |
Events published
OnAfterValidateShortcutDimCode(var GenJournalLine: Record "Gen. Journal Line"; var ShortcutDimCode: array[8] of Code[20]; DimIndex: Integer)(integration)
Trigger event subscribers
- OnDeleteRecordEvent: Codeunit 9080 “Journal Errors Mgt.” OnDeleteRecordEventJobGLJournal
- OnInsertRecordEvent: Codeunit 9080 “Journal Errors Mgt.” OnInsertRecordEventJobJournal
- OnModifyRecordEvent: Codeunit 9080 “Journal Errors Mgt.” OnModifyRecordEventJobGLJournal
Procedures
6 local procedures, no public ones.
Triggers
OnAfterGetCurrRecord, OnAfterGetRecord, OnDeleteRecord, OnInit, OnInsertRecord, OnModifyRecord, OnNewRecord, OnOpenPage
Relations
- source table Table 81 “Gen. Journal Line”
Extended by
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 230 “GenJnlManagement” (5 calls:
CurrentJnlBatchNameOnAfterVali → SetName,OnAfterGetCurrRecord → GetAccounts,OnOpenPage → OpenJnl, …) - Codeunit 4030 “Client Type Management” (1 call:
OnOpenPage → GetCurrentClientType) - Codeunit 408 “DimensionManagement” (1 call:
SetDimensionsVisibility → UseShortcutDims) - Codeunit 6723 “Server Setting” (1 call:
OnOpenPage → GetIsSaasExcelAddinEnabled) - Codeunit 9079 “Background Error Handling Mgt.” (1 call:
SetControlAppearanceFromBatch → BackgroundValidationFeatureEnabled) - Codeunit 9080 “Journal Errors Mgt.” (1 call:
SetControlAppearanceFromBatch → SetFullBatchCheck)
Documented on Microsoft Learn
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Job G/L Journal"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.