SalesAgreementGenerateReleaseorder Form need a remark field

(1) Share

Report

Posted on by faiz7049

1,877

Hi Experts,

I need to add remark field in SalesAgreementGenerateReleaseOrder. This Form has SalesCreateReleaseOrderTableTmp data source. I added a field in SalesCreateReleaseOrderTableTmp as well as in SalesTable table.

I think adding remark field in SalesCreateReleaseOrderTableTmp is not best way because this is inMemory and entity link with it.

Most of or all fields value are coming to SalesCreateReleaseOrderTableTmp and SalesCreateReleaseOrderLineTmp from SalesTable and SalesLine.

How to do it.

My objective is to get remark field text to Sales order confirmation report.

Please guide me how to achieve it.

Thanks,

Faiz

All responses (1)

Answers (0)

Jonas "Jones" Melgaard 1,920 on at

Like (1)

Report
SalesAgreementGenerateReleaseorder Form need a remark field

Hi Faiz,

You use the Sales Agreement Release Orders to generate a release order, which, in this case, is a sales order.
So the values needs to flow from the form, to the order, to the journal, and finally to the report.

Here is how I would have done it:

Add the field on the temp table (SalesCreateReleaseOrderTableTmp) and SalesTable.

Create a CoC on SalesAutoCreate_ReleaseFromAgreement() to store the field value on SalesTable from SalesCreateReleaseOrderTableTmp.

Add the field to the order confirmation journal (CustConfirmJour), and create a CoC on CustConfirmJour.initFromSalesTable() to journalize the value.

Use the field on CustConfirmJour in your customized report.

If you are working with external reports, always try to journalize the values you are sending to externals.