Skip to Content
0

SAP B1 9.2 .csv output format

Apr 20, 2017 at 02:54 PM

64

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Johan Hakkesteegt Apr 21, 2017 at 07:00 AM
0

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 the result to a .csv file
  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

Share
10 |10000 characters needed characters left characters exceeded
Ryan Smyth Nov 17, 2017 at 12:47 PM
0

Hi Johan,

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

Thanks

Share
10 |10000 characters needed characters left characters exceeded