Automatic sales receipt allocation (API)

SUGGESTED

We currently use Sage 200 Cloud and the Sage APIs to feed in data from our bespoke ERP system.

We post an average of about 800 receipts a day, prior to invoices being raised, and therefore there are tens of thousands of unallocated receipts, even though the customer account balances are zero.

I try to do this via the APIs but it's nearly impossible as I've got to look through things individually to retrieve various outstanding items (one-by-one for each customer) and then send back the allocations.

Surely there's a much easier way to do this?!

Thanks