Troubleshooting
Problem
Packing List Prints Incorrectly; SKU Translated into Incorrect Customer Item Number; General Print Troubleshooting
Symptom
PART: Outbound 6.0 SP1 DCS
COMPONENT: <None>
OS: <None> -
<None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB
BROWSER: <None> - <None>
Cause
Resolving The Problem
Using function ID 09753-Func Profile Setup, inquire on the desired function
(the example used here is 08PAC). Note the Rcd Type field, which contains the
print code (for this example, PA4).
Use function ID 09369 to determine
the Print Type {for this example, PAC05}
Use function ID 09376 to
determine the associated .ctrl and .spec files.
Control File For
Criteria : packlist01_crit.ctrl
Ctrl File Data packlist01.ctrl
Spec File
packlist01_d.spec
Gen Crit 2 - blank, 02, or 03.}
Compare the
printed report layout to the print statements in the .spec file to determine
the variable that is printing incorrectly.
In our example, the customer SKU
in the second line of each record was printing incorrectly:
(From
packlist01_d.spec:
print Y_CoOrdForSecondLine
print "Y"
print
SKU_ALIAS size 18
nextline
)
From packlist01.ctrl, determine
the source of the SKU_ALIAS field:
SECTION LOOKUP
SEC_ITEM_X_REF
SEGMENT SQL
# Get SKU Alias for the bill to from X Ref
and
# Get Other Item Cross Refernces.
if (
`SEC_CRITERIA.PICKTICKET_NO.BILL_TO_CUST_ID` != VOID )
begin
SELECT
OUT_REFERENCE_FIELD1
,OUT_REFERENCE_FIELD2
,OUT_REFERENCE_FIELD3
,OUT_REFERENCE_FIELD4
FROM CRP_MANY_TO_MANY_X_REF
WHERE WHSE =
'`SEC_CRITERIA.WHSE.GENERICWHSE`'
AND REF_TYPE = 'CXR'
AND
IN_REFERENCE_FIELD2 = '`SEC_PICKTICKET_DTL.ITEM_ID`'
AND (
IN_REFERENCE_FIELD1 = '`SEC_CRITERIA.PICKTICKET_NO.BILL_TO_CUST_ID`'
OR
IN_REFERENCE_FIELD1 = '`SEC_PICKTICKET_DTL.ORDER_NO.CORP_ORGANIZATION`'
)
end
Select ' ' , CUSTOMER_NAME, CUSTOMER_NAME ,ADDRESS1,
ADDRESS2, ADDRESS3,CITY
, STATE , COUNTRY_CODE , ZIP_CODE , ' '
FROM
ORDER_REL_ADDRESS
Determine the Bill to Cust ID (the organization is
blank):
Select BILL_TO_CUST_ID
from pick_ticket_hist
where whse =
<Whse>
and problem_no = <Problem Number>;
1476
Use the Bill To
and SKU to obtain the customer SKU from the CRP_MANY_TO_MANY_X_REF table (or by
using function ID 09342).
SELECT
OUT_REFERENCE_FIELD1
,OUT_REFERENCE_FIELD2
,OUT_REFERENCE_FIELD3
,OUT_REFERENCE_FIELD4
FROM CRP_MANY_TO_MANY_X_REF
WHERE WHSE =
'CFG27'
AND REF_TYPE = 'CXR'
AND IN_REFERENCE_FIELD2 = '24202'
AND (
IN_REFERENCE_FIELD1 = '1476'
OR IN_REFERENCE_FIELD1 = ' '
)
12486573
Check the setup:
09342 03 Host-WMS
Common Code Map yantra 02/22 12:02
Inquire
Ref Type :
CXR CUSTOMER
In Ref 1 : 1476 In Ref 2 :
24202
In Ref 3 : In Ref 4 :
Priority
: 1
Out Ref 1 : 12486573
If the setup does not show the
correct SKU-Alias pairing (in this case Out_Ref_1) in 09342 - Cust SKU X Ref
for Ref Type CXR, In_Ref_1 as Bill To Id (1476) and In_Ref_2 as the SKU
(24202), change the Out_Reference_Field_1.
Historical Number
PRI48545
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21531165