Hi, my Business Central vendor ledger is in really bad shape and I want to clean it up, but I haven't found a bulk solution. Could someone help me? Is it possible to create a new vendor ledger?
Not many options to create a new vendor ledger. There are a few options you have going forward.
1. Start new. Work with an appropriate partner to just start from scratch. Copy the setup to a new company and then bring in opening balances as of a cutover date. I've seen this done in situations where the subledgers were unmanageable and there has been turnover.
2. Clean up the existing subledger. A lot of work but you can go through every transaction in the current subledger line by line. Quite timely but you don't have to worry about starting fresh (although maybe you want that).
3. Use some data cleanup tools that can help you get a grasp on your data and practice good data hygiene and month end practices going forward. I'm not affiliated with these guys but they have a good health check tool you can use to get an idea on where to start for cleaning up data and developing good practices at month end: Health Check – ERP Connect Consulting
I would honestly consider just starting fresh if its bad enough. A lot of partners will happily work with you to get a quick turn around implementation package if you want to start fresh (say 5-7 weeks). Otherwise you'll have to live with the existing subledger.
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.