You’re offline. This is a read only version of the page.
One of our clients is having a problem in HQ with the Detail Sales Report. When they run the Detail Sales Report 1 of the Stores in right one the money and the other store show around 900.00 more sales than what the store shows at the store level. I looked into the Transaction table in HQ and it is correct but when I looked into the TransactionEntry Table in HQ there are extra item list on this table under certain Transaction numbers. Has anyone ever experience this and do you know how to correct it?
*This post is locked for comments
Thanks Spencer I will start the procedure tonight and catch up on the HQ in the next couple of days.
Sorry, haven't come up with an easy solution so far. The best I can think of would be to use a while loop with a couple of incrementing variables to assign new transaction numbers to those entries in the transaction and transactionentry tables that exist in HQ but not in Store Ops, but I'm having trouble wrapping my head around it.
Also, just a heads up, there's probably a similar situation going on with the PurchaseOrder and PurchaseOrderEntry tables. You'll likely start seeing random items showing up in transfers and purchase orders in HQ.
Well, for future transactions, you can do a "Select max(transactionnumber) from [transaction] where storeid = '{the affected store's id}'" to get the highest transaction number for that store in the HQ database, then go to Store Ops Admin and use the Set Next Transaction Number function under the database drop down to set it to one higher than that number.
This won't fix the existing incorrect data, though. Let me think on it for a bit and I'll see if I can come up with a way of fixing whats already done while preserving all of the data.
Is there a fix for this or am I better off going into HQ delete the extra items and re-set the store with the database from HQ?
Did you restore the store database from a backup? Most of the times I've seen this happen it turns out to be due to transaction numbers being reused after a store backup was restored.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (