B1i: Timed Invoice Export

Hi,

I am relatively new to the Integration Framework and am trying to figure out how to create a scenario that exports all outgoing invoices of the day to an xml file.

Currently, the invoice files are created using the SAP Business One Event Atom. This is working without any issues, but is a bit problematic when invoices get changed/cancelled after creation.

The xml files are mapped to text files for electronic data interchange and need to be unique. Canceled documents should never be transmitted.

What would be the best way to approach this?

Creating a scenario triggered by a timer is not a problem, but how do I get the invoice objects? Would it be possible to create an SQL query to identify relevant doc entries and retrieve the objects using these?

I would be happy to hear other ways to tackle the issue!