I have created a saved search to list all 'stock affecting' transactions for a product, and then use an Advanced PDF template to generate a 'running total' of stock over time.
Can anyone confirm (definitively) what transactions are stock affecting?
My current search is using:
Type is any of:
Cash Refund
Cash Sale
Inventory Adjustment
Inventory Distribution
Inventory Transfer
Inventory Worksheet
Invoice
Item Fulfillment
Item Receipt
Account is:
1001 Current Asses : Stock
I thought this was working correctly, but I've just come across an item where the report is 2 out - so presumably it is not including some necessary transaction type(s).
I've tried looking through the (800+) transactions for the item to try and find something unusual for 2, but I couldn't see anything obvious.
Any other suggestions on how to improve the accuracy of this report? I'm not sure if the transaction types I've listed are correct, or if it needs adjusting??