Skip to Content

SAP B1 9.2 .csv output format

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 21, 2017 at 07:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2017 at 12:47 PM

    Hi Johan,

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

    Thanks

    Add comment
    10|10000 characters needed characters exceeded