Import Journal Movement with X++

(0) Share

Report

Posted on by HelioBuenos

Hi, I have a Upload button in journals -> movement which I can upload csv data type. When I upload, the data all are insert to Journal movement header.
What I want is when the csv data is uploaded, I get one header with one Journal number and all the data are insert to Journal movement lines of the journal number. Please help me.

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Gunjan Bhattachayya 35,423 on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use something like this to create headers and lines.

Please share your existing code here as well in case you want us to take a look at what logic you could implement

Was this reply helpful? Yes No
HelioBuenos 81 on at

Like (0)

Report
Copy link

Link copied!

Hi, after some struggling the link you share is really helpful!

Thank you

Was this reply helpful? Yes No
HelioBuenos 81 on at

Like (0)

Report
Copy link

Link copied!

Now I have another problem. when I finish importing the csv data, my form do not get refresh by itself. When I close the form then open it again, it will show the data that I import before.

Was this reply helpful? Yes No
Suggested answer

Leo Chen Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

You can put some form ds refresh code into your customized Upload button. eg _ds.research(); or _ds.executequery(). See below -

mohsinkhalid.com/.../

Was this reply helpful? Yes No
Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Copy link

Link copied!
Assuming that you have the button in the journal header, you can call the following code

inventJournalTrans_ds.reread(); inventJournalTrans_ds.executeQuery();

Was this reply helpful? Yes No