@Ivy Lopez-Oracle - I spent time on this over the weekend and still cannot get the results desired. This is a big miss for the F & B customers.. Enhancement 74661: Lot Tracking - We need a report that displays Lot Numbers and the Current On HAnd Count for that number on a specified past date. Enhancement 133646:…

@Ivy Lopez-Oracle I find odd that NS has a Food and Bev vertical and for audit purposes NS cannot provide a report of inventory On Hand with Lot Numbers for a specific date. Other than scheduling reports to run end of day on the last day of the month, it is a big miss! The search that you provided give me a total number…

@Ivy Lopez-Oracle What is the location set in the order? yes there is only 1 location Is the location also included in the supply plan? yes there is only 1 location Is the replenishment method of the item in the order set to MRP or MPS? It is MPS TY for your response, I will log a support case.

@Joy Noreen Magoling-Oracle - this should be added to SuiteAnswers

@John Griffin TY sir, I will try this!

@Ivy Lopez-Oracle I have this Assembly item set up for the fixed lead time of 24 Days. Demand is SO driven. I have an SO with exp ship date of 9/1/22. A WO was created with backward scheduling for a 9/1/22 completion. The production Star date is calculating 8/31/22. Regardless of the WO Leadtime MRP runs and appears to be…

@Ivy Lopez-Oracle - I will update this before end of day, I was out of office. TY for the reminder.

@John Griffin - Thanks for this! I am looking to replicate the BOM inquiry with inventory info, aka on hand, available, etc... Looks like it might not be doable.

If an order is partially Fulfilled, can you set the remainder of the order to ship complete? Will NS ship the B/O's complete? My testing got mixed results, I am interested to understand what NS functionality around this.

@Ivy Lopez-Oracle What work arounds does NS suggest? This is the 2nd customer that NS sales was told the customer you can ship international with NS UPS integration, but appears not to be true.

@Jack Daryl Espiel-Oracle - I did see this SAID, but the requirement is to create an approval workflow off of the ECO Type. Given the industry of the user, the Approval goes to different teams based on the ECO types we defined. Is this doable for ECO's?

@Michelle Jabanes-Oracle I am not understanding how this would work with an order for product and a purchase of Gift Certificate. That would mean all transaction forms would need to be custom transaction forms?

@Michelle Jabanes-Oracle - Is there a SAID for your above mentioned solution? I am trying to visualize it.

@Michelle Jabanes-Oracle Your above mentioned comment does not make sense since regarding NON Web store orders when the following defect states; Enhancement # 196320 Gift Certificates > Recipient E-mail > Ability to Customize E-mail Sent to Recipients when Transaction is Created via NetSuite UI (Non-Web Store). Per…

@Joy Noreen Magoling-Oracle - OK I just found the issue. The Box(25) in the table was pointing at the box(6) in the "abbreviation" column. Once I updated it to BX(25) all is good. The purchase price and the last purchase price are looking at the "Abbreviation" field value apparently. I have never had that happen in the 9…

HI @Joy Noreen Magoling-Oracle Yes you are correct, I would expected the Boxes(25) UOM to update on this record. Thanks

@Michelle Jabanes-Oracle .@Joy Noreen Magoling-Oracle I also have a question around this topic. Is there a way to use a workflow to generate the automate emails that are being sent when Gift Cards are purchased? I need to be able to match company branding on the emails sent out of NS and from what I am seeing in this post…

@Joy Noreen Magoling-Oracle Here are the Items UOM fields Here is the AVG Cost, Purchase Price, and Last Purchase Price Details from the Purchaing/Inv tab The following is the related records, the highlighted transactions, are the ONLY ones that wend out with the BCX6 purchase UOM. The second PO had the correct Purchase…

@Micah Timbol-Oracle - Sorry for the delay, I was on PTO. I will confirm what I get during testing on this in a few weeks around creating a deposit of over 1000 lines.

@Ivy Lopez-Oracle Transactions --> Bank --> Make Deposit. Thanks

@Ivy Lopez-Oracle I got this sorted out over the weekend. The issues was between the BOM Record and Assembly items record sub list on the Manufacturing tab of the Assembly record. The locations did not match between the 2 records and thus causing it NOT to get fully processed when you ran the Standard Costing steps. Once I…

Update - Now that the "Cost Engine" ran over night the item record surface the Supply Type field, inventory items are good. I am still NOT able Inventory adjust an assembly item into Inventory as the still thinks Std Cost has NOT been run yet.

The Advanced item location is not and has not been enabled. Demand Planning was turned ON and then later turned off, but that was for a very short time .

There is a value calculated in the Costed BOM inquiry, BUT NS will not allow me to inventory adjust in any items as it does not think a StD Cost record has been created.

I did as you suggested with no luck. :(

It is not showing there. What other features besides Standard Costing has to be enabled. Does Demand Planning? That is when that field shows up in the account.

@Shamaine Chan-Oracle The SO is pending fulfillment and NO billed transactions against the SO.

@Shamaine Chan-Oracle I built the schedule like you said and when I test it the order has 3 lines in the schedule and I am now not seeing the Bill buttons.

I am still not under standing why there is a PO variance when the items were recevd complete. I will likely need to log a case with Support

Yes this was helpful, TY