We have a single transaction that was not uploaded to HQ from one of our stores. All the other transactions from that day were uploaded. Is there a way to re -upload transactions from that day?
*This post is locked for comments
then re sync your store, issue worksheet 401, after sync check detailed sales report. thanks.
here... just copy, paste and execute the query below to your store database where you want to re upload sales. Just do not forget to change the date range.
declare @fromdate as date
declare @todate as date
set @fromdate = '2016-11-01' --- date format must be in year-monthnumber-day
set @todate = '2016-11-02' --- date format must be in year-monthnumber-day
update [Transaction] set StoreID = StoreID
where CAST([Time] as DATE) >= @fromdate and CAST([Time] as DATE) <= @todate
update transactionentry
set StoreID = StoreID
FROM transactionentry te
inner join [Transaction] t on t.TransactionNumber = te.TransactionNumber
where CAST(t.[time] as DATE) >= @fromdate and CAST(t.[time] as DATE) <= @todate
update Batch
set StoreID = StoreID
FROM Batch b
inner join [Transaction] t on b.BatchNumber = t.BatchNumber
where CAST(t.[time] as DATE) >= @fromdate and CAST(t.[time] as DATE) <= @todate
Hi there.
Can You update that transaction with SQL maybe? Just update the comment for example, some field that is not important that much? Another option, return the transaction with F11 and do another sale equal, but do it in the same Batch, so it will not affect the Z read.
In both cases, after that, send a 401/402 worksheets for that store, with date previous to the original sale...
Hope this helps, A.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
