IdealWare Online Users Manual

IY4-17 I/Y MAINTENANCE
31025 Store Master Maintenance

 

PURPOSE

 

The store master maintenance program enables you add, delete and modify data about your store(s). Store master maintenance consists of three screens.

 

Store Master Maintenance is accessed from:

  • Inventory General Maintenance menu.

 

PROCEDURE - SCREEN 1

 

Select Store Master Maintenance from the Inventory General Maintenance menu. The store master maintenance screen 1 displays.

 

LOCATION MASTER MAINTENANCE (SCREEN 1)

┌────────────────────────────────────────────────────────────────────────────────┐
│01/15/08                    D E M O   C O M P A N Y                             â”‚
│                     LOCATION MASTER MAINTENANCE (SCREEN 1)                     â”‚
│                                                                                â”‚
│   STORE CODE                          __                                       â”‚
│                                                                                â”‚
│ 1 STORE NAME                                                                   â”‚
│ 2 G/L DIVISION #                                                               â”‚
│ 3 TRANSFER G/L CODE                                                            â”‚
│ 4 REGIONAL STORE CODE                                                          â”‚
│ 5 INVENTORY CONTROL?                                                           â”‚
│ 6 INVENTORY STORE CODE                                                         â”‚
│ 7 I/Y CONTROL FILE AT WHICH STORE                                              â”‚
│ 8 STORE TYPE (Y/W/R)                                                           â”‚
│ 9 REGIONAL UPDATE/SEARCH PATH                                                  â”‚
│10 H.O.?                                                                        â”‚
│11 MULTI STORES?                                                                â”‚
│12 CURRENCY CODE                                                                â”‚
│13 TAX COUNTRY CODE                                                             â”‚
│14 TAX PROVINCE CODE                                                            â”‚
│15 ORDER REG COSTING TYPE (A/P)                                                 â”‚
│16 RELATED COMPANY                                                              â”‚
│                                                                                â”‚
│PRESS F10 FOR SCREEN 2; F11 FOR SCREEN 3; F4 TO END.                            â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘
STORE CODE
F10 FOR SCREEN 2; F11 FOR SCREEN 3; F4 TO END.

 

Enter store code.

 

The store code is a 2 digit number. If you enter a code that does not yet exist the program prompts you to add a new store. See PROCEDURE - ADD A NEW CODE. If you enter an existing code the program prompts you to modify or delete the code. See PROCEDURE - MODIFY/DELETE AN EXISTING CODE.

 

 

[Enter] to accept displayed default.

 

In a single store environment this value defaults to the normal store code. See PROCEDURE - MODIFY/DELETE AN EXISTING CODE.

 

 

[F4] to exit to menu.


[F5] to display location master list for selection.

 

See PROCEDURE - MODIFY/DELETE AN EXISTING CODE.

 

 

[F10] to access screen 2.

 

[F11] to access screen 3.

 

Example Location Master Maintenance Screen 1 display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/15/08                    D E M O   C O M P A N Y                             â”‚
│                     LOCATION MASTER MAINTENANCE (SCREEN 1)                     â”‚
│                                                                                â”‚
│   STORE CODE                          01                                       â”‚
│                                                                                â”‚
│ 1 STORE NAME                          IDEALWARE STORE# 1                       â”‚
│ 2 G/L DIVISION #                      01  DIVISION 01                          â”‚
│ 3 TRANSFER G/L CODE                   011300      INVENTORY                    â”‚
│ 4 REGIONAL STORE CODE                 00  IDEALWARE STORE# 1                   â”‚
│ 5 INVENTORY CONTROL?                  Y                                        â”‚
│ 6 INVENTORY STORE CODE                01  IDEALWARE STORE# 1                   â”‚
│ 7 I/Y CONTROL FILE AT WHICH STORE     00                                       â”‚
│ 8 STORE TYPE (Y/W/R)                  Y                                        â”‚
│ 9 REGIONAL UPDATE/SEARCH PATH         0100                                     â”‚
│10 H.O.?                               N                                        â”‚
│11 MULTI STORES?                       N                                        â”‚
│12 CURRENCY CODE                       CN  CANADIAN FUNDS                       â”‚
│13 TAX COUNTRY CODE                    CAN                                      â”‚
│14 TAX PROVINCE CODE                   BC  BRITISH COLUMBIA                     â”‚
│15 ORDER REG COSTING TYPE (A/P)        A  AVERAGE COST                          â”‚
│16 RELATED COMPANY                                                              â”‚
│                                                                                â”‚
│** 'M' TO MODIFY; 'D' TO DELETE; CR TO CONTINUE: _                              â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

 

PROCEDURE - ADD A NEW CODE

 

If you enter a code which is not defined the following prompt displays.

 

** NOT ON FILE. DO YOU WANT TO ADD ? (CR=YES/F2=NO):

 

[Enter] to add a new code.

 

The program will step you through each field (see FIELDS below). Once all the fields on screen 1 have been entered, the program advances to screen 2 and then screen 3. When all the fields on screens 1 - 3 are entered the following prompt displays.

 

 

** OK TO UPDATE? (CR TO UPDATE; F2 TO MODIFY; F4 TO BYPASS):

 

[Enter] to accept and update.

 

[F2] to modify.

 

See PROCEDURE - MODIFY/DELETE AN EXISTING CODE.

 

 

[F4] to not add the code and return to CODE field.

 

[F2] to not add a new code.

 

You can enter a different NEW code, an existing code or press [F4] to exit.

 

 


PROCEDURE - MODIFY/DELETE AN EXISTING CODE

 

If you enter an existing code you will be prompted whether or not you wish to modify or delete the code.

 

** 'M' TO MODIFY; 'D' TO DELETE; CR TO CONTINUE:

 

[Enter] to clear the display and return to the CODE field.

 

"M" to modify data fields.

 

** FIELD NUMBER (CR TO CONTINUE):

 

Enter the number of the field you wish to modify.

 

Once you have modified the field data (see FIELDS below) press [Enter] to return to this prompt where you may enter the number of additional fields to modify or press [Enter] again to end modifications.

 

 

[Enter] for modifications complete.

 

** OK TO UPDATE? (CR TO UPDATE; F2 TO MODIFY; F4 TO BYPASS):

 

[Enter] to accept changes and update the file.

 

The file is updated and you are returned to the CODE field.

 

 

[F2] to make additional modifications to the fields.

 

You are returned to the FIELD NUMBER prompt above.

 

 

[F4] to cancel all changes and return to CODE field.

 

"D" to delete the code.

 

** OK TO DELETE? (Y/N):

 

"Y" to delete the code.

 

"N" to not delete the code.

 

 

FIELDS - SCREEN 1

 

STORE CODE

 

Enter a 2 digit store code to access or add.

 

 1 STORE NAME

 

Displays store name; when adding a new code enter up to 35 characters.

 

 2 G/L DIVISION #

 

Displays the G/L division; when adding a new code enter the desire G/L division.

 

The division code defined here is used to determine the division code portion of G/L accounts which are affected in the various processing register programs. For example, you are doing inventory adjustments and the inventory G/L code in the product group file for the affected product's group is xx-1300 and the adjustment G/L code is xx-1310. If the store's G/L division is "01", then (assuming a positive adjustment) the adjustment register will debit account 01-01-1300 and  credit account 01-01-1310.

 

 3 TRANSFER G/L CODE

 

Displays the G/L transfer code; when adding a new code enter a transfer code in the format DD AAAA, where DD is the G/L division and AAAA the G/L account code. This value will be determined by your G/L setup.

 

 4 REGIONAL STORE CODE

 

Displays the regional store code; when adding a new code enter the desired region code or press [F2] to bypass. This is the region that the store belongs within.

 

 5 INVENTORY CONTROL?

 

"Y" to maintain inventory control at store.

 

"N" to not maintain inventory control at store.

 

Use the next field to indicate the inventory store.

 

 

 6 INVENTORY STORE CODE

 

Displays the store code where inventory is maintained; when adding a new code enter the associated inventory store code. This will normally be the same as the store code in the previous field, unless inventory is kept at a different store.

 

 7 I/Y CONTROL FILE AT WHICH STORE

 

Displays the store code that maintains the inventory control file; when adding a new code enter the correct store code, if it is different from the new store you are adding.

 

 8 STORE TYPE (Y/W/R)

 

Displays the store type; when adding a new code enter the desired type. IdealWare currently recognizes the following store types:

 

W = WAREHOUSE

Y = STORE

R = REGION

 

 9 REGIONAL UPDATE/SEARCH PATH

 

Displays the regional update/search path in a multistore environment; when adding a new code enter the path. This field is applicable in a multistore environment only.

 

10 H.O.?

 

"Y" to indicate this store is the "head office".

 

In a single store environment, the single store is the head office.

 

 

"N" to indicate this store is not the "head office".


11 MULTI STORES?

 

"Y" to indicate this store is one of multiple stores.

 

"N" to indicate no other stores.

 

12 CURRENCY CODE

 

Displays the A/P currency code; when adding a new code enter the correct currency code.

 

13 TAX COUNTRY CODE

 

Displays the country code of the tax jurisdiction; when adding a new code enter the correct country code.

 

14 TAX PROVINCE CODE

 

Displays the province code of the tax jurisdiction; when adding a new code enter the correct province code. Press [F5] to display list for selection.

 

15 ORDER REG COSTING TYPE (A/P)

 

This field determines the applicable cost to use for sales order registers.

 

"A" for average cost.

 

"P" for purchase order cost.

 

16 RELATED COMPANY

 

Displays the company code; when adding a new code enter the correct company code.

 

 

PROCEDURE - SCREEN 2

 

Example Location Master Maintenance Screen 2 display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/15/08                    D E M O   C O M P A N Y                             â”‚
│                     LOCATION MASTER MAINTENANCE (SCREEN 2)                     â”‚
│                                                                                â”‚
│   STORE CODE                          01                                       â”‚
│                                                                                â”‚
│ 1 STORE NAME                          IDEALWARE STORE# 1                       â”‚
│ 2 ADDRESS & STREET                    200 - 3680 EAST HASTINGS STREET          â”‚
│ 3 CITY                                VANCOUVER                                â”‚
│ 4 PROVINCE                            B.C.                                     â”‚
│ 5 POSTAL CODE                         V5K 2A9                                  â”‚
│ 6 TELEPHONE #                         298-9077                                 â”‚
│ 7 INTER-STORE #                                                                â”‚
│ 8 FAX #                               298-6377                                 â”‚
│ 9 MODEM #                                                                      â”‚
│10 MANAGER                             IDEAL GUY                                â”‚
│11 ASSISTANT MANAGER                                                            â”‚
│12 SENIOR SALESMAN                                                              â”‚
│13 STORE FOREMAN                                                                â”‚
│14 RESERVED                                                                     â”‚
│                                                                                â”‚
│                                                                                â”‚
│                                                                                â”‚
│** 'M' TO MODIFY; 'D' TO DELETE; CR TO CONTINUE: _                              â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 


FIELDS - SCREEN 2

 

 1 STORE NAME

 

Displays the store name. When adding a new store this field defaults to the store named entered at screen 1.

 

 2 ADDRESS & STREET
 3 CITY
 4 PROVINCE
 5 POSTAL CODE

 

Displays the store address. When adding a new store enter the store address in these fields.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

 6 TELEPHONE #

 

Displays phone number; when adding a new code enter phone number here.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

 7 INTER-STORE #

 

Displays the interstore telephone number in a multistore environment; when adding a new code enter the number.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

 8 FAX #
 9 MODEM #

 

Displays the FAX and modem numbers; when adding a new code enter the numbers.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

10 MANAGER

 

Displays the store manager's name; when adding a new code enter the name.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

11 ASSISTANT MANAGER

 

Displays name of assistant store manager; when adding a new code enter the name.

 

[Enter] to bypass.

 

[F3] to return to previous field.


12 SENIOR SALESMAN

 

Displays name of senior salesman; when adding a new code enter the name.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

13 STORE FOREMAN

 

Displays name of store forman; when adding a new code enter the name.

 

[Enter] to bypass.

 

[F3] to return to previous field.

 

14 RESERVED

 

This field is reserved for future use.

 

 

PROCEDURE - SCREEN 3

 

Example Location Master Maintenance Screen 3 display:

┌────────────────────────────────────────────────────────────────────────────────┐
│01/15/08                    D E M O   C O M P A N Y                             â”‚
│                     LOCATION MASTER MAINTENANCE (SCREEN 3)                     â”‚
│                                                                                â”‚
│   STORE CODE                          01                                       â”‚
│                                                                                â”‚
│ 1 STORE NAME                          IDEALWARE STORE# 1                       â”‚
│ 2 BACKGROUND TASK LOG FILE DIR        /s1/iw/demo/logs/                        â”‚
│ 3 TRANSFER IN DIRECTORY               /s1/iw/demo/trans.in/                    â”‚
│ 4 EXPORT DIRECTORY                    /s1/iw/demo/trans.out/                   â”‚
│ 5 TRANSFER OUT DIRECTORY              /s1/iw/demo/trans.out/                   â”‚
│ 6 WORK FILE DIRECTORY                 /s1/iw/demo/work/                        â”‚
│ 7 DATA FILE DIRECTORY                 /s1/iw/demo/data/                        â”‚
│ 8 CREATE DAILY TRANSFER FILES?        N                                        â”‚
│ 9 'NODE' NAME FOR TRANSFERS           ideal01                                  â”‚
│ 10 INVENTORY LIVE (Y/N)               Y                                        â”‚
│ 11 DEFAULT DELIVERY CODE              DELIVERY                                 â”‚
│ 12 DEFAULT DIRECT SHIP CODE                                                    â”‚
│ 13 DESIGN CENTRE ATTACHED?            N                                        â”‚
│ 14 TRANSFER/RECEIVE ORDERS ?          Y                                        â”‚
│ 15 DEFAULT DELIVERY STORE             01  IDEALWARE STORE# 1                   â”‚
│ 16 DATASERVER PORT/SSL INFO                                                    â”‚
│                                                                                â”‚
│** 'M' TO MODIFY; 'D' TO DELETE; CR TO CONTINUE: _                              â”‚
│                                                                                â”‚
└────────────────────────────────────────────────────────────────────────────────┘

 

 

FIELDS - SCREEN 3

 

 1 STORE NAME

 

Displays the store name. When adding a new store defaults to the store named entered at screen 1.

 

 2 BACKGROUND TASK LOG FILE DIR
 3 TRANSFER IN DIRECTORY
 4 TRANSFER TO WHSE DIR
 5 TRANSFER TO H.O. DIR
 6 WORK FILE DIRECTORY
 7 DATA FILE DIRECTORY

 

Displays the values as determined by your IdealWares consultant and indicates the various directories where your system information is stored.

 

 8 CREATE DAILY TRANSFER FILES?

 

Daily transfer files are used only in multistore environments.

 

"Y" to create daily transfer files between stores and head office.

 

"N" to not create daily transfer files.

 

 9 'NODE' NAME FOR TRANSFERS

 

Displays the node name value as determined by your IdealWare consultant.

 

10 INVENTORY LIVE (Y/N)

 

Use this field to turn off inventory while setting up a new store.

 

"Y" to indicate that inventory is active.

 

"N" to indicate that inventory is not active.

 

11 DEFAULT DELIVERY CODE

 

Displays the default delivery code; when adding a new code enter the delivery code, if applicable. The delivery code is used by the sales order entry program. [Enter] to bypass field.

 

12 DEFAULT DIRECT SHIP CODE

 

Displays the default direct shipping code; when adding a new code enter the default direct shipping code, if applicable. The direct shipping code is used by the sales order entry program. [Enter] to bypass field.

 

13 DESIGN CENTRE ATTACHED?

 

Use this field to associate an Innovis Design Centre with the store.

 

"Y" to indicate an Innovis Design Centre is attached to store.

 

"N" to indicate an Innovis Design Centre is not attached to store.

 

14 TRANSFER/RECEIVE ORDERS ?

 

Applicable only in multi-store environments. If other store delivery orders can be transferred and received via modem for this store select option "Y".

 

"Y" to enable transfer/receive orders.

 

"N" to disable transfer/receive orders.

 

15 DEFAULT DELIVERY STORE

 

Applicable only in multi-store environments. Displays the default delivery store; when adding a new code enter the default delivery store. [Enter] to bypass field.

 

16 DATASERVER PORT/SSL INFO

 

Displays dataserver port and ssl information as determined by your IdealWare consultant.