Re: [MS_AccessPros] Making single entry for bulk consignment same Product Name having same weights of Cartons

 

Hello Khalid,

I am not trying to butt into your conversation with John, but we used to have a similar problem with our products.

Our solution was to have several different units of measure.  For example, we would have an Inventory U/M, a Purchasing U/M and a Selling U/M.

While we may stock items as each, we may purchase them in hundreds or thousands of units.

As an example, we used to purchase steel in hundred weight (CW) but inventory it in (lb).  The program knew the conversion factory between the two units of measure.  So it would receive 1 CW and put 100 lb in inventory.

I believe I understand though that you may have a different problem in that different suppliers may be sending you the same product in different units of measure.  This could certainly be handled in a similar way.

The difference in this method vs the one John was recommending is that this method keeps the inventory part numbers the same, while John is accomplishing this by using different part numbers.  Either solution will work.

Thanks,
Jack

__._,_.___

---

Posted by: jack@shiftsst.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (10)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___