Hi Adam Arrowsmith,
Thank you for your answer. I did the same as you said. After get the Initialize response from NS, the next shape I use is NS Invoice Create Connector as below
Invoice was created successfully. However, I have an issue on this scenario:
My SalesOrder has 2 lines and both attached Inventory Detail. I did fulfillment for line 1. Then ran Boomi process to create Invoice for that SO. The invoice was created successfully. But in SO, inventory detail on line 2 had been disappeared.
I would like to ask for your help on this.
Hi Phi Hoang,
The intricacies of NetSuite item initialization are a little hazy to me but basically the initialize call returns you a "stub" invoice with a bunch of defaults much in the same way as if you created an invoice in the NetSuite UI. Check the initialize response to see if it gave you both line items or only the fulfilled ones. I might suspect only the fulfilled line(s) but am surprised if it had any effect on the original SO.
Thank you for your answer. The initialize response contains both line items. I resolved this issue by removing the line item with quantity = 0.
Phi Hoang - Adam is correct. The method of connecting the initialize shape directly to the create shape is effectively the same as clicking invoice on the SO in Netsuite and clicking save without changing anything. It sounds like you have "invoice in advance of fulfillment" turned off. If memory serves me correctly, you will have to change that setting to allow invoicing of lines that have yet to be fulfilled.
Sjaak is also correct in that you don't HAVE TO initialize first, but in my experience, I have fewer problems when I initialize first even if I have to add some caching of the inbound data and mapping b/w the initialize and create.
My Boomi process was implemented as I want to do exactly same as what user doing on NetSuite UI while creating Invoice. I use Boomi initialize operation to build the document with information instead of I have to do from blank.
I have resolved my problem by removing line time with 0 quantity. However, could you guide me where I can find the "invoice in advance of fulfillment" option? Just want to try some test your guess.
Phi Hoang - Check out Setup > Accounting > Accounting Preferences > Order Management > Invoicing.
Thanks Chris. That must be helpful for knowing these Invoicing options.
I took a look at Invoicing options you told me. The INVOICE IN ADVANCE OF FULFILLMENT option is unchecked but that is what we want. We want to invoice customer only what has been fulfilled, not all lines of the SO.
However, I found an option above that option called SHOW UNFULFILLED ITEMS ON INVOICES which was checked. I unchecked that option and try again, all lines with 0 quantity were removed from Invoice, for both NetSuite UI and returned Boomi initialize document. That is the best solution for this without any change on my process.
Thank you for your help on figuring out this solution.
For your information. We create Netsuite invoices without the initializing step. See the screenshots below.
SUB-Create Netsuite invoice
Thanks Sjaak for sharing your process.
Retrieving data ...