Sage 100

Which table and what field is flagged showing commission has been paid?

AR_SalespersonCommission has a field ""InvoiceAmountPaid"". I'm not sure there's a field for paid commissions.

Wayne, Thanks. I saw that. I was thinking there is another place. When they run the commission report and purge, what is flagged that these invoices were purged? I'm trying to create a complex commission report and mark then as paid and rather then reinvent the wheel creating UDF and scripting I was hoping for a short cut.

They are only purged from the commission file, not from the History file. I don't believe there is a flag anywwhere that identifies them as purged. Once they are purged, that's it, they are permanently removed from the commission file.

OK. Thankls