Journal lines for beginning balances (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Click Project management and accounting > Journals > Beginning balance. Create or select a journal. On the menu bar, click Lines.
–or–
Click Project management and accounting > Common > Projects > All projects. On the Action Pane, on the Project tab, in the Set up group, click Beginning balances. Create or select a journal. On the menu bar, click Lines.
Use this form to create transaction lines for a beginning balance journal.
Tasks that use this form
Create a project beginning balance
Navigating the form
The following tables provide descriptions for the controls in this form.
Tabs
Tab |
Description |
---|---|
Expense/Hour/Item |
Add, remove, or view financial dimensions for expense, hour, and item transactions. |
Fee |
Add, remove, or view financial dimensions for fee transactions. |
On-account |
Add, remove, or view financial dimensions for on-account transactions. |
Buttons (menu bar)
Button |
Description |
---|---|
Post |
Post the transactions that you have created in the beginning balance journal. |
Buttons (lower panes)
Button |
Description |
---|---|
Add |
Enter a new journal line in the list. |
Remove |
Remove the selected journal line from the list. |
Financial dimensions |
Select financial dimensions for the main account, offset account, or, if it is necessary, a payment fee account. The menu options that are available depend on the form that you are currently working with |
Fields
Field |
Description |
---|---|
Project date |
Enter the date that the project was posted to the journal. |
Project ID |
Select the project that the transaction is attached to. |
Activity number |
Select the activity number for the transaction. |
Transaction type |
Select the project transaction type to use when posting to the project. |
Category |
Select the category for the transaction. |
Item |
The identification of the item that is associated with the selected journal line. |
Worker |
The identification of the worker who is associated with the selected journal line. |
Description |
Enter a description of the transaction. If you enter a predefined search name from the Journal descriptions text, a description of the transaction is automatically entered into the field. Text in this field is limited to 30 characters. To enter more text, you can use the Document handling feature to attach a note to the transaction line. To enable the Document handling feature, on the Tools menu, click Options, and then select the Document handling active check box. A note that is attached to a transaction line can be viewed on the hour registration, on an invoice proposal, and on the invoice. |
Quantity/Hours |
Enter the quantity of items or the total number of hours to be posted in the beginning balance journal. |
Line property |
Select the line property that is attached to the journal line. For more information, see Line properties (form). |
Cost price |
Enter the cost price for the quantity of items or the hours spent on the transaction. |
Sales price |
Enter the sales price per hour for the transaction. Entering a sales price here overwrites any default sales price for the current worker. The default sales price is derived from the sales price that was set up for either the current worker or the company as a whole. Sales prices are set up in the Sales price form. For more information about how sales prices are derived, see About sales price models. Tip The sales price applies to time-and-material projects only. |
Cost amount |
The total cost amount of the transaction line, which is the sum of Quantity/Hours multiplied by Cost price. |
Sales amount (Expense/Hour/Item FastTab) |
The total sales amount of the transaction line, which is the sum of Quantity/Hours multiplied by Sales price. |
Cost status |
Select the status that will be assigned to this transaction when it is imported into Microsoft Dynamics AX. |
Voucher |
The ledger voucher number for the current line. The voucher is associated with the line's period and is updated when a new period is selected. Example A journal line has the voucher number 012456_1112 for week 39. When you update the transaction with a project date that is in week 40, the voucher number is changed to 012456_1113. |
Voucher date |
Enter the hour registration date. If the field is left blank, the current date is automatically entered. |
Accrue revenue |
Select this check box to enable revenue accrual for this transaction during the revenue accrual process. |
Sales currency |
The currency that will be used when the project is invoiced. |
Transaction status |
Select the initial status for the transaction line. In fixed-price projects, lines can only have a status of Posted. For other project types, select Posted or Invoiced. Important For fee transactions only, if you select Posted in the Transaction status field you must select the Accrue revenue check box. Fee transactions with a transaction status of Posted that are marked not to accrue revenue must be posted by using the fee journals instead of the beginning balance journal. |
Item sales tax group |
Select the item sales tax group. The value is populated from the Item sales tax group in the Chart of accounts. If this field is empty, the value is retrieved from the Item sales tax group field on the Sales tax tab in the General ledger parameters form. This option is available only for items in the Expense/Hour/Item list. Note If the Exempt check box for the sales tax group is not selected in the Sales tax groups form, the field is not populated, but you can enter a value manually. (Click General ledger > Setup > Sales tax > Sales tax groups.) |
Funding source name |
Select the funding source to which this transaction will be assigned. (Required for time-and-materials and fixed-price projects only.) |
Sales tax group |
Select a sales tax group. A default sales tax group can be derived from a project, a project contract, or an accounts receivable account, depending on the setup of the Item sales tax group method field in the Project management and accounting parameters form. |
Sales amount |
Enter the total revenue for the project that is to be recorded in the general ledger. The total revenue is the income for the project before deductions are made. |
See also
Beginning balance journal (form)
About migrating project data from other ERP systems
Migrating project data from other ERP systems
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).