Help with flow to create invoices in NetSuite

Alvaro Ferreira

March 04, 2022 21:09

Hi! I'm working on a PoC to send orders to NetSuite. What I have so far is:

- Webhook (export) that I post with data for customers, vendors and items, containing external ids for each.
- NetSuite (import) with data mapped from the post request to NS's needs.

All the above works. However, when I need to create an invoice, I simply can't because it asks for internal ids, which I don't have. So a couple of questions:

- Can I create invoices using the external ids I have for the other entities?
- If not, how can I get the internal ids from externals and fulfill my request?

Thanks!

Comments

4 comments

Scott Henderson
March 04, 2022 23:28

CTO

To translate external ids to internal ids, you can configure dynamic lookups directly in your mappings. Please see the following pic, and hopefully this helps!

0
Alvaro Ferreira
March 08, 2022 22:14

Thanks, Scott. That makes a lot of sense. However, I can't select the other field in the filter. The select input is empty (see pic below).

Is it because my source is a webhook? How can I solve this?

Thanks again!

0
Scott Henderson
March 08, 2022 22:59

CTO
The dropdown is most likely empty due to this being a webhook flow, and there isn't any stored metadata about the webhook payload (just a guess though). To work around this you can do the following, and please see pics below for context.
1. Click the settings icon next to the empty dropdown.
2. Set the operand type to expression.
3. Use handlebars to explicitly set the source field. i.e. {{{apple}}}, {{{externalId}}}, {{{banana}}}, etc...
It is worth noting that we have multiple features planned for 2022 to improve this UX in different ways.
0
Alvaro Ferreira
March 10, 2022 18:52

It works!

I appreciate your help!

0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post