maikeru-sama
Active Member
First question, from a real world point of view, I am trying to figure out what exactly is the relationship between F0413 and F0414. I believe that F0413 is the Check Record and F0414 is everything that was paid on that Check. What blows my theory up is that you can void individual items in F0414, which is to say that you can void part of a check. I was hoping someone could clear this up.
Second question, I have written a report that shows all payments made that are tied to a POs (in a given time period specified by the user).
I am trying to figure out how to exclude payments that were voided. This is difficult because if a payment is voided, you will have at least 2 records in the F0414, a PK (Paid) and a PO (Voided/Payment Omitted).
I would like to suppress any lines where a payment was voided in an ER (assuming there isn't a way to tell in the F0413 Header Table), but not sure how exactly to do it. I thought about ordering by certain fields, checking the previous value but in some cases, you pay, you void and then you pay again (at least based on the data at our company).
Any help would be appreciated
Second question, I have written a report that shows all payments made that are tied to a POs (in a given time period specified by the user).
I am trying to figure out how to exclude payments that were voided. This is difficult because if a payment is voided, you will have at least 2 records in the F0414, a PK (Paid) and a PO (Voided/Payment Omitted).
I would like to suppress any lines where a payment was voided in an ER (assuming there isn't a way to tell in the F0413 Header Table), but not sure how exactly to do it. I thought about ordering by certain fields, checking the previous value but in some cases, you pay, you void and then you pay again (at least based on the data at our company).
Any help would be appreciated