B1i: Timed Invoice Export

[former_member972553]

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!

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.