SAP B1 9.2 .csv output format

[RyanSmyth]

Hi,

Wondering if anyone would be able to help with this. I am trying to find out if you are able to set an output type(say for a Purchase Order) in business one as a .csv file that can be emailed to a supplier who can then import the .csv file into their SAP AIO system as an order.

I know there are a number of ways you could do this, exporting a specially modified layout as .csv or even creating a query you can export as .csv but I was wondering if there was a cleaner way of doing this?

I believe in the SAP B1 Intercompany add-on you can do similar things with output/input files but I do not want to have to initialise this.

Any help/guidance would be much appreciated.

Thanks

[RyanSmyth]

Hi Johan,

Many thanks for your recommendations, we were able to sort something out with csv outputs.

Thanks

[Johan_H]

Hi Ryan,

Short of an addon or third party software, saving a query result as .csv is going to be the easiest and cheapest.

I am not sure if it would work, but to mind comes the following solution:

1. Create a stored procedure that takes a given PO number as parameter, that runs the query, and writes...
2. In the B1 client create a user defined field with two options: 1 not sent and 2. send (1. is default)
3. In the B1 client create a formatted search that is triggered by the UDF from step 2, and that runs the stored procedure.

Regards,

Johan