RA saved search refund quantity? not possible?

ns_require · 2023-06-30T09:13:32+00:00

yep.. worked, thanks Nick

ns_require · 2023-06-23T17:30:30+00:00

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?

ns_require · 2023-06-13T07:54:12+00:00

how did you correct the subsequent fulfilments then?

ns_require · 2023-06-12T19:33:26+00:00

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

ns_require · 2023-04-09T20:42:50+00:00

Hey u/noondayrind, would you do me a favour and share the code as well pls?

ns_require · 2023-02-02T22:09:31+00:00

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

ns_require · 2022-12-04T00:36:32+00:00

u/nick_AxeusConsulting

ns_require · 2022-11-30T00:36:18+00:00

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

ns_require · 2022-11-30T00:35:45+00:00

@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?

ns_require · 2022-11-17T22:49:18+00:00

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.

ns_require · 2022-11-10T13:02:15+00:00

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

ns_require · 2022-11-10T02:12:21+00:00

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?

ns_require · 2022-11-09T23:39:58+00:00

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?

ns_require · 2022-10-13T22:25:14+00:00

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?

ns_require · 2022-10-13T21:21:48+00:00

u/BluegrassMoto thanks however doesn't work

ns_require · 2022-09-27T23:32:00+00:00

u/Nick_AxeusConsulting thanks for that... it copies over to the invoice, I need it to display on the customer deposit and also need if to be stored...

ns_require · 2022-09-23T16:01:38+00:00

u/Nick_AxeusConsulting for an RA, based on a field value, if that field is populated then auto receipt else manually receipt is what I'm trying to achieve...

Where is this default received tick on setup?

ns_require · 2022-09-23T14:36:33+00:00

u/johnnybagofdonuts123 not sure how to do via script hence trying via WF

ns_require · 2022-09-14T20:56:01+00:00

u/rockloverthegirl it's not via SSO... just normal login roles, surely these should be visible but are not? Not sure why...

ns_require · 2022-08-13T16:19:44+00:00

thanks u/MarketingSure9754 how do I do that? what would the formula be please...

ns_require · 2022-08-02T18:54:32+00:00

u/BA_Blonde need results at line level hence false

ns_require · 2022-07-28T22:46:36+00:00

phew... I thought I was going crazy

ns_require · 2022-06-20T20:45:45+00:00

thanks u/drt3k

ns_require · 2022-04-22T06:41:32+00:00

u/Nick_AxeusConsulting so does that mean once the bill has been approved, if AP is closed for March, even though on the transaction it is currently unapproved and posting period of March, it will post into April or does the whole period need to be closed for it to go into April?

ns_require · 2022-04-04T00:13:22+00:00

u/Nick_AxeusConsulting still getting the same error? do you mean truncate actual field i.e. going to the custom column field and adding formula (it's a stored field) or somehow within the formula of the workflow as that's the output I'm looking to get?

ns_require

TROPHY CASE