How about trying to make the following tables with rest services? There is no purchasing capability for drugs in either openMRS or iDart. One possible process flow:
- Drug ordered from vendor. I assume vendor can be different than drug manufacturer. Need Drug_PO table and Vendor table.
- Each purchase order (PO) generates one record in Drug_PO table.
- The PO also generates one or more records in the Drug_Inventory for each batch of each type of drug.
The vendor table is the most isolated.
This whole area could eventually be developed into a purchasing system with PO's generating records in multiple types of inventory tables.
Maybe there is already a purchasing system. Then this would be redundant. However, we need to develop a handoff between that system and the openMRS to support the PO Details on the New Goods Receipt screen (page 26 of V4 wireframes).
Let me know what you think.