Share
ReportIs there any report or way to create a report that would show all 'HOLD TRANSACTIONS' from SO or HQ? If not can it be done by SQL query?
*This post is locked for comments
You’re offline. This is a read only version of the page.
620
Is there any report or way to create a report that would show all 'HOLD TRANSACTIONS' from SO or HQ? If not can it be done by SQL query?
*This post is locked for comments
Mabuhay! We use this script.
SELECT TransactionHold.StoreID, TransactionHold.HoldComment, TransactionHold.TransactionTime, TransactionHold.BatchNumber,
[Transaction].TransactionNumber, [Transaction].[Time], [Transaction].CashierID, [Transaction].Total, TransactionHold.TransactionType,
TransactionHold.ID, TransactionHold.DBTimeStamp
FROM TransactionHold CROSS JOIN
[Transaction]
WHERE (TransactionHold.TransactionTime > CONVERT(DATETIME, '2013-01-01 00:00:00', 102))
but the problem is the comment is the same as all transaction. And I notice that it shows on query all the trasanction from ID 1 to last.
Thanks,
I am trying to remove Transactions using worksheets would I be able too use this query to accomplish this?
Delete FROM TransactionHoldEntry where TransactionHoldID = 635
Hey Jeff the drop box link not accessible. Can you post to a different url? Thanks
Here's one for Store Ops, I'll have to modify it for HQ;
dl.dropbox.com/.../Custom%20-%20Orders%20-%20On%20Hold%20Transactions.qrp
I tried it on HQ as well with 0 rows and no errors. Any Ideas what I might change to get company wide results instead of having to connect to each db? Thanks
SELECT * FROM TransactionHoldEntry
where transactiontime >='2000-01-01'
and transactiontime <'2012-09-01'
Thanks for the reply. I have an error" An error occurred while executing query:
Ambiguous column name 'transactiontime'."
I believe it can't be done in HQ, but for the SO, try the following query: -
SELECT the.*,transactiontime FROM TransactionHold th
inner join TransactionHoldEntry the on th.id=the.transactionholdid
where transactiontime >='2000-01-01'
and transactiontime <'2012-09-01'
A Hassan
RMS Leaders
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
