Transfer field value from one screen to another screen

Hi @AndrewA 

To accommodate a larger number of characters in the description field, you can execute the script to modify the table and expand the DAC by adding the "descr" field with the desired length.

Sample code:

ALTER TABLE ARTRAN
ALTER COLUMN Decr NVARCHAR(500)

  
 #region TranDescr
       public abstract class tranDescr : PX.Data.BQL.BqlString.Field<tranDescr> { }
        protected String _TranDescr;
        [PXDBString(500, IsUnicode = true)]
        [PXUIField(DisplayName = "Description ")]
        [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)]        
        public  String TranDescr
        {
            get{    return this._TranDescr;}
            set{ this._TranDescr = value;}
        }
        #endregion

Additionally, you can write the necessary logic in the Field Updated event using appropriate BQL and assign the value to the "descr" field.

Sample code

protected virtual void ARTran_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated baseEvent)
            {
                ARTran row = (ARTran)e.Row;

                // Sample BQL. Write proper BQL to get the descr as per your requirement

                PMRevenueBudget selectRevenueBudget = PXSelect<PMRevenueBudget, Where<PMRevenueBudget.projectID, Equal<Required<ARInvoice.projectID>>,
                                                     And<PMRevenueBudget.projectTaskID, Equal<Required<PMRevenueBudget.projectTaskID>>,
                                                     And<PMRevenueBudget.type, Equal<PX.Objects.GL.AccountType.income>>>>>.Select(Base, row.ProjectID, row.TaskID);

                row.TranDesc = selectRevenueBudget?.Description;

            }

Hi Jini,

Sorry for the delay in getting back to you. I realise now that the first part of your response, the SQL script, is what I needed to do in the first place to avoid the current issue I am having.

As mentioned in the beginning of my question, I had created a new custom description field to replace the original one. Now I want to revert back so that the original description field is the one being used.

Using SQL, is there a way I can copy the value of the custom field over to the original field Maybe something like below?

UPDATE PMRevenuBudget
SET Description = UsrDescriptionExt
WHERE Description = '' and UsrDescriptionExt <> ''

Hi @AndrewA 

You can first modify a single record using the below query,

UPDATE PMRevenuBudget
SET Description = UsrDescriptionExt
WHERE projectid='urprojectID' // Add more conditions if needed

Then remove the where condition and run the script, it will update for all records.

Hi @AndrewA,

By using the ARTran_RowSelected event, you can dynamically update the tranDesc field of the ARTran cache based on the selected row's task ID. This allows you to display the custom description from the related project task in the invoice line.

Hope, it helps.!

Regards,

Sweta

Thanks everyone for your responses! Forgot to update this issue but I managed to resolve it after running the SQL script as suggested by @jinin.

Also, as @aaghaei mentioned, I ran into the issue of the PMRevenueBudget table not existing, but remembered to try the PMBudget table which worked.

Thanks again for your help!

Kind regards,

Andrew