3944796, Can you give me the specifics of your workflow? Trying to do the same and it isn't working for me. Thanks in advance.

Thanks! I did find this and it worked.

This works! Thanks!

I am chiming in on this feed because I don't know if the answer was found and I am having a similar problem. I can create a field on a search that calculates the days since the LSA, but when I try to create a field, the same formula does not work. I am using this field on a Contact record and the search is also of contact…

This issue has been solved. I was referred to SuiteAnswer 10017 which did answer the question. Basically, you map the lines but for any lines not already existing, you would have a null value in the field for that line. So if I am importing 45 lines into a quote currently containing 32 lines, I want to include in the…

Michelle, If I don't map the line id, I get the error: "This record contains duplicated key or keys. Please correct it before next update." I have the same item on several lines which I think doesn't work in the CSV import. I did end up manually adjusting these but I would still like to know if there is a solution. My…

Oh Man! It is a Quote I am importing. I am sorry for leading you astray on that.

Thank you for this answer. It will work in the meantime as these are rare, but I will also vote for the enhancement.

Is this still true that you cannot set last purchase price? What happens when you move into NetSuite from a prior system where LPP existed but now you don't have it? You also don't have average cost because there are 0 in inventory. What is your source of cost information for an item?

Thanks for your response Ivy Lopez! I am sorry I haven't been able to get back and try some of these things. I do have a search that uses the created from and am cross-referencing to pull off related items manually. I was just hoping that someone might have a technique they use. As I was going through the month, I might…

Thank you for the response. I did look into these but most I have already read. One good takeaway is to add the variance status to the bill so I know if there is a variance or not. I guess I was looking for the BEST way that other people are handling this besides going back and rebilling off the PO. I don't understand why…

This is good to know! Thanks, Ivy!

Hi Shamaine Chan-Oracle! I did find the that values were hidden in the file and am currently working with our bank to figure out how to get the file in the form that the bank will not reject. Thanks, though! Holly

I have selected EFT Template "ACH - CCD/PPD". I ran the payments through bill payment processing. I hope that is correct. Everything seemed to process fine, but the file that was created doesn't seem to have all the information. There were no values in the file. Under Company Bank Details, I have the "ACH - CCD/PPD"…

Thank you for this information. That seems to be what I heard before. So if that is the case, I have most of this set up. The issue is that I need info from the bank to set up the bank file. Maybe once that is done, I will see how this works because right now I don't see how the bank file gets prepared.

This seems to be working! Thank you! I think the issue was that trigger on the first state. I had it at After Submit but it needed to be Before Submit. Thanks, again!

Joahnna, Doing this, I am no longer getting a Task upon save. It appears it is making the full circle before creating any task record. I wonder if there is something I am doing wrong in the trigger type? Don't I need it to fully complete the action at State 1 before it transitions to State 2? How can I make sure it doesn't…

Joahnna, Thank you for this response. I actually had tried something very similar to this. I just didn't have the "Do Not Exit Workflow" box checked under the second state. My question is what would be the best thing to use for "Transition on" for the transition? I really struggle with when to use the trigger on or…

I am really looking for recommendations of best practice here. I was wondering if it would be best for me to create another box that is checked at the same time as the creation of the task and basically have the workflow only initiate if that box is already not marked. I hate creating a bunch of extra fields just to make…

Thank you! I have created the support ticket.

Thank you for your response! I tested that and it worked as you said. Honestly, I should have tested it like that in the first place. There are all these little details that a new user of NetSuite simply does not know and sometimes searches come up with an overwhelming amount of information that is hard to pick through.…

Here is a screenshot: There are certain roles that have edit access but the role having the issue is using the default access level.

Thank you for this very detailed response. I never knew about this before but it is very helpful.

I agree if the items are still in receiving. However, in these scenarios, the items have already been transferred to other bins. I believe that it won't update the subsequent inventory transfers that happened before we caught the issue and updated the item receipt. Please confirm that a corrected receipt will not change…

You could create a copy of the original PO and remove the lines already received. Then close the open lines on the original PO. You could also create a custom field that indicates the original PO so that there is a link back to that transaction.