If you are using QuickBooks Enterprise with Advanced Inventory, FinJinni can provide additional analysis reports based on the inventory data in QuickBooks. There are several settings you can choose on the Settings screen for Advanced Inventory:

Always Reload Status From QuickBooks’ Inventory Item Report

This option loads item on-hand quantities from the Inventory Item Status report as of the current date instead of using the quantities from the item list, which can include future pending transactions.

Calculate Inventory Item Status Using FIFO Allocation

This option will run an inventory-allocation process to match up acquisitions (purchases) and distributions (sales) of inventory. It is the equivalent to how QuickBooks uses the “FIFO” option in advanced inventory for reporting.

Note: This allocation process does not take item lots into account. If you want to use FIFO allocation to report on lots, use the next option:

Use FIFO Inventory Allocations for Lots

This option will run a similar FIFO allocation process for Item Lots when those are used. It can be chosen either with or independently from the general item option above.

Include Site-Location (\”Bin\”) in Allocation

If this option is selected, the FIFO allocation for lots will include the intra-site location, usually called “bin”. Purchase and sales transactions will not cross bins unless inventory transfers are properly entered.