Inventory Costs

In Workcube, inventory costs are tracked on the inventory costs screen. The Inventory Cost screen in the inventory module is a report screen. It provides the opportunity to see the inventory costs individually and in total on product basis according to different criteria.

Route: ERP > Sales-Distribution > Cost > Inventory Costs

In order for inventory costs to be tracked on the system and reported instantly on the cost screen, certain settings must be made on the system. In addition to the general settings such as transaction categories, xml settings, products, if we want to track costs on a stock basis (SKU), the "Should costs be tracked on a stock basis?" must be marked as “Yes”. If "No" is selected here, the system still tracks the cost, but keeps it on a product basis. For example, the cost of the product “Bleach 2 liters” is kept, but it is not possible to report separately for variations of this bleach with different inventory codes (For example, Lavender Scent, Pine Scent).

After these definitions are made, Workcube instantly calculates the inventory costs over the transactions in all transaction types recorded on the system and affecting the cost calculation. In Workcube, inventory cost calculations are based on the "Weighted Average" cost method.

Weighted Average: Workcube works with weighted average. The logic of the average weight is as follows. If you have included the same item in the system with 3 different invoices in a certain period of time, and the amount and price of each invoice is different, the system calculates as follows;

Calculates the unit cost by dividing/proportioning the total purchase price to the total purchase quantity. This unit cost you have found is constantly recalculated according to the last entered cost record date in the cost history of the product, and it always gives the Total Quantity / Total Unit = Weight average cost when you open the product cost history page.

Inventory Costs Tracking

Route: ERP > Sales-Distribution > Cost > Inventory Costs

On this screen, you can view the cost information by using the filtering fields.

You can go to the relevant Inventory Detail by clicking on the inventory code.

Viewing Inventory Costs by Different Criteria

Inventory costs in different criteria can be displayed by using the filter fields at the top of the inventory costs screen. These criteria are:

• Filter: You can search by typing the name of the product in this field.
• Price list: You can filter by "Weighted Average", "Standard Sales Price", "Standard Purchase Price" from this field.
• The Weighted Average selection lists the inventory costs calculated as we mentioned above. When the "Standard Sales Price" or "Standard Purchase Price" options are selected, the system calculates and lists the values of the available stocks over the "Standard Sales" and "Standard Purchase" prices recorded on the card of the relevant product.
• Warehouse: You can select a warehouse to filter the cost information on a warehouse basis.
• Inventory/Spec: You can list cost information based on inventory or spec
• Product name/Inventory code: You can filter by product name or by Inventory code. When you select the Inventory code option, you can also search by Inventory code in the filter field.
• Responsible: This field allows searching the Inventory costs list by product responsible.
• Supplier: This field allows searching by product suppliers in the Inventory costs list.
• Product: This field allows searching the inventory costs list by product.
• Category: This field allows searching the list of product costs by product categories.
• USD Display: Display the costs in USD.

When inventory is viewed according to more than one criteria, the results that meet these criteria at the same time are displayed in the inventory cost list.