Ivy Lopez-Oracle NSC Guru

Thanks for the update, Liz! I'm glad that you were able to do the imports successfully. ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same…

Yes Liz, it's correct.

Hi Liz, Then you can use the either the Base Price or the Purchase Price and map it to the Price field.

Hi Liz, I'm glad that you got that part done now! ? For the List Price, that was the just the column header in my CSV file when I did the import on my end. Do you have the Price per item for your SOCORRO CONTRACT Price Level? Is it the same as the Base Price/Purchase Price?

Glad that you now have the report/search that you need. ? If it's not too much trouble, we would greatly appreciate if you can click "Yes" on “Did this answer your question?” below the comment/s that helped in your concern. Doing so will help other community members who might have the same concern find the answer easier…

Is that the complete list? If the job status said that 190 of 190 records imported successfully, then the items in your CSV file should have been added to the customer record. You can refresh the customer record again, or try to clear cache, log out and log back in to check if the customer record has updated. To check how…

Oh, Assembly Build and Work Order Issue are Types of Transactions, not items. Please refer to the screenshot I provided in my previous comment. I added them under the Type filter, not Item: Type.

Hi Liz, You have the correct mapping, but please make sure that Internal ID is selected for the Item internal ID field. Click the pencil icon, then select Internal Id in the dropdown.

Did you perhaps rename these records? I checked on my account, and these are showing under Type:

Hi @Liz Madrid, Since you are importing the Customer Record, pls refer to the steps I provided in my previous comment -- under the section "B. Import Items and Price Level in Customer Record" Kindly double check your mapping.

Hi @KR Mike, If your account just has "Assembly", then it means that Advanced BOM is enabled on your end. As long as the items are in Item Fulfillments, then it will be counted in the search. If you want to also count how many times the items are included in Assembly Build or Work Order Issue transactions, then you can add…

Good morning, Liz! There is no attachments in your comment, only a screenshot. You can send it to me via Private Message if you want.

Hi Dallas, Glad that you figured out the culprit! I ran a few more tests on this one and I think the reason for this behavior is because the Wave # (Applying Transaction) is found in the Shipping Line, while the Expected Receipt Date is on the Item Line and the Receiving Line, but not the Shipping Line. See example below:…

Hi Liz, Once you get export results of the search to a file format you can open in MS Excel, then you can use the VLOOKUP or XLOOKUP function in MS Excel to get the Internal ID and/or Item Name of your 200 items. You can use the Part Number (from your vendor's spreadsheet) and the Display Name (from the Saved Search…

Thanks for that clarification. Can you create this Item Saved Search please, then export the results? Criteria tab: Preferred Vendor = EPD Results tab: Internal ID Name Display Name If you can send me the exported file from the Saved Search, and your spreadsheet with the list of the 200 items, then I can help you create…

Sorry if I was unclear. What I meant was a field or something that the 200 items had in common. Like a common preferred vendor perhaps? I am asking this one so that we can include it in the Criteria of the Item Saved Search like this: And here's the Results tab: The results of this search will show only those items that…

Hi @NitinEOH, Based on SuiteAnswers 100251, demand can come from both sales orders and demand plans. So to answer your question, you can consider importing Sales Orders or Item Demand Plans for this. Refer to the following SuiteAnswers articles for more information: 10003 - Sales Order Import 21024 - Item Demand Plan…

Sure, I can help you with that. I think we can do an Item Saved Search for this one. However, we need to have have an identifier or a field that we can use as a Criteria to get the 200 items. If we don't have one, then all items will be shown in the Saved Search. Do you have an idea of what field we can use to narrow down…

Hi @KR Mike, Have you had the chance to test the solution I provided in my previous comment? Let us know if it worked for you, or if you need further assistance on this one.

No worries, @Liz Madrid. ? Based on the screenshot of the list that you provided, it looks like your list is opened in MS Excel, is this correct? Or are you using another program? Also, is the "Part Number" the Item Name in the system? If so, you can save this file as a CSV file and use it for your import: Basically, your…

Hi @NitinEOH, Please refer to SuiteAnswers 91417 for the documentation about Bar Code Setup for NetSuite WMS. You can also check the WMS User Guide. According to the documentation, the supported Bar Code Formats for NetSuite WMS are Composite and GS1. There is currently no documentation about your specific requirement, but…

Hi @User_RHKAB, I checked on this one, but I don't think it is possible using a Saved Search. You may refer to the following related threads for a detailed explanation on the limitation of getting the details of components in Saved Searches when Advanced BOM is enabled: Saved Search BOM Inquiry for Advanced BOMS Member…

Hi Liz, Ivy here. ? You mentioned in your previous comment that you had a file with the list of 200 items, is this correct?

Hi Liz, I tested this one on my account and I noted that it actually doesn't matter which import you do first. Since you are using a Price Level, you would just need to add the Item and Price Level in the Customer Record. It will then source the Rate/Price that you set for SOCORRO CONTRACT Price Level in the Item Record.…

You're welcome, Dallas! ? Glad that it now works on your end. By the way, NVL is a function that lets you replace a null/blank with a zero or another value. The syntax is: NVL(expr1, expr2) and when expr1 is null/blank, it will return expr2. So for example, NVL({quantity},'0') if {quantity} is null/blank, the function will…

Thanks for providing the screenshot! Per checking, this is still the same formula. In the updated formula I provided, the second operation used is a minus sign (not a plus sign). So it should be: expr1 + expr2 - expr3 - expr4 Kindly double check. I provided the updated formula in my previous comment.

Hi Dallas, Can you share a screenshot of your updated Results tab?

Hi Dallas, I looked more closely at the formula, and it seems that I used a + instead of a - in the formula. My bad. ? Also, I know that the formula we used is a bit long and can be quite overwhelming, but it's simple if you understand where the expressions are coming from. Here's a little something I prepared to help you…

Hi @User_5OUXV, Welcome to our community and thank you for posting your question here! ? @Michelle Jabanes-Oracle, need your expertise on this one. To our other members, feel free to comment your insights as well.

Hi there @John Griffin, Glad to have you with us today and thank you for posting your question here in our community! ? Let me tag our Gurus who specialize in customization: @Jack Daryl Espiel-Oracle / @Joahnna Given Uy-Oracle / @Kristoffer Viray-Oracle, any ideas on this? To our other members, feel free to comment your…