get GST Amount in D365F&O using X++.
public Amount GetGSTAmount(str type)
{
TaxDocumentRowTransaction TaxDocumentRowTransaction;
TaxDocumentComponentTransaction TaxDocumentComponentTransaction;
TaxComponentTable_IN component;
TaxDocumentComponentTransaction_In taxDocumentComponentTransactionIn;
select sum(TaxAmount) from TaxDocumentComponentTransaction
exists join TaxDocumentRowTransaction
where TaxDocumentRowTransaction.RecId == TaxDocumentComponentTransaction.TaxDocumentRowTransactionRecId
&& TaxDocumentRowTransaction. Voucher == this. Voucher
&& TaxDocumentRowTransaction.InvoiceId == this.CustomerInvoiceNo
&& TaxDocumentRowTransaction.TransactionDate == this.CustomerInvoiceDate
exists join taxDocumentComponentTransactionIn
where taxDocumentComponentTransactionIn.TaxDocumentComponnetTransactionRecId == TaxDocumentComponentTransaction.RecId
exists join component where component.RecId == taxDocumentComponentTransactionIn.TaxComponent
&& component.TaxType == TaxType_IN::GST
&& component.Component == type;
return TaxDocumentComponentTransaction.TaxAmount;
} Keep Daxing!!
No comments:
Post a Comment