<>#- 23PRERECIMP UPDATE - CREATE PRE-RECEIPTS FROM EXCEL /3UPDATES THE JITEM AND THE JILOT ESTIMATED COST3 R$%$&JCUST5%,%&.tpl1%%,%& 6#R$%$-%&JITEM,%&.tpl1%%,%& .%R$%$/%&JILOT,%&.tpl1%%,%& 0&R$%$>%&JSLOT,%&.tpl1%%,%& (R$%$%&JTRHE,%&.tpl1%%,%& *R$%$%&JTRDE,%&.tpl1%%,%& <@@A+$' pagetitlePre Receipt ImportB$$F[U#?@ABCDEFGHIJKLMNOPQRSTP#U #UVWXYZ[\ZU #]^_`a]A$9^>$6dU #bcdefgn?U #hijklmnopqrstuvsA$td class="td" <> < nowrap>x+U #wxyz{|}~y(#z$   ($,'TRHILITE 
S$K !$  $+$< width="۩(">8] ! $ 8] ,$ $
8]   1$//20 8 ] $"",8]"#( $, ۩$5$۩ ۩ %8&], 6$$$ө@@8E]T' өBULK^ph!#(3DISPLAY INQUIRY SCREENp'3---------------- DO THE REVIEW/UPDATESu->$ 1
Enter Parameters
 u$ i$$ ۫| $(@' $(($3validation flag4$ SUBFUNCUPDATE$ (6$ ,Missing Data, click BACK and fix the problem!$* ( *1$)ө(*((*\ 1TCUST:C(1*=09),REF1:C(1*=09),EXPDATE:C(1*=09),ITEM:C(1*=09),LOT:C(1*=09),QTY:C(1*=09)$1) $11   @2"$+Validation failed!&$]J1@215]6#$Invalid Customer \$8$^]۩A@3 . .1-^)..) $Invalid Item \ 8$ @N=B @4/$# Item is lotted. Missing Lot Code \B2$_.۩A@4 1/_G0LG$ *NEW*3: @N@4$ Item not lotted \9$@ $ Invalid Date ,13------------------------------ UPDATE LOGIC HERE $% $@6@R$@@@A@ $@L$7. )$@(000$@@@@$@A@4 @@L $*** updated ***,a$ @2@@@@3@@4@۫6 $$+$ 
Receipt Import
Customer|Name|Reference|Expected Date|Item|Item Description|Lot|Lot Exists|Qty|--- Result ---
O D$ #

UPDATE COMPLETE. Click for ۩'homelink#(N C$ 

Click  and resolve the problem(s).#($UPDATE`$ 
Validation PASSED!

: 0 $ N#(C$'?PGM=JBB&WF=JBDEALERS&PGMFUNC=VIEW&SEQ=&POPUP=1#$ ViewV$ '$ 8$""8*U$ I?PGM=JBB&WF=JBITEM&PGMFUNC=LOOKUP&DOSEARCHNUM=_JBITEM1&RETURNTO=MATCHRIC|4#$! Find6V$" >'$# H8L$""8@3T=$ERROR ۩(Ө AT LINE ۩(Ө" IN ۩#^E2#( 3OUTTA HERE&$789@: $;@<SADJITEM7;7 ZSCRAP@= QUICK RECEIPT 3input screen$transitinquiryL$ 
 $ h$ TPaste Receipt Details
Example:

[$ GPaste data below:
jE$ /l$ ' - nI$ 1
r!$ 
|$ Data can be copy/pasted from Excel. Place the columns next to each other, copy the cells you want updated, don't include any column headers.

8 $ ($ܨ8]D N# $ŞX( M:N(1*=47),D:N(1*=47),Y:N(1*=47)b($/// @ $@@g$@@@Ŕl$ %Y%Mz%DzŔŀŞŔ $Ş8ţ] J >$':8b]`;U3 ------ RETURN STRING OF FORM TAGS IN formstart formende$j?$
~W L$@<$&$' R F$+ $
$8TRTDDTRO ERRMESSAGEYYY1YYY2YYY TDELEMENTTDPLAIN TDNOWRAPTDDRTEXTTDDHBRYYCYYSYYZWFCGIWFWFPGMCGI DFORM1LOOKUPYYYVTPLDUMMYRKEY VIEWURLGVIEWURL VIEWURL1WFURL VIEWURL2 FORMNAMEFURL FINDURL1 FINDURLG FINDURL2SEARCHWARNINGFF CGI.BULKBULKBULK1PRESULT1 TRHIGHLITEJITEMJITEMJILOTJILOTR R.CUST R.ITEM R.LOTJCUSTJCUSTDOITEM WFCOCODEWFCUST PREL.ITEM_NOADATE CGI.RDATE CGI.RQTYJSLOTA4B4C4D4C4D4E4F4G4H4F4G4I4J4H4K4L4M4N4O4I4Q4A5A5B5C5D5E5B5F5KK1K2K3K9A3B3A3C3D3E3A7A7B7C7D7E7F7G7H7I7J7B7C7D7L7A10B10A10B10C10D10E10F10G10H10A18B18A18B18C18D18E18F18G18H18JSLOT DOUPDATEEWARNLOTWARN JITEM.LOTTED_ITEM JCUST.CUSTOMER_NAME JITEM.DESCRIPTIONTEXT1 FORMSTART NOSUBMITSUBFUNCFORMEND BACKBUTTONCLOSEGDOWRITEYYMDYMDY.YJMDYMDY.MMDY.D JCUST.CUSTOMER_NOYYY1YYY2YYYJTRHEJTRHEJTRDEJTRDETHROW R.REF1 R.EXPDATE R.QTYEDATE JTRHE.CO_CODE JTRHE.IBTYPE JTRHE.CUST_NO JTRHE.IBREF JTRHE.APPTDATE JTRDE.SEQDSEQ JTRDE.ITEM_NO JITEM.ITEM_NO JTRDE.DESC JTRDE.LOT JTRDE.QTYCW1BREMPTYD1XLCSZCGIVALMDYSAVEL32L33L34L35L37L40WARNFORMENDSUBwE R.FCODE JILOT.LOT_NUMBER JILOT.LOT_TYPE_IND JITEM.PRICE JITEM.CS JITEM.CURR_WEIGHT JITEM.BUILDING JITEM.FTERM2JITEM.REORDER_QTY JITEM.PICK_SEQNCE JITEM.STR_SEQNCE JITEM.HAZARD_ITEM JITEMRECYYY1YYY2YYYJTRHEJTRHEJTRDEJTRDETHROW R.REF1 R.EXPDATE R.QTYEDATECW1BREMPTYD1XLCSZCGIVALMDYSAVEL32L33L34L35L37L40WARNFORMENDSUBDYSAVEL32L33L34L35L37L40WARNFORMENDSUBj34L35L37L40WARNFORMENDSUBBEJTRDECW1BREMPTYD1XLCSZCGIVALMDYSAVEL32L33L34L35L37L40WARNFORMENDSUBԳ