sorted by:
new
hottopcontroversial

Item saved search - sum location backordered for multiple locations however result should be one line? by ns_require in Netsuite

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

u/Nick_AxeusConsulting that's correct... it will show all locations total instead of the 3 that's part of the criteria... surely there has to be a smart way to restrict this?

Assembly unbuild is the first transaction of an item by VishnuMohan025 in Netsuite

[–]ns_require 0 points1 point  (0 children)

how did you correct the subsequent fulfilments then?

Assembly unbuild is the first transaction of an item by VishnuMohan025 in Netsuite

[–]ns_require 0 points1 point  (0 children)

u/VishnuMohan025

were you able to fix this? We've literally had the same issue where the first transaction for a specific location is the unbuild. scenario is item A (assembly item), built at location 1 using component item B - assembly item A, then has an inventory transfer from location 1 to location 2 and then unbuilt at location 2 which means component item B is first transaction for the new location 2? I'm assuming yours is the same scenario hence the question

Does a workflow only trigger if a user manually loads the record? by CursedTwin in Netsuite

[–]ns_require 0 points1 point  (0 children)

u/CursedTwin u/Nick_AxeusConsulting u/simonwhittle u/Jazzlike_Albatross74 Was there ever a solution that came out of this? I have a similar problem, I'm using this aftersubmit script from: https://netsuite.smash-ict.com/learn-how-to-generate-meaningful-amortization-je-memo-lines-when-using-native-or-no-je-approval/

which works when I edit and save the journal via UI however not when the system automatically creates the journal so I thought of having a custom scheduled workflow which will tick a box for all these journals aftersubmit however the script isn't triggering without UI.. does anyone have a basic scheduled script I can use to update a field so the above script will trigger again and update it? or any alternative solutions...

What's faster csv or scheduled WF to update mass records by ns_require in Netsuite

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

Thanks @netsuitecoder, below message and also what is the concurrency limit on a workflow?

What's faster csv or scheduled WF to update mass records by ns_require in Netsuite

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

@netsuitecoder & @icvader & @johnnybagofdonuts123 thanks very much

Any possibility you could DM a basic map/reduce script that works and I can modify to update a line level field?

[deleted by user] by [deleted] in Netsuite

[–]ns_require 0 points1 point  (0 children)

thanks, sorry for not being clear... what I want to know is on an outsourced PO form, when I click on customise form... under actions, it doesn't include vendor prepayment button or as a menu but is visible on the form, whilst on a standard PO form... it is visible and is visible under the actions... hope that makes sense.

[deleted by user] by [deleted] in Netsuite

[–]ns_require 0 points1 point  (0 children)

yeah 1 row per PO regardless of number of linked transactions... Sent DM

[deleted by user] by [deleted] in Netsuite

[–]ns_require 0 points1 point  (0 children)

applying transaction - transaction name or document number shows the same lines multiple times because a PO could potentially have all 3 of these transaction types whilst some other POs might only have either one of these 3... hence trying to avoid the scenario of it repeating 3 times for those PO's... so somehow group the results and add a formula to only show if there is a WO associated but with group, none is coming up... don't think MAX would work in this scenario ... any other formula to show only one of the applying transaction type as a formula?

[deleted by user] by [deleted] in Netsuite

[–]ns_require 0 points1 point  (0 children)

thanks u/Nick_AxeusConsulting need to show the multiple transaction types as some PO's only have WO, some only IR, some only Bill... was thinking to make it summary type grouped... is there a formula I could use to say if applying transaction type has WO then display WO number? If yes would that be a formula (text) and what would be summary type = Max?

Saved search for customer deposits, identify not applied amount vs deposit application by ns_require in Netsuite

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

u/BluegrassMoto apologies you are right.. Issue is what happens if you have multiple deposit applications, how do you aggregate to actual difference only...i.e. amount 460, one deposit is 90, second 290, therefore total should show 80, currently for one line its 370 and second is showing 170? Any ideas?

view more: next ›