Microsoft Access Northwind Credit Notes

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?
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
Gustav BrockCIOCommented:
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.
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks for the help
0
 
Gustav BrockCIOCommented:
You are welcome!
0
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.