Multiple lines inside G/L entry

(0) Share

Report

Posted on by lynix_x

259

Hi everyone,

Let me explain my situation. When i create a sales order with multiple lines with the same g/l account, and i post it. Under g/l entry NAV somehow groups it together and it only shows one line with the sales nr as posted description. Now my challenge is to create gl entry for each line with their description. Since i''m using NAV 2017, is it possibe to use Events for this?. If not, where exactly does the posted description gets populated, and how can i post multiple sales lines to G/L entry?.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (1)

Rob F. 503 on at

Like (0)

Report

Hello,

This is by design to minimize the amount of rows inserted in the G/L Entry table. I recall this is an easy modification as we did this at a company I worked at a few years ago. I don't remember which objects are involved, but I'm sure someone else will be able to assist you, or a quick search online should point you in the right direction.

Regards,

Rob

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

lynix_x ,

i think if you make same GL code by several line in same order it will be integrate , may be you can track it by Line no but im not sure about that

Was this reply helpful? Yes No
ManishS 86 on at

Like (0)

Report

If you use different dimension in the lines then system will post that much of lines.

Was this reply helpful? Yes No
lynix_x 259 on at

Like (0)

Report

Thanks Rob,

i found on forums someone wanted the same modification. But can it be implemented with Events?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We're still on NAV 2013 and so I am not familiar with Events. Here is a link to an older posting about this which has suggested code, just use caution as this is for an older version of NAV.

http://forum.mibuso.com/discussion/22230/g-l-description-to-contain-same-text-as-invoice-line

Regards,

Rob

Was this reply helpful? Yes No
Verified answer

dkatson 2,263 on at

Like (0)

Report

You should use customisation for that. By default NAV group g/l entries, if dimensions in sales line are the same.

Was this reply helpful? Yes No
Suggested answer

dkatson 2,263 on at

Like (0)

Report

And you cannot use events for this customisation unfortunately, bacase this group is made inside posting codeunit.

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

You need to customize this without eventing

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I am looking at this issue also a client - did you manage to solve it?

Was this reply helpful? Yes No