Help adding POs to vendor bills on NetSuite
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!
0
Comments
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.
Please, take a look at the pic:
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
Thanks for posting to the community, Alvaro Lopez. My recommendation is that you sign up for an office hours session so that one of our solution consultants can talk with you to better understand your use case and discuss options.
Office hours is great for these type questions.
This 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.
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 !
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:
Here's how I was able to link the PO to the vendor bill:
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
Hi Rahul Karanjit,
I'm see-sawing between two issues at present:
Any recommendations?
Bas van Ditzhuijzen 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
Please sign in to leave a comment.