Netsuite to Qbooks Invoices

Integrator.io
, , ,
1

I have established connection to Netsuite and able to see invoices \but only customer and total lines .. How to edit parameters so it will also synch item lines that can than be transfered to qbooks Online. ?

2

Hey Greg D,
I looked at the documentation for the Quickbooks to NetSuite integration template in the integrator.io marketplace, and they do have a flow already built for this called QuickBooks invoices to NetSuite invoices. They also have a detailed example explaining how to map data from Quickbooks to NetSuite.

Here are some other helpful documents.

Hope this helps.
Cheers

3

Hi @gregd308 ,

I'm imagining that you're planning to build a flow which would export Invoice records from Netsuite and the POST the records to Quickbooks Online.
Is that about right?

If so, for your initial Export step, you'll want to create a Netsuite Saved Search which includes the Invoices with customer info and line item info.
As you add item info, you may also find that you want to exclude some lines (depending on what you hope to push to QBO). In many transaction saved searches you might want to exclude Main Line, COGS Line, Tax Line and Shipping Line.

Then in integrator.io, on the export step, you'll want to use the "Group Rows" option. So all the lines of a single invoice will be processed as a single JSON record in the following flow steps.

Hopefully this helps get you started on the right path.

Thanks,

Yonton Mehler
Sr. Dev
Celigo