Spectrum - Business Management Software

SpectrumUpdate -4th October, 2016 (SpectrumUpdate-Ver-3-06-016.exe)

Click here to Download Updates >>>

This version can be used by only those clients who have purchased software after 01/05/2015 or customers who are under maintenance contract with Microbrain or it’s authorised dealers.

Steps for Computer connected to the Internet:

	Close Application

	Start Spectrum Update by Clicking on Start - All Programs – Microbrain - Spectrum
	Update menu item OR Click on Spectrum Agent Icon (Clock) Appear at System Tray & click on Open Spectrum Live Update Control Centre.

	Click on CheckForUpdate Button, It will check if any new version is available, if found then it will display release notes.

	To Update latest version click on Update Now Button, It will download update files. After update files are downloaded successfully InstallShield Wizard will
	Start process and will prompt again for update. Here you click on update button and new version will be updated on you computer.

Steps when None of the computers are connected to the Internet:

	Download SpectrumUpdate-Ver-3-06-016.exe file in any removable disk.

	Copy SpectrumUpdate-Ver-3-06-016.exe file in
	D:\Microbrain\LiveUpdate\Updates folder. If you are using Professional multi-user edition then copy it in (Server)\Microbrain\LiveUpdate\Updates folder.

	Run SpectrumUpdate-Ver-3-06-016.exe file & check if
	D:\Microbrain\LiveUpdate\Updates folder has been selected to extract files and just click on UnZip Button & it will extract 3 or more files.

	Please run SU-Ver-3-06-016.exe file to Install updates on computer.

	In network environment if you want to install same updates on remaining computer
	then please check that (Server D Drive) where Updates are downloaded has been defined in Setting of Spectrum Update. If yes then just perform step No. 1 on remaining computer.

Top

Release Notes:

	Note: This Version requires a change in database structure, So please take backup first before installing the updates.


	4th October 2016 – Version 3.6.16

	Accounting, Inventory & Order Module:
	• New concept of account access rights to branch has been provided. Now supervisor is not required to enter branch details in opening balance in account master for account access rights, supervisor has to just select required branch for access rights else don’t select any branch if account is free to access by any branch.
	• Now eTDS file will be generated for TDS FVU 5.2
Top
	17th August 2016 – Version 3.5.15

	Accounting, Inventory & Order Module:
	• Now user can change size of master and data entry window, but it will not affect font size.
	• New concept of Item access rights to store has been provided. Now supervisor is not required to enter dummy item details in stock details in item master for item access rights, supervisor has to just select required store for access rights else don’t select any store if item is free to access by any store.
	• New direct mail sending features has provided, with this user can send mail without mail client like Microsoft Outlook, Outlook Express, Windows Live Mail etc. (Only mail accounts which work in mail client like Microsoft Outlook.)
	• If company doesn’t have any branch and user is not supervisor then while entering expense item costing it displays message you don’t have branch right. Now solved.
	• In any new entry if user clicks on print button without saving entry and after printing he immediately deletes the entry then program was not d-updating entry. Now solved.
	• If user is not supervisor then in sales/purchase enquiry & quotation report it was displaying error StoreCode column not found. Now solved.
	• In account confirmation letter if details reached to footer then footer prints on total. Now solved.
	• If document no. was having any special character then it was displaying error if user clicks on export to file. Now solved.
	• In one purchase bill if there is Pharma RG Item with multiple batch and if any batch is totally sold then in next year it was displaying balance item twice in RG 23D register. Now solved.
	• Now in DO, Challan & Invoice program will display stock quantity in pending order list.
	• In credit note entry if user has not selected gatepass details and user is entering gatepass documents in reference document no. then program was picking and saving gatepass details in that credit note. Now solved.
	• In pending ADI claim reports, if user has entered same document no. in all items then it was displaying duplicate records. Now solved.
	• In Windows 7 & above with new updates, if user select customised reports then it was displaying error. Now solved.
	• If user is not supervisor then in salesman commission report it was displaying error StoreCode column not found. Now solved.
	• Now in ADI claim entry program will display all items of bill of entry even if it is not sold.
	• If there is a multiple batch in bill of entry and first batch was totally sold then in Annexure A of ADI claim report, it was displaying improper quantity. Now solved.
	• In some case when we convert to less round it was reducing value of last decimal place. Now solved.
	• In all register if user don’t enter single branch then branch column will add automatically.
	• Now program will not allowed to enter zero quantity in goods receipt entry if expense item costing entry has done.
	• Now from status enquiry option, user can’t zoom to entry level if user doesn’t have rights for the same entry. In billwise item ledger, issue detail was not printing on document no. wise, now solved.
	• When we skip printer dialog box then it was not printing dos style format properly on laser printer, now solved.
	• In expense item costing entry, it was not displaying issue entry, now solved.
	• Now user can take opening reconcilation from start reconciliation date also.
	• In purchase and salenote entry, if user changes TDS % and TDS on then in edit mode it again pickup from master and change the TDS on, now solved.
	• In expense register if user selects account column and doesn’t select account wise column then amount was rounding to zero decimal, now solved.
	• In salenote entry if users enter party in which TDS is applicable and while editing if user changes party in which TDS is not applicable then program is not allowing to remove TDS information and it stores against that party, now solved.

	Manufacturing Excise Module:
	• In ER1 if there is no production entry and only credit note entry is there then it was not displaying details. Now solved.
	• In supplier credit note entry if user changes branch then post in modvat is enabling. Now solved.
	• In RG1 if user changes order from itemwise to excisewise and item has selected then it was displaying error. Now solved.
	• Now in status enquiry in excise statement & item details user can view only balance stock items.
	• In excise duty summary, new column arrears of duty added which will show if any duty of prior period is yet to be debited.
	• New option for printing of excise code in all excise reports like R.G.23A Part I, R.G23C Part I, RG1, Form IV, Excise Stock summary.
	• Added F3 help in all fields where Serial No. of RG23A/C Part I/Form IV/ RG1 and Serial no. of duty books like RG23A/C Part II, PLA & Service Tax Register, which will show the used serial nos of previous entries.
	• In Check database a new checking for documents posted but not found in excise ledger added.
	• Maximum value of amount columns in TR6 Challan increased to 99 Crores.
	• Bank code used in TR6 Challan, it was necessary to open the code in bank master also. Now that is removed. Checking in Bank Master is removed. Now it will only check in account master.
	• In RG23A/C Part I, When Print Daily summary of issues is selected, then Issue by sales were not being printed. Now solved.
	• While debiting SDN (Debit note to supplier) total duty shown is wrong. (It includes bill wise items duty in addition to calculation duty)
	• The sequence of Excise duty balance in debit entry is changed. Now it will debit ADI first.
	• It will show only columns, which have balances in Debit Entry
	• Now one can split the debit entry grid and freeze the initial columns.
	• New feature of automatically replacing the amount column with balance duty by double clicking on the field added in Debit Entry.
	• Now checking of amount after each column removed in Debit Entry
	• New validation like checking of negative duty balances, negative stock & blank excise percentage in invoices added in eER1/3
	• Removed checking of decimal in assessable value in eER1/3 return.
	• Duty Details when Printed seperately in E.R.1/3 does not print Notification no. wise details. Now solved.

	Payroll Module:
	• In daily attendance, accounting posting and monthly pay generation entry, If company is having only one accounting year then after saving or deleting any entry it was displaying error. Now solved.
	• F3 details added in payroll TDS paid details.
	• In daily attendance it was generating duplicate entries fordatewise generation of attendance. Now solved.
	• In daily attendance while deleting datewise entries it was displaying error. Now solved.
	• In daily attendance save button was not activated when user enter details manually. Now solved.
	• When net pay was zero, entry was not posting. Now solved.
	• Program was not storing branch code in account posting when process has done second time. Now solved.
	• Now profession tax report will show slab wise details, as slab of profession tax for females is different
	• In Employee Master, When PF is Unchecked then even after saving it was checked as PF Type was selected. Now when PF is Unchecked then PF type will change to Not Applicable.
	• If TDS is deducted from salary and any other payment then tds of salary is coming in TDS paid details, but other payment tds is not coming.
	• In employee master now it will allow negative values in Leave & Loan Opening Balances to avoid error-Invalid Property value 380 while editing.
	• EmpID field added in stdlisting
Top
	4th July 2014 – Version 3.3.13

	Accounting, Inventory & Order Module:
	• In ADI report if user has prepared invoice against purchase bill and against issue of the same purchase bill then report was not coming properly. Now program will print report upto one issue made of any bill of entry.
	• In ADI claim report program was not allowing to enter VAT challan details for more than one branch. Now solved.
	• In eReturn of dealer excise if return was prepared for dealer then it was not allowing importer registration no. Now it will allow.
	• In eReturn of dealer excise assessee verification website link has change to resolve problem of security certificate.
	• eReturn of dealer excise file format has change as per new format.
Top
	23rd June 2014 – Version 3.3.12

	Accounting, Inventory & Order Module:
	• Now in excise eReturn, RGForm-2, Pending gatepass statement, RG23-D summary, RG23-D Register program will ask report for All / Local / Self Importer.
	• In one material issue entry if user enter items of more than one bill of entry then ADI reports is not coming properly. Now solved.
	• In party wise outstanding report it was not printing gross net due amount. Now solved.
	• In item costing report in main entry it was not printing original cost amount. Now solved.
	• In item costing report if purchase entry against GIN then it was displaying cost of GIN. Now solved.
	• In company setup when user change branch switch it was displaying error. Now solved.
	• In cash, bank and journal entry if cursor reaches to item costing column then it locks direct typing in narration column. Now solved.
	• In stock summary report if company is having production and issue entry then it was displaying issue quantity in receipt column. Now solved.
	• If in invoice calculation setup user has selected barcode entry and counter sales is also selected and if users tries to print document while viewing then it was displaying error. Now solved.
	• In update database in case of production entry it was not updating properly. Now solved.
	• In update database program was not updating expense costing in items. Now solved.
	• In import database in was not updating expense cost in items. Now solved.
	• New fields LRNo., LRDate, TransporterName, TotalQuantity in form collection statement recordset.
	• If company is not having store and it is taking physical stock report then it was displaying error. Now solved.
	• In ADI report if there is multiple items in bill of entry then it was not sorting items properly.
	• In ADI entry now program will also ask up to date field to pickup entries only up to given date.
	• In ADI report in Annexure A, now program will display all items even items which are not sold.
	• Now GIN and CLN entries will be reflected in ADI reports.
	• eTDS has changed for FVU 4.2

	Manufacturing Excise Module:
	• In eReturn & report of ER-1 if user selects sort alphabetically and excise name in master is duplicate and same name is used in finished goods & raw material, then it was creating duplicate records. Now solved.
	• If excise code not entered in item master and user enters excise code in entry then it was displaying error while saving. Now solved.
	• In year end proper excise stock was not transferring. Now solved.

	Payroll Module:
	• Muster roll was not coming for the period of January to March. Now solved.
Top

	26th February 2014 – Version 3.3.11

	Accounting, Inventory & Order Module:
	• New option auto bank reconciliation has incorporated; in which user can just enter cleared date in unclear bank entries and it will generate bank statement entry.
	• New chargeable module, auto reconciliation from bank statement excel file has been incorporated.
	• New Trial Version features has been provided in which if Security Key Dongle gets damaged or is not working then user can call at Microbrain’s office and activate Spectrum as trial version till your dongle gets repaired, only you have to check for Trial Version when Spectrum displays Evaluation Version. This feature will provide uninterrupted work.
	• Now Form 15G will print as per new format (ONLY IN GRAPHIC MODE.)
	• New ADI claim entry and reports has been incorporated for self importer.
	• New feature, effect of expenses in items costing has been incorporated and now user can give effect of expense in item costing in cash & bank payment, expense bill and journal voucher entry.
	• New report for effect of expenses in items costing has been provided.
	• Batchserial No. field width has been increased to 30 characters.
	• Now in all stock summary report user can print transaction (Item) amount in report.
	• In system parameter if number format style is american then it was displaying error in production entry. Now solved.
	• Now dealer excise reports will not be available if user has purchased only manufacturing excise module.
	• Now program will not allow to enter ‘000000’ as document number.
	• In year-end routine if there was insufficient diskspace then it was displaying error overflow. Now solved.
	• If start reconciliation date is greater than start date of next year then in year-end it converts to start date of next year and all entry was being transferred as pending cheques. Now solved.
	• In salesman commission report if user has adjusted multiple invoice with one credit note then it was printing multiple details of credit note. Now solved.
	• In case of multiple account in bank receipt entry then in account ledger of status enquiry it was showing cheque no of first account in all entry. Now solved.
	• In cash and bank entry if currency was not entered and user is trying to adjust currency document then it was displaying currency amount column in very small size. Now solved.
	• In itemwise sales and purchase report if user selects consignee account name field then the field gets unselected when user runs the same option again. Now solved.
	• Now in import data option, program will not import data if account name is not same.
	• Now program will not allow user to enter tax code in other case (letter) than master.
	• Check subscription button is incorporated in about option of spectrum, to check & update subscription expiry date & other modules.
	• Now program will not download new update if your subscription doesn’t offer it.
	• Now user can download new help file if context not found in HELP.
	• When user export bank reconciliation statement to EXCEL it was not storing sub total of transaction amount. Now solved.
	• Now in bank reconciliation user can print narration in separate column.

	Manufacturing Excise Module:
	• Now in supplier credit note it will not ask for post in modvat.
	• Now all excise master & item master dropdown, it will display excise and item name with its code to avoid duplicate error.
	• In ER1 it was using document date for report and generate eReturn, now it will use deposit date.
	• If production or return from wip entry is against job work then now program will display only one row detail per one issue entry if product code is entered and all relative item will pickup.

	Payroll Module:
	• Now in import daily attendance entry user can unselect checkbox for not to calculate working hours and overtime hours if it has calculated in script.
	• Now users can import daily attendance for same period.
	• In eTDS of salary it was picking Net pay, now program will pickup gross pay for all earnings.
	• Now it will not print payslip for arrears if arrears for a particular month are zero.
	• In shift master new field minimum overtime hours provided, so overtime will calculate if overtime is greater than or equal to minimum overtime hours.
	• In Form 16, new information like interest on home loan, rebate under 87A and surcharge has been added.
	• In daily attendance entry if user changes IN or OUT time then it was not calculating overtime. Now solved.
Top
	24th October 2013 – Version 3.2.09

	Accounting, Inventory & Order Module:
	• Context Sensitive HELP has been incorporated.
	• eTDS file format changed as per FVU 4.0
	• Now in bank pay-in-slip printing, it will not allow user to select print preview in printer setup dialog box.
	• In audit trail report for journal voucher entry now program will store total debit amount as document amount.
	• Now program will warn if cost of item goes to negative in goods inward and purchase entry.
	• In cash / bank and journal entry when any party is debited/credited and pending details are generated, now program will store first cost centre detail in outstanding.
	• In cash, bank & journal entry when program displays outstanding form and after entering outstanding adjustment details if user clicks main form command button then it displays error. Now solved.
	• In sales and purchase order entry, when program displays delivery schedule window and after entering delivery schedule details if user clicks main form command button then it displays error. Now solved.
	• Now in on account adjustment entry, after adjusting one on account entry program will not initialise account.
	• Now user will allow to remove TDS code in accounting entry even no TDS detail required in master.
	• In main splash window and about window if company name has having (&) sign then it was displaying (_) sign. Now solved.
	• In about window if only excise module has purchased then it was not displaying modules properly. Now solved.
	• In party age wise summary reports of accounts payable it was displaying document class of sales. Now solved.
	• In sales and purchase tax summary if user selects cumulative report and selects additional charges, then it was printing all additional charges column even when amount is not there. Now solved.
	• Now user can remove TDS details from purchase, expense & TDS deduction detail entry even when TDS percentage is not entered in account master.
	• In form collection statement expense bill was not coming. Now solved.
	• Now in bank entry it will allow blank cheque date and blank cheque date will not print in cheque.

	Manufacturing Excise Module:
	• Now in RG23C purchase modvat amount will be rounded to rupees.
	• Now if there is no transaction, then in eReturn of ER1 it will add record of first finished items with zero value.
Top
	27th July 2013 – Version 3.2.07

	Accounting, Inventory & Order Module:
	• Now eTDS will generate file for period prior to 1^st April 2013 for compatibility with TDS file validation utility version 3.8.
	• Problem for NIL TDS is solved.
	• Now in status find while typing will search for initial character.
	• In TDS paid listing it was displaying error. Now solved.
	• Now in case of specialised updates, program will not check version.
	• Now in eTDS user can also enter and generate for only late fee challan.
	• In eTDS for year prior to 1^st April 2012, it was showing error Fee amount. Now solved.
	• In Salenote if user selects invoice then it was displaying error. Now solved.

	Manufacturing Excise Module:
	• In case of item-wise Form IV report, it was not displaying report. Now solved.
Top

	10th July 2013 – Version 3.2.06

	Accounting, Inventory & Order Module:
	• eTDS file format is provided as per requirement TDS FVU 3.8.
	• Now in auto payment entry if user double clicks on amount then program will pickup pending amount.
	• In account master other than debtors, creditors and loan, if user enters address in edit mode then it is not saving. Now solved.
	• In Invoice progressive total was not saving. Now solved.
	• Now user can run auto entry option even other user is working in same company.
	• Now in missing document list, it will work even initial characters provided is more than one digit and are alphabets.
	• Now pending amount field will be available in salesman commission report.
	• If in item master sales, purchase account or tax code is wrong then it was creating problem in grid entry. Now solved.
	• In bank statement entry, if company is having branch and user doesn’t selects any entry then it was displaying message for entry has selected for other branch. Now solved.
	• In bank statement entry, after completing one entry if user press F3 key at document no. then it was not working. Now solved.
	• In data listing of expense bill and provisional and user selects tax or cost centre details which is multiple then it was displaying duplicate credit amount. Now solved.
	• In work order data listing product quantity was duplicating. Now solved.
	• In TDS Paid listing it was showing error. Now solved.
	• In outstanding invoice report, if user selects currency detail and it was not showing currency amount in decimal point. Now solved.
	• In party wise outstanding report if user pass auto JV then JV was displaying before receipt or payment entry. Now order has change.
	• In outstanding statement for bank, if user selects particular series and summary then it was not displaying proper value. Now solved.
	• In items ledger if user selects to print gross total and balance quantity is zero then it was displaying error. Now solved.
	• In auto TDS JV user can pickup only pending documents for passed document type.
	• Now in status enquiry it will display cheque no. in ledger and order no. in outstanding.
	• Now in status enquiry facility has provided to find string in any column.
	• Now consignee and cost centre fields is provided in form statement report.
	• Now a salesman credit period field is provided in outstanding interest.
	• Now in item wise sales & purchase detail report consignee and cost centre fields are provided.
	• Now in status enquiry facility is provided to merge account transaction.
	• In auto payment entry program was not storing adjustment detail has display in auto payment entry. Now solved.
	• Now you can send email to multiple email id of account master if separated by (;) sign.
	• Now you can send SMS to multiple recipients, if mobile no. has separated by (,) sign.
	• Poison license no. & LBT No. provided in store master.
	• Now in bank statement entry program will not pickup system date in document date.
	• Now if size has created in master then program will not allow saving entry if user doesn’t enter size in sales and purchase entry.
	• Tax form serial no. width has been increased to 30 characters.
	• Now in account tax wise summary program will print additional charges in columnar format.
	• Now user can enter order no. & date in credit & debit note.
	• In document printing in case of item wise sales tax and tax amount is zero then program was not printing net amount. Now solved.
	• Now default voucher format is graphic.
	• In case of NIL TDS program was showing error in check database. Now solved.
	• If company is having branch and account has created in non-accounting debtors or creditors group then it was not showing that account in consignee fields in entry. Now solved.
	• In bank master in cheque printing for dot matrix setup, spin key was incrementing value by 15. Now solved.

	Manufacturing Excise Module:
	• Post in Excise Option added in GIN/PUR/ISU/PRE/CLN & INV. Now it will not display manufacturing excise related fields if post in excise is not selected.
	• Now you can change excise code of items in data entry.
	• Time of issue when blank then "Invalid use of Null error"- message was displayed in material issue for job work entry.
	• Now no need to make a separate item for excisable & non-excisable item. But if common item made then item wise & Excise wise stock will NOT TALLY.
	• Now program will not replace excise code in Excise Ledger from item master in rebuild database. It will replace only when excise code is blank in excise ledger and not if mismatch from item master.
	• Regeneration of duty book serial numbers for different branches, now possible.
	• In eER1/3 ECC no of branch will be picked if branch required is true.
	• In Purchase entry if purchase from dealer then GP no was replaced by bill no while editing. Now solved.
	• Default excise conversion factor in excise master will be 1.
	• Changed Query of Store wise Excise Stock Statement in Status Enquiry As excise codes with opening stock and no entries, were not coming.
	• In Checkboxes like gatepass, post in excise in entries like GIN, CLN PUR, INV, ISU & PRE, value will not change if cancel is selected.
	• Now excise reports like RG23A/C Part I, RG1 & Form IV will print address & excise details of FIRST store instead of company, when Selected store option is checked.
	• Removed checking of item wise & excise wise stock in check database.
	• In RG23A/C Part I, when Good inward note is prepared from Purchase order and consignee is entered then consignee details were printed. Now it will print party/account details.
	• In Purchase entry when items are picked from GIN then manufacturing & dealer tab where not visible in bill wise form for bill/Pharma items. Now solved.
	• In proforma credit when there is only one entry then sr. no was not getting printed. Now solved.
	• While generating eER1, return date greater then system date was not allowed. Now it will allow.
	• In Material issue for job work, cost rate improper value message was displayed when item is selected when cost rate is zero. Now it won’t display.
	• Bill No. / Date not coming proper in RG23A/C part II for purchase of Bill/Pharma items when against GIN
	• Remark for Total line not coming proper in RG23A/C Part II in credit side for multiple items in purchase.
	• Removed excise related columns from sales & purchase grid, which will reduce form-loading time.
	• When passing miscellaneous debit entry then entry was not getting saved because of message of insufficient balance in excise, even if balance found, as it was not checking for branch. Problem only when branch required is true. Now solved.
	• "Arithmetic overflow error converting expression to data type nvarchar" - error in Monthly Debit entry, solved.

	Payroll Module:
	• New changes made in ETDS for Salary as per eTDS FVU 3.8.
	• Profession tax report included employees where profession tax is not deducted. Now it will not include.
	• In batch mode printing of payslip & form 16 now one can print payslip/form16 for a particular department.
	• While account posting it will not lock all options and it will allow to post even if other users are working in the company.
	• Payroll options when added to customised tool bar was not executing as the menu options were declared as private. Now made public.
	• Default Profession tax slab of Maharastra changed as per current slab.
	• Now full payroll setup can be imported if entry has not begun.
	• New employee codes were not displaying in Monthly pay generation in F3. Now solved.
	• In account posting, cost centre & cost category was getting replaced only in 1st account and not in subsequent accounts. Now solved.
	• Now Import & export of payroll data possible.
	• In monthly pay generation now one can split the grid.
	• Changes in import employee attendance. Holiday assignment & Half day replacement now removed after importing by script. Holiday.GetHolidaytype can be used in script to check whether particular date was a holiday.
	• Changes made in deduction formulas in default data. Now it will not calculate if total earnings exceed ESIC Limit and will initialise deductions if not applicable.
	• After displaying error message it was not focusing on the concerned field in employee master. Now solved.
	• Problem in updation of loan & leave balance especially when March pay is given in April. Now program will consider month for which pay is made and not paid date.
	• Problem in Year-end when March pay is given in April of next F.Y. Now program will consider month for which pay is made and not paid date.
	• Profession tax of FEB month was not calculating properly. Now solved.
	• Over flow error while generating monthly pay from daily attendance. Now solved.
	• Employee master listing not proper. It was sorted on employee name instead of code. Problem only in SQL. Now solved.
	• In Slab master & profession tax summary report, in last line > replaced with >=.

Top