# Help adding POs to vendor bills on NetSuite

**URL:** <https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823>\
**Category:** Integrator.io\
**Tags:** integration-app, import, netsuite\
**Created:** [March 16, 2022, 3:09am UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823 "2022-03-16T03:09:03Z")\
**Posts on this page:** 10\
**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 16, 2022, 3:09am UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/1 "2022-03-16T03:09:03Z")

</div>

Hi!

I'm having a hard time adding POs to vendor bills using the Integrator. I'm able to create the bills, but can't find a way to add POs as related documents.

I'm also expecting that if this is possible, I won't need to add the same items to the bill that are in the PO. Is that a correct statement?

The issue is that in the import mapping I can't seem to find any field that says "purchase order" or "PO".

Any help is appreciated. Cheers!

---

<div class="post-metadata">

**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\
**Post date:** [March 16, 2022, 5:25pm UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/2 "2022-03-16T17:25:22Z")

</div>

I would suggest trying to replicate what you want to do directly in the NetSuite user interface. What you're asking to do isn't really a thing in NetSuite.

---

<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 16, 2022, 8:14pm UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/3 "2022-03-16T20:14:59Z")

</div>

Please, take a look at the pic:

 ![5301043caa20740200000001-39a99abd11a24fb08d250f943badecf5.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/204400ce74c80987633781e08b445dcba604c8e4.png)

---

<div class="post-metadata">

**Author:** ![davidgollom](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/davidgollom/32/6605_2.png) [@davidgollom](https://connective.celigo.com/u/davidgollom)\
**Post date:** [March 16, 2022, 8:33pm UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/4 "2022-03-16T20:33:29Z")

</div>

Yep. Like I said. Recreate this in NetSuite and you'll understand what's going on. What you see is the result of a record transformation(s) using the Bill Purchase Orders screen. I have my doubts you'll be able to replicate this in Celigo. You can transform a single PO to bill for sure but I've not seen this multiple PO to one bill. Maybe one of the celigo people can chime in on the ability

---

<div class="post-metadata">

**Author:** ![katelarson](https://avatars.discourse-cdn.com/v4/letter/k/91b2a8/32.png) [@katelarson](https://connective.celigo.com/u/katelarson)\
**Post date:** [March 16, 2022, 9:11pm UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/5 "2022-03-16T21:11:39Z")

</div>

Thanks for posting to the community, @alvarolopez. My recommendation is that you sign up for an [office hours](https://docs.celigo.com/hc/en-us/articles/360045798291-Which-Office-Hours-session-should-I-attend-) session so that one of our solution consultants can talk with you to better understand your use case and discuss options.

---

<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 16, 2022, 10:53pm UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/6 "2022-03-16T22:53:15Z")

</div>

Office hours is great for these type questions.

[This](https://connective.celigo.com/t/assembly-build-for-work-order/1058) post might be helpful too if you are fine with having 1 PO per Bill. Promoting / transforming one NS transaction type to another is a really common use case, and they all follow the same pattern.

---

<div class="post-metadata">

**Author:** ![carolinecombe](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/carolinecombe/32/4427_2.png) [@carolinecombe](https://connective.celigo.com/u/carolinecombe)\
**Post date:** [January 26, 2023, 10:23am UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/7 "2023-01-26T10:23:05Z")

</div>

Hello everybody,

Did you find a suitable solution for this request ? I have the same problem I woild love to know if you managed to get out of this mindbending problem ?

Thanks a lot !

---

<div class="post-metadata">

**Author:** ![basvanditzhuijzen](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/basvanditzhuijzen/32/4422_2.png) [@basvanditzhuijzen](https://connective.celigo.com/u/basvanditzhuijzen)\
**Post date:** [March 8, 2023, 9:10am UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/8 "2023-03-08T09:10:41Z")

</div>

Hi, you need to map the line fields orderdoc and orderline on the Bill record to link the bill to the purchase order. These are not exposed on the form in NetSuite so Celigo doesnt have a auto-suggest for them but this is how it should be mapped:

 ![5301043caa20740200000001-dd311237238f4ccba0cd410943f20635.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/6/679f4e15df7483a6025c76e4bb3df858ed3d0348.png)

---

<div class="post-metadata">

**Author:** ![rahulkaranjit](https://avatars.discourse-cdn.com/v4/letter/r/ee59a6/32.png) [@rahulkaranjit](https://connective.celigo.com/u/rahulkaranjit)\
**Post date:** [March 28, 2023, 5:18am UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/9 "2023-03-28T05:18:41Z")

</div>

Here's how I was able to link the PO to the vendor bill:

 ![5301043caa20740200000001-d06c15fe156c44249faa46d1f57099d1.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/340c6540f8aad5e6fefce4f757f588eaaa5a82e9.png)

Note: If you want to Bill only one Line Item then, you'll have to use the Items : Replace All Lines =\> true

and Line ID should be mapped to find the exact item with the Items details

---

<div class="post-metadata">

**Author:** ![christianbannard](https://avatars.discourse-cdn.com/v4/letter/c/8491ac/32.png) [@christianbannard](https://connective.celigo.com/u/christianbannard)\
**Post date:** [January 18, 2024, 12:56am UTC](https://connective.celigo.com/t/help-adding-pos-to-vendor-bills-on-netsuite/823/10 "2024-01-18T00:56:38Z")

</div>

Hi @rahulkaranjit,

I'm see-sawing between two issues at present:

1. If I use your method without Line IDs it completes the bill successfully and associates to the correct PO without an issue, yet the Item line information is duplicated.
2. If I add Line IDs (I also need to subtract 1 from them for some reason) and Replace All Lines, the Bill is created correctly with the correct line items, yet the record is disassociated from the PO.

Any recommendations?

@basvanditzhuijzen where would I add these hidden fields in to associate the record correctly? Should that be in an initial transform, direct mapping for the Netsuite fields, or some kind of lookup?

Regards,

Christian
