Prev
Next
Forums Enterprise Resource Planning & Manufacturing Lawson S3 Procurement

matching sales tax invoice

 4 Replies
 0 Subscribed to this topic
 1 Subscribed to this forum
Sort:
Author
Messages
Russell Spreeman
Veteran Member
Posts: 61
Veteran Member
4/5/2016 2:48 PM
    We recently switched from non profit to profit and as such we now have to pay sales tax on many of the items we buy, including things we order via EDI. When we run MA540 the sales tax appears in the MA540CSV file which we get (via GHX, all our EDI vendors come through there) but it's not matching. Do we need an entry in the substitution table? I don't get any errors saying something didn't match but I don't know where else we would set up to have the sales tax amount on the invoice agree with what we have on this side of things. Any suggestions would be appreciated.
    JonA
    Veteran Member
    Posts: 1163
    Veteran Member
    4/6/2016 3:56 PM
      Substitution table record isn't necessary if the tax is appearing on the MA540CSV file. No errors? Nothing on the MA540 fatal error report? Does the invoice tax amount equal the tax amount on the PO?
      Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
      Russell Spreeman
      Veteran Member
      Posts: 61
      Veteran Member
      5/2/2016 5:32 PM
        The invoices are showing up as unreleased with the error “Match unsuccessful, tax out of balance”. This is only happening on invoices with sales tax on them.
        JonA
        Veteran Member
        Posts: 1163
        Veteran Member
        5/2/2016 7:06 PM
          I wish I knew more about sales tax but as we're non-profit I haven't had much experience with it. When you say "this side of things" I'm assuming you have tax on the PO line?
          Jon Athey - Sr. Supply Chain Analyst - Materials Management - MyMichigan Health
          Russell Spreeman
          Veteran Member
          Posts: 61
          Veteran Member
          5/3/2016 12:40 PM

            We did try out a few invoices by putting sales tax on the PO header line. I'm not an accountant or 'purchaser' so I can just relay what they tell me.

            It's been very frustrating because one would think that Infor could have told us 'okay, you need to do this and this with the tax, make sure this and that form are populated, and when you run MA540 this is what should happen.' It's not like we're experimenting with some new unusual idea but we get the feeling we're trying to re-invent the wheel. We've had two tickets open with them and they seem unable to guide us in getting this working so I'm appreciative of whatever input I can get from others.