Mainland - Duplicate Entry Fix
Log into Mainland
General Ledger Module > Analysis > Account Analysis
In the Account drop down menu, look for Accounts Receivable
Take your date back to the first of the previous month
Change Doc Type to InvoicesÂ
Click Search
Export your search to excelÂ
Freeze the top row
Add filters
Sort the "Transactions Reference" Column A-Z
Highlight the "Transactions Reference" Column
Click Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values
Click Ok
This will now highlight the duplicated in light red with Dark red writing
Scroll through the spreadsheet and make not of the duplicate Transactions.
Go back into the system
System Configuration Module > Security > System Utilities
Click Fix Transaction
Add Password
