Skip to main content

Notifications

Announcements

No record found.

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

  • 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

    FINALLY IT IS SOLVED.

    Following were Missing when receiving with Procurement Category.

    1. Purchase expenditure, un-invoiced

    2. Accrued Sales Tax/ VAT on Receipt (For Procurement Category)

    at the time of Receipt, VAT goes to Accrued account but while doing with Procurement Category, I had missed it. Moreover, Purchase Policy gave me better Idea on this. 

    Thanks to Ludwig for directing me towards Procurement Policy from where my mind start working in this Direction.

  • 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

    One More question:

    We have option to define accrued account in the Item group if we want Financial entry at the time of Product Receipt. Where account will be mapped for Procurement Category for Accrued if no Item associated with it.

  • 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

    I never used this option. Please guide which Policy rule I should define from below:

    Procurement-Policy.png

  • Verified 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,

    The item model group setup looks ok.

    About the error that you receive when posting the transaction with a procurement category:

    - Can you test if making this setup here overcomes the issue? dynamicsaxfico.files.wordpress.com/.../en_4.png

    - If this is not the case, can you double check on LCS that this behavior is not due to a bug in your system?

    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,

    We have 2 ways.

    1. We created Item as type Service

    2. Use procurement Category

    With procurement category no need for Item Model group. We mapped procurement category with expense account and just make the PO. Working perfect but with VAT this error is popping up.

    If I create Item with type service and define Item group and in that Item group map account for Purchase expenditure for expense then no issues but when I use procurement category instead whose account is mapped with purchase expenditure for expense in inventory posting, then this error is appearing.  Following is the ITEM MODEL GROUP for Service Item

    0815.WA.png

  • 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,

    How did you setup your service items then?

    Can you share details especially their association with the item model group.

    Many thanks and 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

    So far could not trace the issue.

    Instead of 3-Way Matching, I make it to 2-Way matching and instead of Product Receipt created Project Invoice directly and it get through with proper entry but when making Product Receipt for Service Item, this Error is coming. I know there is no Financial entry for Service item but when I have Service item along with Inventory Item then this is the Issue.

  • 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

    Francois,

    Ledger combination is OK perhaps last dimension is optional. Account even in the range of account structure and not suspended even.

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

    Hello, 

    Could you confirm that the Ledger Dimension combination you are looking for (5209007-HO-GNA-FIN--) exists in you Chart Of Account Structure ?

    We get a similar trouble recently because the Account was not in the the Main Account range defined.

    For example "019999-00-IA" will fired the same error message if I've the following Account Structure setup:

    COA_5F00_Structure.jpg

    Path to form: General ledger\Setup\Chart of accounts\Configure account structures

    Sincerely

    FX

  • 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans