1

How does PostAR link back to an invoice and which table holds the discount given on payments?

I know that invnum holds the invoice details

I'm looking for payments, as well as the discount given on payments.

Jason Aller
  • 3,541
  • 28
  • 38
  • 38
cci sugar
  • 46
  • 5

1 Answers1

2

  • The PostAR table links to InvNum on PostAR.InvNumKey = InvNum.AutoIndex

  • Correct, the invoice header information is on the InvNum table, while the invoice line details are on _btblInvoiceLines.

  • Discount information is on the InvNum table for document level discounts, and _btblInvoiceLines for line level discounts

Karabo
  • 61
  • 2