Best Of

Hi @Vernita

For Est Unit Cost you can select the field "Item Rate", there are 2 Item Rate fields in Transaction Saved Search, select the 2nd one which the field id is {fxrate} if you use a formula (currency) field.

For Current Value and On Hand, its actually a snapshot of the item Location On hand qty and Location Total Value field where item.inventory location = Location (no hierachy) field in the inventory adjustment line before the IA is posted. So don't think its possible to get the value from saved search as the value may change by other transactions posted on the same day.

Regards,
Wee Ming

Hi User_59L06,

I think below Suiteanswer is what you looking for.

Steps to Display the Actual Quantity in Unit of Measure Used in the Transaction When Creating a Saved Search
https://suiteanswers.custhelp.com/app/answers/detail/a_id/28524/loc/en_US

Regards
Wee Ming

Hi All,

Just to update got these 2 buttons enabled now.

Issue was earlier only Administrator role were added to my user.

Customer had customized a new role with which these options were to be enabled .

After assigning this new role to my user , these butons got enabled.

Thanks !

Regards,

Richa

Hi @Kedalene,

I do encountered PFA stucked in Queue before and suiteanswer 106099 do solve my issue.

May be you want to checkout this suiteanswer :-https://suiteanswers.custhelp.com/app/answers/detail/a_id/26150/loc/en_US

Do take note before reprocessing a failed PFA, make sure there is no other PFAs record status is in the "in progress" i.e. non-final stage , final stage status are e.g. failed, cancelled, processed.

All other queued PFAs , have to change it to failed before you reprocess on one of them and wait till its completed then reprocess the next failed PFA.

I suspect that if there are multiple users generating PFAs at same time or the same user creating multiple PFAs before one is completed, then this may lead to PFAs jamming in the queue. So do advise your user to only process one PFA and wait till it complete before generating the next one to see if this help.

Regards
Wee Ming

Hi User_APABE

The offset journal does not need to be in the same period as the original unless you need the offset figures to report in the original period.

"Can we change the posting period after payments have been applied."
» Are you referring to posting period of the journal that is used to apply to a bill , if yes you can change the posting period provided the period is not closed. But after that the payment link will break and you will need to reapply the payment again.

Regards,
Wee Ming

Hello, everyone! Feel free to participate in the discussion and share your valuable insights.

--
In case you know someone who is new to NetSuite, we encourage you to direct them to our newly launched "New to NetSuite" page. This page is specifically designed to offer them information and guidance and help them make the most out of their NetSuite journey. Click here for more details.

Hi @Angelica Mae Segador-Oracle

Thank you for your reply. I have managed to find a solution for this.

I created a transaction saved search of approved Journals that posted in primary book like below :-

Then I use this Saved search as condition check in the Lock Record action in my workflow. It works perfectly.

Regards
Wee Ming

Hey @User_ETZRS,

When you created the custom view, did you make it public?

If, after making it "public," users still can't see it, add the following permissions to their roles:

Custom Sublist = View
Custom Sublists = View
Custom Subtabs = View

Hi @Rachel_A,

You can create a SS like this then use it as a source in your custom field

Then select this SS in your prepayment balance custom field under the Validation & Defaulting subtab

Regards,
Wee Ming