I want to be able to Run a SQL command that allow to see my Cash Drop Amount and Drop Numbers to export from SQL or Database
SELECT * from DropPayout
Displays the amounts but cant find Drop Number or Transaction Number for them as from POS prints
*This post is locked for comments
Drops and Payouts are not recorded like a regular transaction.
They get recorded to a particular Batch.
So if you need more information you can join the select to the batch table like this.
SELECT TOP 1000 droppayout.[ID]
,droppayout.[StoreID]
,droppayout.[BatchNumber]
,[Time]
,CashierID
,droppayout.[Amount]
,Comment
,Recipient
,ReasonCodeID
,batch.OpeningTime
, batch.ClosingTime
,batch.RegisterID
, tenderentry.[Description]
,Cashier.Name
FROM [dbo].[DropPayout]
Left Join dbo.batch On batch.BatchNumber = DropPayout.BatchNumber
Left Join dbo.TenderEntry on tenderentry.DropPayoutID = droppayout.id
Left Join dbo.Cashier on cashier.ID = DropPayout .CashierID
The dropPayout.ID is the DROP# on the receipt. There is not a Transaction Number
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,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (