Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Transaction > Line Unique Key Changes when editing item "description"
What is the issue?
When a user edits the Line Item Description of an invoice which was created from the Bulk Invoice Processing Suiteapp, the system changes the Line Unique Key.
Why is this an issue?
We feed invoicing data to our planning tool (Adaptive) and use the Line Unique Key ID as the primary key for line item updates. Since the values change, we end up with duplicate records as the old keys were synced (and will never get updated again since the now longer associated to the invoice) and then when the keys change the new lines are added to the tool.
Tagged:
1