Matt Bradley

c77839ef-903c-49b7-8932-f39e259cf450

b6a4c692-6c6b-4b12-bdec-c53947b0cb00

Oddly, We've just retried this API call, and it went through this time. May have been a transient error.

Hi Mark, Yes. Same customer!

Usually, this work fine, but for some reason, the API is refusing to pay one particular invoice, claiming that we are attempting to overpay the invoice. Request: [contact_payment] => ( [transaction_type_id] => CUSTOMER_RECEIPT [contact_id] => 934b56e8d85e43efbf5815629eaac44f [bank_account_id] => 4a7ee3e64df74deab20633d2e4d9af64 [date] => 2022-10-11T00:00:00+01:00 [total_amount] => 1497.36 [reference] => DA60235 [payment_method_id] => CREDIT_DEBIT [allocated_artefacts] => ( [0] => Array ( [artefact_id] => 23c914ddacc641f4b08d629e623abbab [amount] => 1497.36 ) ) ) Response: [$severity] => error [$dataCode] => RecordInvalid [$message] => You cannot overpay invoices. [$source] => base [friendlyErrorMessage] => You cannot overpay invoices. Except that the invoice amount is 1497.36, and it is entirely unpaid.

What it is trying to do here is issue a customer_refund for £4652 to refund two previous unallocated customer_receipts of £3526.00 and £1126.00 respectively. I'll get somebody to send an email to [email protected]

We're searching here for an invoice by its invoice reference, so this should be returning either 1 or 0 results. I suppose it is possible that the inner join is causing the query to timeout at the API server, but we wouldn't expect this search to be returning more than a single result.

We're randomly getting 500 errors from the sales_invoices search endpoint: [search] => DA64088 [show_payments_allocations] => 1 Returns a 500 error.

We're sending an API request which appears to be perfectly valid, but for some reason, generates a 500 error. Similar ContactPayments work fine, but this particular one generates a 500 error for some reason. [contact_payment] => ( [transaction_type_id] => CUSTOMER_REFUND [contact_id] => d0fb3586396f4db69e90a7cebce81dcc [bank_account_id] => 4b852dfa7a8e4f20b6fba63f2c6d25d8 [date] => 2022-09-22T00:00:00+01:00 [total_amount] => 4652 [reference] => DA59218-Refund-credit-bal [payment_method_id] => CREDIT_DEBIT [allocated_artefacts] => ( [0] => ( [artefact_id] => 26967b6ffa9d41bc92787ca4f9c8f12d [amount] => 3526.00 ) [1] => ( [artefact_id] => f63314cca6614444ad4ffd64a0cf3a9f [amount] => 1126.00 ) ) ) The response is a 500 error from the API. Any ideas what's gone wrong here?

Hi Brian, We're using the Ols Green libraries. They seem to do the trick. https://github.com/olsgreen/sage-business-cloud-accounting-api https://github.com/olsgreen/oauth2-sage-business-cloud

That's right. We are a car auction, and many of the cars we auction are not eligible for VAT, so an invoice might consist of one large priced item which is zero rated, and then fees which are eligible for VAT. In the VAT breakdown, none of these large priced zero rated items appear.

We're creating our first VAT return in Sage. Because we're migrating to sage, we have some invoices in the pervious VAT period in the new Sage account. We just requested a VAT return calculation for 01/06/2022 - 31/08/2022. However the calculation includes lots of invoices dated May. Any ideas why, please?

We've just downloaded our first VAT report, and in the box 6 section, any transactions which were not elibible for VAT are missing, and not included in the Box 6 total. I'm pretty sure that this is wrong? "Box 6 - Total value of sales and all other outputs excluding any VAT. Include your box 8 figure" According to HRMC: "Box 6 total value of sales and all other outputs excluding any VAT Show the total value of all your business sales and other specific outputs but leave out any VAT. Some examples are: zero rate, reduced rate and exempt supplies fuel scale charges (read Motoring expenses (VAT Notice 700/64)) exports supplies to EU member states, if the goods are moved from Northern Ireland (that is any figure entered in box 😎 supplies of installed or assembled goods in the UK where the overseas supplier registers for VAT here distance sales to Northern Ireland which are above the distance selling threshold or, if below the threshold the overseas supplier opts to register for VAT in the UK reverse charge transactions (read paragraph 4.6) supplies which are outside the scope of UK VAT as described in Place of supply of services (VAT Notice 741A) deposits that an invoice has been issued for But, you do not include in box 6 any of the following: money you’ve personally put into the business loans, dividends and gifts of money insurance claims Stock Exchange dealings (unless you’re a financial institution) "

We are an auction house, and we have vendor customers on behalf of whom we sell goods. In settling up with the vendor, we record an invoice from that customer for the hammer price of the goods, and raise an invoice to them for the seller fees. We then settle the fees invoice with some of the balance of the hammer price invoice from the customer, and make a payment out to the customer for the outstanding hammer price balance. However, it seems that it isn't possible in Sage for me to record in invoice TO and and invoice FROM the same customer. I can only raise invoice TO a "customer" and FROM a "Supplier" meaning that settling up the balances becomes extremely messy, and prone to error when sending payments via Sage API. Can anybody suggest a workaround? This is causing us endless problems.

Actually, scratch that. I am sending paymentmethod_id instead of payment_method_id. Apologies.