Posting Operational Work (Subcontractors) – Part 8

When we post purchase invoice from subcontractor with construction position works, we get standard Posted Purchase Invocie, but with Type = Position on Invoice Line:

Image

 

Next difference, we can see when look at Navigate:

Image

Besides all standard entries, we can see new entry type – Position Ledger Entry. Job Ledger Entry is different, as well.

When we look at Jov Ledger Entry, the most importabnt thing is that we get entry type as Usage and G/L Account as type. We got G/L Account No. from Posting Groups Setup.

Image

 

When we look at Position Ledger Entry, we have standard NAV4Construction entry table, but Document Type is Invoice (that mean, we get invoice from subcontractor). We don’t have to post usage a Position again. System enable us to prepare Certificate for Sales Invoice by automatic.

Image

Advertisements

Posting operational work (Subcontractors) – part 7

In my previous six posts I described posting of own work on projects, using different models. The base characteristics of this models is that we have our own resources and items consumption. Now, we have once more model for posting, when we use Subcontractors work. Target is the same, we need to make some contracted Construction Positions, but now we do not use own consumption.

We have two types of subcontractor’s engagement in our construction projects:

  • First, we can engage subcontractor for do some minor work on our positions. That means, we will work some part of job, and some part of job will made by subcontractors.
  • Second, we can engage subcontractors for doing complete job by position. This is very often when we work on complex construction with very vary business processes, as construction of houses, buildings, etc., because the main constructor often perform only one or two types of works and engage subcontractors for all other works.

I describe how we can planning that in Construction Position Norms in my old post about Construction Position and Norms – Cost Analyze and Bill of Quantities – (Subcontractors), but now I will describe posting of subcontractor usage.

Subcontractor’s minor engagement

This is the simply process. We get invoice from subcontractors for their part of work. For posting, we will use the standard NAV purchase documents, Purchase Order or Purchase Invoice. We will post this as our cost using G/L Account, but we must to set Job No. and Job Task No. in Purchase Lines. When we post document, we will get Job Ledger Entries with G/L Account types. Our own part of job, we will post using Job and Position Journals or using Output Orders. We will invoice position we posting using Position Journals or Output Orders, with the same quantity.

We can use this model for all planned or unplanned costs on project. NAV will be classifies our own usage as resource cost or as item cost, and all other costs as G/L Costs.

As I said, this is very simply process. Other posting method need more customization or more manual work. We choose customizations, and we make automatic model of subcontractors posting in our solution NAV4Construction.

Subcontractor’s complete position engagement

In this example, we engage subcontractors for doing complete job by position. We get invoices/certificates from them for complete position engagement as we have this job in our Bill Of Quantities.

Doesn’t meter I said is too complex process, we mad it simply. For posting, we will also use the standard NAV purchase documents, Purchase Order or Purchase Invoice, but with some customizations. We will post this using Position types (new NAV4Construction type), and we also must to set Job No. and Job Task No. in Purchase Lines.

Image

When we post this document, we will get Job Ledger Entries with G/L Account types (G/L Account from Posting Groups) as cost, and also Position Ledger Entry with output quantity and price from BoQ, and posting type Subcontractor, as well. With only one posting, we will get complete posting process, and we can prepare our invoice to customer.

Construction Management (briefly)

By starting the project and quote acceptance, we start with work on new project. We need to add few specific characteristics: Contract Status (Accepted), Contract No. and Contract Date. We can add many preconfigured setup field (by the company, or by the project). Also, we have to define Job expected end date as the really end date (if we know that this date will be different of end date by the contract)L.

After that, it is possible to monitor effectively all project tasks. Executed works of mechanization or labor work could be entered for each project. Also, material or finish goods consumption could be added. A number of specific parameters in posting process could be added depending on the construction company. We can post all consumption (resources and/or items) and output (construction positions) by two different models. First model (Output Orders) is precise (monitoring all consumption per each position on date on task on project) but more complex for daily work in NAV. Second model (Project Journal and Position Journal) is more relax for posting, but we cannot get the most precise information. Regardless of posting model, we can add many parameters on each journal line. We can add specific monitoring of each resource (by specific mechanization resource no. and each employee if you want) with what is done (Work Type), how much is worked (Ongoing Quantity – different unit of measure), Stand By Time or Extremely Stagnation Time, Mileage (if this is a vehicle)…

When we have many subcontractors, we can post their invoice using Purchase Invoice or Purchase Order with specific Type – Position. When we post this invoice, we get automatically prepared constructing positions for invoice to investor.

Image

After construction output posting on the end of month, all construction lists (Book of Quantities) for all positions could be created with simple command that can be subsequently corrected by the project supervisor. System has multidimensions controls and prepare this constructing positions for invoice.

Image

After gathering signatures for construction lists by project supervisor, you can easily create invoices/certificates for investors without possibility of errors or data inconsistences (for all construction positions, subcontractors work and re-invoice). If invoice is still not accepted, it is possible to post WIP journal. So we can post income on different date, and we can look income per work period and income per invoice date (e.g. for VAT check).

Image

The user can monitor the subcontractor works on each individual position in the construction process if user does not work complete project alone. The user can monitor the subcontractors in complete collaboration life cycle, monitoring the receipt of offer and selection of the best offered deals and registering and posting complete work of subcontractors. Also, all of these tasks could be easily re-invoiced without repetitive entry typing.

Many others, but about that in some other post…