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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / One or More Accounting...
Microsoft Dynamics AX (Archived)

One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

(0) ShareShare
ReportReport
Posted on by AHSAN MINHAS 50

We are getting error while making Product Receipt through Procurement Category when selecting VAT on line Item. With ITEM, everything is working fine but when we select Procurement categories, this error is popping up.

VAT-Error.png

Even on Purchase order VAT is showing for this entry along with Ledger account as below

VAT-Line.png

VAT-Calculation-on-Line.png

VAT-Total.png

Any Clue

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Hi,

    Please check your inventory posting setup under inventory-setup-posting-posting.

    If you use categories then there must be an expense account setup in the purchase order - purchase expenditure for expense section.

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Thanks Ludwig for Reply.

    Account is mapped with the Category under

    Inventory management> Setup> Posting> Purchase Order> Purchase expenditure for expense.

    surprisingly it shows the account in the distribution of Purchase order line and also shows VAT

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Hi AHSAN MINHAS,

    Based on your feedback I would assume that your accounting setup is ok.

    The error message says that an update error occured.

    Have you tried deleting the line or PO and created it again from scratch?

    Does this error occur all the time for all POs or does it only occur for a single one?

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Ludwig,

    Yes the setup is perfect. We tried with new POs and categories but every time result is same.

    When we use same category with SERVICE ITEM, it is going perfect. Only issue arising when only Procurement category is used. 

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Just one correction. When use SERVICE ITEM and define Expense account in Item group it is fine but if I do not define Expense account in Item Group but define in Purchase Expenditure for expense then this error comes. Need to know if with just procurement category, VAT or Sales Tax Calculates as I saw VAT/sales tax group in Procurement category as well

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Hi,

    And if you post without VAT, everything is fine and working as expected?

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Without VAT Entry is Perfect. 

    Below you can see even in distribution, accounts and amounts are calculating. 

    VAT.png

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Is there any separate setting for procurement category with VAT? All scenarios are working except this

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Hi Ahsan Minhas,

    There is no specific setting that I am aware of. Your accounting distribution looks also ok. I alerady double checked LCS and could not find a hotfix or hint.

    Do you have a developer around who can help you debug this issue?

    Can you also test this scenario with a different tax code just to ensure that it is not the tax setting that is responsible for this.

    Best regards,

    Ludwig

  • AHSAN MINHAS Profile Picture
    AHSAN MINHAS 50 on at
    RE: One or More Accounting Distribution is Missing a Ledger account .. Procurement Category Issue with VAT

    Tried many scenarios like creating new category, creating new code etc.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
NNaumenko Profile Picture

NNaumenko 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans