Skip to main content
Solved

Multiply Release Quantity by Newly Set Required Quantity (1.00) in Material Wizard 2 Screen (AM300020)

  • December 5, 2024
  • 2 replies
  • 34 views
T
Pro I
Forum|alt.badge.img+2

Hi I have done a customization where I set the required qty to 1.00 in the material wizard 2 screen which works, I now need to make sure the release qty field also reflects this change where release qty needs to be the 1.00*the BOM, it still seems to be the original qty * the BOM with the logic I have written below.

using System;
using PX.Data;
using System.Collections.Generic;
using System.Collections;
using PX.Objects.Common.Extensions;
using PX.Objects;
using PX.Objects.AM;

namespace PX.Objects.AM
{
  public class MatlWizard2_Extension : PXGraphExtension<PX.Objects.AM.MatlWizard2>
  {
    #region Event Handlers

 // Use RowSelected to update QtyReq when the row is selected or edited
        protected void AMWrkMatl_RowSelected(PXCache sender, PXRowSelectedEventArgs e)
        {
            var row = (AMWrkMatl)e.Row;
            if (row == null) return;

            // Force QtyReq to 1.00 whenever a row is selected or edited
            row.QtyReq = 1.00m;
            sender.SetValue<AMWrkMatl.qtyReq>(row, 1.00m);

            // Optional: add debugging info here for verification
            PXTrace.WriteInformation("AMWrkMatl_RowSelected: Setting QtyReq to 1.00");

            // Perform the MatlQty calculation
            if (row.QtyReq != null && row.BaseQtyReq != null)
    {
       // Check if it's a byproduct, if so, reverse the sign
        var qty = Math.Abs(row.QtyReq.GetValueOrDefault()) * (row.IsByproduct.GetValueOrDefault() ? -1 : 1);
        var baseQty = Math.Abs(row.BaseQtyReq.GetValueOrDefault()) * (row.IsByproduct.GetValueOrDefault() ? -1 : 1);

        // Set MatlQty based on QtyReq and BaseQtyReq (similar to original code logic)
        row.MatlQty = qty * baseQty;
        sender.SetValue<AMWrkMatl.matlQty>(row, row.MatlQty);

        PXTrace.WriteInformation($"Calculated MatlQty: {row.MatlQty}");
    }

        }

    #endregion
  }
}

Any help would be appreciated, thank you!

Best answer by noorula77

Hi ​@TharidhiP ,
can you please try to modify code like this .

Added a RowPersisting event handler to ensure values remain correct during save

 

 protected void AMWrkMatl_RowSelected(PXCache sender, PXRowSelectedEventArgs e)
        {
            var row = (AMWrkMatl)e.Row;
            if (row == null) return;

            // Force QtyReq to 1.00
            row.QtyReq = 1.00m;
            sender.SetValue<AMWrkMatl.qtyReq>(row, 1.00m);

            // Get the BOM quantity
            decimal bomQty = row.BaseQtyReq ?? 0m;

            // Calculate release quantity (MatlQty) as 1.00 * BOM quantity
            decimal calculatedQty = 1.00m * bomQty;

            // Apply byproduct sign adjustment if needed
            if (row.IsByproduct == true)
            {
                calculatedQty = -calculatedQty;
            }

            // Set the calculated MatlQty
            row.MatlQty = calculatedQty;
            sender.SetValue<AMWrkMatl.matlQty>(row, calculatedQty);

            // Add debug logging
            PXTrace.WriteInformation($"AMWrkMatl_RowSelected - QtyReq: 1.00, BOMQty: {bomQty}, Calculated MatlQty: {calculatedQty}");
        }

        // Optional: Add RowPersisting handler to ensure values stick
        protected void AMWrkMatl_RowPersisting(PXCache sender, PXRowPersistingEventArgs e)
        {
            var row = (AMWrkMatl)e.Row;
            if (row == null) return;

            if (e.Operation == PXDBOperation.Insert || e.Operation == PXDBOperation.Update)
            {
                // Ensure QtyReq is 1.00
                if (row.QtyReq != 1.00m)
                {
                    row.QtyReq = 1.00m;
                    sender.SetValue<AMWrkMatl.qtyReq>(row, 1.00m);
                }

                // Recalculate MatlQty to ensure consistency
                decimal bomQty = row.BaseQtyReq ?? 0m;
                decimal calculatedQty = 1.00m * bomQty;
                
                if (row.IsByproduct == true)
                {
                    calculatedQty = -calculatedQty;
                }

                row.MatlQty = calculatedQty;
                sender.SetValue<AMWrkMatl.matlQty>(row, calculatedQty);
            }
        }

View original
Did this topic help you find an answer to your question?

2 replies

N
Jr Varsity I
Forum|alt.badge.img+1
  • noorula77
  • Jr Varsity I
  • 62 replies
  • Answer
  • December 5, 2024

Hi ​@TharidhiP ,
can you please try to modify code like this .

Added a RowPersisting event handler to ensure values remain correct during save

 

 protected void AMWrkMatl_RowSelected(PXCache sender, PXRowSelectedEventArgs e)
        {
            var row = (AMWrkMatl)e.Row;
            if (row == null) return;

            // Force QtyReq to 1.00
            row.QtyReq = 1.00m;
            sender.SetValue<AMWrkMatl.qtyReq>(row, 1.00m);

            // Get the BOM quantity
            decimal bomQty = row.BaseQtyReq ?? 0m;

            // Calculate release quantity (MatlQty) as 1.00 * BOM quantity
            decimal calculatedQty = 1.00m * bomQty;

            // Apply byproduct sign adjustment if needed
            if (row.IsByproduct == true)
            {
                calculatedQty = -calculatedQty;
            }

            // Set the calculated MatlQty
            row.MatlQty = calculatedQty;
            sender.SetValue<AMWrkMatl.matlQty>(row, calculatedQty);

            // Add debug logging
            PXTrace.WriteInformation($"AMWrkMatl_RowSelected - QtyReq: 1.00, BOMQty: {bomQty}, Calculated MatlQty: {calculatedQty}");
        }

        // Optional: Add RowPersisting handler to ensure values stick
        protected void AMWrkMatl_RowPersisting(PXCache sender, PXRowPersistingEventArgs e)
        {
            var row = (AMWrkMatl)e.Row;
            if (row == null) return;

            if (e.Operation == PXDBOperation.Insert || e.Operation == PXDBOperation.Update)
            {
                // Ensure QtyReq is 1.00
                if (row.QtyReq != 1.00m)
                {
                    row.QtyReq = 1.00m;
                    sender.SetValue<AMWrkMatl.qtyReq>(row, 1.00m);
                }

                // Recalculate MatlQty to ensure consistency
                decimal bomQty = row.BaseQtyReq ?? 0m;
                decimal calculatedQty = 1.00m * bomQty;
                
                if (row.IsByproduct == true)
                {
                    calculatedQty = -calculatedQty;
                }

                row.MatlQty = calculatedQty;
                sender.SetValue<AMWrkMatl.matlQty>(row, calculatedQty);
            }
        }

T
N
Chris Hackett
3 people like this
  • T
    TharidhiP
  • N
    NageswaraRaoAddanki60
  • Chris Hackett
    Chris Hackett
T
Pro I
Forum|alt.badge.img+2
  • TharidhiP
  • Author
  • Pro I
  • 105 replies
  • December 8, 2024

Thanks ​@noorula77 I will try this out!

Chris Hackett
N
2 people like this
  • Chris Hackett
    Chris Hackett
  • N
    noorula77

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved