HertsChris Blue Ribbon

Hi Kristoffer. The solution doesn't really meet the need unfortunately. It does 'work' in that it will pull the value from the original field but only when the the record is edited and saved. we need it to be a live field that we can report off rather than needing to edit and save every record to get a value there. The…

Hi Katerina, yes we reconciled it way back. I'm not sure why but the company were reluctant to reconcile from statements two years ago but the amounts match and it doesn't affect any subsequent reconciliations so we are all good. Thank you

So lets try a different approach then, How would you store a value from a field that is populated by a saved search. I understand I cant store that value so my workflow was meant to populate a new field with the value from the first field so I can store it. Since I cant get that to work how would you advise I store the…

Hi @Kristoffer Viray-Oracle , Yes that does work but only if I edit and save the Sales Order.

Kristoffer this is driving me crazy!!! I have changed the workflow to just populate with the word test rather than feed off the first field. The only difference between the first and second screenshot is that in the first one the Store Value is ticked on the field. I have tried this in Edge and Chrome and get the same…

Hi, Yes, so here is the first field which IS populating correctly - The second field which is populated by workflow and is also working but only when Store Value is off, looks like this - Neither field has anything under Sourcing and Filtering. The workflow looks like this -

Hi John, Thanks for the advice. Unfortunately if I select Store Value then the field no longer populates at all. Is it anything to do with the fact that my first field is populating via a saved search on the defaulting tab of the field record? Chris

Thanks Katerina, If I do that to match against the original balance early last year will it affect any of our subsequent reconciliations? If the customer doesnt want to do that is there any way to simply 'remove' the transactions from the Reconcile Bank Statement page? Chris

Hi Mikko, Yes that worked (clear cache)!!! Embarassing I didn't try that. We can't always get everythng right though can we ;) Thank you Chris

Does anyone else have any ideas on this. the user is now using a different browser since her preferred browser constantly redirects the SSO login back to the netsuite customer login page.

Hi Mikko, no changes on the SSO setup no. She should be using the SSO Login. But when we enter the URL for the SSO login now it just redirects to the NetSuite login. This only happens in one browser and only since we tested a non SSO role. I have since removed the non-SSO role from her and she only have SSO roles now. So…

Thanks for all your help Ivy. You're great. Il let you go help some other folk now ;)

That's amazing Ivy. Thank you so much for your hard work on that. The calculation now makes sense to me. Amazing Why is the adjustment on the receipt though. This adjustment looks like it make smore sense on a fulfilment?

I appreciate that Ivy. NetSuite support aren't helping with this. Ill send you a message. Chris

HI, thank you for your responses. Those are the same answers I had from NetSuite support though but they have not been able to tell me how the number was calculated. For audit I need to be able to explain how the number was calculated and not just give a description of the theory. here are the transactions on that item. I…

The item is set to Average costing. At the time of receipting the was a stock of -23 at a value of -£82,739.28 A Receipt was then posted for a quantity of 75 at a total value of £228.81. This receipt then showed on its GL Impact a Cost Of Goods Adjustment of £82,594.55 crediting Cost of Sale, debiting the Asset. We need to…

Hi guys, I had to remind myself how to do this but here it is. First off it is not a Transaction search so sorry about that! I think you could do it via a transaction search though if you search for transactions that have payments against them generated from a certain batch. But you could only do that after the batch is…

No this solution doesn't work for what we are trying to achieve. Essentially we are trying to avoid having to manually post a journal for the bank charges. We have one person processing a high volume of bank recs so that is a lot of manual journal postings. It would be better if we could set an Auto Create rule. It seems…

Thanks Micah. that functionality is exactly what we want but the reason we want a journal instead of a charge is because we want to use it for bank charges which we wouldn't want to to tag against a vendor record. how do we use this feature for bank charges where there is no relevant vendor? Chris

I don't have a search yet. I am as yet unable to even figure out which record I should be using as my basis. I think i should be using a Payment File Administration search but I have tried every field available there and can't figure out how to source the line data.

You are going to need a lot more in your workflow to meet needs and there are a few ways to go about it that might be beyond a Community board post. If you want everything below £1,000 to just auto approve then I would suggest having an end state of your workflow as the Approved state to change the status to approved and…

HI Emilia, I must have been half asleep when I posted this. This is obvious now. thank you so much. I don't know why I was trying to make things complicated. y search works perfect now. Thanks Chris

Thats a shame Joy. Not the answer I wanted really. I wonder how other people manage this. Chris

I have now done this by insisting Created From Type = Purchase Order. We can now analyse the Lot numbers of transactions posted to Accrued Purchases. Thanks for your help.

Yes that works great thanks. Now I just need to remove all the Item receipts that relate to Transfer Orders (as they don't affect the Accrued Purchases)... Will try something on the Created From field. Chris

the duplicates are actually necesarry because i need to see all the relevant lot numbers but I would like to the see the amount assigned to LOT1 and the amount assigned to LOT2. At present I am seeing - Item Receipt 1 LOT1 £2000 Item Receipt 1 LOT2 £2000 Item Receipt 2 LOT3 £1200 What I want to see is - Item Receipt 1 LOT1…

OK then that is useful to know. I am using the following then - Criteria: Formula (text) CASE WHEN ({type} = 'Bill' AND {account} = 'xxxx-xx Accrued Purchases') OR ({type} = 'Item Receipt' AND {account} = 'xxxx-xx Inventory' ) THEN 1 ELSE 0 END is 1 This works now but I have duplicate entries where more than one Lot has…

Just out of interest on this subject - what do other people do with their NetSuite Partners and SSO? What is the preferred way of managing this as I can see a few different ways and want to know what the best practice would be? Thanks

It has been a while since I have been involved in this but I remember it being a difficult subject to relay to Finance team members who are used to the postings being made. The key here is the words 'does not post'. NetSuite doesn't actual post any transactions/journals for the year end but the standard reports are built…

You are 100% right and it is a pain. I have never found an easy way to do this sadly. It really does require going through the records and reassigning from John Smith OLD to John Smith. Obviously that doesn't help with the historic data and system notes data but i wonder if Employee records now support merging @Camille…