I have 3 Database.
1) Purchase Order 2) Material Received 3) Inventory.
kindly need ur suggestion on how i update the the inventory file automatically while creating the Material Received Voucher.
The follow goes :
PO made by Salesmen
When Material received, MRV made.
MRV Details should auto update the related item in the Inventory. i.e If Item1 in PO is 10. So when i make MRV its should be
Inventory Qty = inventory qty + MRV Qty(imported MRV qty from MRV DB).
But i am not able to update. but i am able to get to data to inventory file but cant update.
Please if anyone have the solution. please let me know.