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

  • How Restaurant QR Codes Offer More than Just Contactless Ordering For obvious reasons, the 2020 COVID-19 pandemic did a great deal to accelerate the existing trend towards contactless ordering in all sectors of the restaurant industry.¬†And the use of restaurant QR codes to enable contactless ordering from digital menus was a tremendous help in building customer confidence. As the pandemic continues into 2012, this trend will no doubt continue to gather in strength. (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