web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / CustinvoiceJour.SumTax...
Microsoft Dynamics AX (Archived)

CustinvoiceJour.SumTax is not equal to the Sum of CustInvoiceTrans.LineAmountTax field.

(0) ShareShare
ReportReport
Posted on by mail2vd 1,330

Hi,

I am not sure if i am doing correct comparision.

When I am printing Sales Invoice Report,  Tax amount on Individual sales line are being shown as Blank which is getting populated from CustinvoiceTrans.LineAmountTax field.

but in the same report, there is a summary Tax field which is being populated from CustinvoiceJour.SumTax with some value.  So I believe  Summary Tax field is actually a sum of all the sales Line's Tax Amount and they should match. But somehow Tax amount in Line shows blank in the report.

Can anyone please throw some light on what is getting wrong here?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: CustinvoiceJour.SumTax is not equal to the Sum of CustInvoiceTrans.LineAmountTax field.

    Hi Iamv,

    May be in salesinvoice report have line amount for all saleslines and same taxes for all lines,

    in report grand total = line amount + taxes?

    please check your report tax field value is correct in debugging?

    May be because of customization it is showing blank.

    Thanks

    Suresh

  • Community Member Profile Picture
    Community Member on at
    RE: CustinvoiceJour.SumTax is not equal to the Sum of CustInvoiceTrans.LineAmountTax field.

    Hi Crispin John Augustine,

        As you said additional component contributed by MarkupTrans required , may be

    if want to calculate maintain charges line wise in SO, we required markup trans.

           where markuptransLoc.TransTableId == custInvoiceTrans.TableId

               && markuptransLoc.TransRecId   == custInvoiceTrans.RecId;

    Thanks

    Suresh

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: CustinvoiceJour.SumTax is not equal to the Sum of CustInvoiceTrans.LineAmountTax field.

    Hi lamv,

    Why do you make this comparison?

    Is is a part of your month end closing process?

    Best regards,

    Ludwig

  • Martin Winkler Profile Picture
    Martin Winkler 119 on at
    CustinvoiceJour.SumTax is not equal to the Sum of CustInvoiceTrans.LineAmountTax field.
    One answer here is the Sales tax amount Per invoice line Check Box in General ledger parameters (TaxParameters table field TaxSpecifyLine).
    If this checkbox is checked, custInvoiceTrans has TaxAmounts per line.
    However, in many legislations, TaxAmount should be calculated (only) from total per tax code - and due to rounding issues, you can have mismatches.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans