Stock Costs
In Workcube, stock costs are tracked on the stock costs screen. The Stock Cost screen within the Stock module is a report screen. It offers the opportunity to see stock costs individually and in total on a product basis, according to different criteria.
Path: ERP > Sales-Distribution > Cost > Stock Costs
In order for stock costs to be tracked on the system and instantly reported on the cost screen, certain settings must be made on the system. In addition to the general settings that need to be made such as transaction categories, The selection should be marked as “Yes” . Here If “No” is selected, 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 the variations of this bleach with different stock codes (For example, Lavender Scented, Pine Scented).
After these definitions are made, Workcube calculates the stock through the movements in all transaction types that are recorded on the system and affect the cost calculation. calculates costs instantly. In Workcube, inventory cost calculations are carried out 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 your stocks in the system with 3 different invoices in a certain period of time, and if the quantity and price of each invoice are different, the system makes the calculation as follows;
It finds the unit cost by dividing/proportioning the total purchase price to the total purchase amount. This unit cost you have found is constantly recalculated according to the cost record date last entered in the cost history of the product, and when you open the product cost history page, it always gives the Total Quantity / Total Unit = Weight average cost.
Stock Costs Tracking
Path: ERP > Sales-Distribution > Cost > Stock Costs
On this screen, you can view cost information using filtering fields.
By clicking on the stock code, you can go to the relevant Stock detail.
Displaying Stock Costs Based on Different Criteria
Stock costs can be displayed on different criteria by using the filter fields at the top of the stock costs screen. These criteria are:
- Filter: You can search by typing the name of the product in this field.
- Price list: From this field you can filter "Weighted Average", "Standard Sales", "Standard Purchase".
- The Weighted Average selection lists the inventory costs calculated as we mentioned above.
When the "Standard Sales" or "Standard Purchase" options are selected, the system records the "Standard Sales" and "Standard Sales" and "Standard Purchases" on the card of the relevant product. It calculates and lists the values of stocks on hand based on "purchase" prices. - Warehouse: You can select a warehouse to filter cost information on a warehouse basis.
- Stock/Spec: You can list cost information on a stock or spec basis.
- Product name/Stock code: You can filter by product name. When you select the stock code option, you can also search by stock code in the filter field.
- Responsible: This field allows searching by product managers in the stock costs list.
- Supplier: This field allows searching by product suppliers in the stock costs list.
- Product: This field allows searching by product in the stock costs list.
- Category: This field allows searching in the product costs list by product categories.
When stock is displayed according to more than one criterion, the results that meet these criteria at the same time are displayed in the stock cost list. is displayed.
Feedback
It offers the opportunity to see stock costs individually and in total on a product basis, according to different criteria. "Should Cost Tracking Be Performed on a Stock Basis?" in the Company Flow Parameters. must be marked as “Yes”.