Vernita Bronze Trophy

HI @Richard James Uri-Oracle The search: varexpensereportSearchObj=search.create({ type:"expensereport", filters: [ ["type", "anyof", "ExpRept"], "AND", ["mainline", "is", "F"], "AND", ["taxline", "is", "F"], "AND", ["trandate", "within", startDate, endDate], "AND", ["expensecategory","noneof","@NONE@"], "AND",…

Thanks @Tris Mendoza-Oracle So the parent item BOM does not need to be added as a component to the child item's BOM?

Advanced Financials

Hi @Wee Ming and @Jeremy Guimaras-Oracle Yes, there is an expense line as well. Is there a way to turn off the option to receipt for expenses? thanks

Option B

Hi @Veronica Steluta Mincior-Oracle and @Vajrala Madhu Reddy That Suiteanswer is describing making the option available for items. Previously, it was greyed out on the item record (off memory) if the item had transactions against it. That doesn't apply here. This is is a service item that is newly created and has never…

Hi @Patrick Fresnosa-Oracle This is what the structure looks like in NetSuite: International Head Office isn't a real subsidiary in the sense that there is no legal entity for this in reality. It is designed to allow JAPAC and America to exist in the system. There is no consolidated reporting for the 'International Head…

Map/Reduce

Hi Patrick. Correct. If the net amount is recoded to the project subsidiary, it doesn't make sense for the tax to be sitting against the employee subsidiary. i can't see a way to fix this so I had hoped there was a setting that would allow the system to recode the tax inclusive amount in the adjustment journal., Thanks

Hi @Veronica Steluta Mincior-Oracle The custom role with the missing field is a SuiteSuccess FF PRM-AP and AR Combination role (the permissions of those two roles have been combined to form a single role). The role it is being compared to is a SuiteSuccess FF PRM-Accounting Manager role. This is the role where the…

Hi @Richard James Uri-Oracle That gives an error since that isn't a valid function for a suitelet:

Thanks @Patrick Fresnosa-Oracle I should have clarified: these aren't conventional subsidiaries in the sense that the transactions need to be arm's length. Would it work for that?

Does that mean the preference set at the company level, per the script parameter settings, is overridden by the setting on the workflow action itself ? I have tested and found the answer: The workflow action parameters (within the workflow itself) take precedence over the company level script parameters.

Hi @Nicole Mendoza-Oracle Just to confirm, SuiteQL can be used to return results in the Get Input Stage of a map reduce script, therefore overcoming the limitation of only being able to process 4,000 results at any one time. Is that correct? thanks

Thanks @Jervin Nicholas Teopengco-Oracle No, it didn't work. However, this worked: There were two delays set up: One hour delay for the transition between state 1 and state 2 per the screenshot above. Another one hour delay for the action in State 2: I would expect there to be a 2 hour difference between the exit from…

Vendor Bills

Thanks @Clarisa De Torres-Oracle Is there an option to set a different account as a clearing account for mismatched intercompany transactions (i.e. something other than Cumulative Translation Adjustments). The reason for this being, the Cumulative Translation Adjustment account will have transactions relating to foreign…

Hi @Patricia Rose Ortua-Oracle Is that field available on custom reports? I have tried searching for it on a balance sheet report though couldn't find that field. Thanks

Hi @Veronica Steluta Mincior-Oracle That worked: It looks like SuiteAnswer 67013 is outdated and needs to be updated. Thanks

Subsidiary

Option B

Hi @Veronica Steluta Mincior-Oracle Thanks for testing. The hide field was unmarked: With the suiteanswer (#9860), it seems to suggest the subsidiary is included in the url parameter when publishing a link to the form. Is that correct? in this case, the subsidiary needs to be set when the user submits the form. Thanks

Hi Yes. The delays on the set up are not matching the delays observed on the workflow logs thanks

Just tested it. Thanks @Wee Ming . That worked

Thanks @Wee Ming I was just coming here to post that I accidentally put it into the wrong column This works

Adjustment

Hi @Wee Ming Thanks for that. Your screenshot is exactly what I was trying though it kept returning an error. I am thinking it might be because of the order the fields are set in—I'll try setting title first. Thanks

Option C

thanks Wee Ming. I'll Try

Option A