vsauer
28th July 2006, 11:39
We want to setup incomming EDI orders, but try to use a different warehouse than the cwar from the item table.
Is this possible ?
Cyril Walker
31st July 2006, 06:21
EDI uses the default warehouse for each user found in tdsls039 ( Display User Defaults (Sales) )
The field is tdsls039.cwar.
Cheers,
Cyril.
jroberts
1st August 2006, 21:24
We faced the same challenge, and we ended up using a custom session that updates the warehouse on the sales order after the EDI import is finished. We wanted to base the warehouse on the sales order lines on a warehouse field in the customer master, not the item master.
This approach has worked well for us, but it is not as slick as I would like.
The tables that are affected are:
tdsls041
tdsls045
tdinv001
You may also want to write a pair of records into tdsls051, so that you have the before and after data in a history table.
csecgn
2nd August 2006, 21:59
Or, if you have the possibility for developing customice tdslsdll4280. It's much less complicate then its sounds. Look for case "tdsls041.cwar": and change the logic behind.
Something like:
if tcmcs042.reto = tcyesno.yes
then
edi.field = <your Warehouse>
endif
Not sure about the edi-fieldname, actual I don't have access to our Baan system.
Regards
csecgn