# Help with flow to create invoices in NetSuite

**URL:** <https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831>\
**Category:** Integrator.io\
**Tags:** export, import, webhook, netsuite\
**Created:** [March 4, 2022, 9:09pm UTC](https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831 "2022-03-04T21:09:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![alvaroferreira](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@alvaroferreira](https://connective.celigo.com/u/alvaroferreira)\
**Post date:** [March 4, 2022, 9:09pm UTC](https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831/1 "2022-03-04T21:09:32Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [March 4, 2022, 11:28pm UTC](https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831/2 "2022-03-04T23:28:11Z")

</div>

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!

 ![5301043caa20740200000001-8e428c2446554058bac65a93c2bf4f2a.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/b/b80df7deef92e005d49341e8c89b69dc79ec3793.png)

---

<div class="post-metadata">

**Author:** ![alvaroferreira](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@alvaroferreira](https://connective.celigo.com/u/alvaroferreira)\
**Post date:** [March 8, 2022, 10:14pm UTC](https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831/3 "2022-03-08T22:14:31Z")

</div>

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!

 ![5301043caa20740200000001-864d92d766c741328d119866167a5ed4.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/5/58257db10a1af8b8c5d8eb00a7428439757d2fc6.png)

---

<div class="post-metadata">

**Author:** ![scotthenderson](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/scotthenderson/32/6780_2.png) [@scotthenderson](https://connective.celigo.com/u/scotthenderson)\
**Post date:** [March 8, 2022, 10:59pm UTC](https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831/4 "2022-03-08T22:59:59Z")

</div>

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.

 ![5301043caa20740200000001-4856a2dd4d1e44839ca8a7d861ea880c.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/e4d8c2623a8e35aca77cf853acbc3478c467363b.png)

 ![5301043caa20740200000001-9badffc72911469595985c80629c93d6.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/a/a76ed3bc959a44f7e3b5c146cd1ed1ec04f4b223.png)

---

<div class="post-metadata">

**Author:** ![alvaroferreira](https://avatars.discourse-cdn.com/v4/letter/a/c57346/32.png) [@alvaroferreira](https://connective.celigo.com/u/alvaroferreira)\
**Post date:** [March 10, 2022, 6:52pm UTC](https://connective.celigo.com/t/help-with-flow-to-create-invoices-in-netsuite/831/5 "2022-03-10T18:52:58Z")

</div>

It works!

I appreciate your help!