Export (0) Print
Expand All

Statements (form) [AX 2012]

Updated: September 7, 2012

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

Click Retail > Journals > Open statements. On the Open statements list page, on the Action Pane, in the New group, click New statement.

Use this form to create, calculate, and post statements.

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

Tab

Description

Statement

Create, maintain, and post statements.

General

View the store that the statement is created for and the calculation data for the statement.

Lines

View the statement lines that are generated when the calculate statement process is run.

Setup

Enter the methods and the transaction interval for the statement.

Transaction status

View the settings for sales, sales transactions, and transactions for the statement. These values are created by the statement process.

Statistics

View the statistics settings for sales, discounts, and income and expenses.

Postings

View the date that the statement is posted.

Other

View the date and time of the calculation.

Line details

View details about the transaction lines that are included in the statement.

General

View general details about a selected transaction line.

Amounts

View the amount details for a selected transaction line.

Button

Description

Calculate statement

Run the calculate statement process. This process retrieves the transactions and includes them to the statement, based on a defined set of criteria.

Post statement

Run the post statement process. This process posts the transactions that are included in the statement, generates accounting entries, updates customer accounts, and generates invoices, payment journals, and so on.

Clear statement

Clear the transaction lines that were generated by the calculate statement process.

Transactions

Open the Transactions form, where you can view details about the transactions that are included in the statement.

Shifts

Open the Shifts form, where you can view the details about the shifts for the transaction lines.

Products not found

Open the Products/bar codes not on file form. If any point of sale (POS) sales transactions that are included in the statement have products that do not exist in a product master, you can use this form to view the products.

Blocked products

Open the Blocked products in statement form, where you can view any products that are included in the statement, but that are marked as blocked. During posting, the program temporarily unblocks the products.

Blocked customers

Open the Blocked customers in statement form. If any POS sales transactions that are included in the statement have customers that were marked as blocked, you can use this form to view the customers. During posting, the program temporarily unblocks the customers.

Statements

Generate a report for the statement.

Calculate statement

View the log file for the calculate statement process.

Post statement

View the log file for the post statement process.

Cash declaration

Create a cash declaration for a statement line for the cash tender type.

Transactions

View the details about various transaction types that are included in the statement.

Field

Description

Statement number

The automatically generated unique number that is attached to the selected store.

Store number

The store number that the statement is generated for.

Total discount

The total discount that is given in transactions that are included in the statement.

Line discount

The total line discount that is given in transactions that are included in the statement.

Calculated date

The date when the statement was calculated.

Calculated time

The time when the statement was calculated.

Posting date

The date when the statement was posted.

Staff

The staff member who entered the transaction that is included in the statement line.

Payment method

The payment method for the transaction, such as cash, check, or card.

Transaction amount

The total amount of the transactions that are included in the statement line.

Banked amount

The amount of the transaction line that was deposited in the bank.

Safe amount

The amount of the transaction that was put in the safe.

Counted

The actual counted amount.

Difference amount

The maximum difference that is allowed in the store between the amount of the transaction and the actual counted amount. If the difference exceeds the allowed difference amount that is defined for the store, the statement cannot be posted.

Statement method

The statement method that is specified at the store level.

Staff/register

If the statement method is set to Staff, select a staff person. If the statement method is set to POS terminal, select a terminal. You can also leave this field blank. This field is not available if the statement method is set to Total.

Closing method

The closing method that is specified at the store level.

Start date

The first date for which transactions are included in the statement calculation. By default, the current system date is used. However, you can change the date before you calculate and post the statement.

Start time

The time from which selected transactions are included in the statement calculation for the selected date. You can change the time before you calculate and post the statement.

End date

The last date for which transactions are included in the statement calculation. By default, the current system date is used. However, you can change the date before you calculate and post the statement.

End time

The time to which selected transactions are included in the statement calculation. By default, the current system time is used. However, you can change the time before you calculate and post the statement.

Posted sales transactions

The number of inventory entries that have been posted.

Unposted sales transactions

The number of inventory entries that have not been posted.

Products/bar codes not on file

If any POS sales transactions that are included in the statement have products that do not exist in a product master, the number of products.

Blocked products

If any POS sales transactions that are included in the statement have products that were marked as blocked, the number of products. During posting, the program temporarily unblocks the products.

Blocked customers

If any POS sales transactions that are included in the statement have customers that were marked as blocked, the number of customers. During posting, the program temporarily unblocks the customers.

Transactions with difference

If any transactions that are imported into Retail and included in the statement have a sale or payment difference that exceeds the maximum amount of difference that is defined for the store, the number of transactions.

Transactions on wrong shift

If any transaction headers that are included in the statement belong to an incorrect shift, the number of headers.

Unposted inventory transactions

The number of transactions that are included in the statement, and that are related to physical inventory counts.

Difference amount store

The amount of difference for transactions that are included in the statement, in the default currency of the legal entity.

Sales tax amount

The total amount of value-added tax (VAT) for transactions that are included in the statement.

Net amount

The total net sales amount for transactions that are included in the statement.

Total line discount

The total line discount that is given in transactions that are included in the statement.

Cash discount amount

The total discount that is given in transactions that are included in the statement.

Income

The total amount for income account transactions that are included in the statement.

Expenses

The total amount for expense account transactions that are included in the statement.

Posting date

The date that the statement is posted.

Calculated date

The date that the statement is calculated.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft