How to display GST rates and amounts used in Indian Taxation on Project Invoice Proposal Print Preview report?

Finance and Operations/AX Developer Forum
1

Hi all,

I want to display IGST, CGST, SGST amounts and rates used in Indian Taxation on Project Invoice proposal Print Preview report. We can see these amounts from the Tax document option as shown in following picture:

Snapshot.jpg
Snapshot.jpg930×430 93.9 KB

These rates and amounts can be for a sales order, subscription or hour journal posted on a project.

There are codes available online to calculate GST rates and amounts on Purchase order or sales order confirmation and invoice. But I can’t find a way to calculate the same on Project Invoice Proposal.

Actually, I need this because I want to show these rates and amounts for each line on Print Preview report in action pane.

2

What tables does the report uses?
You can use \Classes\TaxBusinessService.
For reference, see \Classes\SalesInvoiceDP\initSalesInvoiceTmpWithProforma_IN

3

Following class variables shows list of tables used by this report:

class PsaProjInvoiceDP extends ProjInvoiceDPBase
{
PSAProjInvoiceTmp tmpPSAProjInvoice;
PSAProjInvoiceHeaderTmp tmpPSAProjInvoiceHeader;
PSAProjInvoiceTaxTmp tmpPSAProjInvoiceTax;
ProjInvoiceEmpl projInvoiceEmpl;
ProjInvoiceCost projInvoiceCost;
ProjInvoiceItem projInvoiceItem;
ProjInvoiceRevenue projInvoiceRevenue;
ProjInvoiceOnAcc projInvoiceOnAcc;
ProjProposalJour projProposalJour;
PSAProjProposalProj psaProjProposalProj;

FormletterProformaPrint formletterProformaPrint;
FormLetterRemarks formLetterRemarks;
CustTable custTable;
boolean prebill;
PrePrintLevel prePrintLevel;
InventTrans inventTrans;
DocuRefSearch docuRefHeader;
DocuRefSearch docuRef;
boolean printDocuHeader;
boolean printDocuLine;

boolean showSepaNotification;
CustDirectDebitMandate custDirectDebitMandate;
CustBankAccount custDirectDebitMandateBankAccount;

#define.Category(’’)
#ISOCountryregionCodes

//
ProjInvoiceLocalizationTmp projInvoiceLocalizationTmp;

boolean isGEEUCountryContext;

Counter lineNumber;
boolean projCreditInvoicingSalesLine;
//

//
boolean isCountryRegionMY;
CustTable custTable_InvoiceAccount;

#define.Blank(’’)
//
}

4

Try using , \Classes\TaxBusinessService

5

Finally I found the solution. It is the class ProjProposalTotals which provides methods for calculating tax for sales order, hour journal, subscription, on account transactions etc.

Below given is the code for getting CGST, IGST, SGST rates and amounts for each line on Project Invoice Proposal-

static void GetGSTRatesAmountsOnProjectProposal(Args _args)
{
    ProjProposalTotals                  projProposalTotals;

    ITaxableDocument                    taxableDocument;
    ITaxDocumentComponentLineEnumerator lineEnumerator;
    ITaxDocumentComponentLine           componentLineObject;
    ITaxDocument                        taxDocumentObject;


    projProposalTotals = new ProjProposalTotals(ProjProposalJour::find('Your Proposal ID'));
    
    
    taxableDocument = TaxableDocumentObject::construct(projProposalTotals.parmTaxableDocDescriptorRevenueSubTrans());     //Use for Subscription
    //taxableDocument = TaxableDocumentObject::construct(projProposalTotals.parmTaxableDocDescriptorEmplTrans());         //Use for Hour journal
    //taxableDocument = TaxableDocumentObject::construct(projProposalTotals.parmTaxableDocDescriptorItemSOTrans());       //Use for Sales order
    //taxableDocument = TaxableDocumentObject::construct(projProposalTotals.parmTaxableDocumentDescriptorAccTrans());     //Use for On-account transaction
    
    
    taxDocumentObject = TaxBusinessService::calculateTax(taxableDocument);
    
    if (taxDocumentObject)
    {
        // Calculation of Tax amount for Tax type GST and Tax component SGST
        
        lineEnumerator = taxDocumentObject.componentLines("GST","CGST");
        while (lineEnumerator.moveNext())
        {
            componentLineObject = lineEnumerator.current();

            info(strFmt('%1', componentLineObject.getMeasure("Rate").value().value()*100));
            info(strFmt('%1', componentLineObject.getMeasure("Tax Amount").value().value()));
        }

        lineEnumerator = taxDocumentObject.componentLines("GST","IGST");
        while (lineEnumerator.moveNext())
        {
            componentLineObject = lineEnumerator.current();

            info(strFmt('%1', componentLineObject.getMeasure("Rate").value().value()*100));
            info(strFmt('%1', componentLineObject.getMeasure("Tax Amount").value().value()));
        }

        lineEnumerator = taxDocumentObject.componentLines("GST","SGST");
        while (lineEnumerator.moveNext())
        {
            componentLineObject = lineEnumerator.current();

            info(strFmt('%1', componentLineObject.getMeasure("Rate").value().value()*100));
            info(strFmt('%1', componentLineObject.getMeasure("Tax Amount").value().value()));
        }
    }
}

Thanks for your replies.