Bin Quantity - SQL

Answers

• ShaiHulud Member Posts: 228

  2022-06-30 edited 2022-06-30 Answer ✓

  Bin Quantity is calculated from table "Warehouse Entry"

  0
• RabbitPost Member Posts: 17

  2022-07-08

  Hi Shai
  
  DO you know what the calculation is

  0
• ShaiHulud Member Posts: 228

  2022-07-11

  Bin Quantity is calculated in "Bin Content" table's field "Quantity". It's a flowfield with the following calculation formula:

  CalcFormula = Sum("Warehouse Entry".Quantity WHERE("Location Code" = FIELD("Location Code"),
                                                                  "Bin Code" = FIELD("Bin Code"),
                                                                  "Item No." = FIELD("Item No."),
                                                                  "Variant Code" = FIELD("Variant Code"),
                                                                  "Unit of Measure Code" = FIELD("Unit of Measure Code"),
                                                                  "Lot No." = FIELD("Lot No. Filter"),
                                                                  "Serial No." = FIELD("Serial No. Filter"),
                                                                  "Package No." = FIELD("Package No. Filter")));
  

  "Lot No. Filter", "Serial No. Filter" and "Package No. Filter" and FlowFilter fields, so they will not exist in the database, but the others you should be able to find.
  If you're not using alternative Variants or Unit of Measures, then you don't need to include those either. In that case, you only need to filter by Location Code, Bin Code and Item No.

  0