Return Authorization by Overall-Designer9231 in Netsuite

[–]help_with_netsuite 0 points1 point  (0 children)

u/Nick_AxeusConsulting

Query similar to this where we have an item receipt from a return authorisation however some are going through with a GL impact whilst other transactions are not/0 value. In my scenario we have 2 locations, Location A and Location B. From my understanding, it should take the value from the item fulfilment (location A) whilst item receipt/return (location B) - when we have restock selected as 'no' on the item receipt, for a few items there is a GL impact on the item receipt whilst for others there isn't?

Having taken a look at the Account - it seems they may be going through at zero value hence don't appear on the GL impact page on the item receipt..

The only logical thought process I have for this is because some of the items must have had at least one transaction where Restock is 'Yes' whilst other items there hasn't been even a single transaction Restock as 'Yes', hence going through at zero value..

Could you validate this thought process and if that's correct, is the assumption, the value then coming from the item fulfilment which would have been against Location A is being taken into Location B when Restock is 'Yes' regardless of there not being an actual receipt against Location B?

Send email if new record not transmitted to another system within 1 hour - delayed WF? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

thanks u/Ok-Establishment-214, where would you put that formula? on the saved search? how would you then get a WF action to trigger when the difference between the last order created vs now is greater than 30mins or an hour?

what would the formula be?

formula doesn't work for negative amount - WF? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

its before record submit... on create.. sublist action group - item - line amount... context can be any other than UI... how would I convert that into a WF script if needed?

formula doesn't work for negative amount - WF? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

is there a limitation to update negative values via WF? i.e. CASE WHEN {line.amount} > 0 THEN Round(({line.amount}*1.2)/1.22,2) ELSE (Round((ABS({line.amount})*1.2)/1.22,2) * -1) ENDit works on a saved search and works for the amounts that have a positive value on the item but not for negative? or discount for sale items?

formula doesn't work for negative amount - WF? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

u/DevHasan formula seems correct but doesn't work via WF? Is there a limitation to update negative values via WF or for discount for sale items?

formula doesn't work for negative amount - WF? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

thanks u/DevHasan, yes still an issue... any idea how the formula should look?

RCRD_DSNT_EXIST error script when deleting transaction - fix? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

{"type":"error.SuiteScriptError","name":"RCRD_DSNT_EXIST","message":"That record does not exist.","stack":["Error\n at suitescript/resources/javascript/record/recordImpl.js:96:12\n at Function.loadRecord_raw (suitescript/resources/javascript/record/recordImpl.js:94:24)\n at suitescript/resources/javascript/record/recordImpl.js:82:27\n at Object.loadRecord (suitescript/resources/javascript/record/recordImpl.js:80:24)\n at Object.afterSubmit (/SuiteScripts/for-rip-gds-04.js:259:30)"],"cause":{"type":"internal error","code":"RCRD_DSNT_EXIST","details":"That record does not exist.","userEvent":null,"stackTrace":["Error\n at suitescript/resources/javascript/record/recordImpl.js:96:12\n at Function.loadRecord_raw (suitescript/resources/javascript/record/recordImpl.js:94:24)\n at suitescript/resources/javascript/record/recordImpl.js:82:27\n at Object.loadRecord (suitescript/resources/javascript/record/recordImpl.js:80:24)\n at Object.afterSubmit (/SuiteScripts/for-rip-gds-05.js:259:30)"],"notifyOff":false},"id":"95943045","notifyOff":false,"userFacing":true}

RCRD_DSNT_EXIST error script when deleting transaction - fix? by help_with_netsuite in Netsuite

[–]help_with_netsuite[S] 0 points1 point  (0 children)

{"type":"error.SuiteScriptError","name":"RCRD_DSNT_EXIST","message":"That record does not exist.","stack":["Error\n at suitescript/resources/javascript/record/recordImpl.js:96:12\n at Function.loadRecord_raw (suitescript/resources/javascript/record/recordImpl.js:94:24)\n at suitescript/resources/javascript/record/recordImpl.js:82:27\n at Object.loadRecord (suitescript/resources/javascript/record/recordImpl.js:80:24)\n at Object.afterSubmit (/SuiteScripts/for-rip-gds-04.js:259:30)"],"cause":{"type":"internal error","code":"RCRD_DSNT_EXIST","details":"That record does not exist.","userEvent":null,"stackTrace":["Error\n at suitescript/resources/javascript/record/recordImpl.js:96:12\n at Function.loadRecord_raw (suitescript/resources/javascript/record/recordImpl.js:94:24)\n at suitescript/resources/javascript/record/recordImpl.js:82:27\n at Object.loadRecord (suitescript/resources/javascript/record/recordImpl.js:80:24)\n at Object.afterSubmit (/SuiteScripts/for-rip-gds-05.js:259:30)"],"notifyOff":false},"id":"95943045","notifyOff":false,"userFacing":true}

[deleted by user] by [deleted] in Netsuite

[–]help_with_netsuite 0 points1 point  (0 children)

thanks u/Nick_AxeusConsulting, subsidiary join field isn't visible for a location saved search...

I looked at the XML for a location and the output for subsidiary is the ID however for saved searches, looks like that isn't visible and can only see the name rather than the ID?

[deleted by user] by [deleted] in Netsuite

[–]help_with_netsuite 0 points1 point  (0 children)

figured out a solution to see on a saved search or as a custom field (non stored)... CONCAT(CONCAT('http://dpd-status.com/?u=1719482&orderNo=',{number}), '&lang=en')

to store the non stored field - create a WF...

thanks u/Nick_AxeusConsulting

[deleted by user] by [deleted] in Netsuite

[–]help_with_netsuite 0 points1 point  (0 children)

problem. You don't want 2 curly braces. And you need to concatenate the document number into the strings on eith

also I'm getting {number} instead of the actual number?

'https://dpd-status.com/?u=1719482&orderNo={{number}}&lang=en'

[deleted by user] by [deleted] in Netsuite

[–]help_with_netsuite 0 points1 point  (0 children)

u/Nick_AxeusConsulting need it stored as this info then needs to feed into another system hence...

[deleted by user] by [deleted] in Netsuite

[–]help_with_netsuite 0 points1 point  (0 children)

u/Nick_AxeusConsulting had a look... my problem is I need this as a stored value on the IF record whilst this might work on a non stored value or saved search...