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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Vendor Invoice Journal

(0) ShareShare
ReportReport
Posted on by

Hi,

Today I have a strange issue happening when trying to post a manual Supplier Invoice Journal.

Scenario:

-I am trying to create an invoice journal using

Legal Entity/Purchase Ledger/ Journals/ Invoice Journal

The journal contains 3 lines.

 

Line 1

Account type - Supplier

Account - Populated

Invoice - Populated

Description - Populated

Credit - XXXXX

 

Line 2

Account type - Ledger

Account - Populated

Invoice - Populated

Description - Populated

Debit - XXXXX

Line 3

Account type - Ledger

Account - Populated

Invoice - Populated

Description - Populated

Debit - XXXXX

The voucher balances

The issue

-When I validate the voucher it passes.

-When I come to posting the voucher it displays an error 'Account structure xxx for combination yyy is not valid for chart of accounts zzz'

- The strange thing is that account structure xxx is not part of the chart of accounts zzz and the referenced yyy nominal account is not the correct balance sheet account listed in the supplier posting profile.

Notes

-The suppliers group in the Supplier posting profiles is set up correctly

- I have deleted the posting profiles, closed the form, opened the form and re-populated the nominal accounts for each supplier group

-  The supplier transaction has correct financial dimensions set and has been validated by checking the 'Configure account structures' within GL

- When I remove the Financial Dimensions on the supplier transaction and validate the voucher I get a similar error  'Account structure xxx for combination yyy is not valid for chart of accounts zzz' but this time xxx, yyy and zzz are all correct

-The ledger lines also have correct financial dimensions

- I modified the Account structure to allow all dimension values, still same error referencing the wrong account structure

-This was a legal entity that was imported using the import / export framework, I had an issue similar to this in some other modules but it was resolved by deleting the posting profiles and repopulating them.

-Other suppliers within the same supplier profile were able to post ok.

-This is the first transaction for the supplier on this legal entity.

-I have changed the supplier group on the supplier, saved, then put it back to the correct value.

The one thing I can think to do is delete the supplier and re set them up. The problem is that the supplier is shared across multiple legal entities and has transactions across different entities.

Any help on this issue will be much appreciated!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi,

    Have you tried deactivating and reactivating your account structures?

    What Ax version do you operate exactly? Have you already checked LCS for an available hotfix?

    Best regards

    Ludwig

  • ObiOne Profile Picture
    on at

    Hi Ludwig,

    We are on 2012 RTM,

    There does not seem to be functionality to deactivate / reactivate the account structure.

    when I updated the account structure to accept all financial dimension combinations - I thought this would have refreshed the DB tables containing the combinations.

    We are on CU 7 - there is a CU 8 available but I need to look more into this.

    For me it is strange that other suppliers within the same supplier group are able to have an invoice journal posted and it goes to the correct nominal account.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi ObiOne,

    A couple of hotfixes have been released for older Ax2012 systems.

    I have seen similar issues where we finally got it fixed only after applying those Hotfixes.

    Probably check LCS for the fixes that are available for your system.

    Best regards,

    Ludwig

  • Karunakaran nainar Profile Picture
    452 on at

    Hi ObiOne,

    I got the same issue last week , the reason that caused this issue is an DMF update of additional chart of accounts which wrongly update the existing COA, Not sure if this is a bug in DMF.

    to resolve the issue reconfigure your posting profile and in case of other transactions involving bank reset the ledger in the bank master this will allow you to post however you need to make sure your using the right COA if there are multiple COA involved which otherwise will result in two entries in Trail balance meaning you will be posting to a diffrent mainaccount

  • ObiOne Profile Picture
    on at

    Ok I will have to reach out to our MS Partner to have a look as I do not have access to LCS.. Thanks for your help. Do you have a work around I could use to get through month end?

  • ObiOne Profile Picture
    on at

    Hi Karunakaran,

    I have deleted all of the setup for the posting profile. I can not delete the actual posting profile because I get the error:  Supplier posting profile cannot be deleted while dependant Supplier parameters exist. Delete dependant Supplier parameters and try again.

    I am looking into this in more detail. If I am successful I will report back.

    Thanks,

  • ObiOne Profile Picture
    on at

    Ok deleted the profile completely - had to remove the value from the setup form - Ledger and VAT - Posting Profile.

    Will recreate the invoice and report back.

  • Karunakaran nainar Profile Picture
    452 on at

    Hi

    You need not delete the posting profile try removing the account map a different account and reset back to the same account which was there before.

  • ObiOne Profile Picture
    on at

    The invoice did not post and again the referenced account structure is not part of the COA displayed in the error message.

  • ObiOne Profile Picture
    on at

    Yes I had this in other modules and your suggestion resolved the issue - for this one though it is not working.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans