thong127

Stock/Balance Calculation

Discussion created by thong127 on Aug 8, 2017
Latest reply on Aug 8, 2017 by philmodjunk

Hello All,

 

Before I will tell my problem I will give you a brief overview of what I am doing;

 

I have a system that I used to track Quantity Balance/Returned ; Quantity Dispensed ; Lot Number in which material was used.

 

Now we are using Inventory Card system to Determine which Lot Number that a certain material was Used  ;  How much Amount was Dispensed and How much Amount they Returned for inventory until that material is finish ; We want our system to put it in filemaker. Please find below our card sytem

 

card.png

I made a filemaker file with the following tables Materials & Materials Transactions

My problem is How can I Calculate my Quantity Balance with my present set up when they dispensed any amount. I cant get exactly on what I have on my Card system

 

I have attached my file that Im working with.

 

Thanks in advance.

Attachments

Outcomes