プロフィール
Review our AI Community Guidelines before posting AI-generated or AI-assisted content. Verify accuracy and include the appropriate AI disclaimer.
Action Required: Review and submit pending reconciliation matches before the NetSuite upgrade to avoid rework. After 26.2, unsubmitted matches will be unmatched. For more details, see SuiteAnswers 1047397
Explore NetSuite Next with Free Training!
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
Build your skills with the LCS Explorer Pass.
Visit the NetSuite Next community page
to learn more, ask questions, and share your experience.
コメント
-
When I was in consulting, one of the first things we did was create a custom Item field called Discontinued. We would use that to drive reports and sale pricing. Once a Discontinued item was sold out and all transactions completed (Invoice/cash sale) we would then make inactive.
-
Thanks, I will reach out to my account rep
-
Purchase Price is only available on assemblies if you have the accounting preference "Allow Purchase of Assembly Items" Accounting > Accounting Preferences > Order Management It is only used on Purchase Orders to Debit Inventory on a PO Receipt. Otherwise the Assembly/Workorder Build transaction hits Inventory
-
I searched suiteanswers as well as the bundles and cannot find this. Is this part od a SuiteSollutions install?
-
Is that something Custom in your NetSuite account? I do not have that in mine that I can see but I know that could be very helpful!
-
When you say it does not appear in sales order selection, are you referring to the CSV import? Go back into edit mode and click Apply to Forms. I am betting it is not on your default form
-
Jack, thank you as always! Never sure when to plug the to_date into the formula...
-
Actually, you can have the same item number if the item type is different. I unfortunately will have users create an Inventory type item when it is already set up as an Assembly. Same issues when the item is created but the user uses Lower Case and not Upper even when both are Inventory items
-
There are no "predefined" alerts other than looking at the order items but can easily be created using saved searches For POs created through the Order Items, the context will be "Bulk Processing" and will follow what your normal Approval Workflow currently is (if any)
-
Martha, Try 2 things: 1) I usually leave the Action to trigger on Entry 2) If I select Scheduled instead of on Entry, I always also specify the saved search that I used in the main section under Saved Search Condition
-
Paul, Here is my version that shows current available quantity for components that are either Inventory Items or Sub-AssembliesAssemblies. Note we use normal BOMs (not versioning) and we make use of the Obsolete and Effective dates so this search takes the obsolete into account. Also note that since we have multiple…
-
Do you have the FedEx integration turned on? https://netsuite.custhelp.com/app/answers/detail/a_id/9279/kw/Delivery%20Instructions "If Date Certain or Appointment is selected as the FedEx Home Delivery Type, enter Delivery Instructions for the driver. These instructions are encoded into the delivery barcode. A maximum of…
-
I am just going to take a guess that it is because a Custom Field that is derived from search results is for "viewing" only and will not have a value if used in another formula
-
Interesting, I do not have a field by that name or ID within my environment.
-
Paul, I am sure you have this resolved but I am trying to find the original SuiteAnswer on how to deal with Customer Deductions. I think they may have pulled that answer now that they have the Deductions and Chargeback SuiteSolution. I do not have time to install/learn that process. Do you have a "simple" solution you use?…
-
Martha, I think you can create a journal entry to Debit AR making sure you include the customer on the journal entry line so it can be applied. I assume the Credit whatever the original GL Account was on the Credit Memo
-
We have multiple issues also. Scripts are erroring out (Avalara when saving a sales order) Cannot view customers And now unable to login
-
I do that with transaction numbers all the time so when looking at just the tran ID you know what type. Might be doing for similar reason for Customers and Vendors.
-
Sorry for the delayed reply as I was at the Highjump conference. I do not know how I had never seen COGS amount before... Thanks for the help
-
I use a scheduled Workflow to do the same. Just create a saved search of all sales orders pending billing and run every 30 minutes
-
Are you currently trying with a workflow? Are you using the join to "Created From"?
-
Yes, if you use fulfillments (and the above assumptions are true-Always have a sales order) then the fulfillment works as when you sell a Kit type item and fulfill it, you actually get the fulfillment of the component items.
-
In the past I have used Fulfillments (created from sales orders) as a basis of sales as you can get full data on kit members and quantities. It assumes that if it is fulfilled it has been sold. It also assumes that you do not do invoices or cash sales without starting from a sales order.
-
You would use the join to the items {item.locationquantityavailable}
-
I think what you are looking for is (item.locationquantityavailable} (or locationquantityonhand)
-
When I mention COGS I should have said Expense. Is that only associated with the vendor Bill then?
-
Jeff, I am going to the conference on Monday and hoping to have a direct chat with folks there. I am just amazed and the missing functionality (incorrect processing of Units of Measure, no tracking on transfer orders, inability to effectively use Line Level fulfillment locations are 3 simple examples, ) We have not looked…
-
Luckily, no it cannot be changed.
-
Unfortunately, the Item Receipt record is not available to CSV. If you do not script, you could update via a scheduled Workflow that you only ran once.
-
I did not try to clear cache or use another browser but about an hour later the field appeared