Hello there,
I work in a field with long delivery times where we do not only do orders on sales basis, but also "preemptively".
What I need is therefore a list of stock consisting of:
Purchase line qty of item minus reservations qty made on that line (so unsold purchase line entries)
and in addition also
Item ledger entries minus reserved and shipped quantities.
Our system currently goes as follows:
Create a purchase order -> do reservations on purchase line from a sales order. When shipping documents from suppliers arrive, we do a reception of purchase lines, making them item ledger entries (the items then receive unique lot numbers in different locations and bins).
For our sales department, we need to be able to see ALL unsold (received or not received) items (optimally with respective locations, Purchase order numbers and locations)
Is there a quick way to see this in BC? (I saw "qty on hand" in some tables, but that doesn't solve everything).
Or will I need to go experimenting with different report tables and links?
Thanks in advance!