Dear Guru's I have a query as follows.

Case Scenario:
Products are being replenished through multiple Purchase Orders and 'received' accordingly, and bills created.

Once the products are in stock they are being sold (Sales) and delivered and invoiced to customers.
So far all good.

After, a few days or weeks we receive the freight bill for a number of received purchase orders which we compute as ‘landing costs’
Once the LC bill is posted a journal entry is being created for every product prior delivered with a label like “Product name | qty | already out” indicating that a qty from a certain customer sales is already delivered.

Issue:
We are looking into how to, map that line, that qty delivered to the ‘delivery note’ or ‘customer invoice’
Mapping a relation back to the ‘received goods’ or ‘purchase order’ is possible but that is of no use to us, as we need a value (analytic account) in the ‘sales order’ or ‘ customer invoice.

Hope I explained our issue well and someone lead us in the right direction.

If you need further clarification please let us know.