introduction
XChangeIT EDI,basicly they send to us csv file indicating stock receipt and stock return , and we send them back csv file indicating sales and returns
- totally four type of file dd2 sl2 rtf and rtd
- dd2 they send us indicating stock receipt , we will use this to generate item
- sl2 we send them indicating sales,
- rtf they send us indiating what items we should return at the time
- rtd file we send them indicating what we are actually returning
please refer to the following attachement for official references Installation note regarding neeto
- create directory CCDIR/comp/edi
- mount CCDIR/comp/edi/In to the Xchange it softwarre In directory -- the full path name must be less than 256 char
- mount CCDIR/comp/edi/Out to the Xchange it softwarre Out directory -- the full path must be less than 256 char
- create an other directory CCDIR/comp/edi/processed -- note that this is a directory to backup processed file, it is not a mount, it only exist in Control server-- the full path must be less than 256 char
- need a sman with code EDI_OPER
- need to set stcont page 3 "Check for over supply during stock receipt" = 'Y'
- need to set pocont page 1 "Check for over supply during po" = 'Y'
need to set sscont page 2 "allow recurring customer order" = 'Y' This option is no longer necessary
- disallow allocated_to field in header in the braad page 3 right hand side 3 rd option to n
- need to set stcont page 4"Use XChangeIT EDI" = 'Y'
- setup label printing directory and standard report printing diretory under CCDIR/comp
- setup label and standard report printer by ending the sys name with a salsh to print file to directory
- in the script always call condisp and get the standard report printer shor name which will be used as the system printer name
- in the script always detect the $[0] which supposted to ba same as the directory storing the files, and should be a sim link
- make sure all branch have stock allocation when receive set to no in braad
- make sure all sub agent will have minimum invoice amount set to 0
- need to run script to run every 15 minutes to retrive DD2 files in CCDIR/comp/edi/In run
process_dd2 CCDIR/comp/edi/In/*.DD2
- need to run script which generate sl2 files by running
sl2rep -c creditor_code
the program must run every night before midnight or before we roll the date but after all the posting
the program need to be run for every creditor using the XChangeIT EDI
- need to write script and add menu option to print file in a directory then remove them
make sure gencont use seperate seq number per terminal is not set to Y, since we store the next delivery docket number in branch only
I strongly suggest that before going live , need to test our system in one of the store by co running our system with their current system (use their current system for life, re-enter every related transaction into control ) for at least 2 week, and compair all the edi file generated with their current systems.
testing table , when found bug please add to this table
test |
result |
comment |
loading dd2 |
N |
need to talk to bernie to discuss the delete record |
receiving dd2 |
|
|
-donot allow to pick from return tran docket |
Y |
|
-colour receive qty correctly |
Y |
support YEARLY and HALF YEARLY |
-showing statistic correctly after f9 |
Y |
support YEARLY and HALF YEARLY |
-show on co correctly |
Y |
show recurr co on parent - on clild |
processing receive |
|
|
-generating order for pickup customer |
y |
|
-generating order for tradis customer |
y |
|
-auto invoice order for tradis customer |
y |
need to make sure minimum inv is 0 for these debtor to make sure every order get invoiced |
-donot auto invoice order for tradis with no credir |
Y |
|
-generation of order will not cause negative qoh |
Y |
|
-return will have higher priority than order generation |
y |
|
-updating return qty |
y |
|
-generating transfer for stock allocation |
Y |
slightly differ from the spec will still generate sale or co |
-print receipt summary correctly when receive dd2 |
y |
|
-print receipt summary correctly when alloc to branch |
Y |
|
-print label correctly |
y |
need to confirm the detail look with boris |
-print label correctly when doing stock allocation |
Y |
|
-print transfer docket correctly when doing stock allocation |
y |
the printing of transfer docket will be done by steat |
sell by scan co barcode |
Y |
|
sell normally item correctly |
Y |
|
can plan return using customer co barcode |
Y |
|
generating sl2 |
Y |
|
planning return |
Y |
|
finalising retrun |
|
|
-loading rtf |
Y |
|
-generating return base on rtf |
Y |
|
-generating return or docket base on cred |
Y |
|
-user screen when processing rtf |
Y |
but the item received actually take into account of item returned |
-generating rtd |
Y |
|
-converting return doc to crinv should not allow to include picking of receipt doc |
Y |
|
