Ok, so by using the workflow log and realising I could expand the errors even further I noticed that the error was caused by the workflow not being able to find the Employee field to match the data too. This is because the field I needed to match is not Employee but Entity (Employee) By changing my conditional formula from…

Oooh, ok I see now. It's not able to find the field 'employee' which is odd. Based on the expense report, the Employee field uses the ID of entity so should I be using entity? But that doesn't work because when I use the builder an 'entity' is considered a vendor.

Ah yes, it's showing the conditions as False so it's not working. I could break these into multiple add buttons for each condition, but I'll keep poking at it for now to see if I can get this working so as not to make it too verbose.

I tried adding parentheses but that didn't appear to help, unless I'm using them wrong.

Got it, it was in Tabs

Thanks Clarisa, I've gone and submitted a support case, I think in the right place? Hopefully hear back from them soon and I'll update the thread here with their advice if it leads to a solution.

Fixed, I had to make a copy of the send email action and also make that after record submit : direct list edit.

Ok, I've managed to trigger it using a trigger of Before Record Submit : Direct List Edit and the workflow is proceeding to the send email state, but not actually sending the email or showing any error logs.

Will do~ Appreciate the help all the same.

Ok, great, one step closer. However, after I save the form it automatically changes the Shipping Freight Cost items target subsidiary from blank to the selling subsidiary. So I can save the PO, but then target subsidiary for the item is changed back to MPCN and then if I try to submit it for approval, approve it or…

Ok, so I do have Centralized Purchasing and Billing enabled. Meaning this will always be an issue if target location and target sub have values on the PO? The issue is that I don't have target location nor target sub on the PO per line item, unless they're hidden, but I can't see them as options in the form customization.…

Thanks for your response @Clarisa De Torres-Oracle The error occurs at every change to the document after it has been saved the first time. So I save the PO, fine, submit for approval, error, approve PO, error, make change to PO and save, error. You're suggesting the error is occurring because it's trying to create a cross…

I'm not really sure what I did, but it's working now. I think it might have been something to do with it looking to fill the email creator with the value of the field 'next approver' when I deleted the rest of the workflow steps related to the 'next approver' field. Although this didn't flag up as an error in the workflow…

Somehow I've taken a step backwards and it's now skipping the initiation step and submitting itself for approval as soon as I save it. :/

It was part of the customer record for MPNG. I just figured it out on my own, not sure how I would have found this through any particular means. It's still annoying that the + button isn't working, just like it doesn't work for adding new locations. :/ Come on NetSuite.

By changing the items on the transactions to non-inventory items it allowed me to edit and delete the paired intercompany transaction field. This had to be done on the SO first as the PO wasn't allowing me to save the record with no intercompany transaction.

Oh nvm, it was the intercompany expense account lower down.

I had this problem again and updated it with better information, I also used the notepad method to resolve it, very useful. But yea, quotes around the data is fine, but around the column titles there shouldn't be any, this is what my successful one looks like.

I'm happy to use SuiteApprovals or Workflows in order to achieve what I want. I'm hoping to have a simple approval process to allow a group of users to be part of the listed approvers. I'm learning to build this manually in workflows at the moment, where I set the names of each individual who has approval permissions. But…

Fantastic, thank you so much~

No, checking overwrite sub lists does indeed fix the problem. I'm no longer having issues, thank you~

Sorry Lyka, would you mind checking my work? It doesn't appear to be working. Perhaps I'm missing some further settings on the Created By field that I created. Created by Field Saved Search Results:

Forgot I had this issue before. Solution is here. How to fix error: "Vendor/Subsidiary must be unique" when Uploading Items via CSV? — Oracle NetSuite Support Community

Ran into the error again, this did indeed solve the issue.

Sorry, the problem has sorted itself overnight. I don't know if changing the number of list entries is a fix or not for now. Switching browser may also be a fix. I'll try to remember to update this post should the problem present itself again.

I've just stopped mapping all the different unit types other than the Primary, there's no need to since NetSuite will set that all automatically after the import.

I would still want to see the majority of information on an item, it would be just the value of the items. So on an inventory count, I'd want to hide the Rate of the items they're counting. On the receive orders page it would be the Order Total. On an item record, there are quite a few. Total Value, Average Cost, Last…

The permission I was missing was 'Item Fulfillment' A useful trick I learned to find this out was going onto my admin account to the transfer order fulfillment page, copying the URL and going back to the URL in the role that was missing the permission. This then highlighted what permission I was missing.

Side note, the fact that this can happen when mapping is absolutely ridiculous NetSuite. 😠

Ok, so I'm not sure which one it was. But I solved it. By opening the csv in notepad, it was easier to highlight irregularities in the header. In the China column, the formula box just had 'China' written in it where as the Cell had 'China HS Code'. I'm not sure what the quotation marks in the notepad were for, but I…