Skip to main content
Solved

BaseCuryInfoId cannot be empty

  • June 12, 2023
  • 1 reply
  • 191 views

Forum|alt.badge.img

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]
        [PXDBLong]
        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.
        [CurrencyInfo]
        [PXDBLong]
        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.

 

 

Best answer by sweta68

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

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

1 reply

Forum|alt.badge.img+9
  • Semi-Pro III
  • 229 replies
  • Answer
  • June 12, 2023

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


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