Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

duplicate line items in GST Sales entry table/report in AU

Posted on by Microsoft Employee

I have a scenario  as below

 Sales invoice with multiple  line items both items & G/L with GST/VAT

   say, 2 lines with type item & other 3 lines with type G/L 

   when i post that sales invoice 

    In Vat Entry table, it shows 5 line items

    But in GST sales entry table, it shows 11 line items instead of 5 line items

please help me to fix this as soon as possible

Note: It is AU

 

*This post is locked for comments

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: duplicate line items in GST Sales entry table/report in AU

    Hi pitch,

    I think this is behaving because of your Setup (General Ledger/ Sales & Receivable).

    If you have configured your system for any additional posting(For Example see my attachment: here i have presented setup for Discount). There is a separate entry for the given discount. When you get the payment with a payment discount, those will be corrected by additional entries. You can set this up in the G/L Setup, "VAT on discount correction" and Discount Calculation...

    6840.error123.png

    Find the additional Lines in your Ledger Entry and relate to the Setup... NAV has common Business Logic for each case, i'm sure you will be able to relate this to your case...

    [tag:goodluck]

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: duplicate line items in GST Sales entry table/report in AU

    Please post a screenshot: Sales Order, Posted Invoice, 5 line items in the Vat Entry Table, & 11 line items in the GST Sales Entry Table.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans