Basically you have to figure out how to determine the sales order from the CustTrans record that is available there.Īfter that, you still have to customize CustAccountStatementExtDP.insertNewRecords method because for some reason the records are copied from one instance of the (temporary) table CustAccountStatementExtTmp to another.Īfter that the new field should show up in the data set of the report in Visual Studio and you can then include it in the report layout (see Matej's answer on how to do that). This will require some work, because you have no direct way to access the SalesTable record there. Has anyone done such thing, please share your ideas. You will also have to customize the creation of the CustAccountStatementExtTmp records which in this case is surprisingly done in the report controller class CustAccountStatementExtController (usually the report tables are filled in the data provider class). Hi, I want to transfer a customized field value from sales table to CustTrans table, i tried writing code in SalesFormLetterinvoice class in CreatePayment method, still the value is not getting updated for customized field. To do that you have to add a new field to table CustAccountStatementExtTmp that will hold the value of the CustomerRef field from table SalesTable. you can fetch the salesorderId from CustInvoiceJour table via the Invoice Id.

Hi Ahmed, In ‘custtrans’ table you have ‘InvoiceId’ field & In cust invoice jour table you also have the same field so. In addition to Matej's answer (which only covers the customization of the report layout) you also have to make the field available in the report data source. Dear, How can i show sales order NO in the customer transactions form.

Custtrans transtype salesorder ax 2012