Inscrit le: 04 Juil 2018
|Posté le: Sam 7 Juil - 12:10 (2018) Sujet du message: Problems with Headquarters Quantities After Performing
We run a business with one main store with headquarters and store ops servers and three satellite stores with store ops servers. We do all of our receiving at our main store and then send product to the satellite stores with periodic restocks. The problem I am running into is that after performing an interstore inventory transfer, while the quantities in both the sending and receiving store ops databases accurately reflect the transfer, the quantities listed as being at each store within HQ manager are thrown drastically out of wack. This occurs whether I originate an Item Transfer in the sending store's Store Ops Manager or perform the process via a worksheet 330. For example, if I have 1 of an item at the main store and move to transfer it to a satellite store that has 0 of the item, I perform the following steps:
1) Create a worksheet 330 in HQ manager, stating to transfer 1 of the item from the main store A (where 1 is present) to Store B (where 0 are present) and approve the worksheet.
2) I allow both HQ clients to connect to the HQ server and process the worksheet.
3) I log into Store Ops at Store A, open the newly downloaded item transfer, click Issue, Issue All, and Commit.
4)I log into Store Ops at Store B, open the item transfer, click Receive, Receive All, and Commit.
5) I create a Data Upload Worksheet 401, approve it, and make both HQ clients connect and process the worksheet. Now, Store Ops at Store A shows 0 of the item, as it should. Store Ops at Store B shows 1 of the item, as it should. But HQ Manager shows 2 at Store A and 1 at Store B. This result is not uniform. I've performed an identical series of actions and had HQ show as many as 4 or 8 at one or both ends of the transfer. And, of course, I can always request a full item count and perform a reconciliation for both stores, but this is a pain to do every single time, and it seems like a work around for something that should work in the first place. I've even tried setting up SQL Profiler on the Headquarters Server to see what commands the worksheets were issuing to the HQ Database, but I'm not super experienced with SQL and it was kind of overwhelming.
I know this is a pretty general problem, but any help on this matter would be hugely appreciated.
I didn't find the right solution from the Internet.
Creative video production studio