Why does NorthStar Desktop show all my old invoices as uncommitted?

You may run across a customer trying to commit AP in NorthStar Desktop, and very old invoices are showing up to be committed again.

Why is this happening?

With NorthStar Desktop 4.5, we added automatic purging of the MDB files in the C:QReports directory. This was to avoid files like qDBFData.mdb growing to over 1 gigabyte in size and becoming corrupted. Part of this purge routine also removed old invoice numbers from qAPData.mdb.

POSitouch is supposed to purge old invoices from its files TRNHDR.DBF and TRNDTL.DBF, but sometimes this process does not work when using arbitrary-period inventory.

After NorthStar Desktop purges old invoices, if they still exist in POSitouch’s files, then NorthStar Desktop will try to re-import them the next time AP is committed.

What can I do about it?

In NorthStar Desktop 4.10, we changed the purge process so it no longer purges old invoice numbers, so this should not be a problem in the future. We also added new logic that compares data in trnhdr.dbf and trndtl.dbf with what we have in our database. If this occurs again however, NSD 4.12 and above now ignores any invoice that is older than 12 months.


Want to know more about NorthStar products and services?

Request a Live Demo

News & Events

  • A New CBS Holiday Tradition – Recipe Book Edition

    Happy Thanksgiving from our families to yours.

    Thank you for your continued support and trust in CBS. We're grateful for each and every one of you.

    We're going back to the universal language of love and a symbol of families for many: food.

    At times when our family is away, food, or the warm memories of gatherings bring us home.

    Our CBS family is happy to share with you this recipe book of ourĀ favorite dishes to bring us all closer this holiday season. When we can't celebrate the holiday season with those we love, we hope that sharing our favorite recipes brings some bright joy to you and yours.

    Know that CBS is always here for you, there is always someone on the other side of a phone. If you just need someone to talk to, give us a call. We are here to not only support your restaurants but your people as well.

    Please enjoy these recipes from our families' kitchens and some of our client's kitchens.


World View
Monitor all of your active locations and vitals on a single page.

Find the problem, before it's a problem.
Find out how
Recipe Viewer
Manage recipes, replace training manuals, and update communication.

All from one location,
safe and secure.
Find out how
Free Podcast!
Don't miss out as The Restaurant Technology Guys review and discuss everything you need to know. From NRA to MURTEC and the tech in-between.
Tune in Now!
Real Time Web Analytics