JohnCirocco · Sr. NetSuite Administrator · Silver Trophy

And it is even happening in employee center. Glad they tested this

@eleran same here. All 1's

@BryanL Can you share the formula you are using? My guess is you add ".id" to the field you will not get that error.

@User_G2XMD I am assuming that you are supplying items to a Customer that is on consignment? Back when I was in consulting, one of my customers still did an invoice but had a terms code called Consignment which had 365 days until due. If the customer returned the product, an RA and Credit would be applied against the…

@Joy Noreen Magoling-Oracle We have finally figured out what the problem is. Unfortunately, prior to my arrival here, a consultant turned on Cross-Subsidiary Fulfillment. When that is turned on, a very different Location field on sales orders is used to force the Commit Inventory to happen. The field is "Inventory…

@Joy Noreen Magoling-Oracle Unfortunately, clearing the location, saving, then adding and re-saving did not change the result. I did have ACS open a case last week 5157500.

@Joy Noreen Magoling-Oracle Unfortunately, yes I have verified all the points in SA28531 There is no special order PO or work order. Location record has Make Inventory Available And as you can see from the screen shots above, even the sales order line is showing them as available and I can even successfully fulfill the…

@Joy Noreen Magoling-Oracle Yes, there is a quantity of 12 in the same location as the sales order. It also shows 12 available. I replicated this in the sandbox (which is why the item it Test Inventory Item). Also, the quantity picked is 0 on the reallocate items page

@Sharon Hirsc If you are just looking for 2022, you can run an Inventory Activity Detail. You can customize the report and under the Qty column, check the Add Running Balance checkbox. The report may be huge depending on the number of items and transactions so you might need to run for smaller date ranges to get all of…

@Benjamin Paul - USA Yes. First you need a search that selects only the items you want. Assuming you only sell Inventory Items the search is very simple. Criteria = Available Greater than 0 but if you also sell Kits or Non-Inventory Items, you will need more complex criteria. Once you have the search, just customize your…

Jim, If you don't mind doing 2 separate searches (this example is for 2 or more orders): Main criteria (I added the status field to eliminate closed/cancelled orders) Then on the Summary Criteria: And then the results: Hope this helps.

@Katerina Winklerova-Oracle Unfortunately that field {item.vendorname} refers to the generic field in the item "header" (in this case F12SB-OEM) On the Purchasing tab where you specify multiple vendors that you can purchase the item from is the field I need (in this case from vendor Alibab their number is YC-A01D) And here…

@Richard James Uri-Oracle My apologies for not being clear. This is related to both scripts as well as searches looking at the line level of a purchase order. When I use the field in a search I receive ERROR: Field Not Found which is the same error our developer was getting

@Richard James Uri-Oracle I am going to guess that it is related to the ending of the ACH functionality with Coastal. Even though we did not use coastal for ACH processing, we apparently were using the fields on were on the vendor record that we are now learning were also removed when they stopped using coastal on 3/31

@Katerina Winklerova-Oracle We are looking for the field vendorname as shown below on a Purchase Order. It represents what the vendor calls their part number And here is the xml from the PO screen

Katerina, We are actually trying to find the field that is the vendor part on a PO. When you view the page XML, you will see that vendorname (on a purchase order) is actually the Vendor Part Number (Vendor Code from the item record vendor sublist).

@Dave I have heard this in the past and, yes, it was really the number of support authorized users. Finally convinced them.

Since you need to see the Created from transaction, you will need to start with a Transaction Search. Criteria: Results Filter:

I am interested in this as we are also experiencing items having the same reorder point and preferred stock level

I have had this happen when the browser saves a password. If you clear saved passwords in your browser settings, it should get resolved

Yes, if you are based in the Boston data center they are reporting issues on status.netsuite.com

@User_4G41H Kate, For the first question, check out Invoice Groups. The Invoices are still seperate but there is a new record that lets you group multiple invoices into a single document. For the second, unfortunately you cannot have multiple sales orders on a single fulfillment John

@Robert Nedelkow - Oracle Do you recall marking community email as spam? No-Verified my rules and Spam folder empty Does the notification icon get cleared after marking all as read? No-Has not for many months. I reported this way back in pl or May Did your notification preferences change recently? forced every category to…

Sorry for the delay. We will be hiding the column but have a form for stand alone bills. Thanks to all for the help! John

@Joahnna Given Uy-Oracle Thank you so much for this. I will try this out.

Yes, if you use an item type of "Kit/Package" you can sell the set but fulfill using the individual inventory items

Sorry, meant to say modify the Bill form (I was working on my own PO issue and slipped). Anyway, Inline Text shows the value of the field but does not allow the user to edit it

To keep users from altering the field, you can customize the PO form and change the Display Type to Inline Text for that field.

I would definitely check out the Smartsheet tool from Celigo. Much more than reporting. https://www.celigo.com/integrations/Smartsheet/

@clautre You have 2 options: When you get to first screen when editing the CSV mapping, your top right "should" have "Copy to Account". If you do not see it you need to enable it on both Live and Sandbox Your second option is to use a Bundle.