Kitin Basilla Red Ribbon

Hi @Ivy Lopez-Oracle , That worked. Right now the report is only looking at backordered quantities. What is the best way to tweak this formula to also include committed but unfullfilled items: {quantity}-COALESCE({quantitycommitted},0)-{quantitybilled} And one more thing, if using Advanced Item Location feature, what is…

Hi @Joy Noreen Magoling-Oracle That seems to have worked. What I find odd though as per random checking these Invoices have no related Credit Memo.

Hi Ivy, Thank you for checking in. I forgot to mention that we are using Advanced BOM, so the Item: Member Item and Item: Member Qty didn't really produce any values. I tried to look for the component fields in the following tables: BOM and BOM Revision but to no avail.

Apologies for the late revert. It is a transaction saved search with the following criteria: Results tab Here is an invoice were the results shows negative but the UI is positive Once again, the image below is from the saved search result.

We found out this document The documentation you're reviewing is applicable only for the Legacy Data Source, where in this case, the Supply Required by Date should be listed as date_requested. If you're using NetSuite2.com Data Source, then the Field should be listed as requesteddate.

Hi Nicole, Thank you for the response, let me check again.

Here are the details of the Saved Search. Criteria Tab: Type is Purchase Order Main Line is False (Document Number ID starts with P or Document Number/ID Starts with M) Criteria Summary Sum Formula Numeric is 0 case when {custcol_po_approve_line}='Yes' then 0 else 1 end Results Document Number Summary type: Group Item:…

Hi Ely, See screenshots above, checkbox is a custom field.

Hi Joy, Please see screenshots below: SS Criteria SS CRITERIA SUMMARY - in an attempt to say filter based on summary values SS Custom Field

Hi @Dominica Sevilla-Oracle , I am not looking for the item price (selling). I am looking for the item cost (purchase price) specific to the lot number that is on the invoice,

Hi Joy, In response to your questions: Is this reproducible with new Sales Order? - YES, there are a number of new sales order Is the scenario true to specific orders only or to all orders? - Specific orders but there doesn't seem to be any logic of sort that could be defined like, only sales orders entered via UI or only…

One of the components actually has zero components. Does it matter that the wave is created via a schedule? I tried creating a manual wave and was not able to see the sales order that had a missing (no on hand qty) kit component. But that instance I asked about, the wave was created via a schedule.

Hi @Dominica Sevilla-Oracle You're awesome. That solved the visibility issue. However I did come across an error that may have resulted for enabling the Allow Cross Subsidiary viewing permission. When navigating to Billing - Billing Operation - Process Billing Operation - Status an error screen pops up Error An unexpected…