Symptoms:
When you attempt to update the Vendor field (entity field) of a Vendor Bill, you get the following error if the bill is associated with a Purchase Order.
Error: Invalid Entity. Given purchase order ID do not match given entity: <Entity ID>
What's causing this issue?
This issue was identified as a defect in the NetSuite SuiteTalk WebServices API. The details of the defect are as follows:
Issue Number: 627506
Abstract: SOAP Web Services > Update > Vendor Bill > Different vendor from originating Purchase Order > Error: Invalid Entity. Given purchase order ID do not match given entity: xx
Details: Alternate Solution: Update the entity through UI or using SuiteScript. Update the entity in Purchase order prior or in the same request updating the entity in Vendor bill.
Case: 4198956: Defect 627506: Unable to update Vendor Bill entity when it is associated with Purchase Order
What are the workarounds?
As stated in the above NetSuite defect, there are 2 main workarounds but we're also suggesting a 3rd option as well.
Update the entity through UI or using SuiteScript
Update the entity in Purchase order prior or in the same request updating the entity in the Vendor bill
CloudExtend also recommends the following.
If you are a NetSuite administrator or a power user, you can simplify this process for other CloudExtend Excel users by creating a custom Vendor field that the users can set from the app. A SuiteScript or a SuiteFlow can be then set up to look for values in this custom field and update the standard Vendor field. A similar approach is described in this blog post (just substitute the fields in the blog post with your own fields).
What are we doing about it:
We have already logged a ticket with NetSuite and the corresponding enhancement details are mentioned below.
NetSuite has taken this as an enhancement and would wait for votes from users to gauge the level of urgency. We would suggest users and their teams go to NetSuite and vote up the enhancement request.
Issue details:
Issue Number: 627506
Abstract: SOAP Web Services > Update > Vendor Bill > Different vendor from originating Purchase Order > Error: Invalid Entity. Given purchase order ID do not match given entity: xx
Details: Alternate Solution: Update the entity through UI or using SuiteScript. Update the entity in Purchase order prior or in the same request updating the entity in Vendor bill.
Case: 4198956: Defect 627506: Unable to update Vendor Bill entity when it's associated with Purchase Order