Tax amout Print

Business Central/NAV User Forum
1

Sir,

I used vendInvoiceTrans table and fetch the needed columns and create report through display method. Now I need how to fetch tax amount related items, Ex_Bed,Vat,and CST all is stored in Tax amount. I Need report this given below the formats

PONO, Date, Item, ItemName, Qty , Assessable Value EX_BED, VAT CST Total amount.

001 01-04-15 aaa Item Name 10 14000,00 1400.00 - 308 15708.00

I fetched High lighted fields rest fields need your Help. Kindly any one help to give code to complete the reports. TaxTrans and TaxTrans_In tables are stored taxamount.

public boolean fetch()

{

boolean ret,flag;

Query q;

QueryRun qrun;

QueryBuildDataSource qbds;

QueryBuildRange qr_Range;

InventTable inventTable;

;

q = this.query();

qrun = new QueryRun(q);

qr_Range = qrun.query().dataSourceTable(tablenum(vendInvoiceTrans)).addRange(fieldnum(VendInvoiceTrans,InvoiceDate));

qr_Range.value(queryValue(fromDate)+ ‘…’+queryValue(toDate));

while(qrun.next())

{

vendInvoiceTrans = qrun.get(tablenum(VendInvoiceTrans));

if(!flag)

{

itemId = vendInvoiceTrans.ItemId;

invDate = vendInvoiceTrans.InvoiceDate;

itemName = InventTable::find(vendInvoiceTrans.ItemId).ItemName;

itemName = vendInvoiceTrans.Name;

purchId = vendInvoiceTrans.PurchID;

vendInvoiceId = vendInvoiceTrans.InvoiceId;

purchQty = vendInvoiceTrans.Qty;

lineAmt = vendInvoiceTrans.LineAmount;

vendName = vendInvoiceTrans.VendorName_IN;

element.send(vendInvoiceTrans);

element.execute(1);

}

ret = true;

}

if(!ret)

info(strfmt("@SYS58533","@SYS96179"));

return ret;

}

Regards