User Profile

Collapse

Profile Sidebar

Collapse
gcreed
gcreed
Last Activity: Apr 17 '21, 07:23 AM
Joined: Nov 3 '18
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • gcreed
    started a topic stock QTY ON HAND problem
    in General

    stock QTY ON HAND problem

    AvailableQuanti ty: Sum([totalPurchaseDa ta].[purchase_item_q uantity])+(Nz((SELECT SUM(QuantityTra nsferred) FROM Transfers WHERE Transfers.ItemC ode = [totalPurchaseDa ta].[Item Code] AND Transfers.WareH ouseCode = [Warehouse_tbl].[Warehouse_ID]AND Transfers.Proje ctCode = [Projects_tbl].[Project_ID]),0))-(Nz((SELECT SUM([sales_Item_Quan tity]) FROM [totalSalesData] WHERE [totalSalesData].[Item Code] = [totalPurchaseDa ta].[Item Code] AND [totalSalesData].[Warehouse_ID]...
    See more | Go to post
    • gcreed
      started a topic stock QTY ON HAND problem
      in General

      stock QTY ON HAND problem

      AvailableQuanti ty: Sum([totalPurchaseDa ta].[purchase_item_q uantity])+(Nz((SELECT SUM(QuantityTra nsferred) FROM Transfers WHERE Transfers.ItemC ode = [totalPurchaseDa ta].[Item Code] AND Transfers.WareH ouseCode = [Warehouse_tbl].[Warehouse_ID]AND Transfers.Proje ctCode = [Projects_tbl].[Project_ID]),0))-(Nz((SELECT SUM([sales_Item_Quan tity]) FROM [totalSalesData] WHERE [totalSalesData].[Item Code] = [totalPurchaseDa ta].[Item Code] AND [totalSalesData].[Warehouse_ID]...
      See more | Go to post
      • gcreed
        replied to purchases - sales problem
        in Access
        Luuk please check out the db on the following link
        See more | Go to post

          Leave a comment:

        • gcreed
          started a topic purchases - sales problem
          in Access

          purchases - sales problem

          Hello,

          I am working on stock control DB. I have already reached multiple warehouses creation; purchasing; transfer between warehouses.

          my problem now is selling item stock deduction. I will show here the query im using

          Purchase Query:
          Code:
          SELECT Warehouse.[Warehouse Code], 
       Warehouse.[Warehouse Description 1], 
       Item.[Item Code], 
       Item.[Item Description 1],
          ...
          See more | Go to post
          Last edited by twinnyfo; Nov 5 '18, 06:32 PM. Reason: Formatted SQL a bit more neatlier. (Last edited by NeoPa; 1 Days ago at 06:32 PM. Reason: Tidied up a sloppy mess and added the mandatory [CODE] tags.)
          No activity results to display
          Show More
          Working...