Based On PurchId show HSN,SAC,GST,TAX number ,Base Amount ,Tax Amnt,and Total static void Job19(Args _args) { PurchTable purchTable; VendTable vendTable; TaxDocumentComponentTransaction taxDocumentComponentTransaction; TaxDocumentRowTransaction_IN taxDocumentRowTransaction_IN; TaxDocumentRowTransaction taxDocumentRowTransaction; VendInvoiceInfoLine vendInvoiceInfoLine; VendInvoiceInfoTable vendinvoiceInfoTable; DirPartyTable ...
Posts
Update Recordset Example DLS_Test_VendorGSTInfo for this table static void DLS_Test_Details(Args _args) { DLS_Test_VendorGSTInfo dls_test; DLS_Test_GSTDetail dls_test2; delete_from dls_test2; insert_recordset dls_test2 (PurchId,TaxBaseAmount,PurchName,OrderAccount,HSNCode,SAC,CGST,SGST,IGST,RegistrationNumber) select PurchId,sum(TaxBaseAmount),PurchName,OrderAccount,HSNCode,SAC,sum(CGST),sum(SGST),sum(IGST),RegistrationNumber from dls_test group by PurchId,PurchName,OrderAccount,HSNCode,SAC,RegistrationNumber; update_recordSet dls_test2 setting Total= dls_test2.TaxBaseAmount+dls_test2.CGST+dls_test2.SGST+ dls_test2.IGST where dls_test2.PurchId; { info('records inserted'); } ...
How to get Company information and tax information using X++ code in Ax 2012 http://axatulblogs.blogspot.com/2017/09/get-vendors-gst-number-in-ax-2012-r3.html http://axgenius.blogspot.com/2016/08/how-to-get-company-information-using-x.html https://dhruvrthakar.blogspot.com/2017/07/get-vendor-gstin-from-purchase-order-in.html
Diplay Method is to show name and Tax code in Standard form 1)AR>>Journala>>Invoice Journal 2) write Display method in VendInvoice Journal Table to display that field public display TaxAmount gettaxcode() { TaxTrans taxtrans; select TaxAmount from taxtrans where taxTrans.Voucher == this.LedgerVoucher && taxTrans.TaxCode == "BED_EX_KA"; return taxtrans.TaxAmount; } 3) And Also for Name to diplay public display Name getname() { DirPartyTable dirPartyTable; VendTable vendtable; select *from vendtable join Name from dirPartyTable where ...
TaxTrans Table Data Can be sorted by Tax Codes static void Tax_1016(Args _args) { TaxTrans taxTrans_In; VendInvoiceJour vendInvoiceJour; DLSTax_1016 dlsTax_1016; //real BED_EX_KA,Cess_EX_KA,EC_EX_KA,SHE_EX_KAR; //INMF-110000059 delete_from dlsTax_1016; { while select ledgervoucher from VendInvoiceJour { while select * from taxTrans_In where taxTrans_In.Voucher == vendInvoiceJour.LedgerVoucher { dlsTax_1016.Voucher = taxTrans_In.Voucher; switch (taxTrans_In.TaxCode )...