Periodic journal lines (form)

  • Article

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click General ledger > Periodic > Journals > Periodic journals. Select a journal and then click Lines.

Use this form to enter transaction lines that you can repeatedly retrieve and post in the daily journal.

Examples of lines that you can enter in periodic journals are recurring periodic payments, such as rent or subscriptions, for which the amount, text, and other information are the same every time that the voucher is posted.

If you have entered lines in a daily journal that you want to use again, you can save the journal as a periodic journal.

The following tables provide descriptions for the controls in this form.

Tabs

Tab

Description

Overview

Enter transaction lines that you want to use repeatedly in journals.

The following fields are used differently than the same fields in the daily journal:

  • The Date field contains the posting date for the next transfer to the daily journal. The field is automatically updated when transactions are retrieved to the daily journal so that lines cannot be transferred two times per period. When the field is blank, the line is transferred one time per retrieval, and the posting date is set during retrieval.

  • The Voucher field is internal for the periodic journal. When the line is retrieved, the voucher number sequence in the daily journal is used.

General

Enter or view additional information about the selected transaction, such as sales tax and various amount fields.

Invoice

Enter or view information about the invoice that is related to the journal line or transaction.

1099

Enter tax amounts and details to include on the 1099-G or 1099-S form.

Note

(USA) This tab is available only when the legal entity’s primary address is in the United States and the Public Sector 1099G or Public Sector 1099S configuration key is selected.

Project

Enter or view information about the project that is related to the journal line or transaction.

Note

This tab is available only if the account type or offset account type is Project.

Periodic

Enter or view information about the unit, number of units, and last date of the selected journal line or transaction.

The fields are displayed with default settings and are not displayed in the daily journal.

Buttons

Button

Description

Sales tax

View or change the expected sales tax transactions that are related to the journal line.

Print

Print reports that are relevant to the journal lines.

Financial dimensions

Open a menu with options to open a form where you can 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

Date

View or enter the posting date.

Voucher

The voucher number for the line.

Account type

Select the type of account. You can select from the following options.

  • Ledger

  • Customer

  • Vendor

  • Project

  • Fixed assets

  • Bank

Account

Enter or select the account number for the current account type.

For example, if you selected Vendor in the Account type field, select a vendor account number. If you selected Ledger in the Account type field, select a ledger account.

Description

Enter text about the transaction. When you specify an offset account, the same text is used, as long as no other offset transaction text is specified.

Debit

Enter the debit amount in the specified currency.

Credit

Enter the credit amount in the specified currency.

Offset account type

Select the account type for the offset account.

Offset account

Enter or view the account number for the current offset account type.

Note

For the Ledger account type, you can set up a default offset account in the Main accounts - chart of accounts: %1 form. For the Project account type, you can set up a default offset account in the Projects form.

Currency

Select the currency to use when you post in a foreign currency.

Unit

Select the unit to use for the selected periodic transaction. For example, you could select Months for monthly postings. If a date has not been selected, the Unit field does not apply.

Number of units

Enter the number of units defined in the Unit field that make up the interval in which you want to post transactions for the selected journal line. For example, if you selected Months in the Unit field and you want to make quarterly postings, enter 3 in this field. If you selected Days in the Unit field and 14 in the Number of units field, the periodic journal line is posted every two weeks.

Last date

The session date of the last time the periodic line was transferred to a journal. This field is updated automatically.

Transfer

Select this check box to designate the transaction as having been transferred.

Company accounts

Select the set of company accounts that the amounts will be posted to. You can set up the transaction between company accounts in the Intercompany accounting form for both sets of company accounts.

Sales tax group

Enter or view the sales tax group for the journal line. The default value was selected in the Sales tax group field in the Main accounts - chart of accounts: %1, Customers, or Vendors forms, according to the account type.

Item sales tax group

Enter or view the item sales tax group for the journal line. The default value was selected in the Item sales tax group field in the Main accounts - chart of accounts: %1 form. If no value was selected in that field, the value in the Item sales tax group field in the General ledger parameters form is used.

Offset company accounts

Select the set of offset company accounts that the amounts will be posted to. You can set up the transaction between company accounts in the Intercompany accounting form for both sets of company accounts.

Offset-transaction text

If text other than the text entered in the transaction text field should be used, enter it here.

Exchange rate

Enter the currency exchange rate.

Secondary exchange rate

Enter the secondary exchange.

Cross rate

The cross rate for the two exchange rates.

Calculation method

The calculation path from one currency to another currency.

Quantity

Indicate the quantity for the current transaction. Use the Current quantity column type to display quantities in the Financial statement form.

Settlement type

Select a settlement type.

Invoice

Enter or view the invoice number.

Due date

The due date for the invoice that is based on the terms of payment. You can change this date.

Note

The calculation occurs only if you enter an invoice number.

Payment ID

The identifier that was used for the payment. If a payment proposal is used, the payment ID from the invoice or credit note is suggested, but it can be changed.

Terms of payment

The terms of payment for the current invoice.

Tax exempt number

Select the tax exempt number for the transaction. Click General ledger > Setup > Sales tax > External > Tax exempt numbers.

Purchase order

Specify purchase orders that pertain to this invoice.

Note

This field is for information only. You can select multiple purchase orders.

Document

Enter the number, or name, of the document that is the basis of the transaction.

Enterprise number

The enterprise number that is used to identify Belgian companies.

Note

(BEL) This control is available only to legal entities whose primary address is in Belgium.

Document date

Enter or view a date for the document. For example, for a vendor invoice, the date will determine the due date and the cash discount date.

Approved by

The employee who approved the transaction. You can change this. You can restrict the approval function to a specific user group in the Approve field in the Journal names form.

Approved

If selected, the transaction has been approved. By default, this check box is selected.

Invoice payment release date

Enter a release date to put the invoice payment on hold. If you enter a date, the payment will not be generated until that date. This field is available only if the invoice is approved.

To remove a payment hold, clear the entry in this field. Any user can clear the release date, regardless of which user entered it.

Note

This field is displayed only if the account type or offset account type is Vendor.

Release date comment

Enter an optional comment for the Invoice payment release date field.

Note

This field is displayed only if the account type or offset account type is Vendor.

1099 amount

Enter or view the amount to be reported on the 1099 form. For more information, see (USA) About year-end 1099 reporting.

Note

(USA) This control is available only to legal entities whose primary address is in the United States.

1099 box

Select the 1099 form on which to print the 1099 amount.

Note

(USA) This control is available only when the legal entity’s address is in the United States. If the Public Sector 1099G or Public Sector 1099S configuration key is selected, 1099-G or 1099-S options are displayed in this list. If you select G-2 or S-2, use the 1099 tab to enter additional details. For more information, see (USA) About year-end 1099 reporting.

State/province

Select the state or province for the delivery.

Note

(USA) This control is available only to legal entities whose primary address is in the United States.

1099 state amount

The 1099 amount to be reported for the selected state.

Note

(USA) This control is available only to legal entities whose primary address is in the United States.

1099 G-2 Details

If you selected G-2 in the 1099 box field, you can modify the fields in this section. For more information about these fields, review the IRS guidelines for the 1099-G form.

  • G-3 amount is for tax year – Select this check box to enter the year that the G-2 amount applies to.

  • G-8 trade or business income – Select this check box to indicate that the G-2 amount applies to trade or business income.

Note

(USA) These controls are available only when the legal entity’s primary address is in the United States and the Public Sector 1099G configuration key is selected.

1099-S

If you selected S-2 in the 1099 box field, you can modify the fields in this section. For more information about these fields, review the IRS guidelines for the 1099-S form.

The S-2 gross proceeds field is not displayed because this amount is the same as the amount in the Settled federal 1099 field. For more information, see (USA) About year-end 1099 reporting.

Note

(USA) These controls are available only when the legal entity’s primary address is in the United States and the Public Sector 1099S configuration key is selected.

Date

The posting date for the project transaction.

This field is displayed only if the account type or offset account type is Project.

Activity number

The identifier of the project.

This field is displayed only if the account type or offset account type is Project.

Category

The category for the project.

This field is displayed only if the account type or offset account type is Project.

Worker

The worker number.

This field is displayed only if the account type or offset account type is Project.

Line property

The status that the transaction is attached to.

This field is displayed only if the account type or offset account type is Project.

Transaction ID

The transaction text identifier.

This field is displayed only if the account type or offset account type is Project.

Quantity

Specify the number of units for project transactions.

This field is displayed only if the account type or offset account type is Project.

Cost price

Enter or view the cost price of the hours spent on the transaction.

This field is displayed only if the account type or offset account type is Project.

Sales currency

The currency code for sales.

This field is displayed only if the account type or offset account type is Project.

Sales price

Enter or view the sales price for the hours spent on the transaction.

This field is displayed only if the account type or offset account type is Project.

Sales tax group

The sales tax group for project invoicing.

This field is displayed only if the account type or offset account type is Project.

Item sales tax group

The item sales tax group for project invoicing.

This field is displayed only if the account type or offset account type is Project.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).