web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Vendor sub-ledger and ...
Finance forum

Vendor sub-ledger and GL out of balance

(0) ShareShare
ReportReport
Posted on by Shell 16

Hi

We have an issue in D365 where a vendor invoice is posting double the amount of GST to the GST ledger account and increasing the amount posted to the Vendor control account by the doubled GST amount.

Example

Vendor invoice $28.75

Expense $25.00

GST $3.75

The posting in D365 is as follows:

GL

Expense/stock $25.00

GST $7.50

Vendor control $32.50

Vendor Sub-ledger

Vendor transaction $28.75

GST Sub-ledger

GST $3.75

This issue is intermittent, it has happened for a PO invoice, PO/project invoice, Vendor invoice with no PO.  Issue has occurred with different users.

Has anyone had this issue before or may what could be causing it. 

Thanks

Michelle

Categories:
Financial Management
I have the same question (0)
  • ZvikaR Profile Picture
    ZvikaR 168 on at

    when you go to the vendor invoice without PO (I assume AP invoice journal?) of one of the "bad" journals, and press the "Sales Tax" button, what does it show you?

    1 line of GST with 3.75 or something else?

    when at the same form, you select Inquiries > Sales Tax Summary, what do you see there?

  • Shell Profile Picture
    Shell 16 on at

    It's not an AP invoice journal it is a vendor invoice using a procurement category. When I go to the posted GST form it shows 1 line of GST and of the correct value $3.75.

    Thanks

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Michelle,

    Can this be an issue of your GST code setup?

    What kind of code is that and how is it setup?

    Best regards,

    Ludwig

  • Daxer Persson Profile Picture
    Daxer Persson 3,005 on at

    Is it possible to setup some allocation on the main account representing GST, so that this GL-posting is doubled?

  • ZvikaR Profile Picture
    ZvikaR 168 on at

    When you filter by voucher number on the Posted VAT Transactions listing, what do you see?

  • Shell Profile Picture
    Shell 16 on at

    Hi Ludwig

    This is the main 15% GST code that is used on the majority of transactions. It is setup as I would normally configure it.  It is only a few transactions that have the issue which let me to believe the GST was setup is correctly. I have created an invoice for the same vendor, same product or procurement category, same GST and don't get the issue. It has only happened a dozen times.  This is in a UAT environment and has happened in UAT 1 and UAT 2 with refreshed data.

    Thanks

    Michelle

  • Shell Profile Picture
    Shell 16 on at

    Hi Daxer

    There is no allocation setup on the main account and I can't replicate the issue by doing the same transaction to same main account.

    Thanks

    Michelle

  • Shell Profile Picture
    Shell 16 on at

    Hi Zvika

    The posted GST inquiry shows correctly, amount origin = $25, calculated GST amount = $3.75, Actual GST amount = $3.75.

    It seems to be the GL that has the incorrect posting, the sub-ledgers are correct.

    Thanks

    Michelle

  • ZvikaR Profile Picture
    ZvikaR 168 on at

    Try posting a screenshot of the GL voucher, and a screenshot of the sub-ledger posting from the "Posted VAT" form. Maybe by viewing the specific details of this particular transaction we would be able to tell what is wrong.

    It is highly unlikely Dynamics throws off the sub ledger and ledger off balance just like that. Had anything been customized with this?

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Can you also run the ledger reconciliation reports? I wonder if they actually show a variance.

    Best regards

    Ludwig

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans