Item Net Amount Sheet
This report makes it possible to view the item turnover in quantitative and total expressions for the selected period.
To run the report, do the following:
- Select the
icon, enter Item Net Amount Sheet, follow the link. - In the window that opens, select the following filters:
| Filter | Description |
|---|---|
| View By | Specifies by which period the amounts will be displayed (day, week, month, quarter, year, accounting period). |
| Date Filter | Specifies the date or period for displaying information. |
| G/L Account Filter | Specifies a G/L account for which the turnover will be generated. |
| Item Filter | Specifies the item for which the turnover will be displayed. |
| Location Filter | Specifies the warehouse for which the turnover will be displayed. |
| Global Dimension 1 Code | Specifies the value of global dimension 1 by which amounts will be displayed. |
| Global Dimension 2 Code | Specifies the value of global dimension 2 by which amounts will be displayed. |
| Sort Type | Determines the parameters and levels of grouping for displaying information. Possible options: Item-Location-Lot-GL Account Location-Item-Lot-GL Account GL Account-Location-Item-Lot GL Account-Item-Location-Lot |
| Show Items | Specifies whether detail level - Item will be displayed. |
| Show Variant Code | Specifies whether detail level - Variant Code will be displayed. |
| Show Location | Specifies whether detail level - Location will be displayed. |
| Show Lot | Specifies whether detail level - Lot will be displayed. |
| Show Serial No. | Specifies whether detail level - Serial No. will be displayed. |
| Show G/L Account | Specifies whether detail level - G/L Account will be displayed. |
On the Additional Filters tab, you can set additional filters for items to display the required information. Filtering is possible on all fields from the item or variant card. Selected additional filters will be additionally displayed on the FactBox pane.
Item Net Sheet Lines display the item turnover for the period in quantitative and total expressions, as well as the amount of sales of the item for the period of the report, and contain the following information:
- Item No;
- Item Name;
- Starting Quantity;
- Debit Quantity;
- Credit Quantity;
- End Quantity;
- Starting Cost;
- Debit Cost;
- Credit Cost;
- Ending Cost;
- Sales Amount;
- Starting Cost ACY;
- Debit Cost ACY;
- Credit Cost ACY;
- Ending Cost ACY.
To view more detailed information on each amount, click on the amount, and the Value Entries window with the corresponding filters will open. For quantity values, the Item Ledger Entries window with the corresponding filters will open.
Note:
Entries marked with the Inventory Operation Reversed flag will not be displayed in the report.
The Summary tab displays the turnover for the period in quantitative and total expressions, as well as the amount of sales of item for the reporting period, and contains the following information:
- quantity at the start of the period;
- quantity on the debit;
- quantity on the credit;
- quantity at the end of the period;
- cost at the start of the period;
- cost on the debit;
- cost on the credit;
- cost at the end of the period;
- sales amount.
You can export the report data to Excel by clicking the 
button on the Item Net Sheet Lines.