Correct ASN Failure in QAD
This seems to happen when pending pick quantity is present on the shipper being exported. Typically, pending pick records are cleared/deleted during 7.9.5 Pre-Shipper/Shipper Confirm.
To fix this you can:
1) Unconfirm the shipper with 7.9.21,
2) Check if there are pending picks using 7.9.2 Pre-Shipper/Shipper Workbench and set the Remove Pending Pick Qty flag = yes to clear the pending pick record.
3) Confirm the shipper with 7.9.5
4) Export the shipper 35.4.1 resend (this is a new export, we will have a new batch, so, don't use the old batch).
You can find the shipper ID used by the Shipper in 35.4.6.1 ASN Export Audit Report (edexasrp.p). Indicate the shipper and you will see as a result the shipper id used.
Sample Error Message:
** edmfrd_det already exists with Domain "CorvacTR" Sequence Number 44091 Record Structure ID "0001000001000100040000010004". (132)
** edmfrd_det already exists with Domain "CorvacTR" Sequence Number 44091 Record Structure ID "0001000001000100050000010005". (132)
** edmfrd_det already exists with Domain "CorvacTR" Sequence Number 44091 Record Structure ID "000100000100010005000001000500100000010010". (132)
Transformation occurring. Please wait
** Invalid character in numeric input C. (76)
Other menu's to use for validation:
Session Report: 35.7 - can get session number for QCE Workbench
ASN Export Audit Report 35.4.6.1
Pre-Shipper/Shipper Inquiry 7.9.3
Ford Pre-shipper/Shipper Workbench 90.20.5
Transactions by Item Browse 3.21.2