Sales and Purchase ledger postings update nominal accounts based on the Analysis code or record used. Check the Analysis records as follows:
In the Debtors or Creditors ledger, click Settings.
Click Analysis and locate the Analysis record to be checked.
The Debit, Credit and VAT columns show the nominal codes where transactions post for that Analysis record. Analysis records use both Debit and Credit fields as well as the transaction type, so they may appear incorrect when they are correct.
A good way to check if the Analysis record is set up correctly is to create a new one of the same type, take a note of the Defaults used, and then cancel out without saving.
If you need to change the nominal codes on an Analysis record:
Locate the Analysis record in the list
Click View Record
Click Edit
Make the changes required to the Debit, Credit and/or VAT fields.
Click Save
Where the Analysis records have been set up incorrectly, there are two ways to address the issue:
Where the Corrections Tool is not available:
Post reversals of the affected transactions.
Correct the Analysis records (see above).
Repost the transactions.
Where the Corrections Tool is available:
Correct the Analysis codes (see above)
Use the Corrections Tool to amend the incorrect transactions.
Details on how to set up analysis codes can be found in the article How can I create an Analysis code?
Analysis records can be reviewed in bulk using Access Office Integration, and more information on how to do that can be found in the article Access Financials: How can I get information from records into excel?