Shipment entry error

SOLVED

We are working on web integration, orders are imported in Sage but when trying to ship receiving error below. Tairox data integrity is not showing anything. I am running Sage data integrity but in my case that will take few days, 200 GB database. Anybody with similar problem or tips where to look?

 

Parents Reply Children
  • +1 in reply to chiman
    verified answer

    Hi  this is a great discovery - that the error only works with API inserted orders.  This will help solve it.  What you want to do now is push an order in via the API but don't post it, then manually enter an order with identical details, but don't post it.  Now either export both orders to Excel via File -> Export or select both orders in database tables OEORDH and OEORDD and compare what's different between the two.  Its also good that manually entered orders work because it means there is nothing wrong with your system overall.  Once you identify what the API insert is doing wrong, fix it or get the developer to fix it.  Good luck!

  • 0 in reply to Accsys Consulting AU
    SUGGESTED

    Thanks for the tips. We found that mapping was an issue, inserted tax group as a tax authority.

  • 0 in reply to chiman

    That's brilliant   I was really hoping you would be able to spot it.  Unfortunately as you've discovered sometimes the error messages are not helpful.  Ideally the error you received should have been "Invalid Tax Authority" instead of "Errors found during generation" Rofl again fantastic work diagnosing and solving the issue Thumbsup