Abacre and Excel

General discussions about Abacre Restaurant Point of Sale
Post Reply
tomtom
Posts: 2
Joined: Mon Aug 06, 2007 8:41 am

Abacre and Excel

Post by tomtom » Mon Aug 06, 2007 9:14 am

Hi,

I have just tried abacre restaurant POS for a few days and I am willing to continue with it but I have a question:

I need to create an excel sheet that will get some info (the sales of a given department day by day) from the database every month, to generate what I have to give to the revenue department every moth and that I am now doing by hand... is that possible?

If yes, how do I create the link between excel and the database?

Abacre
Site Admin
Posts: 1198
Joined: Mon Jan 31, 2005 5:32 pm
Contact:

Re: Abacre and Excel

Post by Abacre » Mon Aug 06, 2007 11:04 am

You can use, for example, Sales by Category (department) report for given period of time.

Then when you see the report you may use Export button and export this report into Excel.
This may be a solution to your task.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

tomtom
Posts: 2
Joined: Mon Aug 06, 2007 8:41 am

Re: Abacre and Excel

Post by tomtom » Tue Aug 07, 2007 2:48 am

Well... no, it's not, because I need to make one different bill every month, following certain standards of presentation so if I can create a link between excel and the database it would be perfect, with a few macro I think I can have it doing all the job alone, but if I have to generate day by day a report for all my departments and then insert it in the correct template... it will really be quicker to continue by hand (what I don't want to).

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests