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.

All responses (5)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,421 on at

Like (1)

Report
RE: Import Journal Movement with X++

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

inventJournalTrans_ds.reread(); inventJournalTrans_ds.executeQuery();
Suggested answer

Leo Chen on at

Like (1)

Report

RE: Import Journal Movement with X++

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

mohsinkhalid.com/.../
HelioBuenos 20 on at

Like (0)

Report

RE: Import Journal Movement with X++

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.
HelioBuenos 20 on at

Like (0)

Report

RE: Import Journal Movement with X++

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

Thank you
Verified answer

Gunjan Bhattachayya 35,421 on at

Like (0)

Report

RE: Import Journal Movement with X++

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