Display External Item Text in Sales Confirm Report.

Finance and Operations/AX Developer Forum
1

Hi,
I want to display external item text

Path:
Inventory Management>Itemdetails>setup>CustItemDesc>Setup(Button)>Description Tab>External Item Text.
in the sales confirm report.

Can anyone suggest some way what display method should i write.

Thanks,

Vikas Mehta.

2

The External Item Description will be automatically printed on the Confirmation Report. If the Item Description is defined before creating sales order lines.

When you create a sales order line - and select the itemId - the system will look for external item description for that item and customer - if exists, it will be copied to the Name(Text) field in the general tab. By default the Name field will take the Item Name. You have two options here either you can append the Item description with the external item description or you can overwrite the Item Description with the external Item description.(Which you can setup in the AR → Setup -. Forms → Form setup → General tab → External Item Description)

When you post the confirmation the Name field value from sales line table will be copied to the Name field of the CustConfirmTrans(This table is used in the report).

This Name field will be printed in the report - So you need to define the External Item Description before creating sales line (or) change the Name(Text) field in the sales lines (General Tab) and then post the confirmation…

3

Thanks Kranti,

What u said is correct but that is only valid if i want to dispaly ExternalItemId and not ExternalItemTxt

I want to display ExternalItemTxt attached to the description field in the sales Confirm Report,.

Please have some inputs on how will I display ExternalItemTxt. I used the following method in case of the field (description )

display Name Custdescriptionconfirm()
{
;

return CustConfirmTrans.Name + CustVendExternalItem::find(ModuleInventPurchSalesVendCustGroup::Cust,CustConfirmTrans.ItemId,inventDim.inventDimId,CustConfirmTrans.Name,false).ExternalItemTxt;
}

but this doesn’t display any value.

4

It will also display the Item Text.

The below a sample code to display the Item Text…

display ExternalItemFreeTxt custExtItemDesc()
{
CustExternalItemDescription custExternalItemDescription;
;
custExternalItemDescription = new CustExternalItemDescription(CustConfirmTrans.ItemId,
CustConfirmTrans.salesLine().inventDim(),
CustConfirmTrans.custConfirmJour().OrderAccount);

custExternalItemDescription.findExternalDescription();

return custExternalItemDescription.externalItemFreeTxt();
}

5

Thanks Kranti that really worked for me.