le choc des titans Index du Forum
 
 
 
le choc des titans Index du ForumFAQRechercherS’enregistrerConnexion

Problems with Headquarters Quantities After Performing

 
Poster un nouveau sujet   Répondre au sujet    le choc des titans Index du Forum -> le choc des titans -> Quartier general
Sujet précédent :: Sujet suivant  
Auteur Message
robinsenny


Hors ligne

Inscrit le: 04 Juil 2018
Messages: 1
Localisation: ADGER

MessagePosté le: Sam 7 Juil - 12:10 (2018)    Sujet du message: Problems with Headquarters Quantities After Performing Répondre en citant

Hi,


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.


Please help. 


I didn't find the right solution from the Internet. 


References:- 
https://community.dynamics.com/rms/f/106/t/66088
Creative video production studio


Thanks!


Revenir en haut
Publicité






MessagePosté le: Sam 7 Juil - 12:10 (2018)    Sujet du message: Publicité

PublicitéSupprimer les publicités ?
Revenir en haut
Montrer les messages depuis:   
Poster un nouveau sujet   Répondre au sujet    le choc des titans Index du Forum -> le choc des titans -> Quartier general Toutes les heures sont au format GMT + 2 Heures
Page 1 sur 1

 
Sauter vers:  

Index | Panneau d’administration | Creer un forum | Forum gratuit d’entraide | Annuaire des forums gratuits | Signaler une violation | Conditions générales d'utilisation
Template lost-kingdom_Tolede created by larme d'ange
Powered by phpBB © 2001, 2005 phpBB Group
Traduction par : phpBB-fr.com