Hi Baan-fans,

Please help me out with the following issue:
In a BaanIVc4 environment I have to set up internal EDI between 2 sites of the same company. The challenge is, to receive PO's in ASCII-files which have to create SLS-orders in the selling comp. of type Direct Delivery. Can I add a fixed value in the ASCII-file which sets the tdsls041.drct-flag to "Yes" when the field is part of the Conversion Setups? (I saw a thread a while ago which says this Direct Del's with EDI should be impossible........ :(

Thnx in advance
Erik

Erik,

I believe, the Order type should be of direct delivery type while loading the PO in selling company. Yoy have to link the order type to the internal EDI relation in the EDI setup of the selling company.

Thnx Chandra for your reply,

The problem however is, that you can't set the "Direct Flag" to Yes in the ordertype when the Orderkind is "Sales". This works only for Purchase.......
So I'm afraid questions remains unanswered.

Erik

Maybe you misunderstand the Direct Delivery functionality.
There is no Sales ordertype of type 'Direct Delivery'. Rather you set the 'direct delivery' flag in a sales order line to yes, and you then use a session tdsls4240m000 (Generate Planned Purchase Orders for a Sales Order) to generate a Purchase Order (of type 'Direct Delivery') which then gets the delivery address of your customer as the PO's delivery place (instead of your own address as the delivery address). So you are asking your supplier to ship directly to your customer. Because the goods will then never enter your warehouse the Direct Delivery PO procedure skips some steps like maintain inbound - maintain receipts etc. Note: if you use lot valuation I think it is not possible to use Direct Delivery (as you will need a lot price but since the goods never come in you warehouse you will not have lots).

Regards,
Robert

thnx for explaining standard Baan functionality but stillno answer on initial question. we already planned to write a script to update relevant lines after import of EDI-messages but I was hoping for some intelligent EDI-solutions. How naive I could be :D

<quote>The challenge is, to receive PO's in ASCII-files which have to create SLS-orders in the selling comp. of type Direct Delivery</quote>

The point is was trying to make is that the Direct Delivery procedure is from Sales Order to Purchase Order. Not from Purchase order to Sales order.
If it is for specific partnumbers maybe you could lower the field tiitm001.ddfq:

"The order quantity that is critical to direct delivery from the supplier
to the customer. If the order quantity is greater than or equal to this
quantity, the value of the field "Direct Delivery" in the session
"Maintain Sales Order Lines (tdsls4102s000)" is "Yes" "

R.

<quote>The challenge is, to receive PO's in ASCII-files which have to create SLS-orders in the selling comp. of type Direct Delivery</quote>

The point is was trying to make is that the Direct Delivery procedure is from Sales Order to Purchase Order. Not from Purchase order to Sales order.
If it is for specific partnumbers maybe you could lower the field tiitm001.ddfq:

"The order quantity that is critical to direct delivery from the supplier
to the customer. If the order quantity is greater than or equal to this
quantity, the value of the field "Direct Delivery" in the session
"Maintain Sales Order Lines (tdsls4102s000)" is "Yes" "

R.

Looking for info on Direct Deliveries and this thread seems to be the best so far. However I have a simple question. Where is the field for "Direct Delivery" at the Sales Order level?

You set the 'direct delivery' flag in a sales order line to yes, and you then use a session tdsls4240m000 (Generate Planned Purchase Orders for a Sales Order) to generate a Purchase Order (of type 'Direct Delivery') which then gets the delivery address of your customer as the PO's delivery place (instead of your own address as the delivery address).

You set the 'direct delivery' flag in a sales order line to yes, and you then use a session tdsls4240m000 (Generate Planned Purchase Orders for a Sales Order) to generate a Purchase Order (of type 'Direct Delivery') which then gets the delivery address of your customer as the PO's delivery place (instead of your own address as the delivery address).

You set the 'direct delivery' flag in a sales order line to yes.... where is the direct delivery flag on Sales Order lines you speakth of? Form 1, 2, 3, 4, 5, 6? :(

in BaaN 4c4 it is on the first form, third field in the right column of formfields.

Can anyone explain how direct deliveries works? The Sales Order lines status is "Awaiting Direct Delivery"... how does BaaN know when the goods have been delivered by our supplier directly to the customer?

If you set up Item master direct delivery quantity to 0 and if the parmetert are set for generating Purchase order, system will automatically generate PO from EDI order.

If you set up Item master direct delivery quantity to 0 and if the parmetert are set for generating Purchase order, system will automatically generate PO from EDI order.

HHHmmmm.

This maybe more difficult than I thought then. We don't use EDI with the supplier.

We currently hold stock of part A. Our supplier can also ship part A directly to the supplier. It basically depends on the customer location. I.e. if our customer orders part A is in the USA our supplier ships directly. If the customer orders part A is anywhere else in the world we ship from our stock. Setting the direct delivery to Zero at the item master level will always want to ship directly.

Ok even so if all shipments to our customers are shipped by our supplier directly to the customer (which would be ideal) are there order steps that need to be set up?

Entered Order where direct delivery for item A = Zero.
Order status of Sales Order is at "Awaiting Direct Delivery".
Now what? Our supplier has shipped to the customer. How does the order status change from Awaiting?

Maybe a need to pay a BaaN consultant... :(

Well here is this way I would design my solution comsidering your scenario- Direct Delivery and shipping from your warehouse. I was not aware that you can do both way.
All these will be system step (Automated process):
1. Bring the EDI order as normal Order i.e. without Direct delivery flag.
2. Based on shipping location of order make the direct delvery flag to Yes.
3. I will directly create record in planned inv purchase order then.
4. Tranfer INV order to Purchasing using standard Baan session.This will be called in the custom script.
5. Email purchasing group to make them aware that there is a PO sitting.


Upon SHipment. Again this can be manual or automate process
In Manual process one will receive the PO and that Baan will automatically Invoice

In Automated proess:
I would request supplier to send me the PO number Item Quantity shipped, tracking information, freight charge in electronic format- Flat file etc.
Receive the PO and add trtacking information to sales order, so that freight can be billed to customer.

We are doing part of this in our process- Esp the receipt part.
We have a web form where supplier will enter the shipment details - Tracking weight, and also the carton content. We also ask them to enter their Invoice information. Upon enetring this info, system automaticaly process the Purchase Order and as well as proces the SUpplier Invoice through our automatic PO matching process. This has become virtually paperless process and no ine in Purchasing and Accounting has to do any transactions.

Arvind

Thanks avpatil.


2. Based on shipping location of order make the direct delvery flag to Yes.

I still cannot find a direct delivery yes/no flag that everyone keeps referring to. Maybe it was removed by previous BaaN programmers during customization? I wish I could find such a flag...

Hi,
You can look into table- tdsls041. It is called tdsls041.drct. If your form is modifed then it is possible it is not present on the form. But you can test it. Make the direct delivey quantity to zero in item master. Then try entering the sales order for item. Also you can set the Distibution parameter- Generate Planned INV order to Automatc and Generate Purchase Order to Automaic or Interactove to test it out. Hopefully the code is not modified in your system.

Just to add to your question, Baan EDI doesn't generate ASN for direct delivery, which you may have to generate for such orders. ASN are generated on "Print Packing Slip" stage and Direct Delivery orders by passes that step. ANyway Baan ASN are not that helpful. In my scenario I have created my own 856 (ASN) transaction with lot of information, and I do generate ASN for direct delivery orders also.

Arvind

:confused: the flag is to be found om form 1 in sales order line, right side, 3rd field from above. if not, I guess indeed your forms are customized.

Thanks guys, in fact the field was "disabled" on the form. Does anyone have any basic instructions on the direct delivery functionality in BaaN? Even now when I enter an order that I want to test the direct delivery "special" procedure I can't change the direct delivery field from No to Yes. Do I need to create specific order types to allow direct delivery, direct delivery won't allow Yes because of item type? I know we could use this but I have no clue and there seems to be little to nothing anywhere about how this direct delivery works... :sadface:

On my system, it is field tdsls041.drct.
It is on form 1 of Maintain SO Lines (tdsls4102s000) just underneath Back Order quantity.