Statements (form)

Article
05/05/2014

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.

Task that uses this form

Create and post a statement

Navigating the form

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

Tabs

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.

Buttons

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.

Fields

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.