Buyer Control Center

lasandra-linscomb

Has anyone done a modification in FACTS 7.8 where you use the qty on hand from 2 separate warehouses to determine the qty needed to purchase in just one of those warehouses?

Situation:

Warehouse 1 is local and is the selling and stocking warehouse for all items.
Warehouse 2 is an "In Transit" warehouse for items purchased from China that the customer has to take ownership of when they leave the dock in China.
When the item arrives in Florida the customer transfers they qty from warehouse 2 to warehouse 1. Only those items that are "In Transit" are in warehouse 2.

Warehouse 1 is re-stocked from warehouse 2. Warehouse 2 is re-stocked from the Vendor. All purchases are from Warehouse 2. All Sales are from warehouse 1. This worked great prior to 7.8 where we moved the numbers around behind the scenes for the customer to decide the qty needed to purchase. In 7.8 the usage is now rolled up to the supplying warehouse and if warehouse 1 has no qty on hand the numbers presented to buy are correct.

If warehouse 1 has 5000 on hand and the warehouse 2 has zero. The system is recommending that I purchase 1500 since I have zero on hand in warehouse 2 to cover the estimate usage, without considering that I have 5000 in warehouse 1. (remember, No sales ever from warehouse 2, all sales are from warehouse 1)

Has anyone dealt with this issue in 7.8 yet? If yes, can you point me in the right direction?

Thanks,