Skip to main content

Transactions have been processed in ERP but are not showing in the ledgers

A transaction that has been processed but is not showing in any of the ledgers

A
Written by Andrew McNeice
Updated over a month ago

If the user was processing and got the message that Accounts data has been found to be invalid. This means there was a problem with the transaction, maybe the user is trying to post into a period they are not authorised to or the transaction is coded incorrectly causing the error. This will be need to be fixed by support and processed through.

It may be a case that the search filters are excluding the entry that is being searched for or it may be batched. Then see below for some tips.

  • Double check the ledgers and ensure the user has the correct search filters and criteria used. For example, ensure all the records have been loaded in for the account.

  • Check the relevant Batch as the system may be configured to post the batch first.

  • If they are sales transactions then navigate to Debtors then Process Batch.

  • If they are purchase transactions then navigate to Creditors then Process Batch.

  • If they are nominal transactions then navigate to Financials then Process Batch.

  • Please check that the currency of the transaction matches the currency of the customer / supplier. If it does not, then the transaction would need to be posted with the correct currency or to have Any Currency enabled.

  • Do the postings have a value, except for Sales Invoices, the system does not post 0 value transactions to the ledger.
    For example, if using actual costing for the item despatched or invoiced then check the lot despatched as this may not have a unit cost.

  • Does the related Order Type have an interface. For example, the user may have a stock adjustment order type with no Interface code defined so nothing will post.

  • If a sales invoice is missing confirm the order type used to post the invoice. For example, it’s quite common for the invoice to have been processed with the Proforma order type which won’t be configured to post to the ledger.

Did this answer your question?