YYF — NetSuite Community

From my experience, I did some extensive testing, this has nothing to do with hidden fields on a form. When you try to source the Ship Date field on a sales order line, NetSuite may behave in 2 ways. If certain features are enabled in your account, it will pull the value from the Expected Ship Date on the sales order line…

in Sales order saved search formula showing the # of business days the order shipped after ship date Comment by YYF Apr 12, 2024 4:08PM

Defect 720927 regarding the indent issue, was closed with the following message: NetSuite has carefully reviewed the information on the issue and we have concluded that the behaviour is working as expected. We are reviewing SuiteAnswers to ensure that this is documented. Issue Number: 720927 Abstract: SuiteScript > File…

in UI: Are the changes in the Script File Editor expected? Comment by YYF Jun 20, 2023 2:25PM

@Joahnna Given Uy-Oracle Thanks for your reply I followed your advice and create a custom Ship Date column field and a workflow that fills it in based on the date in the standard Ship Date body field. I can confirm that this works, I can now see the ship date on saved searches. I consider this a workaround for a defect…

in How to get Ship Date from main line on a line level Saved Search, Supply Chain Allocation enabled? Comment by YYF Jun 14, 2023 3:02PM

@Joahnna Given Uy-Oracle Thanks for looking into this request. Our requirement is to show the Ship Date from the main line (standard body field) on a line level saved search. Here's a recap of the discussion above: Sales Orders have a standard body field 'Ship Date' which is meant to be used as an expected ship date or due…

in How to get Ship Date from main line on a line level Saved Search, Supply Chain Allocation enabled? Comment by YYF Jun 13, 2023 8:59PM

@Joy Noreen Magoling-Oracle I have no alternate solution. As I explained, my issue is that the Expected Ship Date will always be blank on some orders because I'm using a non-inventory clearing location. Basically, these are drop shipped orders but I enter them as special orders since that allows me to add landed cost and…

in How to get Ship Date from main line on a line level Saved Search, Supply Chain Allocation enabled? Comment by YYF May 29, 2023 4:39PM

Here's an update on this topic: On being unable to use indent: defect 720927 was filed, urgency level is U6 On losing all changes after a syntax error: defect 714661 was filed and a fix was released @w8n2cagr81 I didn't notice the Ctrl-F issue, I encourage you to open a case with NetSuite support For anyone else: if the…

in UI: Are the changes in the Script File Editor expected? Comment by YYF May 18, 2023 2:20PM

@Jack Daryl Espiel-Oracle Case # 5179380 created

in Why is a Non-Preferred Inactive Custom Form being used by default for new Quotes? Comment by YYF May 4, 2023 10:27PM

@Joy Noreen Magoling-Oracle I'm bumping into the same issue and my experience matches the OP's and not what your screenshots are showing. We don't have Demand Planning enabled but we have Supply Allocation which also adds the Expected Ship Date on the lines. Since we enabled Supply Allocation I CANNOT get the mainline ship…

in Ship Date on Saved Search Comment by YYF May 4, 2023 4:12PM

Hi @Jack Daryl Espiel-Oracle See screenshot below, form ID 173 is the only one active and preferred. 191 is inactive This is a partial look of form 173 And this is from 191 I just realized this issue isn't restricted to the Create New menu. I opened a new quote from Transactions > Sales > Prepare Quotes, and you can see…

in Why is a Non-Preferred Inactive Custom Form being used by default for new Quotes? Comment by YYF May 4, 2023 3:59PM

Hi, I'm currently setting up gift cards on my Shopify store and bumped into the same issue. NetSuite is using a Discount Item for partial payment, and a Payment Method for full payment. The problem is that Discount Items (any Item) can use any account type except Bank, while Payment Methods can only use the Bank account…

in How to book Shopify Gift Card revenue in NetSuite Connector? Comment by YYF Dec 22, 2022 4:26PM

Hi @Joy Noreen Magoling-Oracle This solution: Does not sum up the unconfirmed quantities, instead it shows a separate line for each order. Relates each order with every location out there, not just the location the order is on. Is not tested on kit items (I believe it won't work). Does not have a filter for item/locations…

in Compare Location Available Inventory to Uncommitted Quantity (from Unapproved Sales Orders) Comment by YYF Jul 25, 2022 5:56PM

Hi @Joy Noreen Magoling-Oracle Yes, we need a single saved search. We need only 2 pieces of information regarding inventory items, everything else I wrote was just details. The end result should be something like this: We'd like to have this in a reminder, we're flexible in regards to the number showing on the reminder.…

in Compare Location Available Inventory to Uncommitted Quantity (from Unapproved Sales Orders) Comment by YYF Jul 18, 2022 5:02PM

For the record: when you set the Commit Strategy to Do Not Commit, the item will be added to back order. OP said the item was first set to Complete Quantity so this shouldn't apply here.

in How can an item be available and back ordered both ? Comment by YYF Jul 5, 2022 8:36PM

@User_BNWQC b1. Use Item Cost as Transfer Cost = T - system uses the average cost of your Receiving Location I don't think this is correct, the system should use the average cost of the Source Location. Once received, these new units becomes part of the Receiving Location's average. In my case, the Receiving Location had 0…

in Unbalanced inventory in transit Comment by YYF Jun 3, 2022 2:57PM

Hi again I think there's some misunderstanding here, maybe I wasn't clear in my response. John's suggestion didn't discover the cause of the discrepancy, it only confirmed to me that the discrepancy is there, is pretty large, and cannot be explained by rounding error. To reiterate, a Transfer Order was fulfilled at $27.28…

in Unbalanced inventory in transit Comment by YYF Mar 29, 2022 1:51PM

@Joy Noreen Magoling - Oracle-Oracle Thanks for taking the time to responding to this case. I don't think this answers my question though as explained below: 1 - In my case, the difference is between the Item Receipt and the Item Fulfillment related to the same Transfer Order, and the difference is almost $6 per unit. How…

in Unbalanced inventory in transit Comment by YYF Mar 25, 2022 5:31PM

@3ric I understand your issue now. I thought the question was simply how to show all lines of a transaction if any of its lines match a static criteria. I have researched this a lot and found the CASE formula to be the only solution out there. Now the question becomes, can that formula refer to a selection in the Available…

in Display all items in transaction containing *any* item matching the Dept filter in a Saved Srch Comment by YYF Mar 24, 2022 9:57PM

Hi @Joy Noreen Magoling - Oracle-Oracle I know exactly what Transfer Orders are, I use them all the time. However, I don't understand why the Inventory In Transit amount should differ between the Item Fulfillment & the Item Receipt. We always leave "USE ITEM COST AS TRANSFER COST" as checked. so this is what's supposed to…

in Unbalanced inventory in transit Comment by YYF Mar 24, 2022 2:28PM

Hi @3ric Try adding the following Summary Criteria: Summary Type: Sum Field: Formula (Numeric) Formula: CASE WHEN {item.department} = {user.department} THEN 1 ELSE 0 END Description: is greater than 0 From the Standard Criteria, remove this part: Item : Department: mine This formula adds the number 1 for each row that has…

in Display all items in transaction containing *any* item matching the Dept filter in a Saved Srch Comment by YYF Mar 23, 2022 10:38PM

@Ivy Lopez-Oracle This doesn't work for kit items. Is there a solution that works in all cases?

in Slice Item Fulfillments' COGS by the Sales Order line's Price Level Comment by YYF Feb 11, 2021 5:05PM

If someone knows how to achieve these results in Reports and/or Analytics, it would still be helpful.

in Slice Item Fulfillments' COGS by the Sales Order line's Price Level Comment by YYF Jan 20, 2021 5:30PM

Thanks @Ivy Lopez-Oracle for this neat solution, I wasn't aware of the Fulfilling/Receiving Transaction Fields, this will come in handy for many more searches. I modified the criteria and results a bit to fit my needs, here is what I did in case it helps someone: Criteria: Type = Sales Order, Cash Sale Created From = None…

in Slice Item Fulfillments' COGS by the Sales Order line's Price Level Comment by YYF Jan 20, 2021 4:54PM

@Shamaine Chan-Oracle Are you & @Ivy Lopez-Oracle still checking on this?

in Slice Item Fulfillments' COGS by the Sales Order line's Price Level Comment by YYF Jan 19, 2021 10:28PM

YYF Red Ribbon

Comments