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.

  2. On the Options FastTab, you can specify the format options listed in the following table.

    FieldDescription
    Date FilterEnter 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 FilterEnter 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 FilterEnter the filter value for the analysis on the Global Dimension 1 filter.
    Global Dimension 2 FilterEnter 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.

FieldDefinition
No.This field displays the item number.
DescriptionThis field displays the description of the item.
Base Unit of MeasureThis 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 QuantityThese 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 CostThese 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.
  2. 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.

FieldDescription
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 FilterEnter 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 FilterEnter the period that the report is printed for.

On the Options FastTab, you can specify the format options listed in the following table.

ParameterDescription
Rounding PrecisionChoose the required rounding precision: 0.001, 0.01, 1, or 1000.
Replace zero values by blanksSelect this field if you want to replace zero values with blanks.
Skip accounts without net changesSelect this field to exclude from the report the accounts with zero turnovers for the given period.
Skip accounts with zero ending balanceSelect this field to exclude from the report the accounts with zero ending balance at the end of the period.
Skip zero linesSelect this field to exclude from the report the lines with zero values.
Unit of MeasureChoose 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 QuantitySelect this field to print the quantity that is mentioned in the report.
Print CostSelect 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.

Item Obligatory Acts

Find free e-learning modules for Business Central here