IMPORTANT: For multigym deployments with linked retail, you must be cloud hosted to use the First In First Out (FIFO) costing method. This is due to the extensive SQL required to analyze the cost history of a product when transfers are involved.
FIFO costing means that the cost applied to a sold inventory item is allocated based on a “first in, first out” order from available inventory. This is different from RGP’s basic costing method, which applies the latest restock unit cost for any new sale.
IMPORTANT: Anytime a historical restock is changed or a restock is added in the past, RGP will recalculate all of the costs for all impacted sales. This is a requirement as errors otherwise cannot be corrected (for example, if you realize a restock 4 months ago had the wrong unit cost and need to correct it).
Enabling FIFO Costing
Data Entry -> Manage -> Settings -> Manage Cost Method
Note: A password from RGP support is required to activate this feature.
You can later roll back to Basic Costing using the same method. All historical costs are recalculated whenever the costing method is changed.
MULTIGYM: It is critical that all of your RGP instances be updated to the latest RGP version before enabling the FIFO costing method. If your facilities have linked retail, enabling FIFO at one location will automatically enable it at all other locations.
Interface Changes with FIFO
Manage Products / Restocks
FIFO Allocation Grid (shown when clicking the FIFO button above)
This tool allows you to see how sales have been applied to specific restocks.
With FIFO, there are two “Inventory - Count” reports. One report shows the data using the Basic Costing (Legacy) method, and one shows the data using the FIFO method.
Please sign in to leave a comment.