Narration

(0) Share

Report

Posted on by jsshivalik

3,099

I have Document No & Narration Data in CSV format.

I want after every Document No Line no should start from 10000 in Voucher Narration

Document No Narration

a aaaaaaaaaaa

a bbbbbbbbb

c cccccccccccccccc

d dddddddddddd

It should be like this

a aaaaaaaaaaa 10000

a bbbbbbbbb 20000

c cccccccccccccccc 10000

d dddddddddddd 10000

Below is the Code

Gen. Journal Narration - OnAfterImportRecord()
"Journal Template Name" := 'GENERAL';
"Journal Batch Name" := 'Default';
"Line No." := "Line No." + 10000;

Thanks

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

manish.yadav 1,893 on at

Like (0)

Report

Hello Dear,

1. Your Primary Key should be Line No....

Go to last line of page designer and select blank line below last line and click Shift+F4 or View-->Properties

1. You MUST set AutoSplitKey property of your page to Yes

2. Also I strongly recommend you to set DelayedInsert property of your page to Yes

Hope it will resolve your issue.

Was this reply helpful? Yes No