Setting up and Configuring NEOSYS Agency System: Difference between revisions

From NEOSYS User Support Wiki
Jump to navigationJump to search
No edit summary
 
(41 intermediate revisions by 6 users not shown)
Line 1: Line 1:
== Importing Clients ==
== Importing Clients ==
WARNING: You MUST trial out importing in test database first, otherwise you risk messing up your live database clients.


Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.
Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.


In the NEOSYS system, clients are separate from accounts receivable because a client record may be created for preparing a quotation before an accounts receivable account is opened for the client. Also it is possible for more than one client to feed into a single account receivable. In other words "clients" are not necessarily one to one with accounts receivable in NEOSYS - although in most cases they are.
In the NEOSYS system, clients are separate from accounts receivable because a client record may be created for preparing a quotation before accounts receivable account is opened for the client. Also, it is possible for more than one client to feed into a single account receivable. In other words "clients" are not necessarily one to one with accounts receivable in NEOSYS - although in most cases they are.


You can either prepare separate files for clients and accounts/addresses or a single file that contains all columns for both in one file.
You can either prepare separate files for clients and accounts/addresses or a single file that contains all columns for both in one file.


The import file must be in tab delimited text format and its name must be a maximum of eight characters with no spaces and a three character extension.
The import file must be in tab-delimited text format and its name must be a maximum of eight characters with no spaces and a three character extension.


Import must currently be done on the server in NEOSYS maintenance mode and F5.
Import must currently be done on the server in NEOSYS maintenance mode and F5.
Line 14: Line 16:


*CLIENT CODE - required
*CLIENT CODE - required
*CLIENT NAME - required
*CLIENT NAME or ACCOUNT NAME - required
*CLIENT ADDRESS - optional, one line "quick contact 'address'" to show on top of quotes, may not contain full address and possibly is just a contact name and/or tel/email numbers instead of actual address.
*CLIENT ADDRESS - optional, one line "quick contact 'address'" to show on top of quotes, may not contain the full address and possibly is just a contact name and/or tel/email numbers instead of actual address.
*CLIENT EMAIL - optional
*MARKET CODE - required, must exist in Markets File
*MARKET CODE - required, must exist in Markets File
*ACCOUNT NO - optional, must exist in a chart of accounts
*ACCOUNT NO - optional, must exist in a chart of accounts
*EXECUTIVE - optional
*EXECUTIVE - optional
*EMAIL - optional
*CURRENCY CODE - optional, usual currency of billings
*AGENCY FEE - optional, usual fee percent eg 12.5 or 12.5%
*CLIENT TERMS - optional, free format text to be put at the bottom of invoices, override computer generated terms text from account terms.
*CLIENT TERMS - optional, free format text to be put at the bottom of invoices, override computer generated terms text from account terms.
*CLIENT GROUP1 CODE - optional, client code must exist prior to importing. Could be manually entered or imported in a separate file if too many.
*CLIENT GROUP1 CODE - optional, client code must exist prior to importing. Could be manually entered or imported in a separate file if too many.
Line 29: Line 33:
*CLIENT ALIAS CODE (the id, number or code of the client for interfacing to other systems)
*CLIENT ALIAS CODE (the id, number or code of the client for interfacing to other systems)


Multiple other systems can be represented as follows. For example if a client is represented in a system called SAP by the code 1235123 and also in the old system by the code DE767676 then you would put the following information in the import file columns. The space before the 1,2 etc is mandatory but the colon must be omitted. The column name is not case sensitive.
Multiple other systems can be represented as follows. For example, if a client is represented in a system called SAP by the code 1235123 and also in the old system by the code DE767676 then you would put the following information in the import file columns. The space before the 1,2 etc is mandatory but the colon must be omitted. The column name is not case sensitive.


*CLIENT ALIAS SYSTEM 1: SAP
*CLIENT ALIAS SYSTEM 1: SAP
Line 35: Line 39:
*CLIENT ALIAS SYSTEM 2: OLD
*CLIENT ALIAS SYSTEM 2: OLD
*CLIENT ALIAS CODE 2: DE767676
*CLIENT ALIAS CODE 2: DE767676
Up to 9 aliases may be imported in this way.


=== Importing ===
=== Importing ===


In the following example it is assumed that you have prepared a file called CLIENTS.TXT.
In the following example, it is assumed that you have prepared a file called CLIENTS.TXT.


If you are going to link the clients to the accounts receivable (by filling in the account number on every client), you must first import the accounts. This simplest way to do this is to add accounts columns to the CLIENTS.TXT file as per instructions in the accounts module for importing accounts and import the CLIENTS.TXT file into the accounts module. See http://userwiki.neosys.com/index.php/Importing_Accounts_and_Addresses
If you are going to link the clients to the accounts receivable (by filling in the account number on every client), you must first import the accounts. This simplest way to do this is to add accounts columns to the CLIENTS.TXT file as per instructions in the accounts module for importing accounts and import the CLIENTS.TXT file into the accounts module. See [[Importing Accounts and Addresses]]


First verify that the clients can be imported and correct any errors before proceeding
First, verify that the clients can be imported and correct any errors before proceeding


  IMPORTX D:\CLIENTS.TXT CLIENTS
  IMPORTX D:\CLIENTS.TXT CLIENTS


Import the clients
Actually import the clients with the C option (Create)


  IMPORTX D:\CLIENTS.TXT CLIENTS (C)
  IMPORTX D:\CLIENTS.TXT CLIENTS (C)
Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.


Get a List of Clients to verify that the clients have been correctly imported.
Get a List of Clients to verify that the clients have been correctly imported.


== Importing Suppliers ==
== Importing Suppliers ==
WARNING: You should trial out importing on the test database first.


Please follow the notes on importing clients except for the columns in the file.
Please follow the notes on importing clients except for the columns in the file.


If you are importing media suppliers then there is a alternative special procedure for importing suppliers and media vehicles that may be more more helpful in that case. See [[Using_NEOSYS_Media_System#Importing_Supplier_and_Vehicles]]
If you are importing media suppliers then there is an alternative special procedure for importing suppliers and media vehicles that may be more helpful in that case. See [[Setting_up_and_Configuring_NEOSYS_Media_System#Importing_Suppliers_and_Vehicles|Importing Suppliers and Vehicles]]


=== SUPPLIER COLUMNS ===
=== SUPPLIER COLUMNS ===
Line 67: Line 77:
*CONTACT NUMBERS - optional, used for orders
*CONTACT NUMBERS - optional, used for orders
*CONTACT EMAIL - optional, used for orders
*CONTACT EMAIL - optional, used for orders
*ACCOUNT NO - optional, used for accrued costs if the system is configured to accrue by supplier.
*ACCOUNT NO - optional, used for accrued costs if the system is configured to accrue by the supplier.
*SUPPLIER GROUP CODE - optional, supplier code must exist prior to importing. Could be manually entered or imported in a separate file if too many.
*SUPPLIER GROUP CODE - optional, supplier code must exist prior to importing. Could be manually entered or imported in a separate file if too many.


Line 75: Line 85:
*SUPPLIER ALIAS CODE (the id, number or code of the supplier for interfacing to other systems)
*SUPPLIER ALIAS CODE (the id, number or code of the supplier for interfacing to other systems)


Multiple other systems can be represented as follows. For example if a supplier is represented in a system called SAP by the code 1235123 and also in the old system by the code DE767676 then you would put the following information in the import file columns. The space before the 1,2 etc is mandatory but the colon must be omitted. The column name is not case sensitive.
Multiple other systems can be represented as follows. For example, if a supplier is represented in a system called SAP by the code 1235123 and also in the old system by the code DE767676 then you would put the following information in the import file columns. The space before the 1,2 etc is mandatory but the colon must be omitted. The column name is not case sensitive.


*SUPPLIER ALIAS SYSTEM 1: SAP
*SUPPLIER ALIAS SYSTEM 1: SAP
Line 82: Line 92:
*SUPPLIER ALIAS CODE 2: DE767676
*SUPPLIER ALIAS CODE 2: DE767676


== Giving Production Executives (or other Groups) Access to Media Invoices ==
Up to 9 aliases may be imported in this way.


In the Authorisation File:
# In the Tasks section, sort the tasks alphabetically by the lock column (click on the column heading) and check that the code "AMI" is not used already for any lock code. We suggest the code AMI to remind us that this lock represents "access media invoices" - rather like AM is commonly used to represent "access media". If you choose any other code instead of AMI then substitute the code you decide on for AMI in the following instructions.
# In the Tasks section, change the lock next to the MEDIA INVOICE ACCESS task to be AMI.
# Add the key AMI to the list of keys for each of the user groups (not each of the users) that previously had access to media invoices (eg finance, media etc) and also include it in the list of keys for the user group for Production Executive (or other groups) that you wish to enable.
# In the Users section, next to '''every''' user who is to have access to media invoices, use the popup to change the menu to be "Production Media" if they had "Production" before or to "Production Media Management" if they had "Production Management" before. Management gives them access to the billing analysis reports subject to further authorisations.


== Converting database to "invoice numbering per company" ==
== Converting database to "invoice numbering per company" ==


On the Media/Jobs Configuration File the field "Invoice number sequence per company"  cannot be changed after data has been entered in the the database. In other words it has to be predecided.
On the Media/Jobs Configuration File the field "Invoice number sequence per company"  cannot be changed after data has been entered in the database. In other words, it has to be pre-decided.


However you may be able to change it as follows:
However, you may be able to change it as follows:


WARNING This program is not frequently used or recently tested and may have defects. The resultant database must be tested thoroughly otherwise severe loss of data may occur.
WARNING This program is not frequently used or recently tested and may have defects. The resultant database must be tested thoroughly otherwise severe loss of data may occur.
Line 103: Line 107:
  F5
  F5
  AGP
  AGP
  edit line 48 to be 1
  edit line 48 to be 1 (To confirm you are on field 48 press CTRL+E)


  F5
  F5
Line 121: Line 125:
#Ensure that company code is part of the job/order/estimate number format
#Ensure that company code is part of the job/order/estimate number format


== Converting database to "one invoice number sequence across all companies" ==


== Converting database to "one invoice number sequence accross all companies" ==
On the Media/Jobs Configuration File the field "Invoice number sequence per company" cannot be changed after data has been entered in the database. In other words, it has to be pre-decided.


On the Media/Jobs Configuration File the field "Invoice number sequence per company"  cannot be changed after data has been entered in the the database. In other words it has to be predecided.
However, you may be able to change it as follows:
 
However you may be able to change it as follows:


WARNING This program is not frequently used or recently tested and may have defects. The resultant database must be tested thoroughly otherwise severe loss of data may occur.
WARNING This program is not frequently used or recently tested and may have defects. The resultant database must be tested thoroughly otherwise severe loss of data may occur.
Line 139: Line 142:
  CONVINVBYCOMP UNDO
  CONVINVBYCOMP UNDO


== Changing invoice number pattern ==
 
 
== Changing Document Numbering Pattern ==
=== Principles of Document Numbering in NEOSYS ===
Structuring invoice and document numbers is good practice since the documents order correctly when sorted in NEOSYS and even when exported to other systems like Excel – and even when entered into third party systems at suppliers and clients where NEOSYS has no control.
 
There are a few principles which can help while deciding on the structure:
#Best practice is to only have sequential numbering
#Enter things that change least frequently (or not at all) more to the left of the structure.
#Items like sequential numbers must be separated with/from other parts of the structure because sequential numbers in NEOSYS generally do not have leading zeros and therefore can have a variable number of digits.
#To make easier to read and type, consider omitting the / character between parts of the structure that have constant number of characters like company code and two digit year
#Omit prefixes like SCH, JOB, EST, PO, INV etc while numbering documents as it is inconvenient having to enter those letters over and over again every time you want to access a document
 
For example, if we have company codes like A, B, C, the year 2012, number  1000 then a good numbering system will sort correctly in all cases while a poor format will not sort correctly in some cases.  Refer link [http://userwiki.neosys.com/index.php/Using_NEOSYS_Agency_System#Putting_Year_in_Document_Numbers Putting year in Document Numbers]
 
Good Format Examples:
*1000  - Best practice
*X1000 - use when multi-company setup is used
*12/1000 - use when year is required in document numbering
*X12/1000 – also ok, X and 12 are both fixed number of characters so don’t need / to separate X and 12
 
Poor Format Examples:
*X/121000 – sequential number should be separated from year by /
*X121000 – sequential number should be separated from year by /
*12/X/1000 – year changes more frequently than company code X so it should be X/12
*X/1000/12 – 12 changes less frequently than 1000 so it should be 12/1000
*1000/12/X – X changes least so it should be on the left. 1000 changes most so it should be on the right
*12/1000/X – X changes least so it should be on the left
*EST1000 - Omit prefixes as it has to be entered every time while trying to access a document
 
''Notes -''
#Company prefix can be assigned to NEOSYS companies in the Company File. This is particularly useful if the company codes are digits and can be confused with the sequential numbers.
#Using letters for company codes or company prefix is better for sorting because one can omit the / separator character.
#Sequential numbers in NEOSYS generally have a variable number of digits and do not use leading zeros.
#In some places in NEOSYS when asked to enter document numbers, omit the company code and year and enter only the sequential number, NEOSYS will find the document based on the current company and year or search for the first existing document across all companies. The same applies with entering ranges of numbers. NEOSYS will attempt to add the missing company code and year.
 
=== How to Configure ===
This can only be configured for the whole system so that it can only be done only once all of the old invoices for previous years are done. You can also do it in the middle of the year if you are happy for the rest of the invoices for the current year to be in the new format and probably using a different invoice number sequence.
This can only be configured for the whole system so that it can only be done only once all of the old invoices for previous years are done. You can also do it in the middle of the year if you are happy for the rest of the invoices for the current year to be in the new format and probably using a different invoice number sequence.
 
When you are ready for the next invoice (regardless of year!) to come out in the new format you can do the following:
ED AGENCY.PARAMS
line 49 for media invoice pattern
line 50 for production invoice pattern
Examples:
Examples:
   
   
<COMPANY><YEAR>/<NUMBER>         would give invoices something like XX2006/1
<NUMBER>                   would give numbers like 1000


<NUMBER>/<YEAR2>          would give invoices starting like 1/06
<COMPANY><NUMBER>          would give numbers like X1000 


<NUMBER>                   this is the default and provides continuous invoice numbers even across years
<COMPANY><YEAR2>/<NUMBER> would give numbers like X12/1000
   
   
Possible codes are:
 
 
where,
<NUMBER>    provides the usual sequence number
 
<NUMBER>    provides the usual sequence number ( NUMBER is set in [[Invoice_Numbering| Invoice Numbering file]] ) <br><COMPANY>   provides the company code or company prefix from the company file <br><YEAR>     provides the year in 4 digit form e.g. 2012
<COMPANY> provides the company code or company prefix from the company file
 
<YEAR>       provides the year in four digit form e.g. 2006


<YEAR2>    provides the year in two digit form e.g. 06
  '''IMPORTANT NOTES''':  
 
(1) DOING THIS WOULD RE-CREATE THE INVOICE NUMBERS TO START FROM 1
  '''IMPORTANT NOTES''': (1) DOING THIS WOULD RE-CREATE THE INVOICE NUMBERS TO START FROM 1
  (2) THE <YEAR>/<YEAR2> WOULD CHANGE TO THE NEXT YEAR ONLY WHEN YOU HAVE THE NEW INVOICES IN THE
  (2) THE <YEAR>/<YEAR2> WOULD CHANGE TO THE NEXT YEAR ONLY WHEN YOU HAVE THE NEW INVOICES IN THE
  NEW YEAR DATE AND THE NUMBER WOULD RESET ITSELF TO START FROM 1
  NEW YEAR DATE AND THE NUMBER WOULD RESET ITSELF TO START FROM 1


New option in the Configuration File, Invoice Number Format called <YEARWISE> which allows you to specify a different starting invoice number for each year in the Invoice Menu, Invoice Numbering screen. An invoice number format of <NUMBER><YEARWISE> means that while the year does not form part of the invoice number (as would be the case if the invoice number format was say <NUMBER>/<YEAR2>) you can use different ranges of invoice numbers for each year. This prevents the mixing up of invoice numbers between years.
New option in the Configuration File, a Format called <YEARWISE> which allows you to specify a different starting number for each year. An invoice number format of <NUMBER><YEARWISE> means that while the year does not form part of the invoice number (as would be the case if the invoice number format was say <NUMBER>/<YEAR2>) you can use different ranges of invoice numbers for each year. This prevents the mixing up of invoice numbers between years.
 
== [[Invoice_Numbering | Configuring Starting Numbers of Documents]] ==


== How are wip/accrual ledgers structured ? ==  
== How are wip/accrual ledgers structured ? ==  


Wip/accrual accounts are usually automatically created per schedule or job although they can be configured to be per supplier or media vehicle.
WIP/accrual accounts are usually automatically created per schedule or job although they can be configured to be per supplier or media vehicle.


The exact ledger code can be configured in Media Configuration File or Jobs Configuration File.  
The exact ledger code can be configured in Media Configuration File or Jobs Configuration File.  


If there are many schedules or jobs then new wip/accrual ledgers are automatically created when the current one gets too large (too many accounts).
If there are many schedules or jobs then new WIP/accrual ledgers are automatically created when the current one gets too large (too many accounts).


Eg: For 2011 the ledger codes might be:
Eg: For 2011 the ledger codes might be:

Latest revision as of 06:23, 15 May 2018

Importing Clients

WARNING: You MUST trial out importing in test database first, otherwise you risk messing up your live database clients.

Before you start importing anything make sure that you use the clearing procedure to clear down any old data first.

In the NEOSYS system, clients are separate from accounts receivable because a client record may be created for preparing a quotation before accounts receivable account is opened for the client. Also, it is possible for more than one client to feed into a single account receivable. In other words "clients" are not necessarily one to one with accounts receivable in NEOSYS - although in most cases they are.

You can either prepare separate files for clients and accounts/addresses or a single file that contains all columns for both in one file.

The import file must be in tab-delimited text format and its name must be a maximum of eight characters with no spaces and a three character extension.

Import must currently be done on the server in NEOSYS maintenance mode and F5.

CLIENT columns

  • CLIENT CODE - required
  • CLIENT NAME or ACCOUNT NAME - required
  • CLIENT ADDRESS - optional, one line "quick contact 'address'" to show on top of quotes, may not contain the full address and possibly is just a contact name and/or tel/email numbers instead of actual address.
  • CLIENT EMAIL - optional
  • MARKET CODE - required, must exist in Markets File
  • ACCOUNT NO - optional, must exist in a chart of accounts
  • EXECUTIVE - optional
  • CURRENCY CODE - optional, usual currency of billings
  • AGENCY FEE - optional, usual fee percent eg 12.5 or 12.5%
  • CLIENT TERMS - optional, free format text to be put at the bottom of invoices, override computer generated terms text from account terms.
  • CLIENT GROUP1 CODE - optional, client code must exist prior to importing. Could be manually entered or imported in a separate file if too many.
  • CLIENT GROUP2 CODE - optional, client code must exist prior to importing. Could be manually entered or imported in a separate file if too many.

and optional links to other systems ...

  • CLIENT ALIAS SYSTEM (a codeword to identify the other system eg SAP, ORACLE, OLD etc.)
  • CLIENT ALIAS CODE (the id, number or code of the client for interfacing to other systems)

Multiple other systems can be represented as follows. For example, if a client is represented in a system called SAP by the code 1235123 and also in the old system by the code DE767676 then you would put the following information in the import file columns. The space before the 1,2 etc is mandatory but the colon must be omitted. The column name is not case sensitive.

  • CLIENT ALIAS SYSTEM 1: SAP
  • CLIENT ALIAS CODE 1: 1235123
  • CLIENT ALIAS SYSTEM 2: OLD
  • CLIENT ALIAS CODE 2: DE767676

Up to 9 aliases may be imported in this way.

Importing

In the following example, it is assumed that you have prepared a file called CLIENTS.TXT.

If you are going to link the clients to the accounts receivable (by filling in the account number on every client), you must first import the accounts. This simplest way to do this is to add accounts columns to the CLIENTS.TXT file as per instructions in the accounts module for importing accounts and import the CLIENTS.TXT file into the accounts module. See Importing Accounts and Addresses

First, verify that the clients can be imported and correct any errors before proceeding

IMPORTX D:\CLIENTS.TXT CLIENTS

Actually import the clients with the C option (Create)

IMPORTX D:\CLIENTS.TXT CLIENTS (C)

Option O can be used to overwrite (destroy!) existing records. Use with extreme caution and at your own risk.

Get a List of Clients to verify that the clients have been correctly imported.

Importing Suppliers

WARNING: You should trial out importing on the test database first.

Please follow the notes on importing clients except for the columns in the file.

If you are importing media suppliers then there is an alternative special procedure for importing suppliers and media vehicles that may be more helpful in that case. See Importing Suppliers and Vehicles

SUPPLIER COLUMNS

  • SUPPLIER CODE - required
  • SUPPLIER NAME - required
  • SUPPLIER ADDRESS - optional, one line short address for orders
  • MEDIA NONMEDIA - required, "M" for Media Supplier, "P" for Non-media Supplier, "MP" for suppliers that need to work in both the media and jobs module of NEOSYS.
  • CONTACT NAME - optional, used for orders
  • CONTACT NUMBERS - optional, used for orders
  • CONTACT EMAIL - optional, used for orders
  • ACCOUNT NO - optional, used for accrued costs if the system is configured to accrue by the supplier.
  • SUPPLIER GROUP CODE - optional, supplier code must exist prior to importing. Could be manually entered or imported in a separate file if too many.

and optional links to other systems ...

  • SUPPLIER ALIAS SYSTEM (a codeword to identify the other system eg SAP, ORACLE, OLD etc.)
  • SUPPLIER ALIAS CODE (the id, number or code of the supplier for interfacing to other systems)

Multiple other systems can be represented as follows. For example, if a supplier is represented in a system called SAP by the code 1235123 and also in the old system by the code DE767676 then you would put the following information in the import file columns. The space before the 1,2 etc is mandatory but the colon must be omitted. The column name is not case sensitive.

  • SUPPLIER ALIAS SYSTEM 1: SAP
  • SUPPLIER ALIAS CODE 1: 1235123
  • SUPPLIER ALIAS SYSTEM 2: OLD
  • SUPPLIER ALIAS CODE 2: DE767676

Up to 9 aliases may be imported in this way.


Converting database to "invoice numbering per company"

On the Media/Jobs Configuration File the field "Invoice number sequence per company" cannot be changed after data has been entered in the database. In other words, it has to be pre-decided.

However, you may be able to change it as follows:

WARNING This program is not frequently used or recently tested and may have defects. The resultant database must be tested thoroughly otherwise severe loss of data may occur.

In maintenance mode with no other processes open on the same database

F5
AGP
edit line 48 to be 1 (To confirm you are on field 48 press CTRL+E)
F5
CONVINVBYCOMP (U)

Check the conversion worked

ED INVOICES *

Look to see in the top centre of the screen it should say something like X999999**Z. The ** must be present and the Z will be one of your company codes.

Allowing separate job/order/estimate number sequences

Job, Order and Estimate numbers can only have separate sequential numbers per company if COMPANY is part of the number format in the Job Configuration File and.

  1. Verify you have Invoice Numbering by Company enabled
  2. Ensure that company code is part of the job/order/estimate number format

Converting database to "one invoice number sequence across all companies"

On the Media/Jobs Configuration File the field "Invoice number sequence per company" cannot be changed after data has been entered in the database. In other words, it has to be pre-decided.

However, you may be able to change it as follows:

WARNING This program is not frequently used or recently tested and may have defects. The resultant database must be tested thoroughly otherwise severe loss of data may occur.

In maintenance mode

F5
AGP
edit line 48 to be blank or 0
F5
CONVINVBYCOMP UNDO


Changing Document Numbering Pattern

Principles of Document Numbering in NEOSYS

Structuring invoice and document numbers is good practice since the documents order correctly when sorted in NEOSYS and even when exported to other systems like Excel – and even when entered into third party systems at suppliers and clients where NEOSYS has no control.

There are a few principles which can help while deciding on the structure:

  1. Best practice is to only have sequential numbering
  2. Enter things that change least frequently (or not at all) more to the left of the structure.
  3. Items like sequential numbers must be separated with/from other parts of the structure because sequential numbers in NEOSYS generally do not have leading zeros and therefore can have a variable number of digits.
  4. To make easier to read and type, consider omitting the / character between parts of the structure that have constant number of characters like company code and two digit year
  5. Omit prefixes like SCH, JOB, EST, PO, INV etc while numbering documents as it is inconvenient having to enter those letters over and over again every time you want to access a document

For example, if we have company codes like A, B, C, the year 2012, number 1000 then a good numbering system will sort correctly in all cases while a poor format will not sort correctly in some cases. Refer link Putting year in Document Numbers

Good Format Examples:

  • 1000 - Best practice
  • X1000 - use when multi-company setup is used
  • 12/1000 - use when year is required in document numbering
  • X12/1000 – also ok, X and 12 are both fixed number of characters so don’t need / to separate X and 12

Poor Format Examples:

  • X/121000 – sequential number should be separated from year by /
  • X121000 – sequential number should be separated from year by /
  • 12/X/1000 – year changes more frequently than company code X so it should be X/12
  • X/1000/12 – 12 changes less frequently than 1000 so it should be 12/1000
  • 1000/12/X – X changes least so it should be on the left. 1000 changes most so it should be on the right
  • 12/1000/X – X changes least so it should be on the left
  • EST1000 - Omit prefixes as it has to be entered every time while trying to access a document

Notes -

  1. Company prefix can be assigned to NEOSYS companies in the Company File. This is particularly useful if the company codes are digits and can be confused with the sequential numbers.
  2. Using letters for company codes or company prefix is better for sorting because one can omit the / separator character.
  3. Sequential numbers in NEOSYS generally have a variable number of digits and do not use leading zeros.
  4. In some places in NEOSYS when asked to enter document numbers, omit the company code and year and enter only the sequential number, NEOSYS will find the document based on the current company and year or search for the first existing document across all companies. The same applies with entering ranges of numbers. NEOSYS will attempt to add the missing company code and year.

How to Configure

This can only be configured for the whole system so that it can only be done only once all of the old invoices for previous years are done. You can also do it in the middle of the year if you are happy for the rest of the invoices for the current year to be in the new format and probably using a different invoice number sequence.

Examples:

<NUMBER>                    would give numbers like 1000
<COMPANY><NUMBER>          would give numbers like X1000  

<COMPANY><YEAR2>/<NUMBER>  would give numbers like X12/1000

 

where,

<NUMBER> provides the usual sequence number ( NUMBER is set in Invoice Numbering file )
<COMPANY> provides the company code or company prefix from the company file
<YEAR> provides the year in 4 digit form e.g. 2012

IMPORTANT NOTES: 
(1) DOING THIS WOULD RE-CREATE THE INVOICE NUMBERS TO START FROM 1
(2) THE <YEAR>/<YEAR2> WOULD CHANGE TO THE NEXT YEAR ONLY WHEN YOU HAVE THE NEW INVOICES IN THE
NEW YEAR DATE AND THE NUMBER WOULD RESET ITSELF TO START FROM 1

New option in the Configuration File, a Format called <YEARWISE> which allows you to specify a different starting number for each year. An invoice number format of <NUMBER><YEARWISE> means that while the year does not form part of the invoice number (as would be the case if the invoice number format was say <NUMBER>/<YEAR2>) you can use different ranges of invoice numbers for each year. This prevents the mixing up of invoice numbers between years.

Configuring Starting Numbers of Documents

How are wip/accrual ledgers structured ?

WIP/accrual accounts are usually automatically created per schedule or job although they can be configured to be per supplier or media vehicle.

The exact ledger code can be configured in Media Configuration File or Jobs Configuration File.

If there are many schedules or jobs then new WIP/accrual ledgers are automatically created when the current one gets too large (too many accounts).

Eg: For 2011 the ledger codes might be:

ACC11, ACC112, ACC113

Or

WIP11, WIP112, WIP113

NEOSYS also opens up new year charts based on the old year charts ie same control a/c etc. Eg:

ACC12 from ACC11

or

WIP12 from WIP11