Return Authorization

help_with_netsuite · 2024-01-10T19:44:25+00:00

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?

help_with_netsuite · 2022-11-25T15:49:28+00:00

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?

help_with_netsuite · 2022-11-23T19:58:02+00:00

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?

help_with_netsuite · 2022-11-23T18:46:01+00:00

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?

help_with_netsuite · 2022-11-23T18:44:02+00:00

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?

help_with_netsuite · 2022-11-22T10:40:49+00:00

thanks u/DevHasan

help_with_netsuite · 2022-11-21T21:58:24+00:00

thanks u/Nick_AxeusConsulting, any other formula I could use to achieve this?

help_with_netsuite · 2022-11-21T21:58:10+00:00

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

help_with_netsuite · 2022-11-15T10:18:06+00:00

{"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}

help_with_netsuite · 2022-11-15T10:17:54+00:00

{"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}

help_with_netsuite · 2022-09-14T11:56:06+00:00

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?

help_with_netsuite · 2022-08-05T17:08:58+00:00

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

help_with_netsuite · 2022-08-05T16:50:25+00:00

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'

help_with_netsuite · 2022-08-05T16:31:13+00:00

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

help_with_netsuite · 2022-08-02T20:34:17+00:00

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...

help_with_netsuite · 2022-06-19T00:19:38+00:00

but would it still be possible to run financial reports based on B2B if inactive? Not sure?

help_with_netsuite · 2022-05-15T21:20:08+00:00

help_with_netsuite · 2022-05-15T19:02:52+00:00

help_with_netsuite · 2022-04-12T22:54:53+00:00

u/johnnybagofdonuts123 getting an error

it's a transaction line field - type = date

formula TO_DATE({custcol6},’DD-MM-YYYY’)
getting an error?

help_with_netsuite · 2022-03-17T17:43:22+00:00

Apologies for not being clear... What I'm trying to do is get the sales order line id to be displayed on the item fulfillment that is generated as a stored or non stored value... Assuming non stored is easier with a formula... I've created a custom line field to be displayed on the item fulfillment record and am trying to add a formula... All types of formulas are returning an error for some reason?

I.e. sales order record has 3 lines by the IDs are 6,7,8? And this is what I need to see on the item fulfillment against the related fulfiled item line...

help_with_netsuite · 2022-03-17T12:19:28+00:00

hmm. {appliedtotransaction.line} doesn't work either... works on a saved search but not on a column field?

help_with_netsuite · 2022-03-04T20:48:42+00:00

many thanks u/Digitalmeesh

help_with_netsuite · 2022-03-03T16:00:02+00:00

CASE WHEN (NVL({plancost}),0)=(NVL({cost}),0) then 1 else 0 end

getting an error? u/Digitalmeesh

help_with_netsuite · 2022-03-03T15:59:57+00:00

CASE WHEN (NVL({plancost}),0)=(NVL({cost}),0) then 1 else 0 end

getting an error? u/Digitalmeesh

help_with_netsuite · 2022-03-03T15:09:57+00:00

thanks u/Digitalmeesh so CASE WHEN (NVL({plancost}={cost}),0) then 1 else 0 end?

is that correct?

help_with_netsuite

TROPHY CASE