Back to connectors… Back to Sage 300...

Unable to delete non-COMPLETE order (4 replies)

Randy
8 years ago
Randy 8 years ago

We have a client who is unable to delete an order from their Sage.  The order is NOT marked as complete.  When we attempt to delete the order (after mapping the fields specified in your documentation), there is no warning or error thrown in IMan, but the order is not deleted.

Support
8 years ago
Support 8 years ago

Does the order have any shipped (or completed lines)?

Randy
8 years ago
Randy 8 years ago

No, it has neither.  The client says he can create a new order, attempt to delete it, and it will not delete.  He thinks that this behavior changed in 3.2.

Randy
8 years ago
Randy 8 years ago

I just tested on a local Sage 300 SAMINC (Sage sample data), and I was able to reproduce the problem.

  1. Open O/E Order Screen
  2. Grab any customer.
  3. Add any product to order.
  4. Attempt to delete in IMan using Sage 300 connector using the following setup:
    1. Import Type = "O/E Order"
    2. Update Operation = "Delete"
    3. Field Mapping - Transaction Type = "Orders"
    4. Mapped Fields:
      1. Order Number
      2. SYS.WARNING
      3. SYS.ERROR
  5. IMan will complete without throwing an error and without deleting the order.
  6. Order still exists
  7. You can manually delete the order in Sage, which shows that in IMan we are requseting a valid delete.

I did some additional testing and put an invalid order number value in the "Order Number" field, and IMan again completed without writing back to SYS.ERROR or SYS.WARNING.  I would expect at least a warning back if I was attempting to delete an order which doesn't even exist.

Changing the "Action on Transform Error" had no effect.

Please see attached screenshots - this is all sample data.

https://www.realisable.co.uk/wp-content/uploads/2017/09/2017-09-22_09-17-07.png
https://www.realisable.co.uk/wp-content/uploads/2017/09/2017-09-22_09-24-12.png
https://www.realisable.co.uk/wp-content/uploads/2017/09/2017-09-22_09-25-21.png
https://www.realisable.co.uk/wp-content/uploads/2017/09/2017-09-22_09-16-17.png
Support
8 years ago
Support 8 years ago

Randy, there will be a field at the very bottom of the field list ("Delete Record") which also be mapped and the value of the field must be "True" (or convertible to true).

Thanks

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close