2022.0.22 - 2022.0.24 нұсқасының сипаттамасы

1. Profitability of sales for the period

Fixed an error when in the Analysis - Profitability of sales for the period the goods already withdrawn from the action on the date of the start of the analysis were displayed (№131583).

2. Internal transfer

Fixed a bug when prices could not be synchronized correctly (Settings - Settings - Trade network tab - "Maintain the same prices at all outlets") if the goods were moved to an accounting center where they had never been due to a delayed internal transfer, and before the invoice was made effective, a revaluation took place that should have affected all accounting centers. And we received the old price after the invoice became effective at the recipient's accounting center. In turn, this effect could lead to a rollback to the old price at all accounting centers if the postponed internal transfer was to the warehouse of goods in transit and we accepted it (in the settings of the recipient's accounting center in the field "Formation of price when internal transfer of goods to this accounting center "Set "Always take the price from the transferring accounting center") (№157485).

3. Analysis of sales by type of goods

Fixed the error "Out of memory" when working with Analysis - Analysis of sales by type of product. The error was due to the fact that when the form was opened, the list of customers for the corresponding filter was filled in, which took a lot of RAM when there was a large number, and when a separate form was created when switching to a subspecies, it became a problem. Now, when creating a form, the list of customers will not be filled in until the user wants to use the filter, and the amount of memory used by this filter has been reduced by 5 times. Similar manipulations have been made on the forms Document - Trade with invoice for the Recipient filter, Analysis - Analysis of sales of fiscal goods for the Recipient filter, Analysis - Comparative analysis of revenue by type of goods for the Client filter.

If, nevertheless, when working with the drop-down list, there is a lack of memory, then instead of the "Out of memory" error, the user will be shown the following message:

"There is not enough memory to display the entire list of "XXX".

Use the filter to reduce the list."

And the filter will be activated.

The data update has been optimized in terms of retrieving days in which the data for profitability and average cost have already been calculated. It is especially noticeable when the table is empty after the update.

(№167875)

4. Bonus system with an expiration date

Fixed a bug when the automatic calculation of bonus expiration by timer or when running under the owner could incorrectly determine the date of the last successful calculation (the last event was taken, and it could be the beginning of the calculation or even the "Bonus accrual mailing", "Bonus expiration mailing", "Current payroll calculation"). This could lead to the fact that not all the necessary clients were calculated, because they might not have bonuses to be written off from the wrong date, while earlier bonuses (which should have been written off earlier) remained.

TradeSoft for Windows - Deleting statistics of closed periods

Fixed a bug when deleting statistics for closed periods, unaccepted internal transfers of goods in transit were incorrectly determined. The list included corrective invoices for the warehouse of goods in transit, which were generated when accepting the invoice, if during the check of the goods there was more (when accepting, the Keep sender checkbox for goods in transit should be unchecked).

Fixed a bug when, after deleting statistics, customers had an incorrect number of bonuses if, when deleting statistics, the process of writing off unused bonuses started (on a schedule or when the program starts (if there was no calculation for today, it will start when the program starts under a user without role restrictions))). Now, when trying to delete statistics, if the process of redeeming bonuses is in progress, the user will be shown a corresponding message and the process will be interrupted. Similarly, the process of writing off unused bonuses on a schedule or launching the program will not take place if the deletion of statistics is already in progress and has not been completed.
(№167942)

5. Refund to the supplier

Fixed a bug when adding an item to a return to a supplier, if the item has never been delivered from this supplier, the Price in national currency was not automatically filled in, although the delivery of this item was in the system. Now, in this case, the field will be filled with the value of the last purchase of the goods (№169508).

6. Analysis of sales by type of goods

Fixed a bug when in Analysis - Analysis of sales by type of product, sales for the period of goods and services were not displayed if the display of at least one of the four columns was enabled: Profitability, Quantity of balance, Amount of balance, Average cost. And the service was classified as a product that does not have any goods (only services) or a product that was withdrawn from use before the end date of the analysis (No. 172345).

7. Payment with bonuses

Fixed a bug when, after paying with bonuses for an item, if a discount was applied to the item, it made the amount of payment with bonuses for the item become more than the cost of the item. This could cause problems when printing fiscal receipts, since you cannot sell an item with a discount (and payment with bonuses for a fiscal item is a discount) that is greater than its cost. Now, if the amount for the product suddenly becomes higher than the amount of bonuses paid for it, the amount of bonuses will be adjusted and will be equal to the cost of the product (#174193).

8. Software ECR

Fixed five causes of the error "Transaction (process ID 60) caused interlocking of locking resources with another process and became a victim of interlocking. Run the transaction again." error when working with the software ECR.

When executing the INSERT INTO FiscalCheckWorkPlace (WorkPlaceParametersID, FiscalCheckID) VALUES (:WorkPlaceParametersID, :FiscalCheckID) query, it will definitely not block the lock.

When executing the query

SELECT TOP 1 FCO.ID

FROM FiscalCheck FCO

WHERE FCO.DOCTYPE = :DOCTYPE1

AND FCO.ProgramRROID = :ProgramRROID

AND IsNull(FCO.ID,0) > IsNull((SELECT MAX(ID))

FROM FiscalCheck FCC

WHERE FCC.ProgramRROID = :ProgramRROID

AND FCC.DOCTYPE = :DOCTYPE2),0)

probably will not occur.

When executing the query

FROM ProgramRRO PRRO2 INNER JOIN PRROonWorkPlaceForEnterprice WPE ON WPE.ProgramRROID = PRRO2.ID AND WPE.WorkPlaceParametersID = :WorkPlaceParametersID WHERE PRRO2.Active = :Active AND PRRO2.WorkPlace = :Work

probably will not occur.

When you execute the DELETE FROM FiscalCheck WHERE ID = :ID query, it will definitely not cause a blocking, since the query is deleted.

When running the query

SELECT Sum(IsNull(CASE WHEN FC.DOCSUBTYPE = :DOCSUBTYPE0

THEN PT.Sum

WHEN FC.DOCSUBTYPE = :DOCSUBTYPE1

THEN -1*PT.SUM

WHEN FC.DOCSUBTYPE = :DOCSUBTYPE2

THEN FC.SUM

WHEN FC.DOCSUBTYPE = :DOCSUBTYPE4

THEN -1*FC.SUM

ELSE 0,00

END,0)) AS Summm

FROM FiscalCheck FC

LEFT JOIN PayType PT ON PT.FiscalCheckID = FC.ID

AND PT.TorgsoftPayForm = :TorgsoftPayForm

WHERE (FC.ProgramRROID = :ProgramRROID)

AND (FC.Storned = :Storned)

AND (FC.ID > :FiscalCheckID)

AND (FC.TheType = :TheType)

AND (FC.DOCTYPE = :DOCTYPE0)

AND (FC.DOCSUBTYPE IN (:DOCSUBTYPE0,:DOCSUBTYPE1,:DOCSUBTYPE2,:DOCSUBTYPE4))

probably won't occur.

Elimination of these errors should lead to a decrease in cases when the program hangs when printing a PRRO receipt, which in turn could lead to a crash of the program and the sale remains unpaid.

Fixed a bug where a shift closing check was linked not to its shift opening check, but to an earlier one, if this earlier check did not have an associated shift closing check.

(№177866).

9. Business panel - Table settings
Fixed a bug when the arrangement of columns on the "Columns" form was always displayed in the original version and did not correspond to the already changed arrangement of the columns of the table itself, which made it much more difficult to change the position of the columns of this table (#178239).

10) Synchronization with Prom.ua: fixed the error "URL is not in standard URL format", which occurred during synchronization if the "Information delivery address" was specified in the settings of the synchronization object, and an invalid URL was specified in the "Link prefix for the import file" field. Now this field has a validation of the entered value (#178462).

11. Commodity report for the period

Fixed the error "Report - Commodity report for a period, if you clear the period and set "Break by type of goods", and then click Create report (#178464).

12. Document - Repair

Fixed a bug that caused the error message "Field 'to' must have a value" when sending repairs to the service center if the recipient was not selected.

If the recipient is not selected, the processed error message (#178652) is displayed.

13. Software ECR

Fixed a bug when the amount of the used gift certificate and the amount of cash payment in the fiscal check of the software ECR did not match, if a gift certificate was used, which is handled as money and there was a cash payment with the rest (№178726).

14. Analysis of sales of fiscal goods

Fixed a bug when in the Analysis - Analysis of sales of fiscal goods the same sales and returns were displayed when the Payment form filter was enabled, both cash and non-cash payments were displayed (although the form of payment for these invoices was the same), if the costs for these invoices were carried out in a different (as opposed to payment) form of payment (#178830).

15. Automatic update

Fixed a bug when the program offered to update if the last update was not marked as installed in the list of updates, but in fact both the executable file and the database version had already been updated. Additionally, when checking for the need to update during automatic updating, the version of the database program began to be taken into account. That is, within one beta or one stable version (the first two digits of the program version), the database version will be taken into account. For example, if a client has two databases on the same directory and one has been updated from version 2022.0.22 to version 2022.0.23, and the other has not, then earlier when checking for updates for the second database, it did not offer to update, but now it will (№178876).

16. Updates.

Fixed a bug with a long loading of the program on some systems that required a long calculation of the md5 hash of the previously downloaded update file. Now the calculation of the md5 hash will take place in the background. If the user closes the program before this calculation is complete, it will be necessary to wait until it is finished, and a message will be displayed to the user (#178918).

17. Warehouse status

When creating a new product through the mobile application, the fiscality attribute is now set if the product belongs to the type of product with the "Fiscal" attribute. Also, it is now displayed when sorting by the corresponding attribute (#178926).

18. Analysis - Analysis of sales of fiscal goods

Fixed the display of the "check type" status in the "Analysis - Analysis of sales of fiscal goods" for goods that were sold through the PRRO of the mobile application (№178927).

19. Document - Trade with invoice statement

Fixed an error due to which, when partial shipment of an invoice, if the goods of the invoice were reserved, when creating an expense invoice, all the goods of the invoice were removed from the reserve, regardless of whether they were selected for shipment or not.

When partially shipping an invoice, only those items that are selected for shipment in the appropriate quantity will be removed from the reserve at the time of creating the invoice.

If the goods were not fully reserved and were placed in the reservation waiting list (there were more goods in the invoice at the time of reservation than in the warehouse), then at the time of creating the expense invoice, which will fully ship the goods, it will be removed from the reservation waiting list (No. 179102).

20. Translation.

Fixed the error of not translating the name of the system employee SELLER when changing the language (#179109).

21. Implementation - Customer list
Added the ability to control role access for the filters "VIP client", "Wholesalers" and "Filter by card issue". Fixed a bug when the "Discount card type", "Region" and "Language" table columns were displayed even if access to them was restricted (#179138).

22. Mass mailing

Fixed the error "Error when sending a message Error code: 206 Missing or empty URL parameter" when sending a promotional Viber message from Marketing - Customers, Marketing - Contacts and Reminders, Document - Repair, which has a button in the template (#179139).

23. Trading with an invoice statement

Fixed a bug when the name of the accounting center was not displayed in printed form in the Complete list of goods and services - Services tab - Print price list of services, if the program language is not Russian (#179141).

24. Document - Trade with invoice statement

Fixed an error due to which, when deleting all items of an invoice (in particular, if it was the only invoice), all items of the invoice acquired the status "Fully shipped", the quantity in the "Shipped" column of the "Invoice item" table corresponded to the number of items in the invoice, and the invoice itself was marked with the status "Partially shipped". At the same time, when manually adding goods to the invoice, this did not affect either the data on the number of shipped goods or the status of the shipment of goods.

Changes were made to the algorithm for separating the status of shipment of goods: the quantity of shipped goods will be calculated based on information about how many goods were shipped under the invoice when creating the invoice, and if such information is not available (the invoice was created before the introduction of the partial shipment mode, or the goods were added to the invoice manually), then based on the data of the invoice(s) associated with the invoice for the corresponding goods.

When the last item is deleted from the expense invoice (all items), a corresponding warning message will be issued with a recommendation to delete the expense invoice along with the last item. If you refuse to delete an empty invoice, the invoice will still be displayed as partially shipped, even if it is the only invoice for the account.

Also, for the tables "Quotation item" and "Stock availability" in the mode of working with a quotation, the columns "Shipped," "To ship" and "In reserve" will not be displayed.

(№179144)

25. Export to Excel
Fixed a bug that could result in a data layout in the file being broken if the name of one of the exported goods contained a double quote character (#179146).

26. Commodity research

On the form "Product search algorithm" ("Commodity research" - "Full list of goods and services" - "Open (F3)" action), the option "Search by product barcode" was renamed to "Search first by product barcode, then by name", as it is more in line with the real situation. Similarly, in the third search option "Search for goods with own barcodes by name, with manufacturer's barcodes - by barcode", when searching by barcode, the search will then be performed by name, because 450 characters of the name is a unique search characteristic of the goods (No. 179283).

27. Calculation of cost price

Fixed the error of not calculating the cost price for the specified period in Analysis - Period, if you previously calculated the cost price of the previous period. It was especially pronounced with the method of calculating the cost by the last purchase, because unlike other calculation methods, the cost in the expense documents is not filled in for all open periods, but only for the one for which we calculate the cost. And for all calculation methods, the cost price reflected in the warehouse status did not change to the correct one after changes in the documents, and was often simply carried over from the previous period (No. 179295).

28. Warehouse - Current status of the warehouse

Fixed a bug that caused the error message "The DELETE statement conflicts with the SAME TABLE REFERENCE constraint "fk_M4L13" when combining goods. The conflict occurred in the database "TorgsoftDB", table "dbo.InvoiceComposition..." and the merge was not performed.

The reason for the error: the algorithm for combining goods incorrectly handled the situation when both goods (which should be combined into one) were sold in one sale and then returned (#179302).

29. Document - Trade with invoice statement

Fixed a bug due to which the "Sending method" field in the "Email settings" editing form was not filled in and the value of this field could not be selected from the list. The error was detected when calling this form from the edit form "Regional printing and sending settings..."

The value of the "Sending method" field in the "Email settings" form will be filled in automatically depending on the value of the "Sending method" field selected in the "Regional print and send settings..." editing form

Also, the button "Template without region..." has been added to the "Print settings" form. Clicking the button brings up the template editing form for an "empty" region without having to select it from the list of regional settings. If a template without a region has not been created, it will be created automatically, in the same way as it is created by clicking the "Regional settings..." button. The template for an "empty" region can still be selected for editing in the "Regional print and send settings..." workspace (#2).

(№179342)

30. Software ECR

Fixed an error of exceeding the number of workplaces for the paid function Software ECR if the mobile application paid for the sale by bank transfer with the printing of a receipt to the ECR. In this case, the mobile application took +1 workplace (№179379).

31. Torgsoft for Windows.

Fixed a bug when in the Document - Order of a remote client, the action "Record / correct data on the counterparty" erased the previously entered customer data in the system if they were not in the order. If the order does not contain any data about the client, it will not overwrite the existing data, and if the order contains data, it will be updated for the client (№179408).

32. Software ECR

Fixed error:

Error from the server on the PRRO 4000XXXXXX: 400

Error code: 9 DocumentValidationError

Sale. Line 5. The calculated amount of transaction -XXX.XX is not equal to the amount in document -XXX.XX

This error could occur when printing a receipt on a software ECR if the receipt contained a negative quantity of goods (№179411).

33. Torgsoft for Windows - Distribution of goods

Fixed a bug when in the Document - Distribution of goods, if during the creation of internal transfers (valid) goods are not enough in the sender's warehouse, then depending on the prohibition of sales in the minus, a dialog or information window appears that the goods are not enough in the warehouse, and in the case of the information window or clicking Cancel in the dialog, the creation of the internal transfer was interrupted, and it turned out to be half full (up to the problematic goods), although in the distribution itself (if you reopen it) it visually seemed that all the goods were moved. Now, if the item is not enough in the warehouse, and in the case of the information window or clicking Cancel in the dialog, the creation of the internal transfer will be interrupted and it will be deleted, the item distribution will not indicate that the items have been transferred (#179426).

34. Document - Trade with invoice statement

Fixed a bug that displayed an incorrect quantity of goods awaiting reservation if the goods were reserved and a partial shipment of this product was made (#179429).

35. Excise tax declaration

Fixed a bug when the Report - Report on the sale of excisable goods incorrectly calculated the amount of tax liability. The excise tax percentage was simply multiplied by the sales amount, although the sales price in the program already includes taxes (№179437).

36. Automatic update

Fixed the error ": Cannot open file "". Filename, directory name, or volume label syntax is incorrect" when launching the program or searching for an update through Help - Check for updates if the downloaded and ready-to-install update does not have an "Update folder" (#179457).

37. Backups.

Fixed the error "The UNIQUE KEY constraint is violated by "uqsPartner". Cannot insert a repeating key into the "dbo.Partner" object. The value of the repeating key is (<NULL>, Reserve warehouse XXX <NULL>).", which could occur when reserving a product (№179503).

38. Repair.

Fixed the error of the lack of access to the "Document files" button on the Repair editing form in the roles setting and, accordingly, the lack of access to the "Document files" button on the Repair editing form (#179559).

39. Implementation.

Fixed a rare error when rounding up a check, discounting sales items and paying for them with bonuses (bonuses are the main condition), the amount displayed for payment did not match the amount saved in the Torgsoft database (it became visible when the sale was subsequently called for editing). One of the consequences of this error was that the forms and amounts of payments on the fiscal receipt of the software ECR did not correspond to the implemented ones (for example, an additional "Prepayment" appeared) (No. 179600).

40. Dynamic characteristics

Fixed a bug when saving a dynamic characteristic that is stored in HTML encoding, characters that are not in the ANSI encoding were not saved (#179618).

41. Bulk mailing.

Fixed the "Invalid date format" error when sending messages without a date (for example, verification messages) via the SMS Center service if the time zone is not Ukrainian. Similar changes have been made to the Nikita Online service. For these two services, the time of sending and message statuses have also been changed. For SMS Center, the server will consider the time of sending in the time zone set in the personal account settings, and for Nikita Online, the time set in Torgsoft will be converted to Bishkek time, taking into account the current time zone on the computer. The status time for both services will not be converted and will be displayed as sent to us by the server (#179621).

42. Warehouse - Goods in transit

Fixed a bug that caused the same waybill from the "goods in transit" warehouse to be accepted twice.

The error occurred in a situation where, between the appearance of the request for acceptance of the invoice and the click of the "Yes" button in the request window by one user, the same invoice was accepted by another user (#179639).

43. Software ECR
Fixed an error when, when printing a service document, the service document withdrawn from the action of the ECR was present in the list for selection, which is displayed when working with more than one ECR at the current workplace (№179665).

44. Intermediary.

Fixed the error of the absence of the List of intermediaries in the roles setting of the work form (№179686).

45. Registration of a software ECR
Fixed the error "XSD validation failed. Also fixed the error "XSD validation failed. Invalid attribute xsi:nil of element 'M02'.", which could occur when sending the cashier registration form under similar conditions (#179709).

46. Full list of goods and services

Fixed a bug when the Commodity - Full list of goods and services for the actions Edit and Open was set to one hotkey F3. For the Open action, the hotkey has been changed to F8 (#179976).

47. Warehouse - Goods in transit

Fixed a bug that could cause another invoice to be accepted when accepting a waybill from the "Goods in transit" warehouse (#179980).

48. Software ECR

Fixed an error in the incorrect formation of a link to the tax website (with an incorrect check amount parameter, the fractional part separator is not a dot) in the QR code of the fiscal sales and refund receipt, if the check amount is fractional and the fractional part separator in the Windows regional standards settings is not a dot. The link generation code has been removed from the default receipt template, and it has also been removed from the templates supplied with the installer from version 2022.0.22 (№180023).

49. Document - Goods receipt - Import
Fixed the error "Parameter [VALUE] data type is unknown.", which could occur when importing values of dynamic characteristics for existing goods (№180045).

50. Receipt of goods

Fixed a bug when customers were displayed on the Receipt editing form when selecting a supplier from the Counterparty form. Now only suppliers and buyers are displayed on this form (#180132).

51. Software ECR
Fixed a rare issue that could result in data loss (rollback) of changes in the settings of the ECR and similar problems (№180339).

52. Document - Trade with invoice statement

Fixed an error due to which, when partial shipment of the invoice, when specifying the quantity of goods to be shipped more than can be shipped, the error message displayed not the maximum quantity of goods that can be shipped, but 0 (№180379).

53. New mail
When adding a recipient counterparty, the error "EDRPOU code must be a number", which could occur when searching for a counterparty by EDRPOU code, has been fixed (№180412).

54. Synchronization with Prom.ua
Fixed a bug when performing actions with a copied invoice that was created as a result of downloading an order from Prom.ua, led to a change in the status of the order in the online store. Currently, the copied invoice has no connection with the Prom.ua order (#180487).

55. Synchronization with Prom.ua
Fixed a bug that could result in not all new orders being uploaded. The problem was related to the limitation of the API request for receiving orders, which by default returns information about only 20 orders. As a result, if more than 20 new orders were received since the last order acceptance, only the last 20 were downloaded (#180874).

56. Bonus system with an expiration date

Fixed a memory leak error when calculating the write-off of bonuses with an expiration date when launching the program under the Owner or on a schedule. This, in turn, could lead to the program itself stopping working and the application server regularly freezing (#180953).

57. New Mail.
Fixed the error "Cannot set value for field UndeliveryReasons is expected to be an array instead of a string" that could occur when updating the TTN status (#180996).

---