Statements (form)
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
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. |
See also
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).