Batch allocation to sales on fifo basis

[khawar]

I have seen lot of people asking how to allocate individual batches of purchase to sales through query

Attached db includes some sample reports including purchase batch allocationto sales on fifo basis, inventory report and profit reports.

Batch allocation report show individual sale transactions and on the other side what purchase batch (and how much quantity from that specific batch ) is allocated to that specific sales transaction based on first in first out inventory method also showing their respective purchase prices.