Articles tagged #INVENTORY
Articles tagged
#INVENTORY
Resolve Revalue Standard Cost Error: "Invalid Item Reference key XXXX for subsidiary X"
Lists>Accounting>Revalue Standard Cost Inventory-- Result:Failed: Invalid Item Reference key XXXX for subsidiary X
CSV Import on Inventory Adjustment Throws an Error: "You cannot create an inventory detail for this item"
When importing a CSV File to create or update anInventory Adjustmentrecord, an error: "You cannot create an inventory detail for this item" can be encountered when the item you are importing is not aSerial/Lot Numbered Itemor does not use bins.
Display Items with Negative Stock (Quantity On Hand) and Send Monthly Email Alert
The user needs to set up a report/search that gets emailed once per month which displays all of the stock negatives at that time.
Item Settings and Stock Levels for Multi-Locations
After you distribute existing unallocated inventory or when you enter new item records, you can configure item settings per location. On item records, you can set a preferred location, reorder point, and preferred stock level. You can also view quantities or inventory levels.
Non-Inventory Item: Generate Accruals
Non Inventory Items > Generate Accruals = T > Item Receipt has no GL ImpactItem settings at the time the Purchase Order line iscreatedis the basis of whether accruals will be generated or not.Item receipt shows no GL Impact even if Generate Accruals is set to True on the item record.Note:In order for the new setting to take effect, the Purchase Order item line should be created from scratch. As such, making a copy of a Purchase Order that was created before Generate Accruals was enabled will still inherit the old settings. The old settings will also remain if you make a copy of an old Purchase Order, use Copy Previous button to make the new line, and save the Purchase Order.
Permission to Access Review Negative Inventory Page
Scenario :
Solution :
- Navigate toSetup>Users/Roles>Manage Roles
- Custom Role: ClickEdit
- ClickPermissions
- ClickLists
- Permission:SelectItems
- Level:Select at leastViewlevel
- ClickAdd
- ClickSave
Review Inventory Activity
If you use NetSuite OneWorld, this task opens a customizable version of the Inventory Activity Detail report. This report provides a view of specific inventory values. The report details are based on the item level total inventory value in a specific subsidiary context.
Review Inventory Cost Accounting
When closing a period, you must run the costing accounting process for the period close. To complete this task, ensure that there are no costing items to be corrected and that inventory costing calculations are not already currently running.
Reviewing Negative Inventory
You can identify any negative inventory values that can be corrected by adjusting them to be positive. This process does not create a physical count. A physical count should already be completed before you begin this task.
Quantity Available on Purchasing/Inventory tab is Less than Inventory Detail tab
When the quantity available onPurchasing/Inventorytab is less then the quantity available on theInventory Detailtab.
Inventory Cost Revaluation Has GL Impact To Inventory Account
An Inventory Cost Revaluation sets the standard cost of an item. This process identifies which cost and cost category will be used on transactions for this item as of the effective date. After the revaluation is performed, transactions entered use the newly established standard cost for items.
Inventory Adjustment > Click Inventory Detail > Enter Inventory Detail > The Total Inventory Detail must Be NaN
With Advanced Bin/Numbered Inventory Management enabled, create an Inventory Adjustment for an Inventory with Inventory Detail.
Saved Search on Inventory Count of Lot Numbered Items to Show the Inventory Numbers and Quantities on Snapshot Detail and Count Detail
Scenario
Solution
- Navigate toLists>Search>Saved Searches>New
- SelectTransaction
- Search Title:EnterTitle
- ClickResults
- ClickStandard
- Filter:
- SelectType
- SelectInventory Count
- SelectItem
- Selectnot none
- SelectStatus
- SelectInventory Count:Approved,Inventory Count:Completed/Pending Approval
- SelectItem fields...
- SelectIs Lot Number
- SelectYes
- SelectIs Lot Number
- SelectFormula(Numeric)
- Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' or {transactionlinetype} = 'Count Quantity' THEN 1 ELSE 0 END
- Formula (Numeric):Selectequal to
- Value:Enter1
- Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' or {transactionlinetype} = 'Count Quantity' THEN 1 ELSE 0 END
- SelectType
- ClickResults
- ClickColumns
- Field:
- SelectDate
- SelectDocument Number
- SelectItem
- SelectFormula(Text)
- Formula:EnterCASE WHEN {transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
- Custom Label:EnterSnapshot Lot Number
- SelectFormula(Text)
- Formula:EnterCASE WHEN{transactionlinetype} = 'Snapshot Quantity' THEN {inventorydetail.quantity} ELSE null END
- Custom Label:EnterSnapshot Quantity
- SelectFormula(Text)
- Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.inventorynumber} ELSE null END
- Custom Label:EnterCount Lot Number
- SelectFormula(Text)
- Formula:EnterCASE WHEN {transactionlinetype}='Count Quantity' THEN {inventorydetail.quantity} ELSE null END
- Custom Label:EnterCount Quantity
- ClickAdd
- ClickSave & Run
No Items Showed on Create Inventory Count Page
Scenario
This holds true even if the previous inventory count made on 12/31/2020 has already been deleted. This last inventory count date is not editable because this is based on the inventory count generated from the create inventory count page. Itis also not advisable to delete an inventory count as there may be inventory adjustments related to it.
Solution
- Navigate toTransactions>Inventory> EnterInventory Count
- Populate required fields with preferred values
- Itemstab
- SelectItemfrom the drop-down list
- ClickSave
Items associated with Bin are not showing on Inventory Count page
Itemsassociated withBinare not showing onInventory Countpage
Inventory Count Sheet Does Not Appear for Printing Supply Chain Forms
Inventory Count Sheet does not appear for printing when navigating toTransactions > Management > Print Supply Chain Forms > Inventory Count Sheet
Search Item Next Count Date
To create a report with an empty Next Count Date, please follow the following: