Peoplesoft is our main system for finance. We are using SAP for logistics applications. I am building a interface to send AP invoice details from SAP to peoplesoft on a daily basis. This interface needs to pick up only those invoice that are free for payment i.e. bseg-zlspr (payment block) field is blank. For example, if an invoice is in invoice verification process, it should not be sent. Till this point, it is easy to get the details of these invoices.
Once the invoice verification is done, bseg-zlspr field will become blank and needs to be picked up by interface. But the issue is how to select these invoices. Since the interface will run daily, I can select for invoices that are created on that day or changed on that day. But the issue, when the value of bseg-zlspr field is changed from blocked to free for payment, none of the date field value changes on either bkpf or bseg tables.
Any ideas how to handle this???