How to import a invoice with items that are serialized and non-serialized

Ian Luck

• December 28, 2021 21:34

I am trying to simply import invoices into netsuite. I keep running into a similar issue with the addition of inventory detail on my mapping. I want to be able to add serialized and non-serialized items on the same order, however, whenever I try to run the import I get the error that NetSuite item cannot be added with an inventory detail. My overall question: is there a way to import item lines that have inventory detail and others that do not in the same import into NetSuite? Help would be greatly appreciated! Thanks!

0

• 

  Greg Griffin

  • January 20, 2022 23:21

  

  

  Did you ever find a resolution this need?

  0
• 

  Connor Vander Zalm

  • May 06, 2022 15:21

  I'd love to see an answer to this as well

  0
• 

  Greg Griffin

  • May 06, 2022 15:26

  

  

  I ended up using a formula to conditionally post the inventory detail field mapping values. It works for us as the lot tracked items can be determined based on price. When the condition isn't met the inventory detail mapping is skipped. If you can find some field in your payload to pivot on - it can work.

  {{#compare ItemPrice.Amount ">" 15}}value to post{{/compare}}

   

  1
• 

  Connor Vander Zalm

  • May 06, 2022 16:25

  Thank you Greg

  0

Please sign in to leave a comment.