This blog is about the possibilities of implementing ERP solution Microsoft Dynamics NAV in the construction industry. We will discuss about question „Is construction industry ready for ERP?
Of course, I will post about standard NAV, as well :)
After we have copied new job plan from source, we can change these date intervals to another by running the ‘Change Job Planning Line Dates’ batch job. This is useful if we have copied planning lines from another job and now want to rearrange the dates, by moving them all to another date.
We can start this batch job from Jobs->Periodic Activities->Change Job Planning Line Dates. I started story about this functionality in my last post. We can also use this batch job to update currency exchange rates on selected jobs. This is useful if the currency exchange rate has moved and we want the jobs updated to reflect the new exchange rate.
In the Currency Date section, we specify how currency dates should be changed. We only need to fill in the fields in this section if we want to change currency dates on the jobs.
In the Planning Date section, we specify how planning dates should be changed. We only need to fill in the fields in this section if we want to change planning dates on the jobs.
These are description of fields on this batch job:
A date formula is a short, abbreviated combination of letters and numbers that specifies how to calculate dates. We can enter date formulas in various date calculation fields and in recurring frequency fields in recurring journals.
In all data formula fields, one day is automatically included to cover today as the day when the period starts. Accordingly, if we enter 1W, for example, then the period is actually eight days because today is included. To specify a period of seven days (one true week) including the period starting date e.g., then we must enter 6D or 1W-1D.
The date calculation formula can contain a maximum of 20 characters, both numbers and letters. We can use the following letters, which are abbreviations for time specifications. It is possible that there letters are different when we use non-English language (we must read help file for specific language). There are the basic letters:
We can construct a date formula in next three ways:
1) The following example shows how current plus a time unit.
2) The following example shows how a number and a time unit. A number cannot be larger than 9999.
3) The following example shows how a time unit and a number.
The following example shows how we can combine these three forms as needed:
The following example shows how we can use a minus sign to indicate a date in the past.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics