Deleting cash transaction

V5 Question
1

Hello Guys
We are looking to delete all cash transaction

It is still showing in reports, we dont want to change the report as we might take cash again after the trial period.

What is he best way to do this? slq changes or we can do this via the manage administrator frontend

Also what sql studio should we us for version 5 on 32 bit windows 10

Thank you
Savyn

2

Clear database transaction in database tools clears the sales history after you have built and tested your setup.

3

I think hs asking for JUST cash…

Its not going to be possible, its an all o nothing situation, it’ll mess with your database table by clearing just cash transactions.

4

Hello

Thank you

i only want void or cash transaction not to show in work period report.

if i can change the report to not calculate cash and void, that will solve all the order we get dumped or cash order which we allocate separate as we use this money as running expense.

any idea how can do this

thanks
savyn

5

Im not an accountant but just because you use the cash for expences wound not usually mean you do not declair it on your reports…

6

Hi JTRTech

We do declare but with the bureaucratic accountancy rule in Spain we asked to right everything separately. The work period is good for general but I need to split all. Also when there is lost of void they likely to raise questions and we our nature of take away lost of order and cancel, void etc.

An example we cannot but milk.from Mercado as the receipt is not accepted. Thus we use cash as petty cash.

Hope make sense and I can rewrite the report one for cash, one for CC and removing void from displaying.

I cannot see which field expression to use.

Many thanks

Savyn