Customer Relationship Management

[royvij]

Once in a blue moon one of our customer service representatives accidentally imports a VI import file twice doubling the number items on several orders. Is there a way to stop an order number from importing twice? 

[BigLouie]

Welcome to the Sage Community!  Yes there is. With Perform Logic. Most of us either delete the source file or rename the source file.  On the old Sage Talk there were a number of examples posted.

[BigLouie]

Forgot to ask what version of MAS you are on.  Plus there is also perform logic that checks to see if the sales order already exist in history.

[royvij]

We are currently on MAS 200 version 4.05. I hope to get us to 4.4 soon.

[royvij]

Do you happen to have the commands that were listed on that page? 

[royvij]

**Crickets**

[BigLouie]

SETERR EXIT_LOGIC
F$=STP(VI2_IMPORT_FILE$)
F=POS("."=F$,-1)
IF F<>0 THEN F$=F$(1,F-1)
F$=F$+".csv" ! OR WHATEVER EXTENSION YOU WANT
ERASE F$,ERR=*NEXT ! DELETES THE FILE IF IT ALREADY EXIST
CH=FFN(VI2_IMPORT_FILE$)
IF CH<>-1 THEN CLOSE (CH)
RENAME VI2_IMPORT_FILE$,F$
EXIT_LOGIC:
EXIT 

Place in the VI folder