Uploading Gen Journal Lines

(0) Share

Report

Posted on by jsshivalik

3,027

Gen. Journal Line - OnAfterImportRecord()

"Journal Template Name":='GENERAL';
"Journal Batch Name":='TEST';
"Source Code":='GENJNL';
"Posting No. Series":='JV';
"Line No.":="LineNo."+1000;

Below is the Data. I want if 2 rows no is same then same Document No should be generated . For e.g 2&3 in below case. Is it possible or Document No generated is different for each row.

08.06.2017	Invoice	1	Vendor	V000001
08.06.2017	Invoice	2	Vendor	V000001
08.06.2017	Invoice	2	Vendor	V000001
08.06.2017	Invoice	3	Vendor	V000002
08.06.2017	Invoice	3	Vendor	V000002
08.06.2017	Invoice	4	Vendor	V000003

Thanks

*This post is locked for comments

All responses (2)

Answers (1)

jsshivalik 3,027 on at

Like (0)

Report

RE: Uploading Gen Journal Lines

Hi

I am a newbie . How we can generate Document No

Thanks
Verified answer

Suresh Kulla 43,745 on at

Like (0)

Report

RE: Uploading Gen Journal Lines

You can have different Document No. Store the Row no. OnAfterImport in a variable and then compare that value every time in OnBeforeInsert and if it matches use the previous document no. or else generate a new one.