I get few questions about work in Bill of Quantities from my friends, and I will try to give answers.
1) When we have too much construction positions (I speak about thousands), how we can import the fast. This is usually case in building construction.
2) When our customers/investors require from us quote in special file, how we can prepare that. We would not refuse big job because of that.
1) We have two solutions. If we already have this positions in our construction positions code-list, we can use command ‘Import from Excel’; we need prepare file with codes and quantities and NAV will import them. If we have not these positions (usually we have not them), we have specific function we call ‘Massive positions import’. This function import all positions from Excel; if we have this position in our code-list it is fine, but if we have not, NAV will create them in Construction Position code-list and add them Unit of Measure. Depends of description length, system will fill only description fields or will create extended text. Also, system will create Cross-reference code for this specific project and if we want create Normative Headers. Except creating in Cons.Position code-list, NAV will fill all BoQ lines.
2) All users or partners can modify or make new Quote report. But, if this is not enough, because come customers can require that you must fill their Excel files, we have command ‘Export to Excel’. This is not perfect solution and system is not magical L, but it can help to reduce time to prepare document. We can export all important data to Excel file. You need to repack in required document design.
I am not explain all BoQ functionalities in my posts, but this is enough to understand way of working. If you have some other questions, I expect them and I will try to give you an answer.