User_25S2N Red Ribbon

[ATTACH=JSON]{"data-align":"none","data-size":"small","data-attachmentid":428251}[/ATTACH]

We need to pass this as criteria rite?. In saved search by using formula field, we place formula in formula field and that condition we need to take?

it's getting like this, [ATTACH=JSON]{"data-align":"none","data-size":"small","data-attachmentid":428230}[/ATTACH]

Hi, Can anyone suggest like which formula need to use for my requirement. For example i have a field called "BirthDate" in customer record (21-nov-1990). While building a search based on "birthdate", we should mention criteria like that customer has to be in search Results till (21-dec). Thanks!

Thanks for your quick response J.J. But my requirement is like Need to pull all customers and they should be removed automatically after a month from his birth date.

Yeah i have replaced that field over their (formula you have assigned). Even it's getting error like syntax error

Thanks mwhite!. It contains syntax error, Could you please check it once :(

Same thing i to did. but Same error occurred.

Thanks mwhite!. It contains syntax error, Could please check it once :(

Thanks for your reply mwhite@hgyp.com! It's working fine. But it won't work for past data i mean like if that customer birth data is like 20-nov-1998. Need to filter out through date and month. Can you guys help using custom formulas using (functions as decode and some other). Thanks!

Thanks for your reply Nelliott. I have done it by that we can able to pull phone number from newly created records. with that need to pull data from existing records

And how to get the line count of the Invoices whose line amount is greater than 200 dollars.i am doing through saved search, can you guys suggest any formula to get those line count.

Hai javier, Thanks for your reply. And i need help regarding closing transactions. Can we reclose the closed order?. If yes how can we do that.

Hi Carl, Thanks for your response! How can we take criteria as active Employees AND (Supervisor is Inactive OR Expense Approver is Inactive)? As we are creating the employee saved search, we can access supervisor and expense approver data because they are employees right? I'm thinking to pull out the inactive supervisor…

Hi Stephanie, Thanks for your response and valuable time. Have a Good Day! Thanks!

Hi Everyone, Can anyone help me to sort it out so quickly, it's an urgent to us. Please can we create a saved search that looks at: [LIST] [*]Active employees [*]Supervisor is not active [*]Expense approver is not active [/LIST] Can the results then show: [LIST] [*]Subsidiary (no hierarchy) [*]Employee Name [*]Job title…

Thanks for your response pcutler! But we need to restrict only to Journal entry record. So opt for Scripting part.

Thanks for your reply Derek Sachs!

Thanks Robert!

Hi Robert, Small help! Where can we find Financial Forum were my topic moved. Thanks!

Hi Derek Sachs/Jhelver Layderos, Thanks for your reply!. Actually what happens in that screen is When I tried to run depreciation it through's an error like permission violation. After i check with that asset depreciation had done and journal get posted like it got Nullified with same account(credit and debit). Mr Derek…

Hi Everyone, Now i'm facing an issue like when I went into Net Suites to dispose of some additional assets and few assets didn't dispose correctly and journal are not impacted correctly and for few Journal Entry not get created. Can anyone help like what may be the reason for this issue. Thanks!

Hi... I have set up Work Centers in AM as well as Netsuite, But i am to get that list of work centers in Tablet Data Entry screen. Could you please help me What i need to do to get that list over their. Thanks!

Can you suggest any article or process to set up

Hi Everyone, I have set up work centers in AM and also Core Netsuite also but i'm facing same issue that list is not coming over their. Something like this, Could you guys have any idea about this can help me to resolve this issue. [ATTACH=JSON]{"data-align":"none","data-size":"medium","data-attachmentid":428641}[/ATTACH]

Thanks for your response paynerm!. I don't have that much knowledge on AM tablet data. we have started using this module few days back. Could you please help me like how to set up Work centers in AM as well as Netsuite.

Hai How to get the line count of the Invoices whose line amount is greater than 200 dollars.i am doing through saved search, can you guys suggest any formula to get those line count

Thanks Robert Nedelkow