Packing List Prints Incorrectly; SKU Translated into Incorrect Customer Item Number; General Print Troubleshooting

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.