Importing closed customer and vendor transactions into AX 2012

(0) Share

Report

Posted on by Community Member

Hi All,

I am trying to figure out a way to import customer and vendor transactions that have already been closed into AX 2012 r2 CU6.

I can the transactions in just fine using the DIEF, but I run into problems with marking them as closed or settled. As far as I know, there is nowhere in the general journal form to mark if a line has been previously settled before posting it. That makes sense, but there has to be a work around somehow.

Or if no one is sure how to import closed AP/AR transactions, can you at least shed some light on what actually lets AX know if a transaction is settled? Is it just whenever the settled amount field in the custtrans or vendortrans tables equals the amount field? Or is there something else?

Thank you for the help.

Phil

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Dick Wenning 8,705 Moderator on at

Like (0)

Report
Copy link

Link copied!

example is vendor, but in general the same

blogs.msdn.com/.../dynamics-ax-export-import-framework-for-vendor-balance-migration.aspx

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report
Copy link

Link copied!

but why importing settled amounts?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Dick,

It seems like the link you posted only describes how to import open cust or vendor transactions and not settled ones, I could very well have overlooked something though.

And we want to import the settled transactions for reporting purposes. So that we can run reports against customers or vendors and return detail that would not be in the general ledger transactions.

Thank you,

Phil

Was this reply helpful? Yes No
Dick Wenning 8,705 Moderator on at

Like (0)

Report
Copy link

Link copied!

why not import it like open trans and settle them after.

settlement from code is not so hard

invCustTrans = CustTrans::find(this.recidInvoice);

payCustTrans = CustTrans::find(this.recidPayment);

custTable = CustTable::find(this.CustAccount);

invCustTrans.transData().markForSettlement(custTable);

payCustTrans.transData().markForSettlement(custTable);

custtrans::settleTransact(custTable

Was this reply helpful? Yes No
André Arnaud de Cal... 305,583 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Phil,

In the past with older AX versions I created import jobs and imported first the "invoice" transacions and posted them. In a second run I imported the "payment" transactions and this file contained information on the invoices being setlled. I have not done this with DIXF (aka DIEF) yet. You probably have to customize the entity to be able to specify the settlements. The code suggestion from Dick to mark settlements could be applied in the correct way then.

Was this reply helpful? Yes No