Recent content by gcreed

Thank you very much, you have a brilliant mind. actually i thought you will not be able to solve it (my bad) i still have to connect (Project_ID) because my stock has warehouses and projects. i make a purchases, sales and transfers to a selected project and a selected warehouse. can i send you...

Sir, I have checked your file. The problem is when i try to transfer From warehouse 1 To 4. Quantity transferred will not show in (available quantity). (i assume because to purchase has been made on warehouse4)

YES, im aware of the version i shared, i fixed it all. im just facing a problem with the availablequantity field in warehouse_items(query)

i can share the db if you need it

let's say i have and ITEMCode "1" & 2 WH "Main Warehouse" "2nd Warehouse" i create a purchase invoice for (ItemCode "1") and i select (wh1"Main Warehouse"). now when i transfer (ItemCode"1") to ("2nd Warehouse"), AvailableQuantity will deduct the quantity from "Main Warehouse" but WON'T add the...

everything works fine ONLY if i make a purchase with 0 quantity to all warehouses, because as you see the code above starts with purchase table

multiple (not specific)

i didn't quietly understand your solution, can you please explain or maybe send me an example please.

AvailableQuantity: Sum([totalPurchaseData].[purchase_item_quantity])+(Nz((SELECT SUM(QuantityTransferred) FROM Transfers WHERE Transfers.ItemCode = [totalPurchaseData].[Item Code] AND Transfers.WareHouseCode = [Warehouse_tbl].[Warehouse_ID]AND Transfers.ProjectCode =...