Forum

Helping others, engage in discussions, share your experiences and knowledge with other users.

Antony

Sorting items by tariff code: how it works and when to use it

Antony 2018-10-23 18:22:54


I want to share a technical support request

Request
How can obtain the increasing codes numbering for the tariffs codes appear in the printouts?

Answer
TheTariff column can contain up to 20 alphanumeric characters.
The entries are automatically positioned in the (Price List, Price Analysis, etc.) editor and in the print which can be ordered by Tariff, based on the reading of the individual letter that composes the string. For example, the string '100' is not read as a single number but as individual elements in succession : 1; 0; 0; ...

In this case, the string '100' is positioned before the string '51' (considering the first letter of both the strings)

Therefore, in order to get the string 51 (or group of items 51) before the 100 (or group of entries 100), you just need to add zero as the first character in the 51 string, obtaining '051'(which consists of the same number of digits as '100'). This condition will allow to have an increasing sorting of data up to the '999' string.

Note- consequently, if the entry was 1000, we should have add two zero before 51 '(four digits in total).

ENTRY ORDERING- (BoQ, Price List, Estimates and Request for proposal)
In the Measurements editor and in the Printout of the BoQ the entries are listed following the insertion order ('Normal' ordering).
On theGeneralpage of the BoQ print settings it is possible to change the default sorting from 'Normal' (insertion order in the Measurements editor) to 'Tariff' (ordering according to the tariff) -> see explanatory image
In thePrices List editor, Prices Listprint document, Work EstimateandRequest for proposal the ordering is always by 'Tariff'.