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

please refer to the following attachement for official references Installation note regarding neeto

  1. create directory CCDIR/comp/edi
  2. mount CCDIR/comp/edi/In to the Xchange it softwarre In directory -- the full path name must be less than 256 char
  3. mount CCDIR/comp/edi/Out to the Xchange it softwarre Out directory -- the full path must be less than 256 char
  4. 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
  5. need a sman with code EDI_OPER
  6. need to set stcont page 3 "Check for over supply during stock receipt" = 'Y'
  7. need to set pocont page 1 "Check for over supply during po" = 'Y'
  8. need to set sscont page 2 "allow recurring customer order" = 'Y' This option is no longer necessary

  9. disallow allocated_to field in header in the braad page 3 right hand side 3 rd option to n
  10. need to set stcont page 4"Use XChangeIT EDI" = 'Y'
  11. setup label printing directory and standard report printing diretory under CCDIR/comp
  12. setup label and standard report printer by ending the sys name with a salsh to print file to directory
  13. in the script always call condisp and get the standard report printer shor name which will be used as the system printer name
  14. in the script always detect the $[0] which supposted to ba same as the directory storing the files, and should be a sim link
  15. make sure all branch have stock allocation when receive set to no in braad
  16. make sure all sub agent will have minimum invoice amount set to 0
  17. 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
  18. 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

  19. need to write script and add menu option to print file in a directory then remove them
  20. 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

  21. 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

Neeto (last edited 2013-09-18 06:09:34 by localhost)