We have a scenario where items are received in hierarchical containers. For simplicity assume the following hierarchy -
A container (C) is received with one or more small containers (SC) with has one or more Boxes (B) which has one or more items. C->SC->B->Items. C, SC and B have unique ids
When items are sold to different customers, want to be able to trace the items to its original C, SC and B
What is the best way to capture ids of all the containers (say) in a Purchase Receipt?
For example, the Container id can map to Batch number (ERPNext), Box id can be mapped to Serial Number (ERPNext) What is the best way to deal with intermediate containers (SC) in this case?