Skip to main content

Hi Team,

Anyone came across this issue before, we are getting error when running commissions for Projects. This is a customized screen and while debugging can see BaseCuryInfoId and ProjectCuryInfoID values under PMTran are not set. When compared with previous version i.e. 2019 there is a change in DAC definition.

public abstract class baseCuryInfoID : PX.Data.BQL.BqlLong.Field<baseCuryInfoID> { }
         PXDBLong]
        ÂCurrencyInfo(CuryIDField = nameof(TranCuryID), CuryRateField = nameof(BaseCuryRate), ModuleCode = BatchModule.PM)]
        public virtual long? BaseCuryInfoID
        {
            get;
            set;
        }

2022 R1 

 ÂCurrencyInfo]
                public virtual long? ProjectCuryInfoID { get; set; }
        //
        // Summary:
        //     The identifier of the CurrencyInfo record that stores exchange rate from the
        //     transaction currency to the base currency.
        //
        // Value:
        //     The value of this field corresponds to the value of the PX.Objects.CM.Extensions.CurrencyInfo.CuryInfoID
        //     field.
        hCurrencyInfo]
        CPXDBLong]
        public virtual long? BaseCuryInfoID { get; set; }

 

Any idea if this value needs to be set manually or some sort of configuration that needs to be done at system level?

Similar changes can be seen for property ProjectCuryInfoID.

 

 

Hi @vibindas ,

In the 2022 R1 version, the CurrencyInfo attribute has been added to both the ProjectCuryInfoID and BaseCuryInfoID fields. This attribute indicates that these fields are linked to the CurrencyInfo table, which stores exchange rate information and other currency-related details.

To retrieve the values of ProjectCuryInfoID and BaseCuryInfoID, you should query the CurrencyInfo table instead of the PMTran table. The CurrencyInfo table will provide the correct values for these fields in the 2022 R1 version of Acumatica.

Regards,

Sweta


Reply