Universal Function File Exporter (UFFE)
|Previous Next | Direct link to this topic|
NB: Your SAP Partner need to have a “SAP Business One Software Development Kit” license from SAP to be allowed to use this feature. Read more here
With UFFE you are able to export data from SAP to any format using either C#/SQL or a mix. You can launch UFFE as a normal universal function or you can run it on a schedule.
UFFE supports two export types: Single and Batch.
The single export type will be described first.
When creating an export, you will need a few things.
1. A template (how the file should look)
2. Some SQL/C# to get header data
3. Some SQL/C# to get line data
4. Optionally a way to mark a document/what you export as done using SQL or C#.
NOTE: Before continuing please read the single export type as this section will not cover shared features.
The batch export type is a way to support formats that need some header and footer data and multiple documents in between.
You have a format where you need to define some header data, then you need to write all open invoices and in the footer you need to summarize the value of all the invoices.