D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Sales Tax Payments Difference

  • 1.  Sales Tax Payments Difference

    SILVER CONTRIBUTOR
    Posted Dec 18, 2014 04:40 PM

    I have an issue where we have run the Sales Tax Payments job, but the amount posted to AP (invoice to the Tax authority) is different than what the report stated the amount would be.

    I can't figure out a way to track down the difference between what was posted, and what the report said should have been posted. All of the transactional data I see support the report's figure. I have not been able to find data that supports the posted value. 

    ------------------------------
    Lonnie Smith
    Business Analyst
    Stupp Bros., Inc.
    St. Louis MO
    ------------------------------



  • 2.  RE: Sales Tax Payments Difference

    GOLD CONTRIBUTOR
    Posted Dec 19, 2014 09:16 AM
    Just to make that clear you are saying the posted sales tax (under GL/inquiries) supports the reports figure? I'm asking because there were a few issues with the report in the early AX2012 (guessing your version) days. Do you have a report called: Sales tax specification by ledger transaction you can run?

    ------------------------------
    Anja Fisher
    Partner Consulting Services
    Arbela Technologies
    Cumming GA
    ------------------------------




  • 3.  RE: Sales Tax Payments Difference

    SILVER CONTRIBUTOR
    Posted Dec 19, 2014 10:04 AM

    First, to be more precise, I'm talking specifically about Use Tax, which is accrued in a Use Tax Payable and paid to the taxing authority the month following.

    The posted S/T from invoices match the report.  The payable created via the "Update" function on the Periodic job Sales Tax Payments, differs.

    So the real life example looks like this: The G/L Payable balance for November was $4,141.11, the Sales Tax report shows $4,141.19 (penny diff. immaterial) which is what I expect.  However, when the Update was run for the Sales Tax payment, the Payable created was $4,154.27 (a difference of $13.08)  The payable is for more than has been accrued to the ledger.

    We are on 2012R2 CU6.

    ------------------------------
    Lonnie Smith
    Business Analyst
    Stupp Bros., Inc.
    St. Louis MO
    ------------------------------




  • 4.  RE: Sales Tax Payments Difference

    GOLD CONTRIBUTOR
    Posted Dec 22, 2014 08:42 AM
    I would look into two things next: run the reconciliation report (instead of the sales tax payment report) and see if that agrees with the sales tax payment report. If those two agree - I would reconcile the posted sales tax transactions (inquiries) to both reports and the GL. My guess is the $13 difference could be credit notes into prior periods, or manual adjustments of the use tax amount upon posting.

    ------------------------------
    Anja Fisher
    Partner Consulting Services
    Arbela Technologies
    Cumming GA
    ------------------------------




  • 5.  RE: Sales Tax Payments Difference

    SILVER CONTRIBUTOR
    Posted Jan 22, 2015 05:39 PM

    Ok, we have determined that the issue has something to do with taking a discount. So what has happened is, the Sales Tax payments report is showing the discounted line item times the tax, but the amount being posted to the Taxing Authority during the "Update" function is using the gross (pre-discounted) value times the tax.

    Below is an example of what shows up in the accounting distribution of an item with a discount taken.  The red boxed amounts is the difference between what the Sales Tax payments report shows and what is posted to the Tax Authority. I would expect the discounted amount to be in both places. Does anyone know if this is a bug, or is there some setting we missed that is creating this problem?



    ------------------------------
    Lonnie Smith
    Business Analyst
    Stupp Bros., Inc.
    St. Louis MO
    ------------------------------




  • 6.  RE: Sales Tax Payments Difference

    Posted Jul 11, 2019 08:37 AM
    Did you ever find any resolution on this? We are experiencing the same issue where the Sales Tax payments report is showing the discounted line item times the tax, but the amount being posted to the Taxing Authority during the "Update" function is using the gross (pre-discounted) value times the tax. Therefore, our sales tax subledger and our General Ledger for the accrued sales tax account is not in balance.

    Any guidance or knowledge on what to do? If we are missing a set-up parameter? Why this is happening, etc... would be greatly appreciated.


    ------------------------------
    Rebecca Bunch
    Universal Leaf Tobacco Company, Inc.
    Richmond VA
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role