Information Systems:Carrier Interface (legacy) - Revision history

Norwinu: Norwinu moved page Information Systems:Carrier Interface to Information Systems:Carrier Interface (legacy): Renaming

2021-06-09T17:45:23Z

Norwinu moved page Information Systems:Carrier Interface to Information Systems:Carrier Interface (legacy): Renaming

Jeremym: /* Transmission */

2018-02-19T20:05:20Z

Transmission

Jeremym: /* Transmission */

2018-02-19T20:04:48Z

Transmission

Jeremym: /* Overview */

2018-02-19T17:50:35Z

Overview

Jeremym: /* Overview */

2018-02-19T17:50:04Z

Overview

Norwinu at 16:04, 28 October 2016

2016-10-28T16:04:22Z

Jeremym: /* Waybills Missing Customer Number */

2016-08-25T21:41:24Z

Waybills Missing Customer Number

Norwinu at 17:12, 15 July 2016

2016-07-15T17:12:32Z

Jeremym: /* Invoices */

2016-06-23T19:12:59Z

Invoices

Norwinu at 07:22, 23 June 2016

2016-06-23T07:22:07Z

Show changes

@@ Line 144: / Line 144: @@
  __ FEB 25 15  6:15 AM     429 ATL MAI 5_DIST_20150225061501_RCV64830980.dist
-Most of the times shown are the same as the ones in WRKJOBSCDE, so were the automated transmissions.  It happened that on Feb 25 Data Trax FTP server was down, so we had to transmit again manually.  I did this by keying in TR (Retransmit) in front of the 6:15AM line, and pressing enter.  The FTP process shows on the screen, so you can see whether or not it is successful.  When FTP is complete, you must press enter to exit.
+Most of the times shown are the same as the ones in WRKJOBSCDE, so were the automated transmissions.  It happened that on Feb 25 Datatrac FTP server was down, so we had to transmit again manually.  I did this by keying in TR (Retransmit) in front of the 6:15AM line, and pressing enter.  The FTP process shows on the screen, so you can see whether or not it is successful.  When FTP is complete, you must press enter to exit.
 To look at the original 6:15 transmission to see what happened, go to Unity / Start uniPHARM Extensions / VA Company / Work with UWD IT Tools / FTP Logs / Atlas FTP Logs.

@@ Line 126: / Line 126: @@
 ==Transmission==
-You can see a log of transmissions to Data Trax for Atlas shipments.  Go to Unity / Start uniPHARM Extensions / VA Company / Warehouse Menu / Picking and Shipping Menu / Retransmit File, View Log.  The date range prompt defaults to today; change it if you want.
+You can see a log of transmissions to Datatrac for Atlas shipments.  Go to Unity / Start uniPHARM Extensions / VA Company / Warehouse Menu / Picking and Shipping Menu / Retransmit File, View Log.  The date range prompt defaults to today; change it if you want.
 /27/15  13:18:06    uniPHARM -- PRODUCTION               PLRIQ047/LISTCTL
@@ Line 197: / Line 197: @@
  You must first open a connection.
  Enter an FTP subcommand.
  > quit
 ==Scan Data==

@@ Line 44: / Line 44: @@
 ==Overview==
-Atlas (for the lower mainland) is the carrier most automated to the IBM i.   Shipping records, that contain information on all the packages that they will pick up and deliver for us, are created when picking is completed, and transmitted to Atlas (via Datatrac) .  Transmission times are just before the time the drivers come to uniPHARM to pick up the shipments.  Datatrax splits up the shipments by route, and downloads to each driver’s hand held unit.  The drivers scan the boxes as they pick them up from our warehouse, then scan them again when they deliver them to our customers.  We receive scan data back just moments later.  Up to three times a month, we receive electronic invoices; which contain details by each shipment (waybill).
+Atlas (for the lower mainland) is the carrier most automated to the IBM i.   Shipping records, that contain information on all the packages that they will pick up and deliver for us, are created when picking is completed, and transmitted to Atlas (via Datatrac) .  Transmission times are just before the time the drivers come to uniPHARM to pick up the shipments.  Datatrac splits up the shipments by route, and downloads to each driver’s hand held unit.  The drivers scan the boxes as they pick them up from our warehouse, then scan them again when they deliver them to our customers.  We receive scan data back just moments later.  Up to three times a month, we receive electronic invoices; which contain details by each shipment (waybill).
 ==Process==

@@ Line 44: / Line 44: @@
 ==Overview==
-Atlas (for the lower mainland) is the carrier most automated to the System i.   Shipping records, that contain information on all the packages that they will pick up and deliver for us, are created when picking is completed, and transmitted to Atlas (via DataTrax) .  Transmission times are just before the time the drivers come to uniPHARM to pick up the shipments.  Data Trax splits up the shipments by route, and downloads to each driver’s hand held unit.  The drivers scan the boxes as they pick them up from our warehouse, then scan them again when they deliver them to our customers.  We receive scan data back just moments later.  Up to three times a month, we receive electronic invoices; which contain details by each shipment (waybill).
+Atlas (for the lower mainland) is the carrier most automated to the IBM i.   Shipping records, that contain information on all the packages that they will pick up and deliver for us, are created when picking is completed, and transmitted to Atlas (via Datatrac) .  Transmission times are just before the time the drivers come to uniPHARM to pick up the shipments.  Datatrax splits up the shipments by route, and downloads to each driver’s hand held unit.  The drivers scan the boxes as they pick them up from our warehouse, then scan them again when they deliver them to our customers.  We receive scan data back just moments later.  Up to three times a month, we receive electronic invoices; which contain details by each shipment (waybill).
 ==Process==

← Older revision		Revision as of 16:04, 28 October 2016
Line 1:		Line 1:
		+	=Overview=
		+	Carrier Interface is a series of Infonet and RPG programs that integrate shipping info (tracking, billing etc.) from our transportation/courier partners. It comprises many technical elements, and there are distinct areas, such that 'Carrier Interface' is really a large topic. This page may be thus be converted into a category in the future.
		+
	=Waybills=		=Waybills=

← Older revision		Revision as of 21:41, 25 August 2016
Line 522:		Line 522:

	==Waybills Missing Customer Number==		==Waybills Missing Customer Number==
		+
		+	Returns from the stores to uniPHARM are sometimes manual waybills, so they do not have a customer number. When we receive them, the program attempts to figure it out, but is not always successful. The more accurate we make this file, the better the decisions based on it are.
		+
		+	To find waybills that are missing a customer number, select a date range, and key in ‘y’ for ‘include blank cust # only’, and press search. Sort the customer name column so that records for the same customer can be corrected at the same time (you will only have to determine the correct partner number once).
		+
		+	Click on the waybill number to display the detail. In the ‘Select Partner’ box, key in parts of the ‘Pickup From’ name and/or address. When an entry with a matching address shows, click on it, then ‘update’ and ‘go back’.
		+
		+	There is a problem with the Loomis (DHL) data, in that when they cannot determine the customer number, they sometimes put in the first one on the file; which is ‘10005’. So filter waybills by customer 10005, and correct any that not say “Aaronson’s” for the name. Sort by customer name to identify these easier. Click on customer name again to reverse the sort order to find more that are not for Aaronson's.

	[[Category: Carrier Interface]]		[[Category: Carrier Interface]]

@@ Line 305: / Line 305: @@
 To confirm that a sheet has been uploaded, look at carrier invoices in InfoNet, and filter for one of the miscellaneous carriers; for example Sea Air.  Click twice on invoice date, to get a sorted list; newest invoices first.
-[[File:carrint-3.jpg]]
+[[File:Carrint-3.jpg]]
 Compare this to the completed months in the spreadsheet, and upload those that are missing.
@@ Line 356: / Line 356: @@
 ==Atlas Driver’s Scanner Misread barcode==
-[[File:carrint-1.jpg]]
+[[File:Carrint-1.jpg]]
 The leading ‘3’ in the shipment (or waybill) number was read as a ‘W’.  As we have the same information (date, time, and signature) under the correct number, the driver must have scanned the bar code again.
-[[File:carrint-2.jpg]]
+[[File:Carrint-2.jpg]]
 ==Job ATLAS_INT has an error message==

@@ Line 9: / Line 9: @@
 =Invoices=
-Loomis generates invoices for the previous week (Saturday to Friday), and makes them available to us on Monday – we pick them up from their FTP server using a scheduled job (job name DHLINV).  Atlas is not as automated, and manually prepares invoices weekly, and on the last day of the month.  Because we don’t know for sure when they will be ready, the scheduled job (same one that gets Loomis’ invoices) runs at 10PM on Monday, Tuesday, and Wednesday.  The less used carriers send us paper invoices, which Gerald keys into a spreadsheet, which I.T. checks and uploads into WebSmart (the instructions are in ‘Other Carriers’ further down in this document).
+Loomis generates invoices for the previous week (Saturday to Friday), and makes them available to us on Monday – we pick them up from their FTP server using a scheduled job (job name DHLINV).  Atlas is not as automated, and manually prepares invoices weekly, and on the last day of the month.  Because we don’t know for sure when they will be ready, the scheduled job (same one that gets Loomis’ invoices) runs at 10PM on Monday, Tuesday, and Wednesday.  The less used carriers send us paper invoices, which Gerald keys into a spreadsheet and uploads into WebSmart (the instructions are in ‘Other Carriers’ further down in this document).
 To see what this scheduled job does, go to Unity / Start uniPHARM Extensions / VA Company / Work with UWD IT Tools / FTP Connections / Carrier Invoice FTP Config.  Press page down to see the records.