World P4205 Ship Confirm - in Batch?

macmiw

Member
Has anyone seen a method to do ship confirm via batch processing. Either a JDE dream writer (directly or work around) or something on their own. I believe there maybe something in OneWorld but we're looking for a method in World. Something that would accomodate sales details, cardex, inventory, etc. as the P4205 does.

We'd like to feed our shipment release information from our outside third party warehouse and use it to automate our ship confirm at our end.
 
We wrote a program to advance the next status code to "580 Print
Invoices". That night when sales update (P42800) runs, then our
inventory and cardex entries are created. One note of caution, if you
are using the WMS system the F46* files are not updated.

Darryl Huggins
Grace Management Group
A73 cum 11



Darryl Huggins
AS/400 V4R4. JDE A73 c11
 
Re: RE: World P4205 Ship Confirm - in Batch?

Darryl, thanks for the response. Sounds interesting, can I get you to clarify for me:
a) your program to advance status for invoicing does no other specific processing right?
b) Sounds like if not done previously, the P42800 will additionally 'ship confirm' the sales details? and create cardex, update inventory, etc.. the same as if it was ship confirmed by hand (online)?
Note: Did you build in any kind of exception handling for short or changed product?
 
RE: RE: World P4205 Ship Confirm - in Batch?

a) Your program to advance status for invoicing does no other specific
processing right?

1. We only advance the statuses after ALL boxes of an order have passed
through our shipping stations.
2. The order is checked to make sure that it is not on any type of sales
hold.
3. Only lines with a next status of '560' are set to '580'. We also set
field SDLTTR = '560' and SDADDJ = today's date in JDE Fmt.

b) Sounds like if not done previously, the P42800 will additionally
'ship confirm' the sales details? and create cardex, update inventory,
etc.. the same as if it was ship confirmed by hand (online)?

We discovered this by "accident" because we did not have a document type
defined in UDC 40/IU. JD Edwards has a document on the Knowledge Garden
describing all of the functions of the P42800 program. We found the
document to be helpful.

Note: Did you build in any kind of exception handling for short or
changed product?
No. If we are short on an item, the box containing the item is sent to
our "hospital" area and waits for the product. We have been discussing
how we could short ship and then create a backorder, but it is not on
our project list at this time.

Darryl Huggins
Grace Management Group
208 Winding Way
Spartanburg, SC 29306
864.515.9515 Ext 269




Darryl Huggins
AS/400 V4R4. JDE A73 c11
 
Re: RE: RE: World P4205 Ship Confirm - in Batch?

Darryl, one other interesting dream writer we saw in manual:

Have you ever seen the P47071S EDI Receiving Advice Edit/ Create Sales dream writer. From the manual looks like it's supposed to update sales details based on external advice (although it still doesn't do the ship confirm piece). Perhaps the two dream writers could work together (the P47071S and the P42800).

thanks again for sharing your experience.. Sandy
 
I took a copy of P4205 and turned it into a batch program that reads a file that supplies the necessary information for ship confirming order details.

The batch file that it uses as input basically has all of the required fields from the V4205 video, including all necesary fields in the subfile area.

In addition to ship confirming the line and bumping the order status, partial shipments will cause a split line to be created with the leftover qty using the same rules that P4205 uses.

I also created a special subroutine to create freight lines in the F4211 file when the line type 'F' is processed from the batch file, assigning new line numbers starting with 900.000, so as not to conflict with existing lines on the sales order.

Total time needed to create and test the program was approximately 4 weeks...
 
Back
Top