Find invoices from a customer that are newer then a given date

Question

Im currently listing all invoices from a selected customer.

I would like to filter on this result, and only list the invoices newer than a specified date.

// Find debtor
$debtorHandle = $client->Debtor_FindByNumber(array('number' => $economic_api->customerId))->Debtor_FindByNumberResult;

// Find order ids for debtor
$orderHandles = $client->Debtor_GetInvoices(array('debtorHandle' => $debtorHandle))->Debtor_GetInvoicesResult->InvoiceHandle;

// Find all orders for debtor
$invoices = $client->Invoice_GetDataArray(array('entityHandles' => $orderHandles))->Invoice_GetDataArrayResult->InvoiceData;

 

Do i have to check every invoice in my script or is there a filter available?

Answer 1

Hi Steffen

If date span is your primary interest you could consider using Invoice_FindByDateInterval followed by Invoice_GetDataArray and only look at invoices matching your criteria.

Depending on the business setup and amount of customers and activity this could quickly become more cumbersome.

Filtering is not available like we have it via REST. The only filtering via SOAP is the one you're already using, such as FindByNumber etc.

P.S. Your comments mention Orders but you're dealing with Invoices. Is this on purpose?

Comments

In that case I'll stick to my solution and check the date of all the  returned invoices.
My client have more than 5000 invoices in his system, so I'm pretty sure that's going give somekind of timeout.

I started out using a snippet fetching orders and forgot to change the variable names :) So thats why it says orders some places - just poor naming :)

Thanks for your input :)