sales tax report

Hello. Does anyone know how to prevent A/R Summary Credit Notes from appearing on the sales tax report? The system assumes that these credit notes are sales-related but only the OE credit notes are sales related. We have a tax code that calculates no sales tax but the amounts on the AR credit notes still show up in the sales numbers of the sales tax report. I even click on the "calculate sales tax" button in the taxes tab for the customer to uncheck this, hoping this will solve the problem. Unfortunately, the numbers still show up on the tax report as negative sales. Just to reiterate, the tax amount is zero for the tax code on the AR summary credit notes but the amounts in these credit notes, which are hitting non-sales related GL accounts (the user selects the GL account that will be the other side of the accounts receivable entry), continue to show up on the tax report as negative sales amounts (again tax amount is zero but I do not want the tax basis and invoice amounts to be affected by AR credit notes).

  • 0

    Hello Michael,

    I would suggest printing the report from Item Tax Class rather than Tax Authority.. if you print by Tax Authority it will print all documents that have that authority so it will include documents created in modules other than Order Entry such as Accounts Receivable.

    Other than that, you can also have the report customized via Crystal Reports.. if you do not have Crystal Reports you can reach out to your Sage Partner.

    If this question does not resolve your problem, perhaps you can reach out and open a Customer Support ticket..

    Regards,

    David Crampton

    Sage

  • 0

    I don't think you will be able to eliminate credit notes from showing up in the tax reports.  You may have to edit the credit notes when they are entered to not calculate taxes.  Then you can set the Tax Base for the tax authorities to zero and thus change the value showing on the tax report.  This will show tax base and tax amounts as zero.

    Not sure it helps but may be a work around for you.

  • 0 in reply to Terry Gair

    I was thinking more that for these Credit Notes, the user could enter an item tax class "exempt" or "non-taxable" and make it Tax Class 3 or 4.. and then when printing the tax report, just don't select that tax class in the range.