on 03-24-2010 7:58 AM
Hi All
Is there anyone who has done any automated exports from SBO to a flat file?
We need to export delivery doc info to a flat file (txt) then it will be imported to another system.
Rgds
Bongani
Hi Bongani,
another way would be to use SAP B1iSN.
With B1i you can create flat files (xml or csv) automatically when a new delivery note is created/updated in B1. If you like you can also create these files on time scheduled basis.
For the way back B1i can monitor a folder for incoming files to update the delivery notes in B1.
For further information you could look at [SAP Business One Integration Technology Forum|;.
Kind regards,
Marcus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Dlamini.....
You need to get the support of externa application to achive your requirement which would collect the data directly from
back end of the desired table which would export the data. You shud take the technical help......
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Rahul
Please see scenario for this requirement below:-
The delivery note will be captured via DTW imports as they will be standard every week, then an export needs to be provided to the external application.
Once the file is imported they update the dates and quantities on the external application and then export the file to be imported in SBO to update the dates and quantities.
So if they get the data from the back end extracting only the date, card code, doc num and item code , then exporting a text file with date, card code, doc num, item code and quantity to be imported in SBO automatically via DTW scheduled job.
Is this scenario possible ?
Rgds
Bongani
Hi Dlamini.....
You need to create another application which will take your data directly from back end to the destination file. It requires technical help......
Regards,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
11 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.