Administration, Core Financials, and Project Accounting

[chayton6]

I have so many questions with Data Import Manager, and I've searched the help to no avail. Can anyone help me with the questions below?

1 - We want to be able to process our payroll JEs (from ADP) via DIM. Is it possible to setup the source connection so that we are prompted to browse for the file each time and then have the saved mappings apply? Or will we have to save the xls spreadsheet from ADP to the same file name each time and then process the job?

2 - We are importing to 'Pending GL Transactions' (for payroll JEs). When we process the job, we choose, under Process Options, 'Journal Numbers' - "Generate During Insertion" - but it NEVER creates the journal numbers. We continue to get blank fields. What am I missing to get this to work properly???

3 - We want each record line to have the *same* journal number. Some of our JE files have hundreds of record lines. When we manually key these in, we have no problem with every line having the same JE #. However, if we key the same JE number into each record line of the staging table and try to import, we get a duplicate record failure. It insists that each row has it's own JE. How do we fix that?

We were so hoping this tool would help us really save time with JEs, but so far it's just been a nightmare to setup and the helpfiles are anything but helpful

Thanks everyone,

D

[trodman]

Danielle,

Have you tried using Data Porter?

Tim 

[dbcoles]

DI doesn't support varying excel file names, but does support wildcards and archiving of text files, so if you can move to that format, you can get the dynamic behavior of DI grabbing all the files you've put into a directory that match the wildcard. There is no capability currently of having the file as an input parameter.

Items 2 and 3 sound like bugs or setup issues. I suggest you follow up with support on those, so that we can either help you modify the mapping (for #2) or correct the issue.

[G2009]

I noticed on a post that wildcards can be used in the file names for the Data Import Manager. Can you provide me with more detail.

My client has 10 users importing AR Invoices. The source file is on \\server\'username'\invoices.xls. Can i use the wildcards on the username portion of the path to pick up the person who is logged in.

Thanks for your help.

[trodman]

Since each user is doing their own imports, what about using DataPorter.

[dbcoles]

chayton6,

When you say you get blank fields for the journal #'s, do you mean in the staging table? The generation of journal #'s is during the insertion into MAS 500, not during extraction from Excel, so for example, you would need to create "dummy" journal #'s in your file, which would be replaced by MAS 500 journal #'s during the insertion. Look at the sample files, there should be a minimal mapping example for this DI which hopefully will help you (I think they are for SOA company).  I have not tried the example below, but I'm guessing it needs debit and credit amounts too (before it will actually post).

An example from the file is below - note each header must be unique journal #:

StgJournalHdr has:

CurrExchRate	CurrID	Financial	JrnlID	JrnlNo	PostCmnt	PostDate	ReverseJrnl	ReversingDate
			JE	106		03/20/08
			JE	107		06/02/08

And StgJournalDetl has:

AcctRefCode	CreditPostAmt	DebitPostAmt	GLAcctNo	JrnlID	JrnlNo	PostCmnt	PostQty
			6400000000	JE	106
			6400000000	JE	106
			1020000000	JE	106
			7200000000	JE	106
			9600000000	JE	106
			7550000000	JE	107
			1010000000	JE	107