Using inventory valuation¶
Inventory valuation is a quintessential accounting procedure that calculates the value of on-hand stock. Once determined, the inventory valuation amount is then incorporated into a company’s overall value.
In CoquiAPPs, this process can be conducted manually— by warehouse employees physically counting the products— or automatically through the database.
Understand the basics of inventory valuation¶
In order to understand how moving products in and out of stock affects the company’s overall value, consider the following product and stock moves scenario below.
Receive a product¶
For example, consider an physical product, a simple table, which is categorized as
Furniture in the product form’s Product Category field.
Navigate to the the product category itself by going to Costing Method as
In First Out (FIFO) and the Inventory Valuation field as
Alternatively access the Product Categories dashboard by clicking on the internal link arrow on the individual product’s form, by hovering over the Product Category field.
Next, assume 10 tables are purchased at a price of $10.00, each. The PO for those tables will show the subtotal of the purchase as $100, plus any additional costs or taxes.
After selecting Validate on the PO, use the Valuation smart button to view how the value of inventory was impacted.
Developer mode must be turned on to see the Valuation smart button.
The consignment feature allows ownership to items in stock. Thus, products owned by other companies are not accounted for in the host company’s inventory valuation.
The Stock Valuation dashboard then displays valuation of all products in the shipment, along with their quantities and valuation. In the example of 10 tables being purchased, the Total Value column of the dashboard would display a calculated valuation of $100.
In CoquiAPPs, automatic inventory valuation records are also recorded in the Accounting app. To access
these accounting entries, navigate to
STJ prefix in the Journal and Number
Deliver a product¶
In the same logic, when a table is shipped to a customer and leaves the warehouse, the stock valuation decreases. The Valuation smart button on the DO, likewise, displays the stock valuation record as it does on a PO
The inventory valuation report¶
To view the current value of all products in the warehouse, go to Date, Quantity, and Total Value of the inventory.. The records in the table are organized by product, and selecting a product’s drop-down menu displays detailed records with the
The Inventory At Date button, located in the top-left corner of the Stock Valuation dashboard, shows the inventory valuation of products available during a prior specified date.
Update product unit price¶
For any company: lead times, supply chain failures, and other risk factors can contribute to invisible costs. Although CoquiAPPs attempts to accurately represent the stock value, manual valuation serves as an additional tool to update the unit price of products.
Manual valuation is intended for products that can be purchased and received for a cost greater
than 0, or have product categories set with Costing Method set as either
Cost (AVCO) or
First In First Out (FIFO).
Create manual valuation entries on the Stock Valuation dashboard by first navigating to , and then click the little gray drop-down icon to the left of a product’s name, to then reveal stock valuation line items below as well as a teal + (plus) button on the right.
Click the teal + (plus) button to open up the Product Revaluation form, where updates to the calculation of inventory valuation can be made, by increasing or decreasing the unit price of each product.