SBX - Search With Button

SBX - Forum Post Title

G/L Entry Table Updataion

Microsoft Dynamics NAV Forum

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

Question Status

Unanswered

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
My Badges

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
My Badges

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
My Badges

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
My Badges

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
My Badges

See the other Thread.

Reply

SBX - Two Col Forum

SBX - Migrated JS