Can I use FIFO or LIFO for my inventory?

Note: We will sunset inFlow v2 on July 31, 2024. This means inFlow v2 will no longer be offered for download and we will no longer be hosting its Knowledge Base and support articles.

FIFO and LIFO costing is available in inFlow v3. Not sure which version you’re on? Check by going to the Main Menu > Settings > About inFlow.

If you’re on v3 please see this article for help with the new FIFO/LIFO costing feature.

If you’re not on v3 and would like to use FIFO/LIFO costing, we have a workaround you can use, outlined below:

You can use sublocations to track your inventory with FIFO/LIFO costing. This isn’t exactly what it’s designed for, but it’s worked well for a number of people. We recommend you enter receiving dates in a yyyymmdd format so that they can be sorted and used when completing orders.

To turn on sublocations, make sure the option “Show Sublocation” is on under Company Settings > Company > Products & Inventory.

To purchase/receive your products:

  1. Open your purchase order.
  2. Click Advanced to expand to advanced workflow.
  3. Click the Receive tab and be sure to enter the date of your inventory into the sublocation column (or give it a batch number). This will allow you to stock each item to a separate sublocation which is named after that item’s date of arrival or associated batch.

To sell/ship the items:

  1. Open your sales order.
  2. Click Advanced to expand to advanced workflow.
  3. Click the Pick tab and select your items from the correct sublocation (i.e. match the sublocation to the correct batch based on whether you’re using FIFO or LIFO).

From the movement history screen, you can also filter to show all the movements within a certain batch. Double click on the row to bring up any related orders.

Yun Ling
Archon Systems
w,
+1.866.923.4974
260 Carlaw Ave #397
Toronto, ON, M4M 3L1
Canada
May 23, 2012