1,445
Dear All,
I receive quantity at store i.e. 200 units of an item , when headquarter synchronize the store, it triplicate the quantity at headquarter i.e. 600
update me
Regards,
Shahid Ghafoor
*This post is locked for comments
I believe u need to run the SQL profiler while the 401 being executed so that u can identify who is inserting into the ITL table
Yes Dear, Customization done in a way that we calculate the landed cost and allocate it to the item for correct per unit cost of the items including invoice cost.
In this custom application we just calculate the per unit cost and just hit the PurchaseOrder,PurchaseOrderEntry table with received status.
but commit the Purchase order through application (RMS 2.0) ; and
TableSync on HQ is empty at this time
Regards,
Shahid Ghafoor
Is there any customization done on this database? like triggers created on the ITL table? or for example entries in the TableSync table?
select count(*) from item=10064
select count(*) from itemdynamic=201274
select count(*) from store=20
Actually , Now a day problem is that I received a purchase order of 500 units of an item, it correctly update the store quantity as well as Inventory transfer log table.
As, Store client communicate the Headquarter, it triplicate the quantity on both store and Headquarter,.
After this check the inventorytransferlog table, there are three entries with the same PO Number, referenceID of one PO is correct and others PO reference ID's are zero,
Then I check the inventory transfer movement report, in which report show that one movement is made through "PO/Inventory Transfer" and others are "Unknown", and the same case is in the HQ.
In both the place inventory movement history report show the three entries with same PO number and two of them are "unknown"
Still a big problem! why after the synchronization of client-server, entries and quantity triplicate
Regards,
Shahid Ghafoor
where does it triplicate the qty? in which report or screen? can u run the following queries and post the results?
select count(*) from item
select count(*) from itemdynamic
select count(*) from store
Dear, Actually, one Client is is wrongly configured with Headquarter Database rather than store database. When it synchronize with HQ Database, it effect the first store only(Mean Store ID is 1 in HQ) , and Now the client the correctly configured with Store database. but when we create PO from first store , then data triplicate and other stores are working fine.
Make sure you are running only one copy of HQClient for that store. If there are more than one computers making the connection, they will all connect on the same schedule and create multiple copies of the same order or entries in that order.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (