table 7302 "Bin Content" - add "Expiration Date Filter" flowfilter

[Flavioide]

Describe the request

field(XXXX; "Expiration Date Filter"; Date) { Caption = 'Expiration Date Filter'; FieldClass = FlowFilter; }

 field(26; Quantity; Decimal)
        {
            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"),
                                                                "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                "Package No." = FIELD("Package No. Filter")));

field(29; "Pick Qty."; Decimal) { CalcFormula = Sum("Warehouse Activity Line"."Qty. Outstanding" 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"), "Action Type" = CONST(Take), "Lot No." = FIELD("Lot No. Filter"), "Serial No." = FIELD("Serial No. Filter"), "Package No." = FIELD("Package No. Filter"), "Expiration Date" = FIELD("Expiration Date Filter"), "Assemble to Order" = CONST(false)));

 field(30; "Neg. Adjmt. Qty."; Decimal)
        {
            CalcFormula = Sum("Warehouse Journal Line"."Qty. (Absolute)" WHERE("Location Code" = FIELD("Location Code"),
                                                                                "From 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"),
                                                                                  "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                "Package No." = FIELD("Package No. Filter")));

    field(31; "Put-away Qty."; Decimal)
    {
        CalcFormula = Sum("Warehouse Activity Line"."Qty. Outstanding" 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"),
                                                                              "Action Type" = CONST(Place),
                                                                              "Lot No." = FIELD("Lot No. Filter"),
                                                                              "Serial No." = FIELD("Serial No. Filter"),
                                                                              "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                              "Package No." = FIELD("Package No. Filter")));

        field(32; "Pos. Adjmt. Qty."; Decimal)
        {
            CalcFormula = Sum("Warehouse Journal Line"."Qty. (Absolute)" WHERE("Location Code" = FIELD("Location Code"),
                                                                                "To 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"),
                                                                                  "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                "Package No." = FIELD("Package No. Filter")));

    field(50; "Quantity (Base)"; Decimal)
    {
        CalcFormula = Sum("Warehouse Entry"."Qty. (Base)" 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"),
                                                                  "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                 "Package No." = FIELD("Package No. Filter")));

        field(51; "Pick Quantity (Base)"; Decimal)
        {
            CalcFormula = Sum("Warehouse Activity Line"."Qty. Outstanding (Base)" 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 Filter"),
                                                                                         "Action Type" = CONST(Take),
                                                                                         "Lot No." = FIELD("Lot No. Filter"),
                                                                                         "Serial No." = FIELD("Serial No. Filter"),
                                                                                         "Package No." = FIELD("Package No. Filter"),
                                                                                         "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                         "Assemble to Order" = CONST(false)));

    field(52; "Negative Adjmt. Qty. (Base)"; Decimal)
    {
        CalcFormula = Sum("Warehouse Journal Line"."Qty. (Absolute, Base)" WHERE("Location Code" = FIELD("Location Code"),
                                                                                  "From 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"),
                                                                                     "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                  "Package No." = FIELD("Package No. Filter")));

        field(53; "Put-away Quantity (Base)"; Decimal)
        {
            CalcFormula = Sum("Warehouse Activity Line"."Qty. Outstanding (Base)" 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"),
                                                                                         "Action Type" = CONST(Place),
                                                                                         "Lot No." = FIELD("Lot No. Filter"),
                                                                                         "Serial No." = FIELD("Serial No. Filter"),
                                                                                         "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                         "Package No." = FIELD("Package No. Filter")));

    field(54; "Positive Adjmt. Qty. (Base)"; Decimal)
    {
        CalcFormula = Sum("Warehouse Journal Line"."Qty. (Absolute, Base)" WHERE("Location Code" = FIELD("Location Code"),
                                                                                  "To 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"),
                                                                                     "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                  "Package No." = FIELD("Package No. Filter")));

        field(55; "ATO Components Pick Qty."; Decimal)
        {
            CalcFormula = Sum("Warehouse Activity Line"."Qty. Outstanding" 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"),
                                                                                  "Action Type" = CONST(Take),
                                                                                  "Lot No." = FIELD("Lot No. Filter"),
                                                                                  "Serial No." = FIELD("Serial No. Filter"),
                                                                                         "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                  "Package No." = FIELD("Package No. Filter"),
                                                                                  "Assemble to Order" = CONST(true),
                                                                                  "ATO Component" = CONST(true)));

    field(56; "ATO Components Pick Qty (Base)"; Decimal)
    {
        CalcFormula = Sum("Warehouse Activity Line"."Qty. Outstanding (Base)" 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"),
                                                                                     "Action Type" = CONST(Take),
                                                                                     "Lot No." = FIELD("Lot No. Filter"),
                                                                                     "Serial No." = FIELD("Serial No. Filter"),
                                                                                     "Expiration Date" = FIELD("Expiration Date Filter"),
                                                                                     "Package No." = FIELD("Package No. Filter"),
                                                                                     "Assemble to Order" = CONST(true),
                                                                                     "ATO Component" = CONST(true)));

Additional context

This new flowfilter is usefull for anyone want to calculate the quantities at a certain expiration date

[JesperSchulz]

Sounds fair, but since the code you are referring to is in the BaseApp, you'd have to suggest and fix this code in the BaseApp contribution pilot: https://github.com/microsoft/businesscentralapps. For access to the pilot, please fill out the following form: https://forms.office.com/r/E9wyE5a58f.

This repository is only for extensibility requests or pull requests towards the 1st party Business Central apps.

Would you like me to move the issue to the contribution pilot for you?

IMPORTANT: Microsoft is not going to address the reported issue for you. You will have to get the issue approved, and then push a pull request with the suggested changes yourself. If you would like Microsoft to address the issue, please create a support request. Learn more about our support channels here: https://aka.ms/bcsupport.

[JesperSchulz]

Closing due to inactivity. It's not a valid issue for the ALAppExtensions repository.