1. Home
  2. Point-Of-Sale Software
  3. Reprint or export multiple transactions

Reprint or export multiple transactions

Last week our government ordered all wholesalers in our country to deliver them a digital copy of all transactions made with restaurants over the last 5 years due tax collection issues. One of our customers is using RMS for their wholesale company and so they need this digital copy.

I tried to find an easy way to export transactions of specific (restaurant) customers to a pdf or something similar but with no result. Does anybody has an idea to do this?

Maybe with an SQL query? It will need an ?Account #? filter and a ?Date? filter to do the job. The export can be a bmp, jpg, pdf or something similar. Someone who can help me out with this? Thanks in advance, Justin Janson

Reply to
Justin Janson
Loading thread data ...

hi Justin, go to Reports > Sales > and Detailed Sales or Detailed Sales Tax and a more sales tax analysis report. Export to HTML or CSV format or you can use the PRINTER as PDF to send this in deigial format. remember you said one of your customers is using the RMS so you not look at customer wise reporting, however the store wide reporting.

If not help this let me know or describe > Last week our government ordered all wholesalers in our country to deliver

Reply to
Akber Alwani

Hi Akber,

Thanks for your reply. I do understand the way to manually export one transactions from the report generator and/or export the 'overview' of transactions to a PDF this way. That is not the problem. The real problem is that I need a copy of each actually transaction (stored as a BMP in the MSSQL database) for about 100 different customers over the last five years. We are talking about more than

10.000 transactions. That's impossible to do manual. If I can use a SQL query to somehow get the stored BMP's out of the database it would be a day work and we are done.

The only filter I need for that is the account number field and date field.

Any ideas?

Thanks, Just> hi Justin,

Reply to
Justin Janson

What country do you live in?! I want to remember to not do business there with a ridiculous query like this coming from the authorities!

Anyway, this will not be soemthing you can accomplish using SQL. The stored images of the receipts need to be viewed using the journal viewer I think.

You might want to plead with them to just provide reports. Getting line-item level detail from the database should be easy.

Reply to
Jason

Haha... The country, or better, island is Curaçao. Ever heard of it? Just next to Aruba. I'm not surprised about this kind of requests... you don't want to know what else they do. But it's a nice place to live, dispite the weirdos who come up with this kind of things.

Fortunally they accepted the reports and not only the original 'copy'. So they are doing it no with the line-item level details. It's enough for them... thank god.

Anyway, thanks for your response!

K> What country do you live in?! I want to remember to not do business there

Reply to
Justin Janson

I operate just a few islands up... We get the same kinds of ridiculous requests, but we can usually provide a report and they can spot check for accuracy if they want. Usually the response is voluntary, but basically required because they will target you if you don't comply.

You have to take the bad with the good. Burdonsome government, but few lawyers.

Reply to
Jason

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.