Core Financial Modules

[stu]

Hi,

My manager and I were wondering how to upload a journal entry into Mas using Excel? We have done everything manual so far...

Thanks,

Sarina

[Maureen]

You have 2 choices - using G/L Exchange - found under Utilities under General Ledger; or using Visual Integrator.

Instructions for both can be found under HELP.

[connex]

Two more choices include BOI or scripting.

[BigLouie]

This is a very common import and very easy to do. We use it to import payroll entries every two weeks. We use VI but you can just as easily use Exchange. Here is ours:

0001 Temp01 STR TEMP REPL 2 Start: 1 Len: 60

0002 H.SourceJournal STR STD ASSN 1 Start: 1 Len: 2 GJ

0003 H.EntryNo STR STD REPL 2 Start: 1 Len: 6

0004 H.PostingDate STR DATE REPL 2 MMDDYYYY 20070913

0005 H.JournalComment STR STD CALC 3 Start: 1 Len: 2,048

Calc. Expression: MID((Temp01$),1,2)+"/"+MID((Temp01$),3,2)+"/"+MID((Temp01$),5,2)+" Payroll"

0006 H.AcceptOutOfBalance STR Y/N ASSN 3 Start: 1 Len: 1 Y

0007 H.JournalDeleted STR Y/N ASSN 4 Start: 1 Len: 1 N

0008 L.AccountKey STR STD REPL 1 Start: 1 Len: 9

0009 L.PostingComment STR STD CALC 2 Start: 1 Len: 2,048

Calc. Expression: MID((Temp01$),1,2)+"/"+MID((Temp01$),3,2)+"/"+MID((Temp01$),5,2)+" Payroll"

0010 L.DebitAmount NUM STD REPL 3 ###,###,###.00-

0011 L.CreditAmount NUM STD REPL 4 ###,###,###.00-

[timg]

To which table does this VI job post?

I am trying to set this up need some help to get the job set up.

[BigLouie]

Welcome to the Sage Community. It is normally better to start a new thread. But to answer your question this goes into Gneral Journal Entry. Note that for payroll we do two things. This VI job imports into General Journal Entry. the Journal is printed and reviewed and then posted. The cash comes out of a wash account. We then go into General Ledger Transaction Entry and make another entry using the wash account so that the transaction shows up in Bank Rec.