Hi @Chad C, Per checking, the ability for the sales data to roll up to the parent is still logged as enhancements: Enhancement # 64021 : Allow the ability to customize the Sales by Customer Summary report to only show Parent Customers with all job/subcustomer sales figures rolled up into the Parent Customer Enhancement #…

Hi @Kitin Basilla, You can try this Transaction Saved Search: Criteria tab: Formula used: case when {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) > 0 then 1 else 0 end Results tab: Formula used: Assembly Item Back Ordered Qty: {quantity}-nvl({quantitycommitted},0)-nvl({quantityshiprecv},0) Total Qty…

Hi @kmd_14170, You're in the right track with using Inventory Adjustments or Inventory Adjustment Worksheet. The error you're getting is usually due to entering New Qty = 0 with New Value of greater than 0. In that case, before saving the Inventory Worksheet, please make sure/review each item with New Qty = 0 that the New…

Hi @Dallas H, I just wanted to touch base and see if you had a chance to check out the previous comments. If any of them were helpful, we'd really appreciate it if you could take a moment to click "Yes" on "Did this answer the question?" This helps others with the same question find the answer quickly, and you'll earn…

Hi there @Paul Salkeld, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @User_MEMX1, Welcome to the NetSuite Support Community! We're glad to have you with us today and thanks for posting your question here. 😊 Have you tried checking the Cash Basis preference under the More Options > Additional Options of your report?

Hi @User_F6209, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @Dallas H, I agree with what @Tiru Chembeti said. You can use Item Groups to see the components at the PO level. Assembly Items are designed to be Built, or purchased as a whole Assembly. That being said, on a PO, it is standard behavior that only the Assembly Item is shown, not the components. Components of Assemblies…

Hi @Camila O, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to help you with your concern. Please allow them some time to investigate and get back to you. In the meantime, if any…

Hi @User_ZCWF3, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the…

Hi @tech work, I just wanted to touch base and see if you had a chance to check out the possible solution I provided in my previous comment. If it was helpful, we'd really appreciate it if you could take a moment to click "Yes" on "Did this answer the question?" This helps others with the same question find the answer…

Hi @User_FL4CK, I just wanted to touch base and see if you had a chance to check out the possible solution I provided in my previous comment. If it was helpful, we'd really appreciate it if you could take a moment to click "Yes" on "Did this answer the question?" This helps others with the same question find the answer…

Hi @Varonis inc., Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Elychelle Gulen-Oracle and @Dominica Sevilla-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to you. In the meantime, if any other…

Hi @Lee Ann R, Per checking, it seems that your requirement is currently a system limitation and is logged as: Enhancement # 110467: Lists > Sublist View of Records> Ability to have the paginate based on the sort that was selected in the sublist view, or be able to have more than 25 records per page You can vote for this…

Hi @Sivasubramaniam, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Patrick Fresnosa-Oracle and @Clarisa De Torres-Oracle to check this one. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any thoughts, insights, or…

Hi @Alex.S-2016, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to take a look at your question and provide you with their insights. In the meantime, if any other members have any…

Hi @US Water Systems, Inc., Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle, @Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get back to…

Hi @User_REJ14, Per checking, it seems that using Mass Update to update the reorder point of items (when MLI is turned on) is not yet possible. This is logged as Enhancement # 109179 which you can vote for in the SuiteIdeas page. However, you can still do a bulk update of the items' reorder point using CSV Import. First,…

Hello @User_REJ14, Are you using Advanced Item Location Configuration? Kindly share some screenshots please of the following so we can test it as well on our end: Location sublist on the Item Record Steps you are doing when performing the mass update

Thanks for checking and appreciate your understanding on this one, @Nickey! The only other scenario I can think of is that an Assembly Build was created for this Work Order, but was somehow "unlinked", which is why there are no Related Records appearing on the Work Order. As a last Hail Mary, can you try creating a…

Thanks for providing the screenshot, @Nickey! It may be that there was an Assembly Build that was created on 1/17/2023 which is why the status was set to Built. Then, this Assembly Build transaction might have been deleted, but the status of the Work Order did not update. You can check if there were any Assembly Build…

Hi @Nickey, This is weird, I tested on my account and the status that can be selected on the transaction is only Planned and Released. Once I created the Assembly Build record, the status is set to Built. But if that Assembly Build record is deleted, then the status goes back to Released. Anyway, can you share a screenshot…

Hi @dylanvv, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Richard James Uri-Oracle, @Nicole Mendoza-Oracle, @Jack Daryl Espiel-Oracle and @Joahnna Given Uy-Oracle to take a look at your question and provide you with their insights. Please allow them some time to investigate and get…

Hi @eleran, Thanks for reaching out to us in the NetSuite Support Community. Let me tag our gurus @Jack Daryl Espiel-Oracle,@Joahnna Given Uy-Oracle and @Kristoffer Viray-Oracle to help you with your question. Please allow them some time to investigate and get back to you. In the meantime, if any other members have any…

Hi there @User_CDQ4X, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @Nickey, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. In the meantime, if any other members have any thoughts, insights, or suggestions, we encourage them to share them with you.

Hi @Nickoletta Gounaris, Thanks for reaching out to us in the NetSuite Support Community. Our gurus are currently checking your question and we'll get back to you as soon as possible. Thanks @GauravAgrawal for sharing your insights on this! In the meantime, if any other members have any thoughts, or suggestions, we…

Try this using an Item Saved Search: Criteria tab > Standard subtab Criteria tab > Summary subtab Formula used: CASE WHEN {transaction.type} = 'Sales Order' THEN {transaction.quantity} END ABS(CASE WHEN {transaction.type} = 'Sales Order' THEN {transaction.amountunbilled} END) ABS(CASE WHEN {transaction.type} = 'Purchase…

Thanks for the update, @KNason76! Glad that your search now provides the data that you need.

Hi @tech work, You can go to Lists > Accounting > Shipping Items > New to create new Shipping Items you can use in transactions. Visit SuiteAnswers 9271: Creating Shipping Items for more information.