Error: Applied To Txn Add payment amount” field has an invalid value. You can’t pay more than the amount due.
Overview
This article addresses an issue that occurs when posting Shopify Payouts. The problem arises when one or more orders within a payout are adjusted after the payout report is generated, leading to a mismatch between the payout summary total and the posted order details.
Possible causes of issue:
The sales tax amount of the posted order doesn't match the adjusted value in the Payout report.
An order item may have been removed after the payout report was generated.
Here are a couple of different steps to follow depending on what caused the error:
A. The sales tax amount of the posted order doesn't match the adjusted value in the Payout report.
Sometimes, the sales tax settings may not be configured correctly.
We recommend downloading the tax amount associated with the order and recording it as a line item.
If the settings are incorrect, the order total may be mismatched due to selecting the sales tax settings to recalculate or missing tax calculations from the order.
To resolve this issue:
Navigate to Integration> Accounting> Posting Settings, and Sales Tax.
Make sure the settings are configured to download the tax amount as a line item. Please review the sales tax settings in the posting settings for guidance.
This way Webgility will download the exact tax amount associated with the online order.
Unsync the posted order and repost it again, after reconfiguring the sales tax settings.
B. An order item may have been removed after the payout report was generated.
This issue occurs when an order item is removed after the order has been processed.
Items might be removed for various reasons, such as being damaged during shipment, being out of stock but not updated in the store, or being canceled by the customer after placing the order.
However, Webgility posts the order to QuickBooks before these changes are reflected, causing discrepancies in the payout summary.
To resolve this issue:
Go to Integrations> Store, and Settings.
Enable the option ”Do not download removed items with the order”.
Unsync the posted order, then redownload it to update the order details.
Finally, repost the order, this will resolve the issue.
Note: For further guidance, please refer to this help article to ensure all settings are configured according to the recommended suggestions.
If you have any questions or need more help, please contact our support team.