G/L Entry Table Updataion

Question Status

Unanswered
Ashwini.123 asked a question on 16 Apr 2018 12:06 AM

Hi Experts,

Please tell me how to update the G/L Entry table Automatically please tell i have added new discount for particular customer i want to add that discount amount into G/L entry table please tell me how we can achieve this..

Thank you 

Reply
Hannes Holst responded on 16 Apr 2018 5:22 AM

Hi,

Any change to the G/L Entry-table is not recommended in general.

And it doesn't really make sense to show a discount field in this table, IMHO.

When a discount is posted e.g. through the Sales Order, the entered discount will be posted automatically to the selected G/L Account.

What's the purpose of your discount-field?

Reply
Ashwini.123 responded on 16 Apr 2018 10:37 PM

Hi Hannes ,

How to select the G/L account for Discount, my G/L account Name is Cash Discount, i want to store my discount amount (after posting sales order) in Cash Discount G/L account.please give solution

Thank you

Reply
Hannes Holst responded on 17 Apr 2018 3:48 AM

Hi,

Search for "General Posting Setup".

In this page are two columns "Sales Line Disc. Account" and "Sales Inv. Disc. Account".

To use an account for a specific customer only, you have to create a new "Gen. Bus. Posting Group".

Here you'll find further information about Posting Groups in NAV:

docs.microsoft.com/.../finance-posting-groups

Reply
Ashwini.123 responded on 17 Apr 2018 4:14 AM

Hi Hannes,

My discount is not related to "Sales Line Disc. Account" and "Sales Inv. Disc. Account", this discount is new discount (similar like sales line Disc account) for particular customer thats what  i need to store this discount in G/L Entry please give any solution..

Thank you

Reply
Hannes Holst responded on 17 Apr 2018 5:59 AM

See the other Thread.

Reply