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!