Anyway, what I'm hearing is that there's probably not a workaround for this within the Adagio suite?

Get and transform now reads PDFs directly, so you might want to check again.

And, when you can get the data into some regular format, there are lots of ways of bringing it into Adagio.

You might also hire a programmer to create an Excel application that validated the data entry done manually from the POS day end report and then created the necessary export files for Adagio.

And of course, you might look at a different POS system with some better connections to the outside world.

I feel like I'm getting ripped off! I pay a subscription fee for the latest version of Excel and it doesn't have pdf under Get Data...
In any event, the report I get has a three column upper panel and then three different columns in the bottom section so I'm having trouble contemplating how it would reliably re-order that. *sigh*
I'd ditch my F&B POS in a heartbeat if I could... I'm always looking for something that's up to date but that will do everything I need... so far nothing...

Check for updates for Excel. I got an email from them saying they would be rolling the feature out in the coming months.

You might also consider contacting your POS supplier to ask for suggestions or even pinging Ms. Google to see how others have approached the problem. You aren't likely the only person on the planet trying to do this.

ah, you're rockin' the developer subscription! nice!

my POS supplier used to be very helpful, then ORACLE bought it and now they don't know or care about any of the legacy stuff... and when I say 'legacy' I mean we spent $50K to upgrade to the 'latest' version about 3 years ago...

Hugh:

I've helped a lot of companies create solutions to import their POS data into Adagio GL, AP, & AR (depending on the requirements). I've never seen a POS system that didn't export the transactions to some kind of an electronic file for whatever accounting system.

In one case I've had to grab the transaction file meant for QuickBooks (or was it Simply I forget) and in several cases I've had to grab the transactions meant for the (piece of junk) integrated accounting solution.

I find it hard to believe that you have 2 POS systems that don't produce anything for accounting as all POS developers know that they need to provide accounting something or they'll find sales few and far between.

Hi Hugh,

Depending on the database used by your POS systems, it may be possible to extract the transactions directly from their data.

A number of Consultants on this forum have experience with a variety of data structures and if you were able to identify where the data resides and the database format (DBF,ACCESS, MySql etc), they may be able to offer suggestions on how to get it into Adagio. I believe some consutants have tools that can extract the data and send it to Adagio form the POS reports.

new tack...
while I imagine I can engage someone to delve into the various databases and extract sales data to post to the GL but that puts me back to where I am now where I have a fragile proprietary system that will break if I change anything. The companion problem is that I need to audit my sales clerks individually on the way through so my latest thought is the AR module whereby my total revenues are the sum of what my sales clerks bring in individually. This would allow me to have a daily batch with an entry for each sales clerk that I could work on for as long as it took and then post and import to the GL. I'm envisaging each batch totaling zero:

[img]https://lh3.googleusercontent.com/T3DIPG...hA=w310-h549-no[/img]

reasonable? crazy?

Hugh

I think the same problem still exists, where is the source files going to come from?

The data will get keyed in from the various sources the same as we do now. I'm not actually trying to save labour per se, I'm trying to develop a more robust system than what I have now which is people keying the data into a fragile and poorly designed system of spreadsheets.
I could develop a new system of spreadsheets that would create a GL upload file but I thought I'd look into keeping it in the (Adagio) family first.
There are a ton of nice checks and balances in accounting software that don't need to be developed from scratch and that can't be defeated by someone doing something inadvertent is my thinking...