What is the InvcHead.ClosedDate?

What we are trying to do is average out a customer’s paying terms. Which we will need the date that the invoice was fully paid. Is this the InvcHead.ClosedDate?

I was going to link InvcHead with CashDtl/CashHead, but noticed this field.

Field help says: "The latest transaction date (CashDtl) which was available when the invoice was closed. This is used to improve record selection performance when selecting invoices that were open as of a certain date. (Used by the aged invoice report). This is updated during the CashReceipt posting process, Adjustment entry or Apply Credit memos programs… "
This would be the right value based on what you mention.

1 Like

Awesome, thanks