Wednesday, August 17, 2016

eOne Smartconnect - Integrating Purchase Orders - Subtotals don't match, Only single lines integrate


  • http://www.eonesolutions.com/blog-post/tech-tuesday-smartconnect-purchase-order-map-error/

  • Run this to make the subtotal not required
  • UPDATE SmartConnect..[Field] SET Required = 0 WHERE Node = 'taPoHdr' AND TechnicalName = 'SUBTOTAL'

  • Set PO Create to Updateifexists true
  • Set PO Line to Updateifexists true
    • But untick the Update existing on the map itself
  • Add a line id field on your data source with unique lines
    • Map this to Line Number
  • Subtotal does not include vat

No comments:

Post a Comment