Option field printing problem on excel

Business Central/NAV Developers Forum
1

ExcelBuf.AddColumn(FORMAT(“Item Ledger Entry”.“Document Type”),FALSE,’’,FALSE,FALSE,FALSE,’’);

It prints 0,4, such of value .

but i need text value as like ,Sales Shipment,Sales Invoice,Sales Return Receipt,Sales Credit Memo,Purchase Receipt,Purchase Invoice,Purchase Return Shipment,Purchase Credit Memo,Transfer Shipment,Transfer Receipt,Service Shipment,Service Invoice,Service Credit Memo,Item Receipt,Item Shipment

how to solve this?

2

you can take a text variable and based on the option you have to export the text like

IF “Item Ledger Entry”.“Document Type” = “Item Ledger Entry”.“Document Type”::Order then

DocType := ‘Order’;

Use DocType in export…