Friday, May 4, 2012

Version 312.508.10326

Features added / modified

Update Revenues\Expenses for Payroll
Added the ability to update Revenues\Expenses, for Payroll via Special transactions.

Series numbering brought fwd
During the execution of 'Series numbering brought fwd' job, are set in grid the series that will be excluded from the general rule.

Fiscal year for payroll for multicompany databases.
A new job is added, which creates new fiscal year for payroll, in all the companies of the database.

Resolver in Revenues/Expenses
Added in Revenues/Expenses link a resolver, Expense Value (Negative expense) - Expense VAT Value (Negative expense).

Select multiple entries from available list
Given the possibility to be imported to the document the selected browser results opened by right clicking : from list

CRM access level
A field 'Access Level' has been added in CRM parameters per user.
Once completed, each new action posted from that user comes with this level proposed.

Revenues/Expenses Book
The report revenues/ expenses book, gives results when last year selected .

copy - paste of softone messages
Added the ability to copy messages that appear in Softone.

Scroll bar in Softone messages.
Added scroll bar in messages that appear in Softone.

Infinity in aging
The column for older balance is now with infinity sign (-oo).

Sales/Purchases statistics per item
In the filters is available the number of months. This option is aggregating quantities - values ??in one column (corresponding to the number of days).

Services in Retail module
Added the ability to select services in Retail documents.

Selection of Pricing policy in Retail module & Recalculation.
Added in Retail module, in Related Jobs, the options Select agrement and Recalculation.

Printform for email
Fixed PRINTFORM for printing on Email.

Fixed assets - accelerated depreciation methods (Romanian Legislation)
Incorporation of Accelerated depreciation method.

Unpaid document balance-date status
For Outstanding documents was given the ability to set the date of validity (requires FIFO openitem).

Projects - Items Balance
Added filter for 'Projects w/o transactions'

Update alternative prices upon saving a purchase documnet
Added parameter in the types of sales that determines which of the alternative prices will be updated.

Extra fields in Draft entries table
Added Extra fields in Draft entries table

Possibility to set up Pricing Policies for Items and Lots.
Given the ability to set pricing policies in lost.

Cost of goods sold in project financial data
Added column to the financial data of the project that reflects the cost of goods sold. Refers to the goods contained in a sales invoice and matched with the module of projects, either in a header or line level.

Characters (length) in field serial number
The length of the serial number field is increased to 35 characters.

Gross profit aggregate - Projects
In Project Financial data added the columns of the project cost of goods sold, sales value and gross profit.

Update rates of wastage at job in lines of production documents
In producing documents generated from work , is filled the wastage rates that exist in the specification.

Customer data in contacts
Added the parameter "Transfer trader data
", The general parameters of contacts. The default value is [Yes]. To prevent the auto-complete of data to be set ['No].

IBAN code validation in cash accounts
Added validation of IBAN in cash accounts.

Reports with services transactions
The following reports created.
"Sales of services per customer" and "Services analysis per customer."

Reports for Services transactions and Suppliers
New available reports: 1. Service purchases per supplier, 2. Service analysis per supplier

Cash accounts: Different Exchange rate in Accounting compare with Commercial part.
Transfer of TDEBIT, ADEBIT, TCREDIT to ACREDIT. It gives correct results only when traders are matched one to one with an G.L. account, with the same currency. In the event of improper use of significant issues will arise.

Lots & FIFO automatically analysed in lines
Added in the related jobs of Sales and Inventory, the job 'Lots Proposal'. Upon execution the behavior is the same if Automatic coverage existed.

Lock and "Inventory balances brought fwd"
If "Inventory balances brought fwd" is executed in a fiscal period and is locked the first fiscal period, it appears o prohibition message.

Filters expected - reserved at job "Shortage orders"
In Shortage orders job added filter regarding the available categories for expected - reserved.

Function for balance in local currency
In the function CusBalance was added parameter which returns the balance in local currency and not in the currency of trader.

The cash charges SOCASHEXP became Master Form and allow design view

Remittances as Retail Advances
Remittances are now available as Retail Advances.

Open new fscal year to all companies massively
New job: 'Mass import of fiscal year' is available in Periodic jobs - Change fiscal year

Expenses and methods of calculation
Possibility of new method for calculating expenses "Charge Rate * Line Value before discount"

Expenses - Intrastat
Intrastat option is no longer available in expenses card.

Printing job data 'Order planning'
Added printout by pressing a button through the interface of the work

Order planning with a different priority by customer branch
Added the field 'Scoring' in customers branches. If no value is set 'null' it will take this into account while executing the job, otherwise use 'Scoring' from customer card.

Automatic Lot creation
The ability of automatic Lot creation is now available from document lines of purchases. The job can be selected by right click on the document lines.

Detailed control report -Sales
In Detailed control report of Sales is available for selection as a column, the series of the document, where the description 2 shows the description of the series.

Exclude items from Intrastat file
Added filter for excluding items involved in the same invoice, from the file and Intrastat report (filter "Items without intrastat code).

Matched documents report
In 'Matched documents' report when 'Only matched' is selected there is also available the module selection. Open-design documents also participate.

Open-design documents in 'Brief accounting report'
Open-design documents are also calculated in Brief accounting report

Supplier prices in Purchases orders
Added purchases parameter in order not to update automatically the grid "prices per supplier - Last purchase price
" with the value set in the Order.

Dialogue for W\h change in document convertion. Sales to purchases and the opposite.
In the dialogue of sales document convertion to purchases (and the opposite) a filter was added for the selection of W\h.

No copying of canceled document (as conversion)
Added check and error message that the document we are going to copy is canceled.

Physical stocktaking per document
Added option to not participate in the balance transactions made after the posting of the physical stocktaking document.

Size of attached image.
Limited size of the photo can be entered by the user.

Negotiable instruments and returns
Added to document types of payments and collections , the parameter 'Outstanding cheques (own)'. When 'Yes' is selected, the available negotiable instruments limited to those having as original trader the trader of the document.

Description of transaction
In Items transactions (related jobs) appears the name of the transaction.

Update actg link of special cash accounts in Revenue/Expenses
Added the entity of 'Special cash accounts' in job 'Execute update' for Accounting from Commercial module.

Phase of project and Payment methods
Added the option "per project phase" in Payment methods

Update Commercial from Payroll
Improvements in job 'Update Commercial from Payroll'

Posting a new remittance from Related jobs
Option 'New remittance' is now avvailable through traders' special transactions.

Display of canceled negotiable instruments in printouts and views.
Added a filter in printouts for the display of canceled negotiable instruments.

Transfer of remarks from sales opportunity to Order.
Transfer of remarks from sales opportunity to Order.

New Tab in the 'People data' of the company (legal representatives)
Added to the Companies tab - People data - Details of persons entitled "company representative." In the Property there is a stringlist indicating roles for submission of forms.

Filters in Cash Accounts cards
Is given the choice of all series or types of documents for receipts or payments.

Depreciation of Fixed Assets on Revenue-Expenses
In case where has been posted a F/A depreciation with link to Expenses, from the related jobs of depreciation document, the expenses document appeared in the list of depreciation documents

New report "Sales per customer branch"
Added a new report "Sales per customer branch" similar to the "Item analysis per customer branch".

Order planning
Appears in the grid of the orders the earliest date of the claim.

Order planning
Button for refresh data was added in job 'Order planning'.

Characters (length) for field Lot code
Increased the size of the Lot code field to 30 characters.

Region for the qlikview analysis (sales-purchases)
Region and Season were added as filters in qlikview analysis (sales-purchases).

Creation of set items with items that follow lots.
Added the ability to post specific lot in consumption lines of a Set.

Browser for 'Item sets' and line expansion
Possibility for 'line expansion' in 'Item sets' browser.
Addition of dimensions to Sales forecasts
Salesperson was added as available dimension in Sales forecasts

Traders Balance aging
In customers Balance aging report added the filter 'Apply open-item: To date reference'. With this option is not checked matchings, later from the reference date .

Balance per W/H
Improved the execution time for 'Balance per W/H' report.

Shortage/Requirements job and current date
At Shortage/Requirements job, the current date is proposed for the creation of documents.

Size of Negotiable instument number 40
Negotiable instuments number field is now bigger CHEQUE.CHEQUENUMBER (from 25 to 40).

Branch as filter in General Ledger report
In General Ledger report (Official reports) added as filter the branch of the company

Order planning
Added the filter 'Geografical zones' in job 'Order planning' from Inventory Items browser.

Balance cost in Inventory trial balance and Card of item
Given the possibility of selecting cost price for calculating the value of balance and added column to the tab 'Period data', that calculates the balance based on the cost of the corresponding period.

Coverage of pending to document lines
In option , available in lines document, added filter regarding dates.

New functions for Import Script
To Import Script added the following Published functions:
-Function RenameFile (OldName, NewName) renames the file with name OldName into NewName name file.
-PILib RenameFile VarArray (OldName, NewName, 2)
-Function DirectoryExists (Directory): checks whether there is the list Directory, and returns True or False. BC. x = CallPublished ('. ', PILib DirectoryExists Directory)
-CreateDir Function: Creates the list Directory. BC. x = CallPublished ('. ', PILib CreateDir Directory)
-Function RemoveDir (Directory): Deletes the Directory Directory if it is empty. BC. x = CallPublished ('. ', PILib RemoveDir Directory)
-Function ForceDirectories (Path): Ensures that all the lists of the Path exist. In the event that there will be created. BC. x = CallPublished (' ForceDirectories ', PILib. Directory)

Addition of function and credit control
Addition of function and credit control thatreturns the number of months based on a specific date i.e. today and the newest umpaid document

Modify printed document, prohibition based on the behaviour of the document.
When creating a new sales series with behaviour: Shipment note,Sales Invoice and Retail receipt, prohibition is proposed for the option 'Modify printed document'. Also during the modification of the specified field an error message will appear.

Series numbering brought fwd - Filter for module selection
Added dialogue for selecting modules in job 'Series numbering brought fwd'

Introduction of autonomous documents without any necessary link to an entity
Introduction of autonomous documents without any necessary link to an entity

Register of non-physical persons
Possibility of the application to connect to the non-physical persons register and verify data for Customers, Suppliers, Debtors, Creditors, Draft Entry. The job will only work for clients with contract.

New Credit control formula
Added the expression "Number of days without servicing the oldest settlement". The function returns the difference between the days of orientation dates and the oldest outstanding arrangement

CusFirstDateOpenTerm function
Added function 'CusFirstDateOpenTerm', which returns the first date of the outstanding payment.

Cumulative trial balance of inventory transactions and extra filters from items cards
Added the filters: Accounting category, Commercial category, Group, Manufacturer, Brand, Model, Country of origin, Season.

Detailed trial balance - Company filter
In Detailed trial balance added as a filter the companies.

Pricing policy based on country or trader currency
Possibility to define a pricing policy based on country or trader currency.

Item with attributes - Wholesales/Retail price analysis
Before posting a new item that has attributes, you can select the Hyperlink to choose the wholesale / retail price and to set different prices.

Added filters in statisrics reports
Added filters in reports:
1. Sales statistics per customer (Manufacturer, model, country of origin, season )
2. Purchase statistics per supplier(Manufacturer, model, country of origin, season)
3. Statistical orders per customer (commercial category, Accounting category, group, Manufacturer, brand, model, country of origin, season )4. Orders statistics per supplier (commercial category, Accounting category, group, Manufacturer, brand, model, country of origin, season), 5. Servises Sales Statistics (commercial category, Accounting category, group, category, Subcategory, season)
6. Sales statistics of services per customer (commercial category, Accounting category, group, category, Subcategory, season)

Behavior - Purchases/Sales per item
Behavior was added as filter in 'Purchases/Sales per item' Statistic reports

Opposite Account Journal (Rom Legislation)
Rebuilt of report "Opposite Account Journal"

Order planning
Added totals of requirements and distributions by characteristic,
coverage rates, colors for greater usability and
filters for detail section.

EAN codes and existing altenative codes.
The job creates new EAN codes and always ignores the altenative codes associated with other inventory items.

Order planning
Can be printed the 'Order planning' of the item as displayed in the monitor.

Browsers and Contracts
Added possibility to expand lines with trader lines, and also analysed the fields of Service, Trader, Trader branch

General Ledger Trial Balance
Αdded the ability to display the column : balance with sign with respective totals.

Create Intrastat imports file - CrtIntrastat (Romanian Legislation)
Modifications applied for "Intrastat imports file"

Sales - Purchases history
In Sales - Purchases history was added columns for quantities (executed and canceled)

Intrastat Imports -compaction (Romanian Legislation)
In Intrastat Imports report applies compaction for lines with the same data - sum values

Filter "Only items with trns or balance"
Filter "Only items with trns or balance" was added in the following reports: "Monthly inventory statement" and "Monthly report (correlation codes)".

U.O.M 1 for items without attributes
The field U.O.M in lines is calculated as value-line / qty1, if strict relationship is set between sales UOM and UOM1. Otherwise if affected the quantity1 and there is no strict relationship, was not conducted again the calculation.

Filter in "Monthly inventory statement per W/h " & "Monthly statement (correlation code) per W/h"
Added the filter 'Only items with trns or balance
' in the following reports: "Monthly inventory statement per W/h "

Create Intrastat exports file - CrtSIntrastat (Romanian Legislation)
Modifications applied in "Intrastat exports file" based on 2012 official changes

Intrastat - C.N. and Complementary U.O.M
'None' is available for Supplementary Unit field.
Based on this option madifications applied also to Intrastat xml exports

Intrastat- List of Delivery terms
Updated the List of Delivery terms regarding Intrastat

function for related documents
1. Added function which uploads to Azure the files found in physical disk. That fuction
a.takes the filename as a parameter
v.posts a new record in files directory
g.uploads the file to Azure.
d.updates the URL of the file which was posted with the address located at Azure.
The function returns us to the Url Azure. eg X.PUTFILE ("C: \ \ filename.txt")
2.Added function with which we can call html link. That function takes as parameters the url and the caption and returns string. eg href ("", "in").

Intrastat exports xml
Modifications applied to Intrastat exports xml file

CallPubllished funtion ModuleIntfGetValueToFile
Added the function ModuleIntfGetValueToFile which allows the contents of a blob field to extract to a file.
GetValueToFile (DataSetHandle, FieldName, FileName)

Project cards (PRJC_STM)
Added multiple filter in all preojects reports
1. Main projects (sub-projects not included)
2. Sub-projects only
3. All (sub-projects included)

Bug fixing

Error "Connection interrupted"
Fixed an error "Connection interrupted due to communication fail. Please run Soft1 again" when working in an environment client / server.

Save an 'Open report' with different name
If an Open report was saved with a different name (Save as ...) then when you run it displays the name of the former.
The name of the custom stored properly, with the wrong title.

Error when closing the application
Error occured when closing the application if a document was posted that created on-line link to GL same behavior when a customer or items copied to another company.

Configure the company information from the header of the report
Can be defined by the user the data displayed in the header of a report.

Configure the company information from the header of the report
In System Settings > General report data, when 'apply settings to existed reports was selected data were not saved when I choose to see the 'company data'.

Print to Excel
When exporting a browser (eg items) on Excel, the fields that had long character can not be shown in the cells, but "struck" in the middle and at the end of it 3 dots are added ...

Spell check
In fields of comments (e.g. comment document) the spelling is not checked on the last word of the text

Error in client and sql monitor
Error appeared in a client / server environment with sql monitor performance and cost price calculation. Messages in sql monitor displayed at the end of job.

Malfunction restrictions for designer and logical limitations
In the database designer in logical limitations that existed by = and then were deleted during posting

Series rediraction in custfindoc
Fixed to work properly and the redirection of the type.

Error during Cost Price calculation
In client-server mode the job cost price calculation for options for all types of codes and all values ??of cost / sales showed a message "connection interrupted due to communication fail. Please run Soft1 again".

Color in line columns of documents
In Line columns of documents with color and backgrounds, the color did not appear in the text.

Error in Bills of materials from documents
Fixed Error 'Autoincrement Assignment' at job 'Bills of materials from documents'

Customers trial balance from projects module.
If Revenue documents are posted with project at the document lines then in Customer trial balance printout from projects, nothing was printed.

Filters in browsers
Did not work properly the filters of the browsers when there was a call from command line.

Email Import
During the execution of the job 'Email Import', if there were more than one series available for selection for the imported email, message "must be given the number of document" was displayed.

Sales statistics and pivot analysis
Access violation occured in Sales statistics and pivot analysis

Data flows and documents
Problem occurred in target document when items with attributes participated or option 'Use of barcode' had selected.

Shortage/Requirements job and Suppliers' payment method
In document created by the Shortage/Requirements job, is proposed the method of payment of the supplier.

Comments of the branch from sales document
If text was registered in the comments field of a branch from the customer file, the text does not appear in the hyperlink 'customer branch' in sales document.

Change the date of special transaction with automatic collection
If in series has declared that the collection is automatically created, is transferred also the date of the original document in case of modification.

Filter 'Cash' in sales statistics.
The cash field appeared as 'locked'.

Type of trader Inentory statistics
Type of trader did not work properly when selected as filter in Inentory statistics

Recalculation of canceled and cancellation documents
Recalculation did not work in canceled or cancelation documents.

Azure - Posting Revenues-Expenses documents
When posting a Revenues-Expenses documents, fields : Document, number of the series were not updated.

Orders (ORDER_STM)
During the printout Orders (ORDER_STM) if a specific item code was given, orders of other items would appear also unless the flag 'Detailed' was selected.

Balance per company
Option 'Balance per company', through trading parties related jobs, dod not work properly.

External file of General Ledger in client/server.
During the creation of external file for General Ledger (Accounting from commercial mod.) an error would appear in client/server enviroment.

Purchase documents to sales with intermediate line deletion.
During the conversion of a Purchase document to sales, that had inventory items with attributes, if intermediate lines where deleted, then at the final posted document, the quantities of the attributes where not correct.

Last Saas user
Keeps the last user when entering the application environment in Saas - on demand.

User-defined tables and pivot execution
In inventory browsers when using one of the extra tables (UTBL) of item file, an error appeared in pivoting (access violation in xdll.dll).

Transfer among WH
During execution of job "Transfer among W/H" , a transaction can be executed among the selected W/H.

Alternative packaging
When posting/updating an entry where not shown correctly the attributes.

Fixed Assets and cost centers.
If entities were selected to be shown, in a printout an error message would appear INVALID COLUMN NAME X_CODE.

Agreement with combined scaling.
In document lines with 'packing of similar lines' and 'use of barcodes' enabled , in case of combined scaling an error was made in scaling.

Documents file - Related docs
When deleted file that is stored in the db through the related docs of the documents , then could not be stored in another object.

Filtering comments filed for custmaster
At custfindoc, during the selection of comments, the sosource filter of custfindoc did not work properly and comments of all modules appeared.

Draft entry conversion - salesperson
During a draft entry conversion (related docs) an error message would eppear regarding the id of the salesperson.

Non greek characters in excel from command line
If you create an excel file with command line it did not display the greek characters.

Opposite account card (ROM_GL_STM) (Romanian legislation)
Rebuilt of report "Opposite account card"

Inventory - Balance aging report
Balance aging report for Inventory did not work properly in case a spesific w/h is selected.

FIFO and automatically creation of Composition documents
Composition documents that were created automatically from inventory documents, were not taken into account, in FIFO Cost price calculation.

Bills of materials from documents
'Error in Autoincrement Assignment' appear while executing the job 'Bills of materials from documents'

General Ledger Trial Balance with fields from user-defined tables.
With client/server status, in General Ledger Trial Balance printout, question marks (?) appeared for fields from user-defined tables

Qlik View
When updating from client message appeared: abstract error

The report "Control report" in sales and purchases showed no results (wrong use of the fiscprd filter).

Create a local installation
Did not work correctly the creation of offline local installation.

Standard data
Standard data ddid not appear after re-login in the program.

Print document in email-pdf
When printing a document formatted to email pdf. and form in xls, the file containing the email was ending to xls and not pdf.

Print a document to mail
When choosing to print a document to mail by right clicking on the browser the following error appeared "ole error: 80040E14. Incorrect syntax near '=' "

Time entry in Azure
The field 'Entry time' at Azure environment displays the time from 2 hours before the real one.

Sales statistics and pivot
In sales statistics, the Pivot selection displays the message:
Access violation at address 0A07D696 in module 'SOExtEditors.bpl'. Read of address 00000314.

Invalid Argument in designed columns
In PC running XP it appeared "Invalid Argument" when selecting a an item and the sales document had in the proposed columns the fields(reserved - expected).

Date in documents after creating new branch
Since introduction of the new branch was made in an existing company, and re-login to the new branch, the proposed date in sales documents was 31/12/1899.

Users rights in Offline enviroment
Did not work properly the users rights in Offline environment.

Wrong matchings when executed from remmitances module
If remittances were matched to invoices and then re-matched and , then fails to delete the matching and the remaining value was the previously matched

Sales to Purchase with designed columns
During the conversion of a sales document to purchase, if designed colums was defined a n error message appeared.

Pack of similar lines in documents and 'pricing policies'
If you had set in the document type 'pricing policies: Yes" and "Pack of similar lines", and was posted customer without pricing policyi, there was packing of lines.

Chart of accounts in a branch
Did not appear the chart of accounts and the correct date if the login was made with a different branch of the proposed.

Custom view in projects
Fixed the error 'Invalid column name LoginDate' appearing after saving a view in projects.

Wrong calculation for Gross Profit
In the financial ata of the project the column "gross profit" calculated wrong.

Login to pc with win2000
At the login from a win2000 pc error appeared with reference to bpl70.dll.

Calculation "to date" in the Balance per WH
In report "Balance per WH", account was taken only months from the field" to date "instead of the date.

Menu at Offline client
Logging in the client directly, when offline, does not propose the right menu.

Data flow rule (Sales to Production)
In data flow rule from a sales document to production, displays message "dataset not in edit or insert mode"

Conversion to Purchase from Sales
During the conversion of a sales document (order) in purchase (order) an 'Access violation' appeared.

Azure: Report forms
At Azure is not stored the changes made for printing forms.

Email import - address 'from'
If you import an email and change the operator then was changing also the address "from" and proposed the email of the user.

NVL Error
Fixed an error that affects all browsers-scripts that use the function NVL.

Fields in 'Balance per WH'
In report 'Balances at WH', if in the design had been added a field from MTREXTRA and MTRDATA, error message appear "There is nothing to print."

Unpaid documents report and aggregates
If during the matching of documents, by changing the price was "excluded from the aggregates", then the report 'Unpaid documents' show incorrect unpaid value.

Composition documents, Resolver for lines
Appear only the fields of lines of composition documents

Errors while Matching
If transactions were matched, upon
change in value or the date of the document, is not updated and fields opntamnt, isclose.

Matching issue upon deletion of line value
Upon deletion of line value, the matching was deleted but no document was proposed for new matching

Documents to be matched
After deleting remmitances matchings, the matched documents appeared to have closed.

Remmitance with multiple matching
In a remmitance which had been many matchings, deleting one, was deleted and the rest.

Branches in Order Planning
Do not appear the filter "branches" when 'Order Planning' was selected with right-click on documents browser.