Sales and Purchase ledger postings update nominal accounts based on the Analysis code/record used. These can be checked as follows:
In the Debtors or Creditors ledger go to Settings.
Click Analysis and locate the Analysis record to be checked.
The Debit, Credit and VAT columns show the Nominal Codes of where transactions will post to for that Analysis record.
Note: Analysis records use both the Debit and Credit fields as well as the transaction type and so may appear to be wrong 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 then ...
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?
f you require more detailed assistance, please raise a new case online and reference the title of this article.