Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Supplier Inventory levels in WebERP
04-15-2014, 06:08 AM,
#1
Supplier Inventory levels in WebERP
We have a need to be able to track and sell inventory for our some of suppliers. We have the following requirements:
1) Track Supplier Qty at each Location in the system (Create additional locations as needed)
2) Do not see this inventory in our G/L or Inventory Valuation Reports
3) Give each supplier ability to maintain Qty at each Location only for their Inventory
4) Have the ability to own some inventory of the Supplier's (In our Valuation and G/L) and also just see what they have that we don't own (See total Qty available to sell)
I was going to code the following changes and was wondering if people had feedback and or enhancements they would like to offer.
- Create a new table for Supplier Inventory (supplierstock) levels (Key Stock ID and Vendor ID) - and possibly also Supplier UOM, Their Part/Description copied from purchdata or linked to this table for display
- Modify PurchData.php to create supplierstock table in the background if it doesn't already exist, delete it is last purchdata record is removed for Stockid, Supplier ID
- Create a new table supplierstockloc (Key stock ID, Supplier ID, LocID) to hold the actual Qty
- New script accessible by Supplier when logged in for adding, updating and deleting supplierstockloc table
- New report script to show these Supplier Stock Levels (and include our own Inventory levels if selected)

Thoughts or feedback?

Thanks,
Andrew
Reply


Messages In This Thread
Supplier Inventory levels in WebERP - by agaluski - 04-15-2014, 06:08 AM
RE: Supplier Inventory levels in WebERP - by phil - 04-22-2014, 05:39 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)