Wiki Detay | wiki workcube

Every business needs stock controls and analysis of stocks as a result of these controls in order to have a certain amount of stock, to meet incoming demands and to make future plans. With stock management, catalogs containing thousands of stock codes are managed practically. All transactions involving stock movement, such as all shipment orders, purchase and sales delivery notes, stock receipts, are measured and tracked with the stock analysis report.

Path: BI-Reports>Standard Reports>Stock Analysis Report

Desired stock analyzes are made with different filter options in the Stock Analysis Report. The fields or filter options displayed on the screen vary depending on the selected report type and the selections made in the xml settings.

Stock Basis: Stocks are taken on a stock basis if they are tracked as sub-stocks, that is, on a variation basis. In this way, different stocks of each product can be examined one by one. It shows the beginning and end of the period stock amounts.
Product Based: Product based tracking is done. For example; reports products on a row basis since there is only one product card, even if a product has more than one sub-stock. It shows the beginning and end of the period stock amounts.
By Category: Groups the products on the basis of parent and child categories and shows the end-of-period stock amount.
Based on Responsible: Groups and brings the products belonging to the product responsibilities selected in the product detail. It shows the end-of-period stock amount.
By Brand: It brings the products by grouping them according to their brands. It shows the end-of-period stock amount of each brand.
Supplier Based: Reports according to the supplier selected in the product card. It brings only supplier-defined products by grouping them and shows the end-of-period stock amount.
Document-based: Documents that make stock movements are reflected. It brings stock quantities directly as a document, not as a product or stock. Therefore, a product will come with whatever documents it contains. When the report is taken on a document basis, it returns the stock quantity in the document directly, as input or output quantity, depending on the relevant document, rather than the beginning and end of period quantities.
Spec Based: It returns the end of period and beginning of period quantities on the basis of main spec for the products produced. It shows how many spec records there are for a product, on separate lines, on a spec basis.
By Lot: Returns the end-of-period and beginning-of-period amounts on a lot basis, taking into account the defined lot numbers. It shows the number of lot numbers of a product on separate lines on a lot basis.
On a warehouse basis: If there is more than one location for a warehouse, it groups all of these locations according to the warehouse to which they are connected and brings the end-of-period stock amount. In this report type, warehouse selection does not include locations, only warehouses.
Based on Location: Selecting a single warehouse is mandatory in order to receive the report. More than one warehouse cannot be selected. It shows the income and end-of-period stock amount of all locations connected to the selected warehouse. In this report type, when selecting warehouses, only warehouses are displayed.
Based on Product Group: Based on the general parameters of the product selected in the product card. For example; Such as those that are supplied, those that are on sale, or those that have the production box checked.

Boxes in the report

Show Cost: When checked, it will bring stock costs.
Transaction Currency: When selected, the transaction brings foreign currency inventory costs. To be able to mark, the report type must be product, stock or spec based.
End of Period Unit Cost: It only works in product and stock based report type, it cannot be selected in other report types. When checked, the end of period stock unit cost column opens under the end of period stock.
Volume: Unit and total volume columns are opened depending on the volumes defined in the product detail.
Cost Based on Location: When the box is checked, location selection in the warehouse area becomes mandatory. More than one location cannot be selected at the same time.
Cost Based on Warehouse: When the box is checked, warehouse selection in the warehouse area becomes mandatory. More than one warehouse cannot be selected at the same time.
Attention: Cost boxes based on Warehouse and Location cannot be selected at the same time.
Included in Inventory: Products marked included in inventory appear in the product detail.
Stock Age: When checked, the selected It is calculated by taking the weighted average of the purchase transaction amounts between the dates (in descending date order), the sum of which provides the end-of-period stock amount, and the day difference of these purchase transactions compared to the current date. (Total days * Stock quantity weights / Current Stock Amount)
Stock Turnover Rate: When checked, stock turnover rate and average stock holding time information are displayed. (Cost of Goods Sold (COGS) / Average Inventory)
System 2nd Currency Br: The 2nd currency column selected in the Accounting Period opens.
Sales Invoice Amount-Amount Cost: Returns the quantities and amounts included in the sales invoice. In order for the cost to be displayed, "Show Sales Invoice Cost Information" in the Manual stock receipts are not received.
Retrieve Transactions in Locations Belonging to 3rd Party Institutions: If existing Warehouse-Locations are rented and if the "Stocks in this Location belong to 3rd party institutions and individuals." box is checked in the location detail, only the stocks in this location are selected.
Attention: Stock movements in locations belonging to third party institutions and individuals are not included in the calculations.

Depending on the selected transaction types or filter options, the following girths appear.

Beginning of the Period Stock: Returns the total of stock entry and exit transactions until the report start date.
Intra-Period Purchasing: It comes from the quantity totals of invoices of the purchase type.
Intra-Period Purchase Return: It comes from the quantity totals of invoices of the purchase return type.
Intra-Period Production: It comes from production voucher stock movements.
Intra-Period Sales:It comes from the sales type of invoices. comes from the quantity totals of the transactions.
Costs: When this option is selected, cost columns are displayed.
Intra-Period Sales Cost: For each invoice (stock amount in the sales invoice * Net Cost recorded in the invoice) is calculated and the total of all invoices is written. It is displayed when both sales and cost options are selected.
Beginning of Period Product Cost: Beginning of Period Stock Amount * Product Unit Cost
End of Period Product Cost: Beginning of Period Stock Amount * Product Unit Cost
Intra-Period Sales Return: Sales Return Type: comes from the quantity totals of transactions.
Intra-Period Consumption: Comes from consumption slip movements.
Intra-Period Waste: Comes from waste slip movements.
Intra-Period Counting: Comes from counting slip transactions. Income.
Intra-Period Count Reset: Income from count reset voucher transactions.
End of Period Stock: Amounts of the product in stock including the selected end date are income.
Total Cost: Calculated unit cost with the end-of-period stock

Hint: If the stock age is transferred in Period Maintenance Transactions, the control is done by selecting the stock age box on this report.

Feedback

Did you find this content helpful?

Please Write Your Feedback!

Name*

Last Name*

Email *

About Workcube Objects

Inventory Analysis Report

There is the same one called report.stock_analyse. It was disabled because it was a WO created only for popups. Ömer Turhan 3 February 2021

Type: Report Version: cancel vcancel Licence: Standard Author: Workcube Core