# Item general ledger turnover
The following pages and reports enable the creation of turnover sheet for goods and materials.
 Item General Ledger Turnover - Page 12449
 Item Turnover (Qty.) - Report 12469
## Item general ledger turnover page (12449)
The Item General Ledger Turnover window shows the turnover for items in quantities and costs, the balance at the beginning of the month, positive and negative adjustment, and the balance at the end of the month.
The Item General Ledger Turnover window is created monthly, and can also be created for the date of inventory. The data in the Item General Ledger Turnover window is checked with the warehouse accounting data. The cost data is checked with the net changes and balances of:
 Account 41, Items
 Account 10, Materials
To access the Item General Ledger Turnover window
1. Choose the ![Tell Me feature] icon, enter Item G/L Turnover, and then choose the related link.
1. On the Options FastTab, you can specify the format options listed in the following table.
 Field|Description
 --|--
 Date Filter|Enter the period the data is analyzed for. You can use the buttons in the lower left of the window, or you can specify the period manually.
 Location Filter|Enter the location code that the information must be filtered for. You can enter a maximum of 10 characters, both numbers and letters.
 Global Dimension 1 Filter|Enter the filter value for the analysis on the Global Dimension 1 filter.
 Global Dimension 2 Filter|Enter the filter value for the analysis on the Global Dimension 2 filter.
The window contains fields with the information listed in the following table. You can't edit the fields.
Field|Definition
--|--
No.|This field displays the item number.
Description|This field displays the description of the item.
Base Unit of Measure|This field displays the base unit of measure of the item. The unit of measure is specified in the Item card as the Base.
Starting Quantity, Ending Quantity, Debit Quantity, Credit Quantity|These fields provide information about the quantity of the item-item quantity at the beginning and at the end of the period, and positive and negative correction in quantities of the item. Quantities are specified in base units of measure.
Starting Cost, Ending Cost, Debit Cost, Credit Cost|These fields show the item's opening and closing costs and cost movements for the period. The values are calculated from Cost Amount (Actual) on value entries.
To display the selected item card
 Choose the Item button and then Card (Shift+F5 key).
To print the Item Turnover (Qty.) report:
 Choose Print > Turnover Sheet.
## Item Turnover (Qty.) Report (12469)
To analyze net changes and balances of items and materials, you can print the Item Turnover (Qty.) report and export it to Microsoft Office Excel. The report prints the following data from the Item General Ledger Turnover window:
 Item number and description
 Balance at the beginning of the specified period (quantity and cost)
 Positive adjustment (quantity and cost)
 Negative adjustment (quantity and cost)
 Balance at the end of the specified period (quantity and cost)
 Unit of measure
The following procedure shows how to access the turnover sheet.
1. Choose the ![Tell Me feature] icon, enter Item General Ledger Turnover, and then choose the related link.
1. Choose the Print action, and then choose the Turnover Sheet action.
The turnover sheet is printed monthly and on the date of inventory, but it can be printed for any given period.
The Item FastTab of the request page contains fields with the information listed in the following table.
Field|Description
--|--
No.|Enter an item number or a range of item numbers to print an item general ledger turnover for one item or for a group of items.
Location Filter|Enter the location code that the information must be filtered for, to print the Item General Ledger Turnover window for one or several locations. You can enter a maximum of 10 characters, both numbers and letters. The field value is entered automatically in the Location Filter field
Date Filter|Enter the period that the report is printed for.
On the Options FastTab, you can specify the format options listed in the following table.
Parameter|Description
--|--
Rounding Precision|Choose the required rounding precision: 0.001, 0.01, 1, or 1000.
Replace zero values by blanks|Select this field if you want to replace zero values with blanks.
Skip accounts without net changes|Select this field to exclude from the report the accounts with zero turnovers for the given period.
Skip accounts with zero ending balance|Select this field to exclude from the report the accounts with zero ending balance at the end of the period.
Skip zero lines|Select this field to exclude from the report the lines with zero values.
Unit of Measure|Choose a unit of measure for calculating report quantities: - Base - In base units of measure - Sale - In units of measure for sales - Purchase - In units of measure for purchases
Print Quantity|Select this field to print the quantity that is mentioned in the report.
Print Cost|Select this field to print the costs that are mentioned in the report.
To export the report to Excel, use the report output options. Export to Excel isn't a field on this report's request page.
## Related information
item-obligatory-acts
Find free e-learning modules for Business Central here<https://learn.microsoft.com/training/dynamics365/business-central>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/localfunctionality/russia/item-general-ledger-turnover, MicrosoftDocs/dynamics365smb-docs at 46907ac (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/localfunctionality/russia/item-general-ledger-turnover/
