How to import Expense journal using DIXF

(0) Share

Report

Posted on by ShaqAX

709

Hi everyone,

How to import Expense journal using DIXF ?

Can we use these two entities to import Project > Journal > expense :

And is there possibility to create new entity for that with modifications to make it more simple ?

Especially for the lines, as I have succeeded to import the table (header), but import the line always failed. It is succeeded to insert into staging, but the error is while insert into the table saying "Results. Error(s) occurred while writing entity record"

As this is a journal with relates to Project which has table LedgerJournalTrans_Project, I only specifying these information :

JOURNALBATCHNUMBER

LINENUMBER

ACCOUNTCOMPANY

ACCOUNTTYPE

CREDITAMOUNT

CURRENCYCODE

DEBITAMOUNT

PROJECTCATEGORY

PROJID

QUANTITY

TEXT

With pre-setting of Default offset account, so that when the record inserted, I hope the journal created with the offset is filled already with that setting, as I know this information is mandatory.

So for the custom entity of "ExpenseJournalLineEntity", also whether it is ok to only include LedgerJournalTrans and LedgerJournalTrans_Project for its data source while the rest is removed.

Any special setting during import ?

Sorry, it is actually two questions:

Can we import Project Expense Journal ?
If yes, then can we duplicate the entities to make it more simple as I noticed some are not used in my current business process.?

Thanks,

I have the same question (0)

All responses (10)

Answers (1)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi,

For Q1:

Project expenses can either be imported via a GL journal (=> check out the standard project template available for that purpose "ProjExpenseGeneralJournalLineEntityTemplate") or via the "Journal lines for project" entity that you will have available when you open a project expense journal. If you have less than let's say 1000 lines to import, I would go for those standard templates rather than DIXF.

For Q2:

You can modify the import templates as needed.

Best regards,

Ludwig

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Hi,

I'm sorry, where can I find this template "ProjExpenseGeneralJournalLineEntityTemplate" ?

and "Journal lines for project" entity, I believe is the same one that I attach the picture, is it ?

My import actually will be less then 1000 ( < 50 even), and the error I get is when I only test with 1 line.

Btw, I tried with the "ExpenseJournalLineEntity" though, now it is saying "Journal batch number must be filled in"

like this :

Results. Field 'Journal batch number' must be filled in.
Results. validateWrite failed on data source 'LedgerJournalTrans (LedgerJournalTrans)'

Which is make me confused as I already specified the Journal Batch number and it is exist already since I succeeded to import the header previously, so I'm using one of those Journal batch number from my existing header table's record.

If not mistaken, this error usually related to the number sequence, but not sure why. I have put the number sequence for Journal Id (Journal batch number) to "Allow manual", Also it is weird why it has to do with number sequence, because obviously it is Journal Line table, the Journal batch number should follow what already exist in the header table, so it should take a look at the Journal batch number field which is specified in the source file, in this case my excel file, am I right to say that ? Something need to set afterward ?

Thanks,

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

Hey,

Please clear my understanding, Are you providing the journal batch number in the line file? I understand that you created the journal successfully but on the line file, the same journal number will be required for a successful import.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello ShaqAX,

Please try this journal template in the GL journal section:

Best regards,

Ludwig

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Hi Sohail,

Yes, I specified the journal batch number in my excel file for this journal line. The journal table has been imported separately, but I'm using the same number. So I am wondering why now it is said "Journal batch number must be filled in"

Thanks,

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Hi Ludwig,

Appreciate this information, However I'm still looking for the solution of using DIXF, since this is important to my other purposes.

Thanks,

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi ShaqAX

You can use following entities for import of project expense journal (one for heading and one for lines)

Regards,

Alireza Eshaghzadeh| Business Consultant | My blog

Please mark this thread as verified if the answer is helpful.

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Hi,

Yes, I think that is the same entity as I attached on the first time ->

Thanks

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Yes. I am using entity "Project expense journal lines" for import and it works fine on 10.0.20.

For test, please try to create the journal line manually, then export it via data management and delete the journal line. Compare the exported file to your source file to find the difference.

You can try to import the exported file (e.g. in Excel) to check if you the get the same error message.

Regards,

Alireza

Was this reply helpful? Yes No
ShaqAX 709 on at

Like (0)

Report

Hi,

Okay, will try that. It is just I don't understand why the error saying Field 'Journal batch number must be filled in" when the excel file is confirmed to have that field specified.

Just afraid there is some setting I missed out.

Thanks,

Was this reply helpful? Yes No