Ivy Lopez-Oracle NSC Guru

You're welcome, Sophie! ?

Yes Sophie, I understand that you want the running balance of the value of the item. You can do it by customizing the report and adding the running balance for the Inv. Value column instead. The report will look like this: In Reports, users can only add 1 running balance column. This is the standard behavior of the system,…

Hi Sophie, The Inventory Valuation Detail report has those information. 1. Go to Reports > Inventory/Items > Inventory Valuation 2. Click the On Hand column for the item you need the information for 3. After clicking that, you will be redirected to the Inventory Valuation Detailed report for that item. Select the correct…

Hi Sophie! Looks like what you need is the standard Inventory Valuation Report we have in the system. You can find it in Reports > Inventory/Items > Inventory Valuation. Then click the item you need to get a detailed report of. However, the ability to add more than 1 running balance column per report is a current system…

Hi @Johnny Cash, Glad to have you with us today and thank you for posting your concern here in the community! I checked this as well on my standard test account and I was also unable to find this field on the results tab of a transaction saved search. Upon further checking my resources, I found out that this is field is…

Hi @KaylaM, Glad to have you back with us today and thanks for creating another thread here in our community! ? Allow me to tag my colleagues who can assist you with this concern. @Camille Cagalingan-Oracle and @Micah Timbol-Oracle, any ideas on this one? To anyone else who has insights on this concern, feel free to…

You're welcome, Asher! Allow me to tag my colleagues @Pauline Joy Cac-Oracle and @Jack Daryl O Espiel-Oracle as they can further assist you with your concern about adding the Inventory Detail and Price fields from the Item Fulfillment. Anyone else who has any idea about this, feel free to comment on this thread! ?

Thanks Erick! Hello Asher, To be able to print the Advanced PDF/HTML form of Packing Slips in the Item Fulfillment, do the following steps: 1. Go to Customization > Forms > Transaction Forms 2. Look for Standard Packing Slip then click Customize Note: If you have another preferred form, look for it instead, then click Edit…

Hi @rburns515, Glad to have you back with us today and thanks for creating another thread here in the community! ? May we know if you are utilizing Matrix Items? if so, you can set the price of the matrix subitems, so that it will reflect automatically when the the item (color and/or size combination) is selected on the…

Hi @User_HD44H, Yes, you can import sales/demand into NetSuite. Here are some helpful SuiteAnswers articles to guide you in the import process: SuiteAnswers 21024 - Item Demand Plan Import SuiteAnswers 21027 - Weekly Item Demand Plan Import SuiteAnswers 21022 - Demand Plan Body Data SuiteAnswers 21023 - Demand Plan Sublist…

Hi Debbie, Glad to have you back with us today and thank you for posting your concern here in the community! Kindly allow us some time to check this on our end. I'm also tagging our guru, @Shamaine Chan-Oracle, who has the expertise in this area. Any thoughts on this one, Shamie? Any other users who can share their…

Hi Debbie, Glad to have you back with us today and thank you for posting your concern here in the community! Allow me tag our guru, @Shamaine Chan-Oracle, who has the expertise in this area. Any thoughts on this one, Shamie? ? To the community, feel free to join in on the discussion.

Thanks Shamie! Hi Chad, First thing I thought of after reading your concern was to use the 3rd Party Billing fields in the customer record. However, this is limited to only one 3rd Party Billing Account Number per customer. The ability to enter multiple third part account numbers on the customer record is not yet supported…

You're welcome, Asher! ? ====================================== If you find my previous reply to your question as helpful, others with the same question might find it helpful as well. By marking “Yes” on the “Did this answer your question?”, you’ll be able to aid the community to find the solution much easier and faster…

Hi @dle_35705, Per checking, Inventory Status for Kit/Package Items is not yet supported in the system. Maybe you are referring to the Members of the Kit/Package items? If so, then you can use the Member Item field in the Results tab of an Item Saved Search. Or are you perhaps referring to the inventory quantity of…

Hi @Kenny Wise, Glad to have you back with us today! Hope you are doing good! ? I checked my resources about your concern and I noted that customization of the Advanced Manufacturing tablet is not yet supported. There is an existing enhancement request for this functionality: Enhancement # 444334. You can vote for the…

Hi Asher, Glad to have you with us today and thank you for posting your concern here in the community! ? Upon checking my resources on this, it seems that this is not yet possible in the system. I did find an enhancement for this which you can vote for in the SuiteIdeas page: Enhancement # 213160 : Lists > Accounting >…

Hi Dallas, We very much appreciate your understanding on this and as much as I would like help you out more on this, I'm afraid I don't have any information about how other customers work with this functionality on a daily basis. Everyone has their own processes, depending on how big or small their business is. At this…

Hi Dallas, I understand your concern, but I'm afraid this is just how the demand planning in the system works. Since Demand and Supply is calculated/generated per item, then it is also how the Transfer Orders will be created. You also mentioned about the items having the same vendor/supplier. However, note that DRP…

Hi Asher, Based on the fields you mentioned, it seems like you are importing inventory adjustment. I tried the same on my test account using the information you provided and I also encountered an error: "The total inventory detail quantity must be XX." For serialized items, I think that we have to import them 1 line at a…

Hi @farrago, Glad to have you with us today and thank you for posting your concern here in the community! ? Allow me to tag our experts on this topic, @Jack Daryl O Espiel-Oracle and @Pauline Joy Cac-Oracle so they can further assist you with this. To our other members who have insight on this, feel free to comment on this…

Hi Dallas, Maybe you can try changing the Lot Sizing Method of the item record to Periods of Supply? You can then set the Periods of Supply Type to either Weekly or Monthly, and the Supply Type as Transfer (for DRP). I believe we went over this in a previous thread you also created. (thread link) I tried this out on my…

Thanks Shamie! Hi @User_U78W1, From my understanding, you are looking for the appropriate field name in ODBC equivalent to UI's line item Quantity column. Upon checking your concern, I found SuiteAnswers 67653 which states that item count and quantity values are not exposed as columns in the Transactions table. I checked…

Hi @Dallas H, After further checking on your concern I noted that the ability to consolidate all Transfer Orders made from Demand Planning to one Transfer Order where To Location is the same is not yet available in the system. This is logged as Enhancement # 390899 and you can vote for it in the SuiteIdeas page. I also…

You're welcome, Chris! I'm glad that you are now able to get the results that you need! ?

Hi @dle_35705, Glad to have you with us today and thank you for posting your concern here in the community! ? Let me tag our guru with expertise on this topic, @Jeff Pineda-Oracle, so that he can work with you on this concern. To our other community members, feel free to comment your ideas or suggestions on this thread.

Hello @jmack_admin, Glad to have you with us today and thank you for posting your concern here in the community! ? I have already coordinated your concern to our gurus who specialize on this topic, @Pauline Joy Cac-Oracle and @Jack Daryl O Espiel-Oracle and they will get back to you for any updates or if additional…

Hi @User_KVW5F, Welcome to the community! ? Glad to have you with us today and thank you for posting your concern here! I have already coordinated your concern to our guru who specialize on this topic, @Shamaine Chan-Oracle and she will get back to you for any updates or if additional information is needed. In the…

Hi Chris, Thank you for clarifying the needed results. To achieve this, you can use a Formula (Currency) field instead with the formula:{inventorydetail.quantity}*{rate} then just set the custom label to Amount. Let me know if this works for you. ? ====================================== If you find this reply to your…

Hi @PaulFleetwood, Thank you for posting your concern in our community! I have already coordinated this with gurus who specialize in Workflows, @Jack Daryl O Espiel-Oracle and @Pauline Joy Cac-Oracle. Please allow them some time to check on this and they will get back to you for updates or if any additional information is…