I have attached a document on the purchase line (standard feature) with respect to LOT number. All the items has item tracking enabled and lot number is required. So each line in PO is mandatory to attach one document. So once the document is posted, the same attached will be copied to posted purchase invoice.
So the issue I'm trying to solve is I have to show the same document when I create a sales order with the same item and select the same lot the attached which is attached in the posted purchase document should be shown when a sales order is creating for that particular lot and item combination and once the sales order is posted it should be copied to posted sales invoice too. May I know what is the best way to solve it?
I'm thinking to flow the attachments to Item ledger entry once the purchase order is posted and fetch from there when we're creating sales order and selecting the lot.