Payment journal import

(0) Share

Report

Posted on by Community Member

Hi,

I am new to Accounts Payable. I have a task to import Payment journal invoice from Excel spreadsheet or CSV. All these are purchase invoices for local rates. Posting would be done manually later on once this is imported.

can you please let me know what all tables would be affected in AX and what classes are needs to be used?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Dan Emreus 1,162 on at

Like (1)

Report

Hi VDY,

The tables that are definitely affected by this is LedgerJournalTable and LedgerJournalTrans. If you look at the datas ources for form LedgerJournalTransVendPaym you will see all datasources that in some way also could be affected. There are several ways to do this import but you can use the classes AxLedgerJournalTable and AxLedgerJornalTrans for this.

If you google on e.g "Import Ledger Journal Trans Ax 2012" you will get more help.

/Dan

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

You can also explore possibilities to use data export import framework for this task.

Tough it can be achieved by populating the tables pointed out by Dan, you need to be careful and use the right API's to populate fields referring to reference recId fields like LedgerDimension, OffestLedgerDimension, DefaultDimension etc.

Thanks,

Priyanka

Was this reply helpful? Yes No
Tony Wan 210 on at

Like (0)

Report

personally, i would highly recommend on using DIXF as the tool when it comes to data migration. depends on the version of ax you're using for the moment. you can refer to the existing entities for Payment journal import.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

It sounds like the Data Import Export Framework (DIXF, DIEF, DMF) is what you want to use for this. I believe that it has to be installed on versions up to R2, but comes standard as of R3. There is an existing target entity for importing records into the LedgerJournalTrans table. It is called "Ledger Balance".

DIXF is ideal for importing records from an Excel or CSV file (or directly from another database). AIF could be used, but you'd likely have to create a transform to convert to XML and that could be a pain. Then you still have to setup the AIF. DIXF solves this easily.

There is a slight learning curve, but once you understand the DIXF, it can be really handy. The DIXF involves a staging table, a class and a query to import records into AX (in this case, DMFLedgerJournalEntity, DMFLedgerJournalBalanceEntityClass, and DMFLedgerJournalTransEntity). You'll need to create a Processing Group that references this Target Entity. Then setup the mapping. Then import.

Depending on the depth or customization of your data, you might not have to even customize any code. This potentially can all be setup in the workplace. However, custom data will likely require development work. There are a number of online tutorials for DIXF that walk you through the basics.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

sorry but i need it in AX 2009 version. don't know why i selected ax2012 while raising this question? I think DIXF won't work with AX 2009, right?

Was this reply helpful? Yes No
imran ul haq 4,017 on at

Like (0)

Report

HI friends,

Further to the above discussion, how about the settlement, do we have to select on the journal line(s) after import manually or is there a way we can include it in the import, as I checked by including the "Markedinvoice" field in the import file but it just bring the invoice number didn't settled. Can you please tell me how I can import the journal with settlement.

This is tested on AX 2012 R3.

Thanks,

Imran Ul Haq

Was this reply helpful? Yes No