Troubleshooting
Problem
How are the quantities derived on the UPS pickup summary barcode report
Symptom
PART: Outbound 6.2 SP2 DCS
The number of packages on the UPS Pickup
Summary Barcode Report should equal the number of unique tracking numbers
assigned to a particular UPS manifest.
In DCS 6.2 SP2 HF12, there is a
defect with the Summary Barcode Report in that the total number of packages on
the report equals the number of cartons on the manifest. Total number of
packages may differ when pallet IDs are used giving all of the cartons on the
pallet the same tracking number.
Cause
Resolving The Problem
A defect has been filed.
A work around is to change the
ups_pickup_barcode.ctrl file to select the unique number of tracking numbers
for the manifest number.
Code taken from
ups_pickup_barcode.ctrl:
SECTION LOOKUP SEC_NO_OF_CARTONS
SEGMENT
SQL
SELECT COUNT(*) FROM CARTON_HDR
WHERE WHSE = '`SEC_CRITERIA.WHSE`'
AND
MANIFEST_NO = '`SEC_CRITERIA.MANIFEST_NO`' AND
CARTON_STATUS <
'81'<br>SEGMENT FIELDS<br>NO_OF_CARTONS NUMBER <br><br>Where the correct count
should be something like:<br>SECTION LOOKUP SEC_NO_OF_CARTONS<br>SEGMENT
SQL<br>SELECT COUNT(distinct tracking_no) FROM CARTON_HDR<br>WHERE WHSE =
'`SEC_CRITERIA.WHSE`' AND<br>MANIFEST_NO = '`SEC_CRITERIA.MANIFEST_NO`'
AND<br>CARTON_STATUS < '81'<br>SEGMENT FIELDS<br>NO_OF_CARTONS NUMBER
Historical Number
PRI49096
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21535327