-
CSV import Item Receipt Kit item with lot numbered components and regular components
Is it possible to import an item receipt from a return of a kit that contains both lot numbers and regular items as components? I have tested with serialized items, and it worked fine, but is not working with the lot numbered items. I found the suite answers ID 78387 that indicates about mixing the lot numbered with…
-
Lot Number Expiration Date Calculation
Is there any way to find out the exact way that NetSuite calculates the expiration date of a lot number? Our production schedule is 24/7 at the moment and we're finding lots that were created around 1:00am Central Time with the expiration date being 1 day shorter than expected. For example, this item X has a shelf life of…
-
NSC | Viewing Inventory Stock Ledger by Lot Number
Scenario: The user wanted to view inventory stock ledger information on a per lot number basis, including quantities and values tied to specific lots. Attempts to customize the Stock Ledger report by adding the Serial/Lot Number field did not work as expected because the report displayed all associated lot numbers for the…
-
Create a show message action on Workflow
HI, I want to create a workflow and use the Show Message action to display : Ulta requires a minimum of 10 months shelf life. Scan another lot. On the item fulfillment record, when a user fulfills a lot whose expiration date is less than 10 months the error message pops up. It will only apply to the customer Ulta. We also…
-
Adjust Wrong lot in Bin using inventory Adjustment
We need to correct quantities that were stored in Bin under the wrong lot and move them to the correct lot. Following the NetSuite Community reference “NSC | Adjust Wrong Lot Number In A Bin — NetSuite Community”, we created both positive and negative lines within the same Inventory Adjustment. However, the est. unit cost…
-
Using Additional Lot/Serial Number Fields in WMS
Is it possible to record values via the WMS PO receiving process to a custom Additional Lot/Serial Number Field set up via the Lot Auto Numbering SuiteApp? I can see some new fields appear in WMS, such as Heat Code, but the custom fields we created do not appear. How do we make these fields appear so we can enter…
-
Why does Lot Numbered Items with "Lot Numbered" cost method donot create COS/COGS entries correctly?
Lot Numbered Items with "Lot Numbered" cost method do not create COS/COGS entries correctly in line with cost method of "Lot Numbered" during "item fulfilment" this is also raised on the sutireanswers too. details: 1. create item ->lot numbered 2. costing method ='Lot Numbered" 3. create 3 differenct po with different rate…
-
NSC | Expiry Date Updated on the Item Receipt Is Not Saved
Scenario: A user tries to update the expiry date on an Item Receipt, expecting the system to save the new value. However, upon saving the transaction, the expiry date reverts to the original value, and the changes do not persist. The user wants to know why this happens and how to correctly update the expiry date. Solution:…
-
NSC | Difference Between Serialized Item and Lot Numbered Item
Scenario: The user wants to know the difference between Serialized Item and Lot Numbered Item. Solution: To clarify the difference: Lot Numbered Items These track the purchase, stock, and sale of items in groups or batches by assigning a single lot number to the entire group. Each lot may have a unique cost, and the lot…
-
NSC | Purchase Order > Inventory Detail > Lot Auto Numbering popup not appearing
Scenario: The user has the Lot Auto Numbering SuiteApp installed in their NetSuite account, but the Lot Auto Numbering popup does not appear in the Inventory Detail window of a Purchase Order. Despite following the setup steps outlined in SuiteAnswers ID 100720 and SuiteAnswers ID 100706, the issue still persists.…