Invoice Payment Creation Failed

Learn how to solve an invoice payment creation issue in Webgility.

Virendra avatar
Written by Virendra
Updated over a week ago

Error:

When posting orders as a paid invoice, the invoice gets created, but payment creation fails and shows the following error: You can't create a payment more than the amount due.

Reason:

The invoice amount is less than the payment amount when creating the payment for the invoice. This is likely due to the tax being calculated differently between the store and QuickBooks. If the store tax is greater than what QuickBooks calculates it as, this causes a difference, and the payment cannot be applied to the invoice.

Scenario 1:

Enable Mark Invoices Paid (for a single type of transaction only)

To resolve this issue, you will need to either correct your tax calculation in your store or in QuickBooks to make sure the tax calculation is the same in both. Or, you will need to select an option in Webgility Desktop called “Create payment of transaction total in QuickBooks.” This will cause Webgility Desktop to create a payment based on the invoice total rather than the order total.

If the user is posting orders based on payment method and there is a new payment method on the order, Webgility isn’t posting the payments for those orders. The user needs to map the payment method to Webgility to create payments. To map payment methods on Webgility, please refer to the link.

To post orders based on payment method, please refer to this link.

Scenario 2:

Payment creation failed when posting the Payouts/Settlement report.

If a user is posting the Shopify payout or the Amazon Settlement report, then the user needs to enable the payment settings “create payment when posting payouts/settlement with payment date as payout/settlement date” to record the payment in QuickBooks.

Navigate to Integrations> Accounting POS/ERP> Posting Settings> Orders to enable “create payment when posting payouts/settlement with payment date as payout/settlement date.”

After saving the create payment settings, post the payouts/settlement reports to QuickBooks, and the payments will be successfully created.

Did this answer your question?