Hi @"Peter Bergsma", Glad to have you today! Just to verify, are you pertaining to the Order Items page? (Transactions > Inventory > Order Items). Or are you referring to a specific report? If this is a specific report, kindly post a screenshot of the said report so that I could check on my end. If what you are pertaining…

Hi @"hunter" We're on it! Let me test this one out for you. Can you send by the way the following so that I can replicate the same parameters on my test account: * Criteria tab of the Saved Search * Results tab of the Saved Search Cheers! @"Herdi Rana-Oracle"

Hi @"bennyeos"! We're on it! Let me check and research on this one on my end. We'll update this thread on our findings Cheers! @"Herdi Rana-Oracle"

Hi @"4275646", Glad to have you int he community! Can you send a screenshot of the following so that we can check the parameters set in your saved search? * Criteria tab of the Saved Search * Results tab of the Saved Search * The Results of the Saved Search after hitting Save and Run (remember to mask/hide confidential…

Hi @"HDefriedman", Glad to have you today! Can you send a screenshot of the report you are trying to customize (remember to hide confidential information)? * Click on the customize button * Kindly take a screenshot of the Edit columns and the Filter tabs of the Report builder page Allow me to endorse this thread to our…

Glad it worked! Regards, @"Herdi Rana-Oracle"

Oh, so basically, if the PO line item is not associated to any Inbound Shipment, it should return 0 and not null right? I think this can be done through NVL expression. Try this: NVL({quantityonshipments},0) This formula would return the value of 0 if the Quantity on Shipments column is null. If you are going to…

You are correct. With regards to the Quantity on Shipments, it only pulls out the quantities in the inbound shipments, regardless of the status (either received or in transit) This is another enhancement, as logged under 557317 Inbound Shipment > Receive > Quantity on shipment column should show as 0 on PO after receipt,…

That's good! Let me know if it worked after your testing Regards, @"Herdi Rana-Oracle"

You are correct. In the AM scanner, there are no Shipping function in LPN (or even in the Shipping action) that allows users to scan/use the LPN ID in the Shipping Process. It seems that the LPN function in the AM Scanner focuses more on the Production side. I tried to check if the Ship load function uses the LPN ID. But…

@"Aaron Pelz", just to verify, you would like to expose the Quantities included in the Inbound Shipments for your Purchase Orders? Am I correct? You are right that exposing the Quantity in Transit (External) in reports is still an enhancement: 504022 Reports > Inventory/Items > Current Inventory Snapshot > Customize > Edit…

Hi @"nathanatwesspur", Based on my undeerstanding, you would like to know if it is possible to source/refer another item for the calculation of the preferred stock level calculations (if Replenishment Method is Reorder Point). In other words, just like an Alternate Source for the values to be used in the calculation…

These are the facts that I have gathered through my sources. I have tried a run down on the LPN actions in the scanner. One point that we must consider is that Advanced Manufacturing module focuses more on production. LPN in Advanced Manufacturing provides a set functionalities to create production record for lot…

LPN action provides a set functionalities to create production record for lot controlled items, move items from one bin to another bin and merge multiple LPNs I have tried the Pick LPN function in the AM Scanner. Based on my testing, this functionality would need the following: * LPN record (which is created through Create…

Hi @"javiermagana", That's what I'm currently testing as well! Let me to verify my sources on my end for this one and I'll be updating this thread on my findings Regards, @"Herdi Rana-Oracle"

Hi @"Martha Hakes", There are no reported issue yet in the status.netsuite.com as of the moment. Nonetheless, I recommend that you file a support case for this so that they can investigate the matter thoroughly. For the meantime, you may try the following: * Clear browsers' cache * Use other browsers * Use the Standard…

Hi @"farrago", Just to verify, you are setting this transaction saved search to Type: Item Fulfillment, am I correct? The goal here is to compare the Date Created and the Date the said Item Fulfillment is marked as Shipped. I think this can be done by sourcing the System Information fields in the saved search. Can you try…

You are correct, if you have multiple lots but only one line item, you would need to enter/scan these lots separately to assign the actual quantities to be picked. With regards to the assignment of the carton, by core functionality, this can only be done in the picking side. Meaning, by standard design, the carton can only…

Thanks for sharing @"CDuf"! It will be helpful for other users Regards, @"Herdi Rana-Oracle"

Based on my understanding, you would like to know if it is possible to have a Ship All functionality on WMS. Basically, the Transfer All core behavior in WMS is available if the item being transferred. This would allow users to transfer all Lot Numbers from one location to another instead of entering the quantities. This…

Glad to be of help @"ScandyAndy" ! Cheers! @"Herdi Rana-Oracle"

Thanks for clarifying @"ScandyAndy" Upon the mapping of the CSV import, can you see the Matrix Option - Item Condition from the NetSuite Fields pane? If yes, can you map that against the Item Condition column instead of the original mapping you shared to me in this thread: Since on my end, for my Matrix Options, the one…

Hi @"paula.courtemanche", Just to verify my understanding, you noted that in your Item Receipt, there is a change in the GL Account of the GL impact am I correct? So basically, for example, before it is Debit to Inventory, but it has been changed to Debit Expense. May I know if the involved item in the Item Receipt has…

Hi @"4180980", You would like to conduct a csv importation to update the Customer/Lead Record right? Basically updating customer's Price Level as indicated in the Financial tab: You can conduct csv importation to update these records. Note however, that since Customer and Lead are two different record type, you would need…

Hello @"Tybrneryan"! This is interesting. Let me check this one on my end and I'll provide updates on my findings Regards, @"Herdi Rana-Oracle"

Hi @"jenluna" You are correct that Landed cost can only be tracked for Inventory Items within the system. We use the Landed Costs feature to track the expenses you incur when purchasing your inventory. Landed costs provide the ability to increase the asset value of inventory by capitalizing additional expenses associated…

Hi @"4270648", Based on my understanding, you would like to know if it is possible to convert an Assembly item to Item group (and vice versa). This is to cater your business model wherein the said item can be sold either assembled or can be sold in a component level instead. The system supports conversion of non-inventory…

Hi @"kelvin2oo9", This is an interesting question. Let me endorse this thread to our Guru who can give you an insight as to this behavior Regards, @"Herdi Rana-Oracle"

Hi @"Sophie Sk", Thanks for the details you shared! This will be helpful for our Gurus to test further in your query I will be endorsing this thread to our Guru who can provide you their inputs Regards, @"Herdi Rana-Oracle"

Hi @"RedWing_37086", Based on the error, it seems that it is looking for the phone number in the shipping address. You mentioned that the Ship to addresses are correct and complete, may I also verify if the Phone Numbers are populated as well? I think I encountered a similar case wherein this particular behavior is…