I'm working on migrating our manufacturing business to LSMB.
One of the raw materials we purchase is steel in bars of various shapes, and
lengths of 12, 20, 24, and 40 feet. The steel is priced and billed to us from
our vendors by either hundredweight "Cwt", hundredfoot "Cft", or
hundred-square-foot "Csf"; but we want to track inventory, bill-of-materials,
and over-the-counter casual sales by the foot.
Our existing purchasing/inventory/bill-of-material system accomplishes this by
having the following fields in the StockItem table:
- a BuyUnits text field (used for purchase orders)
- a SellUnits text field (used for inventory, bill-of-materials, and customer
invoices)
- a SellUnitsPerBuyUnit field, which is used by the stored procedures that
calculate the InventoryCost and SellPrice fields based on ItemCost,
FreightCost, and Markup.
A key item to note is that SellUnitsPerBuyUnit is a floating-point value; for
example, with steel angle 1-1/2" x 1-1/2" x 1/4" thick there are 42.74 feet per
hundredweight, so SellUnitsPerBuyUnit = 42.74.
I've read the discussion in 22.1.5 in the book, and it seems like our case
corresponds to #2, strategy (b).
-- Am I correct in understanding that I would create a part entry for the
per-foot units for selling and inventory, then create an assembly of (1)
hundredweight of steel angle which is made up of one line item of 42.74 feet of
the previous part?
-- I take it that we would, for example, receive a purchase order for 3.744 of
the hundredweight assembly, and restock the assembly quantity from negative to
zero (each p.o. or each day) so we can maintain our inventory in feet (or
square feet)?
-- Is this the most straightforward way to handle this in the current version
of LSMB?
Thanks!
--Dan Meis <dm...@jacksonlbrharvester.com>
Systems Designer
Jackson Lumber Harvester Co., Inc.
830 State Road 37
Mondovi, WI 54755
Office: +1 (715) 926-3816
Fax: +1 (715) 926-4545
VoIP: 17772459...@callcentric.com or +1 (715) 598-4477
http://www.JacksonLbrHarvester.com "Sold Around The World"
------------------------------------------------------------------------------
Minimize network downtime and maximize team effectiveness.
Reduce network management and security costs.Learn how to hire
the most talented Cisco Certified professionals. Visit the
Employer Resources Portal
http://www.cisco.com/web/learning/employer_resources/index.html
_______________________________________________
Ledger-smb-users mailing list
Ledger-smb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
