ahmedjamalaboelez
Ahmed J. Aboelez
- Local time
- Today, 01:14
- Joined
- Feb 25, 2015
- Messages
- 79
Gentlemen, good day
i need your help regarding attached database
i have 3 tables
1 - invoice lines
2 - store available loots ( every loot has its own cost)
3 - invoice usage material
when i click invoice post button , i need loop event , to create records in table (invoice usage materials ) for each invoice line , go to first batch record and create line with the quantity available in the batch , and if the quantity was not enough go to next batch line ... ets
I really appreciate your kind help because all my warehouse work depending on this kind of transactions
i need your help regarding attached database
i have 3 tables
1 - invoice lines
2 - store available loots ( every loot has its own cost)
3 - invoice usage material
when i click invoice post button , i need loop event , to create records in table (invoice usage materials ) for each invoice line , go to first batch record and create line with the quantity available in the batch , and if the quantity was not enough go to next batch line ... ets
I really appreciate your kind help because all my warehouse work depending on this kind of transactions