Solved

BaseCuryInfoId cannot be empty

  • 12 June 2023
  • 1 reply
  • 135 views

Userlevel 3
Badge

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.

 

 

icon

Best answer by sweta68 12 June 2023, 14:02

View original

1 reply

Userlevel 7
Badge +10

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


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