Credit notes in Access invoicing system


I am trying to find a simple way to handle credit notes in a simple accounting/billing Access database such
as Northwind. I a not quite sure how Northwind handles them.
Would an entry in the Invoices table with a negative value suffice?

Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
I would think so, but of course that would depend on your system and the way it's setup. In most financial type systems I deal with, there are "transaction" tables (like AR Invoices, AP Invoices, etc), and each of those generally have a Credit "type". To enter a credit, the user typically checks a box for Credit, enters the information, and your code handles the rest.

I've also seen systems where a Credit Memo has to "reverse" another transaction. For example, you could not simply enter a $100 "credit" - you'd have to tag that credit to an existing debit transaction.

And of course if you're posting these, you'll have a Journal table of some sort. You'd have to handle that as well.
PatHartmanConnect With a Mentor Commented:
It's been a long time since I've designed an accounting system but it seems like that would work.  You will have to add a reference field so you can reference the invoice the credit is for and the Credit Memo itself will be assigned an Invoice number.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great, thanks very much
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.