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



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.