If you do an item search for stock unit, it's blan...
# suitescriptr
reptar
09/11/2023, 9:00 PMIf you do an item search for stock unit, it's blank for non-inventory items. I believe what I want instead is called "base unit", but I don't see that column in the records browser. Trying to do UOM conversion, which I will eventually do with N/query after getting the item data.
c
Clay Roper
09/11/2023, 9:02 PMSince non-inventory items are not inventory-tracked, there is no stock unit applicable. The base unit for an item is related to the unitstype.
r
reptar
09/11/2023, 9:04 PMFor the uom conversion, I am to convert purchase units to stock units. What is the equivalent conversion for non-inventory items?
a
alien4u
09/11/2023, 9:22 PMI’m confuse when reading what you need @reptar , not inventory items are not stocked because they are not inventory items, it makes sense there is no stock units.
Therefore, you may need a different way to account or handle those because conceptually there are no stock units.
r
reptar
09/11/2023, 9:31 PMIt's a requirements gap. The requirement is to convert to stock units.
reptar
09/11/2023, 9:32 PMI think it's probably purchase unit to consumption unit?
reptar
09/11/2023, 9:35 PMI'm doing a costed BOM.
a
alien4u
09/11/2023, 9:37 PMNo, I think this is a tricky case: aka: what the customer/requester wants is not what she/he needs.
There is no logical reason for non-inventory items being converted or calculated to stock units because those are not mean to be in stock.
https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_N2211898.html
r
reptar
09/11/2023, 9:39 PMThe use case is we buy things in 50 packs and install 5 of them into an assembly. The purchase price of the assembly needs to be converted from 50 pack to 5 units, for example.
a
alien4u
09/11/2023, 9:41 PM@reptar You are overthinking this:
• Purchase Price x BOM quantity = the end.
If this is a non-inventory item there is no added cost associated to it, no stocking cost, no warehouse cost, no nothing… unless they are using the wrong Item type for the task.
r
reptar
09/11/2023, 9:42 PMSo there's nothing to do for non-inventory items?
a
alien4u
09/11/2023, 9:42 PMThere is more to it ofcourse… 50 pack divided by how many units per pack, give you the unit purchase price, then times the BOM quantity…
r
reptar
09/11/2023, 9:43 PMBut I have to do a UOM conversion to get from 50pack to each!
reptar
09/11/2023, 9:44 PMThat's what I'm asking. What to convert to
reptar
09/11/2023, 9:44 PMsorry, new to this area and unclear requirements
a
alien4u
09/11/2023, 9:45 PMIf you purchase by packs and consume by units then it would be only that for non-inventory Items and you can skip stock units…
r
reptar
09/11/2023, 9:45 PMok, just use the conversion rate to get to base
a
alien4u
09/11/2023, 9:45 PMThis only for non-inventory items because stock units are just a middle man in this scenario..
alien4u
09/11/2023, 9:48 PMPictures this:
• You purchase X Inventory Item per Pallets/Packs.
• You break those aparte and store them by units(stock units).
• You now consume them by units or packs or what not.
In this scenario you have a three way calculation in your hands. But but, with non-inventory Items the stock units are out of the equation.
alien4u
09/11/2023, 9:52 PMIn your scenario it would be:
• Purchase Price and Purchase UOM.
• Is the consumption UOM (BOM level) different than the Purchase UOM?
• Then do your calculations accordingly.
3 Views