Distribution, Manufacturing, and Internet Modules

[cpaulnorthcott]

We have credit cards with many transactions that need to be entered into MAS 90 and this is being done manually at the moment being very time consuming. I also use QuickBooks online banking for some QuickBook clients and most banks and credit cards company statements can be downloaded where all the transactions are imported into the bank or credit card register. Then it is just a matter of matching the transaction to a GL account of which QuickBooks remembers for the next time the same transactions are downloaded. How is online banking done with MAS 90? I would be grateful for some suggestions on the most efficient way to do this process in MAS 90. Thanks!

[DFeller]

MAS 90/200 does not have this feature.

Dawn

[SRYork]

If you can download the transaction detail into a CSV text file or Excel spreadsheet. You could create an import into GL or AP.  I would import into GL Transaction Entry if I was not trying to keep track of the invoices by vendor and I wanted to link the receipt of cash to Bank Rec.  If I was trying to keep detail tracking in AP, I would think importing into manual check entry would be best since that will allow you to create the invoice and pay it on the same transaction.

[cpaulnorthcott]

Dear GatorGal,

Thanks for the advice I am not too concerned about keeping track of the invoices by vendor but do want to keep detail tracking of the expense account and add detail in the comment field as to what the expense is. I can download a bank statement file in Excel spreadsheet and add further columns for the comment field. I am new to creating import jobs and don't know what the correct format for the fields (columns) is to import it into MAS 90. Please can you point me in the direction where I can get instructions how to do this?

Thanks

[SRYork]

Support has several sample import jobs they use to test VI with.  If they don't know where they are, they can contact their QA contact to obtain some we use to test VI.  As I mentioned in my earlier response, if you want to tie your import into Bank Rec, you should as for a sample GL Transaction Entry import job to use as a go by. If you do not want to tie the import into Bank Rec, you could use a General Journal Entry import job to use as a go by.

If you are not currently on a support agreement, your reseller should be able to get them for you.

Both of these imports are really straight forward (but I maybe a bit hardened to the task as I generally don't get involved until someone has problems doing something unique with their imports.)  The clip note version is:

1. Access VI IMport Maintenance,
2. Give your import job a unique name
3. Select the proper import table (GL_GeneralJournalHeader or GLTransactionJournalHeader)
4. On the configuration tab, select the import file type.  Other than that, I would start by accepting the defaults.
5. On the Data Table identify which column in your Excel spreadsheet your data will be maintained.
6. Accept and compile your import job
7. Test you import job.

The business objects used to accomplish the import will generally keep everything straight for you.  The only tricky thing is VI compares the current row with the previous one to determine when to break between header records (individual entries) and detail records (your detail / account lines).  As a result, you want to be sure that each detail line / header is unique and not the same as the previous row.

[SPyle]

Wouldn't it be cool if the sample VI jobs Sage uses to test VI were made available to the user base, rather than having us all try to create them on our own?

The sample BA reports were very helpful when I started with that module.  Are these on the sage support site somewhere that I'm just not aware of?

[SRYork]

Unfortunately, the sample VI Jobs I am aware of are "really" old and not great examples.  They were created pre-framework using the legacy file layouts and have been carried forward for "testing" purposes.  They would give you an idea of how to do VI, but no one has really reviewed them (then or now) to determine if they provide the "best" and "most" informative sample.  They do get the job done but should not be interpreted to be authoritative on "how to" structure a VI Job.

I do know a colleague of mine has forwarded this thread to support.  If they do not already have someplace on the support forum to provide VI examples, hopefully this will instigate one.  I would recommend you request it.  I would also hope as time goes by the examples there would be updated and reviewed to provide "authoritative" examples for everyone to use.