Using Scripts to Automate Imports

There are up to four buttons that can be connected to particular scripts.

To activate these buttons two components need to be placed in the base directory of your Salesmatrix - a picture file for the button and a script file that is activated for this button. The base directory is installed, by default, on C:\Program Files\Salesmatrix\Scriptsv3.

The button pictures must be named "button1.jpg", "button2.jpg", "button3.jpg" or "button4.jpg".

In a similar fashion the script files that are activated behind these buttons must be called "scriptv31.smd", "scriptv32.smd", "scriptv33.smd" and "scriptv34.smd".

Editing Script Files

Each script file (*.Smd) file is stored as a text file. To modify the file, you can open it with a text editor like MS Word or WordPad. The following is a description of what is stored in the file:

Line Number	Description	Example
Line 1	Transaction Field that links to customer	Trans Customer Link =INVHEADER.CUSTOMER.
Line 2	Transaction Field that links to Salesman File	Trans Sman Link =INVHEADER.SALESPER.
Line 3	Transaction Date Fieldr	Trans Date =INVHEADER.TRANDATE.
Line 4	Transaction Header to Line item Linking statement	Trans Inv No =INVHEAD.INVNO=INVLINE.INVNO
Line 5	Transaction Field that links to Product File	Trans Prod Link =INVLINE.ITEM.
Line 6	Transaction Value Field	Trans Value =INVLINE.FAMTSALES.
Line 7	Transaction Cost Field	Trans Cost =INVLINE.COSTSALES.
Line 8	Transaction Units Field	Trans Units =INVLINE.QTYSOLD.
Line 9	Product Code field (must match transaction field)	Prod Link =ICITEM.ITEMNO.
Line 10	Product Description field	Prod Name =ICITEM.DESC.
Line 11	Product Value Field (not required)	Prod Value =ICITEM.SALEPRICE
Line 12	Product Cost Field (not required)	Prod Cost =ICITEM.COST
Line 13	1st Product Category Field	Prod Cat1 =ICITEM.CATEGORY.
Line 14	2nd Product Category Field	Prod Cat2 =ICITEM.ALTSET.
Line 15	Customer Code field (must match transaction field)	Cust Link =ARCUS.IDCUST.
Line 16	Customer Name field	Cust Name =ARCUS.TEXTSNAM.
Line 17	Customer Category 1	Cust Cat1 =ARCUS.IDGRP.
Line 18	Customer Category 2	Cust Cat2 =ARCUS.CODESTTE.
Line 19	Salesperson Code field (must match transaction field)	Sman Link =ARSAP.CODESLSP.
Line 20	SalesPerson Name field	Sman Name =ARSAP.NAMEEMPL.
Line 21	SalesPerson Category 1	Sman Cat2 =ARSAP.BRANCH
Line 22	SalesPerson Category 2	Sman Cat1 =ARSAP.DEPT
Line 23	Product Selection Statement	Prod SQL =SELECT DISTINCT ICITEM.ITEMNO AS CID, ICITEM."DESC" AS CNAME, ICITEM.CATEGORY AS PCAT1, ICITEM.ALTSET AS PCAT2 FROM ICITEM ICITEM.
Line 24	Customer Selection statement	Cust SQL =SELECT DISTINCT ARCUS.IDCUST AS CID, ARCUS.TEXTSNAM AS CNAME, ARCUS.IDGRP AS CCAT1, ARCUS.CODESTTE AS CCAT2, ARCUS.CODEBRANCH as CCAT3, ARCUS.BUSTYPE as CCAT4, ARCUS.DiscLevel as CCAT5 FROM ARCUS ARCUS.
Line 25	Salesman selection statement	Sman SQL =SELECT DISTINCT ARSAP.CODESLSP AS CID, ARSAP.NAMEEMPL AS CNAME FROM ARSAP ARSAP.
Line 26	Transaction selection statement	Tran SQL =SELECT INVHEADER.CUSTOMER AS CCUSTID, INVHEADER.SALESPER AS CSMANID, INVHEADER.TRANDATE AS DTRANDATE, INVHEADER.ITEM AS CPRODID, INVLINE.FAMTSALES AS NVALUE, INVLINE.QTYSOLD AS NUNITS, INVLINE.FCSTSALES AS NCOST FROM INVLINE INVLINE, INVHEADER INVHEADER WHERE INVLINE.INVNO=INVHEADER.INVNO
Line 27	Special date format selection (can be left blank for standard MS ODBC Date formats)	Dates ={ACCPAC}{Timestamp}
Line 28	Product Description	Desc1 =Products
Line 29	Customer Description	Desc2 =Clients
Line 30	Sales Person Description	Desc3 =Branches
Line 31	Product Category1 Description	CatP1= Type
Line 32	Customer Category1 Description	CatC1 =Region
Line 33	Sales Person Category1 Description	CatS1 =Type
Line 34	Product Category2 Description	CatP2 =Location
Line 35	Customer Category2 Description	CatC2 =Status
Line 36	Sales Person Category2 Description	CatS2 =State
Line 37	Customer Category3 Description	CatC3 =Branch
Line 38	Customer Category4 Description	CatC4 =BusType
Line 39	Customer Category5 Description	CatC5 =DiscLevel
Line 40	Customer Category3	Cust Cat3=ARCUS.CODEBRNCH
Line 41	Customer Category4	Cust Cat4 =ARCUS.BUSTYPE
Line 42	Customer Category5	Cust Cat5 =ARCUS.DiscLevel
Line 43	Tooltip text on Button rollover	Tooltip =Imports from Accpac Advantage Series

Return to Main Menu

Copyright Infyra Pty Ltd