Version 10 Considerations

Version 10 Considerations

Company increased to 3 characters

Location increased to 3 characters

Invoice numbers were 8 (location prefix 2+6) now increase to 11 (location prefix 3+8)

Documents prefixed with location no. increased by 1 character e.g. purchase order, sales orders, GRN’s Debit Notes from 8 to 9

1st Edition,

It is the policy of BML (Office Computers) Limited, and its parents, to improve products as new technology, components, software and firmware become available. BML (Office Computers) Limited, and its parents, therefore, reserves the right to change specifications without prior notice.

All features, functions, and operations described herein may not be marketed by BML (Office Computers) Limited, and its parents, in all parts of the world. Therefore, before using this document, consult your system supplier for information that is applicable and current.

Copyright Notice

This document contains information which is proprietary to and considered a trade secret of BML (Office Computers) Limited, and its parents. It is expressly agreed that it shall not be reproduced in whole or part, disclosed, divulged or otherwise made available to any third party directly or indirectly. Reproduction of this document for any purpose is prohibited without the prior express written authorisation of BML (Office Computers) Limited, and its parents.

Disclaimer

BML (Office Computers) Limited, and its parents, makes no representation and no expressed or implied warranty of any kind with the regard to the documentation for any particular purpose. Whilst every effort has been made to ensure the accuracy of the documentation BML (Office Computers) Limited, and its parents, accepts no liability for any losses or consequential damages arising directly or indirectly from the use of the documentation.

BML (Office Computers) Limited, and its parents, reserves the right to amend this documentation without obligation to notify any person or organisation of any such amendments.

Index

CHAR 4

MAST 5

Company Code 5

Locations 5

Document Numbers 6

Location Company Links 6

USER 7

Nominal 10

Stock Nominal Integration 10

SKM17 10

Free Format 11

SLE1 Transactions 12

Stock Transactions 14

Miscellaneous 15

SKMEM/SLMEM/PLMEM 15

ZZ Programs 15

CHAR

The version 10 conversion routine writes a report to $dd_SPL/ROB005/VZ100. This file MUST be checked.

Users wishing to convert to version 10 must already be on version 93 or above.

MAST

Company Code

The company code has been extended from a single character alphanumeric code to a 3 character alphanumeric code. Any combination of alphanumeric codes may be used but special characters or embedded spaces will NOT be permitted, e.g.

Company No. : A C

09:16:13------

|Middle character cannot be a space|

|if third character is not a space |

------

Company No. : C-A

09:00:13------

|Middle character not valid - |

| |

| can only use the following: |

| ABCDEFGHIJKLMNOPQRSTUVWXYZ |

| abcdefghijklmnopqrstuvwxyz |

| 1234567890 |

------

Existing companies are converted moving the company code to the first character and space filling the remaining 2 characters.

Locations

Up to 999 locations may now be maintained (set in MAST Option 1).

No. extra stk locations: 999

Printers

The number of available printers (Option 9) has increased from 254 to 1000.

Document Numbers

When document numbers are not prefixed with the location number the invoice number and credit note number have increased from 6 characters to 8 characters. All other document numbers remain unchanged at a length of 6 characters.

Where document numbers are prefixed with the location number (Option13) all document numbers have increased by 1 character to accommodate the increased location number. The entry of 6 characters in MAST remains unchanged with the exception of invoices and credit note document numbers which have increased from 8 characters (location prefix 2+6) to 11 characters (location prefix 3+8). The entry of 8 characters for these document types has been incorporated.

Co:A Prog:MAST - Master file maintenance

Location address:

LOCATION 100

Post Code :

Vat Reg.No. :

Telephone No. :

Company Reg.No :

ANA Loc. Code : Source Term ID :

Document Numbers

Invoice : 60000004 Goods Receipt : 600011 Purchase Order : 600022

Credit Note : 00900000 Debit Note : 600002 Goods in : 600000

Sales Order : 600017 Specials : 600002

Back Order : 600003 Sales Enq. : 599996 Purchase Enq. : 600000

Crn Order No. : 900000 Transfers : 600005

Account :

Location Company Links

(Option 15) has been amended to accommodate the increased number of locations.

Printer Locations

(Option 16) has been amended to accommodate the increased number of locations.

USER

To accommodate the additional locations the USER maintenance program has changed substantially.

After entering the user id, 3 additional options are given by the way of function keys.

Co:A Prog:USER - Charisma* user access user_dlt Date:DD/MM/YY

USER-ID : ROB005

01234567890123456789012345678901234567890123456789

Location update ?: YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY more

Location enquiry?: YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY

YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY more

Company access : @ A ABC B C H L c h

Record - Deletion? Amendment? Insertion? File-print?

Y Y Y Y

Ledgers- Sales? Stock? Nominal? Purchase? S.O.P.? Misc?

Y Y Y Y Y Y

Password :SYSTEM Show cost price : Y Decimal is comma: N

Access level :9 Show profit : Y Show SP in SKE20: N

Menu name : Main location : 000

Log use :Y Tele rep code : 001

Default printer :NONE ID is cust a/c : N Incoming mail : Y

Box-drawing character :R Default scanner : 'Pop-up' help on: Y

f3 f4 f5

Update Lc Enq Locs Comp Acc

F3 maintains the locations available for update. The number of locations available is determined by the setting in MAST.

Up to 998 locations may be maintained.

Co:A Prog:USER - Charisma* user access user_dlt Date:DD/MM/YY

USER-ID : ROB005

Allow update on these location999 @ A

YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY

YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY ...... Y ......

......

...... Y

Location no: 000

Y to select - N to remove f1 - Accept f8 - Exit

F4 maintains the location enquiry available. The number of locations available is determined by the setting in MAST.

Co:A Prog:USER - Charisma* user access user_dlt Date:DD/MM/YY

USER-ID : ROB005

Allow enquiry/report on these 999 @ A

YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY

YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYY.YY

.YYYYYYYYY YYYYYYYYYY YYYYYYYYYY ...... Y ......

......

Location no: 000

Y to select - N to remove f1 - Accept f8 - Exit

F5 maintains the companies available to the user. When selecting this option the user will be prompted for a company code. If a company is entered which the user does not have access to, the program will prompt ‘Allow access to this Company’. If a company is entered which the user does have access to the program will prompt ‘Remove company access’

Co:A Prog:USER - Charisma* user access Date:DD/MM/YY

USER-ID : ROB005

has access to these companies

ABC

Company Code:

f5 f8

Search Exit

Nominal

Sub-heads

If you have main parms 'Is location = sub-head' - Y' then sub-head location nominal accounts are created automatically within NLM1 for the sales analysis nominal code, (set in MAST option 4) and the carriage nominal, (set in MAST option 6).

e.g. If 10 locations are in use the following nominal accounts are created automatically in NLM1. In version 9 subhead 100 is created for location 0.

123000 SALES
..123000001 SALES ANALYSIS
..123000002 SALES ANALYSIS
..123000003 SALES ANALYSIS
..123000004 SALES ANALYSIS
..123000005 SALES ANALYSIS
..123000006 SALES ANALYSIS
..123000007 SALES ANALYSIS
..123000008 SALES ANALYSIS
..123000009 SALES ANALYSIS
..123000010 SALES ANALYSIS
..123000100 SALES ANALYSIS

As version 10 accommodates a location of '100' we have amended the software to now use '999' for location 0. The invoice update routines have also been amended to facilitate this requirement.

When this functionality is being used, users upgrading to version 10 will need to be made aware of the amendment within version 10 and make the appropriate nominal journal from their sales account with a subhead '100' to the new sub head ‘999’.

Stock Nominal Integration

When Stock Nominal Integration is used there is a facility to automatically create a batch number for stock programs updating the nominal. This is determined by the parameter, ‘Auto location/dayno batch numbers’. The version 9 functionality uses the combination of the stock location and julian day number. In version 9 this equates to 2 chars for the location and 3 for the current day giving a total of 5 chars. It was not considered viable to permit the same functionality within version 10 as the increased location and date would exceed the current batch limit of 5 chars. The location has been removed from the creation of the batch number, thus leaving just the julian day number, all locations will update to the same batch. If a user’s requirement is to have separate batch numbers for locations then this parameter should not be switched to Yes, batch numbers should be entered manually. An alternate option is to update separate sub head nominal accounts for locations using the existing SKM17 functionality.

SKM17

In version 9 it was recommended that location 000 update to nominal sub account 100. As a location record may now exist for location 100 it is suggested that sub account 999 be used for location 000.

Free Format

To facilitate the reporting of increased field sizes, free format documentation will need amending accordingly. Fee format documentation is unique to each user, the below is only a guideline for the necessary changes. The reporting of All free format documentation should be checked.

Invoices / Credit Notes / Acknowledgements

Free format ‘Sales order number’ (H019) should be increased from 8 to 9 characters.

Free format ‘Transaction / Invoice number’ (H026) should be increased from 8 to 11 characters.

Free format ‘Sales order number’ (B105) should be increased from 8 to 9 characters.

Collation (B108/B109) ‘Delivered on your order number …’ should be increased from 8 to 9 characters.

Advice Notes / Confirmed Orders

Sales order number H043 increased from 8 to 9 characters.

Purchase order numbers

Free format ‘Purchase order number’ (H033) should be increased from 8 to 9 characters.

SLR1 Statements

Free format ‘Our Ref’ (B002) & (B031) should be increased from 8 to 11 characters.

PLR5 Remittance Advice Notes

Free format ‘Our Ref’ (B002) should be increased from 8 to 9 characters.

Debit Notes

Free format ‘Purchase order number’ (H021) should be increased from 8 to 9 characters.

Free format ‘G.R.N. number’ (H022) should be increased from 8 to 9 characters.

Free format ‘Debit note number’ (H024) should be increased from 8 to 9 characters.

Transfer Notes

Free format ‘Transfer Number’ (H018) should be increased from 8 to 9 characters.

Collection Notes

Free format ‘Sales order number’ (H043) should be increased from 8 to 9 characters.

Quotations

Free format ‘Enquiry number’ (H043) should be increased from 8 to 9 characters.

(V5FFCHK)

SLE1 Transactions

The display of sales transactions and historical transactions has been amended to incorporate the larger ‘Our Reference’ field, which holds the increased sales invoice number. To incorporate the larger filed a new toggle function has been introduced to change the display between Our Reference, Their Reference and Due Date

Co:ABC Prog:SLE1 - Sales enquiry tr_sel Date:DD/MM/YY

BML001 - BML (OFFICE COMPUTERS) LTD O/s: 146.87

Cur: 146.87 30-Day: 60-Day: 90+Day:

30 DAYS--|60 DAYS--|90 DAYS--|120+ DAYS|

29.37 117.50

Date Batch Type Our Ref Original Outstanding Balance

*05/July N05 INV OREF 117.50 117.50 117.50

21/July I21 INV 10060000006 29.37 29.37 146.87

Back Select Comments Inv.Hist Rec.Hist All trans f8Exit

History Diary Tran note XFax Stmt Query UTheirRef Locate Eof

Co:ABC Prog:SLE1 - Sales enquiry tr_sel Date:DD/MM/YY

BML001 - BML (OFFICE COMPUTERS) LTD O/s: 146.87

Cur: 146.87 30-Day: 60-Day: 90+Day:

30 DAYS--|60 DAYS--|90 DAYS--|120+ DAYS|

29.37 117.50

Date Batch Type Their ref Original Outstanding Balance

*05/July N05 INV BML002 117.50 117.50 117.50

21/July I21 INV SM/1234 29.37 29.37 146.87

Back Select Comments Inv.Hist Rec.Hist All trans f8Exit

History Diary Tran note XFax Stmt Query UDue date Locate Eof

Co:ABC Prog:SLE1 - Sales enquiry tr_sel Date:DD/MM/YY

BML001 - BML (OFFICE COMPUTERS) LTD O/s: 146.87

Cur: 146.87 30-Day: 60-Day: 90+Day:

30 DAYS--|60 DAYS--|90 DAYS--|120+ DAYS|

29.37 117.50

Date Batch Type Due Date Original Outstanding Balance

*05/July N05 INV 05/July 117.50 117.50 117.50

21/July I21 INV 21/July 29.37 29.37 146.87

Back Select Comments Inv.Hist Rec.Hist All trans f8Exit

History Diary Tran note XFax Stmt Query UOur Ref WAmnd Due Locate

Converted transactions

Invoice numbers have been increased from 8 characters to 11 characters. V9 = (location prefix 2 + 6), V10 (location prefix 3 + 8).

All other document numbers such as order numbers, purchase order numbers, back order numbers, GRN's etc have increased from 8 characters to 9 characters to accommodate the increase of location number.

For example where an invoice was 01286282 the new format will be 00100286282.

For conformity existing invoice history, sales transactions and stock transactions are also converted.

e.g. before

Co:B Prog: SLE1 - Sales enquiry Date:DD/MM/YY

BML001 – BML ACCOUNT O/s: 1434.37

Cur: 435.62 30-Day: 998.75 60-Day: 90+Day:

Date Batch Type Our ref Their ref Original Outstanding Balance

23/12/04 DWM12 INV 01285065 NI4346 998.75 998.75 998.75

07/Jan W0701 INV 01285517 CONSIGNM 269.05 269.05 1267.80

14/Jan W1401 INV 01285892 N-14433 66.97 66.97 1334.77

21/Jan W2101 INV 01286282 N-14433 99.60 99.60 1434.37

after

Co:B Prog:SLE1 - Sales enquiry Date:DD/MM/YY

BML001 – BML ACCOUNT O/s: 1434.37

Cur: 435.62 30-Day: 998.75 60-Day: 90+Day:

Date Batch Type Our Ref Original Outstanding Balance

23/12/04 DWM12 INV 00100285065 998.75 998.75 998.75

07/Jan W0701 INV 00100285517 269.05 269.05 1267.80

14/Jan W1401 INV 00100285892 66.97 66.97 1334.77