How to compute Over short amount that shows in the z report

Hello HNLuhar....I copied and pasted this from the batch list report.....it reads the batch table to calculate "over/short"- hope this helps.....

PaidOut + Dropped + LayawayClosed + PaidOnAccount + CustomerDepositRedeemed

• Clos> Hello, can anyone tell me how the over short amount in the z report is

Wow. That is exactly what I was looking for. One more thing and I can use SQL to get the information from the Z report - I need the closing amounts by tender type. Any ideas?

Jason - I've gathered the tendertotals table tracks (by batch) open, shift and closing amounts - - see if this is what you are looking for - - replace the X with the batchnumber you are interested in - - hope this helps.....

select tt.batchnumber, t.descripti> Wow. That is exactly what I was looking for. One more thing and I can use