My Prepayment Account Balance is not equal to my Prepaid Orders subledger
Description
Cause
Resolution
  1. Go to Setup, Settings, Vendors and Purchases, Linked Accounts, Invoices and Payments, Prepayments and Prepaid Orders
    1. Verify the linked accounts are selected accurately

If you are in History mode:

  1. Go into the Chart of Accounts and remove the opening balance on the Purchase Prepayments account.
  2. Instead, enter the Prepd Ord./Prepayment in the Payments journal.
    1. If the deposit/prepayment is before the start date (of the fiscal year), the date the prepayment to the start date
    2. Consult with an accountant as your situation may be unique

If you are not in History mode:

  1. A journal entry may have been posted to the Preypayment account. To find this journal entry, go to Reports, Journal Entries / Transaction Details, General.
  2. Look for the Prepayment Acct. Balance linked account number in the reports.
    1. You may need to search previous fiscal years
  3. If you find the linked account, this is the journal entry that caused your integrity issue and should be reversed and posted into the Payments module rather than the General Journal.
  4. Determine if the Prepayment Acct. Balance (L) is more accurate than the Prepd Ord./Prepayment side (R) on the Check Data Integrity window.
    1. Seek advice from an accountant before reversing or posting adjusting transactions.
    2. Transactions can only be reversed if found in the Current Fiscal Year or Previous Fiscal Year.
Steps to duplicate
Related Solutions