Author Topic: Adding Invoices Out of Sequence  (Read 343 times)


  • Member
  • *
  • Posts: 1
Adding Invoices Out of Sequence
« on: April 02, 2017, 04:34:53 PM »
Hi forum,

I've been asked by a client who is using FM Books Connector whether they are able to pass the invoice number from FM to QB. In other words, to tell QB "use invoice number X". Reading the documents, it seems as this is simply a matter of sending the desired invoice number to QB. No?

If it is that simple, are we able to send the invoice numbers through out of sequence? There are multiple sales staff and invoice #9 might beat invoice #8 into QB. Would that be a problem?


Will Batt

  • Administrator
  • Member
  • *****
  • Posts: 7
Re: Adding Invoices Out of Sequence
« Reply #1 on: April 05, 2017, 04:08:00 PM »
Yes this is possible.  You can tell QB to use a particular invoice number and order does not matter.  You just need to call PCQB_RaAddFieldWithValue( "RefNumber"; <<your_invoice_number>>).  Just make sure to refer to Intuit's OSR for the proper order where to call this.

Geoffrey Gerhard

  • Guru
  • Member
  • ****
  • Posts: 470
Re: Adding Invoices Out of Sequence
« Reply #2 on: April 07, 2017, 12:02:17 PM »
As noted, you can create the Invoices in whatever sequence you want. Like FMP there are reports and views where the creation order determines some or all of the sort order. This means that you might see Invoice# 1001 appearing above Invoice# 1000.

Another thing to keep in mind: If a QB User enters an Invoice manually, its RefNumber will default to the next sequential value. Passing the Invoice Number ( RefNumber ) as part of an InvoiceAdd request, in this situation is almost guaranteed to result in some duplicate Invoice Number values.


Geoffrey Gerhard
Creative Solutions Incorporated
14000 Creekside Drive
Matthews, NC  28105
704) 814-6852