Microsoft Access Northwind Credit Notes

Murray Brown
Murray Brown used Ask the Experts™
on
Hi
I am trying to work out how the Microsoft Access Northwind database handles credit notes at a table level?
Are they entered as negative invoices? Which tables are affected?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
It's the sum of the invoice lines.

If either quantity or unit price is negative, so is the invoice line, and if the invoice lines sums up to be a negative total, the invoice becomes a credit note.
Murray BrownASP.net/VSTO Developer

Author

Commented:
Thanks for the help
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You are welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial