Unable to delete non-COMPLETE order (4 replies)
Does the order have any shipped (or completed lines)?
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.
I just tested on a local Sage 300 SAMINC (Sage sample data), and I was able to reproduce the problem.
- Open O/E Order Screen
- Grab any customer.
- Add any product to order.
- Attempt to delete in IMan using Sage 300 connector using the following setup:
- Import Type = "O/E Order"
- Update Operation = "Delete"
- Field Mapping - Transaction Type = "Orders"
- Mapped Fields:
- Order Number
- SYS.WARNING
- SYS.ERROR
- IMan will complete without throwing an error and without deleting the order.
- Order still exists
- 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.
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
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.