Shopify IA Auto billing error: "Failed to save record because The total can not be negative."

When auto billing orders with a gift card redemption line. If one or more items are closed in the sales order, the sales order will bill with a negative value since the gift card redemption line is more than the sum of the remaining items. Manual fix is to subtract the refunded gift card amount from the sales order redemption line so it will bill to zero. It would be good to have the refund flow support doing this operation. Custom flow might be another way around this.

1 Like

Would love to see a better resolution to this as we are frequently seeing the error.

Are you utilizing the gift card line item setting in the IA settings? And the custom refund adjustment tracking item?

https://docs.celigo.com/hc/en-us/articles/228224387-Sync-order-refunds-between-Shopify-and-NetSuite#h_01JD5B099XAFXESC68X73TAD2D:~:text=NetSuite%20item%20to,or%20other%20change.