Freight line creation from Pitney Bowes

[jmk2]

I am working at a client that utilizes the Pitney Bowes (PB)shipping software. I have been given the task of creating a Freight line associated to the Sales Order that was shipped by PB. I have researched the Shipment Confirmation program (P4205) and found how it creates Additional Lines (using BSFN B4200310). To automate this process, it looks like I would have to exexute the F4211 Edit Line and then the F4211 End Doc. Has anyone had to create additional Sales Order detail lines to an existing order? Am I on the right track with writing a process to execute BSFN's within B4200310? Is there an easier solution? Please advise!

 

[KarenR]

We have used a Pitney Bowes interface for freight with OneWorld for a few
years now. Our approach was to setup a "default" sales order template that
would automatically enter a freight line (line type F) on each sales order
at the time of order entry. The line has a qty of 1 but $0 price. When the
order ships via Pitney Bowes, we have Pitney Bowes running an SQL update to
populate the $$ amount of the freight charges and set the Y/N flag in the
FRTC field to a Y (the order has shipped).

The ship confirm batch program is set to data select all orders at the
correct status with the freight flag to Y.
The whole process was easy to setup once we wrote the SQL statements and
determined which field to use the Y/N flag. We didn't need to customize the
OneWorld side at all except to setup the order templates (15 minutes).

Karen

Karen Riner
OneWorld System Administrator
Awana Clubs International
[email protected]
OW B7332 SP16, NT & 2000, Oracle 8.1.6
Optio, Pitney Bowes