Skip to main content
Answer

Payment column of check form being multiplied by 10

  • December 17, 2024
  • 1 reply
  • 37 views
D
Varsity I
Forum|alt.badge.img

I’m reworking the AP check form (AP641000) for a client and for some reason the standard $Paid00 variable is multiplying the payment amount by 10.

When $Paid is assigned a new value in the report, it uses “=IIF($LineNbr = 0, Sum([APPrintCheckDetailWithAdjdDoc.AdjdInvtMult]*[APPrintCheckDetailWithAdjdDoc.CuryAdjgAmt]), $Paid00)” which I didn’t change. I know that APPrintCheckDetailWithAdjdDoc.AdjdInvtMult is 10 but I can’t find any documentation about what that field is or how it’s defined. I have voided and recreated this check multiple times so I suspect that may have something to do with it. 

I unfortunately cannot share the .rpx file because it contains sensitive client information. 

Best answer by lauraj46

Hi ​@dgranger70 ,

From the DAC definition, this field is defined as:

#region AdjdInvtMult
        public abstract class adjdInvtMult : PX.Data.BQL.BqlShort.Field<adjdInvtMult> { }
        [PXShort]
        [PXDBCalced(typeof(IIf<
            Where<APInvoice.docType, Equal<APInvoiceType.debitAdj>>,
            shortMinus1,
            short1>), typeof(short))]
        public virtual short? AdjdInvtMult
        {
            get;
            set;
        }
        #endregion

Based on this, that seems to be just a multiplier to correct the sign for credits.

Have you checked your joins to make sure that you aren’t adding duplicates in your calculation?

Laura

1 reply

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • Answer
  • December 20, 2024

Hi ​@dgranger70 ,

From the DAC definition, this field is defined as:

#region AdjdInvtMult
        public abstract class adjdInvtMult : PX.Data.BQL.BqlShort.Field<adjdInvtMult> { }
        [PXShort]
        [PXDBCalced(typeof(IIf<
            Where<APInvoice.docType, Equal<APInvoiceType.debitAdj>>,
            shortMinus1,
            short1>), typeof(short))]
        public virtual short? AdjdInvtMult
        {
            get;
            set;
        }
        #endregion

Based on this, that seems to be just a multiplier to correct the sign for credits.

Have you checked your joins to make sure that you aren’t adding duplicates in your calculation?

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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