Hello everyone! I’m working on a project that has me totally stumped. I’m trying to create a report or search that ties sales orders and inventory balance together to allow for the determination of which transfer orders need to be prioritized. The difficulty that I’m running into is that the sales orders utilize a child item of the normal stock item. Anybody have any clues on how I can tie these together?

Can you give some examples of what you need. One thing I've previously done with transfer orders by line was comparing the Inventory level of the TO & FROM locations with the ITEM's Location Available. In the above I started it as an Item search which allows the joining of the Item's Inventory Location to the Transactions to/from locations to the return the Location Available. If that helps.

Hmm. I tried something like that and was unable to make it work due to the items in question being lot numbered assemblies. Sorry for the lack of specificity. The end result that I need is to look at the amount of the child inventory on sales orders vs. the parent inventory in stock. Does that make more sense?