Is there a conversion process, other than export/import. Granted, the only file worth converting is the vendor file, since Adagio Checks doesn't keep transaction history, but I figured I would ask.

I tried launching Payables, but it offered to create a new database, rather than finding the Checks data and offering to convert it.

Steve

Hi, Steve,

Open the Checks vendor file using GridView. You can ExcelDirect this information, massage it and import it to the new Payables dataset.

I was mistaken about Adagio Checks not keeping history. It does. It also keeps check reconciliation information.

It sure would be nice if there was a way to transfer at least the check reconciliation information over to Payables without having to export it to Excel, import it as a manual check batch, and post the batch.

Is there?

By the way, GridView for some reason doesn't capture the Default GL account field, and neither does the SmartFinder.

Steve

Hi, Steve,

The Default GL account/dept fields are stored as the Inv Distribution Acct and Inv Distribution Dept fields. You'll find these in the Q/C Vendors table using GridView.

The way you're transferring the Checks information is the correct way to do so, using GV

I'll enter your suggestions to R&D for a future release.

The two fields you listed do not display in GridView.

I think there is a problem with the Q/C Vendors data dictionary table.

Can you please check and let me know.

Steve

Also, as part of the conversion process, I exported from Adagio Checks the last payment date and amount.

Yet I don't see any way to import those fields into Adagio Payables.

Am I missing something, or are those fields just not available for importing?

Steve

The Inv Distribution Acct and Inv Distribution Dept fields are marked as Hidden in the dictionary. Use the /a parameter on the GridView shortcut to show all hidden fields and you can get everything when doing the view on QC vendors.

Activity fields in Payables such as Last Payment date are not editable on Vendors, unlike Statistics fields such as YTD Payments. Therefore, Activity fields are not importable either.
If you want these dates in Payables, use GridView R/W.

Got it. I had /a already on the shortcut, but I had launched GridView from within another module instead of from the shortcut.

Steve