 |
Delivery Answers |
|
I am expecting to receive a package. Can I have my package routed to another address?
For security reasons, UPS does not reroute packages for consignees until one delivery attempt is made...
|
|
|
|
|
UPS cannot provide you with a test file containing actual billing data. You can, however, download a sample file to view the Flat File Bill's layout and format.
To do this, select Get Flat File Bill Downloads below, then select Download in the table headed Download Flat File Bill Sample File. The sample Flat File Bill is formatted exactly like an actual Flat File Bill. It contains different charge types to help you become familiar with the file's structure and content.
To ease implementation of the UPS Flat File Bill in your organization, consider first converting a single, low-volume UPS account number, then rolling out the conversion across other accounts.
|
|
 Back to Top
|
|
No, it is not possible to modify the Flat File Bill's format. You can, however, use the Flat File Bill Tool to analyze the file data. If the pre-defined reports do not meet your needs, you can develop custom queries and reports with the Flat File Bill tool.
|
Back to Top
|
|
To do any of these things, please contact UPS Technical Support. To navigate to the Technical Support form, select Get Technical Support below.
|
|
Back to Top
|
|
Your Flat File Bill may not have arrived for any of the following reasons:
-
The e-mail address we have on file is incorrect
-
The Flat File Bill was transmitted, but the destination e-mail address was unreachable (because of a problem with your server, for example)
-
The Flat File Bill was accidentally deleted
If you do not receive your Flat File Bill by Monday evening, please contact UPS Technical Support. To navigate to the Technical Support form, select Get Technical Support below.
|
|
Back to Top
|
|
Yes, we can resend your recent Flat File Bill to you, but we recommend you first try to locate the e-mail containing the link to it. Check your inbox and deleted e-mail folders. If you can't locate the e-mail or the file, please contact UPS Technical Support and provide the date of the missing file. To navigate the Technical Support form, select Get Technical Support below.
|
|
Back to Top
|
|
To learn about the layout and format of the Flat File Bill, consult the Technical Documentation or the sample data file, which can be downloaded from the Flat File Bill Downloads page. To navigate to the downloads page, select Get Flat File Bill Downloads below.
|
|
Back to Top
|
|
Sender information will display for Air Shipping Document (ASD), Consignee Billing shipments, Freight Collect shipments, and third-party shipments where the shipper is the third party billed. Sender information does not display for outbound manifest shipments.
|
Back to Top
|
|
Receiver information will display for all shipments except Freight Collect and Consignee Billing shipments.
|
Back to Top
|
|
A list of Transaction Code meanings can be found in the Technical Documentation, which can be downloaded from the Flat File Bill Downloads page. To navigate to the downloads page, select the Get Flat File Bill Downloads below.
|
|
Back to Top
|
|
The Transaction Code field will appear blank for inbound Freight Collect shipments and Third-party shipments where the shipper is the third party billed. Packages billed Freight Collect and Third Party are identified in the Bill Option field by the codes 02 and 03 respectively.
|
Back to Top
|
Reference numbers display in different ways in the Flat File Bill. The file can contain up to two reference numbers which, in order to display, must have been entered at the time of shipping. The following rules apply to the display of reference numbers:
- Two sets of reference numbers can populate the Reference Number fields, depending on the type of shipment; the rules are consistent for both manifest and Internet-source shipping transactions
- A single-piece shipping transaction -- that is, neither UPS Hundredweight Service® nor non-rate-shopped -- will display Package Reference #1 and Package Reference #2
- A single-piece, rate-shopped, or Hundredweight shipment will display Shipment Reference #1 and Shipment Reference #2
- A multi-piece shipment will display in the following manner: the parent line will display Shipment Reference #1 and Shipment Reference #2; each child line will display Package Reference #1 and Package Reference #2
|
Back to Top
|
|
Charges for address corrections are detailed in rows displaying ADC in the Transaction Code field. The Flat File Bill displays the sender information, entered by the original shipper, in the Sender fields and the UPS-corrected information in the Receiver fields. If there is a correction to the Floor Number or Suite/Room number, the shipper-entered information displays in the Miscellaneous Line 1 field and the UPS-corrected information displays in the Miscellaneous Line 2 field. The value shown in the Net Charges field represents the charge for the address correction, not the transportation charge associated with the package.
|
Back to Top
|
|
Charges for residential and commercial adjustments are detailed in rows displaying RES in the Transaction Code field. The Service Description field will display Residential Adjustment if the package was shipped as a commercial delivery but the address was residential. The Service Description will display Commercial Adjustment if the package was shipped as residential but the address was commercial. The Flat File Bill shows the tracking number, reference numbers, and shipper and receiver information for the package. The value shown in the Net Charges field represents the charge for the residential adjustment or the credit for the commercial adjustment, not the transportation charge associated with the package.
|
Back to Top
|
|
A Saturday surcharge will always display as a separate line item. It will, however, share the same tracking number, though reference numbers will not be provided. The Transaction Code field will display PRE. The Service Description field will display Saturday Delivery. The value shown in the Net Charges field represents the charge for the Saturday delivery, not the transportation charge associated with the package.
|
Back to Top
|
UPS Hundredweight Service® shipments are represented on multiple rows in the Flat File Bill. The first row of a UPS Hundredweight Service shipment is considered the Shipment Row and contains a summary of the entire shipment, including the total net cost and total net incentive for the shipment. The Tracking Number field will be blank, the Quantity field will show the total number of packages in the shipment, and sender and receiver information will be populated on the summary row only.
The Transaction Code field will display CWT or CW2 if the shipment was received by a Hundredweight Pickup Book or Hundredweight Shipping Document, respectively. However, if the shipment was received through a manifest shipping system, the Transaction Code field will show MAN and the Service Description will display Hundredweight and the service.
The subsequent rows of the shipment display the individual packages in the shipment, including: tracking numbers, any reference numbers, etc.
To connect the shipment line with its respective child packages, a sort can be performed on Miscellaneous Column 3, which will establish the association between the shipment line and its child packages. A secondary, descending sort on the Quantity field will place the summary shipment row as the first row for each shipment.
|
Back to Top
|
Charges for Shipping Charge Corrections are detailed in rows showing SCC in the Transaction Code field. The shipper-entered weight is shown in the Actual Weight field and the UPS-audited weight in the Billed Weight field. The amount shown in the Net Charges field represents the difference between the original transportation charges based on the shipper-entered weight and the new transportation charges based on the UPS-audited weight.
If a dimensional weight scan triggered the correction, this will be shown in the Dimensional Weight column with a Y.
Shipping Charge Corrections are also provided for UPS Hundredweight service and Consignee Billing (CBS) shipments and use the same date and time stamp mechanism outlined above.
|
Back to Top
|
|
Adjustments are displayed with a Transaction Code of ADJ and a service description of the adjustment. The value shown in the Net Charges field represents the debit or credit adjustment charge.
|
Back to Top
|
|
Plan Numbers, Account Numbers, and other fields containing the letter E sometimes display as scientific notation, not as alphanumeric text. This happens when the file is imported into Microsoft® Excel under a General format instead of a Text format. You can fix the problem changing the file suffix from .csv to .txt and saving the new file.
|
Back to Top
|
|
Text qualifiers (" ") appear when data within a field could be mistaken as a delimiter. For example: John Smith would not require text qualifiers. But the comma in Smith, John would be regarded as a beginning point for a new column if used without text qualifiers. The Flat File Bill, therefore, would enclose this in quotes: "Smith, John".
|
Back to Top
|
|
|
|
|
Can UPS provide me with a Flat File Bill to test before I enroll?