Hi Everyone,
I am trying to export the AP_CheckDetail and CheckHeader information but I need to have a counter on the invoices.
There is a field NumberOfDetailLines but if the Check has 5 invoices this field shows 5 but I need to have each invoice listed as 1, 2, 3, 4, 5 (e.g Inoivce 001 = 1, Invoice 002 = 2, Invoice 003 = 3).
I have created a Temp field to Add 1 (Temp001+1) but if I select Reset Temp Variable each record has a 1 (resetting on the Detail line). If I don't select the reset it continuously counts ALL records (not just the ones for the specific Vendor).
Any ideas?