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

  • Dining Experience Key to Tempting Customers Back With ever-proliferating cooking shows on TV, a seemingly never-ending list of online recipes, and YouTube educators, it’s never been easier for keen amateur chefs to produce excellent and nutritious meals for a fraction of the cost of dining out. (more…)
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