Microsoft Dynamics NAV

Forum Post: RE: NAV2013 Update Rollup 2 - download fails

Neville Foyn — Thu, 23 May 2013 01:11:00 GMT

I have just been able to download it from your link, looks like it is back up

Cheers

Nev

Forum Post: RE: NAV Server 2013 RAM Sizing and Usage

Neville Foyn — Thu, 23 May 2013 01:07:00 GMT

As mentioned, the performance requirement is hard to nail down, you could run Windows 7 on a PC with 512 Megs of ram but it wouldn't be fun to work on, this is how we make recommendations to our clients, it is not meant to be perfect from a technical perspective it is rather aimed at making things more understandable

With regards to the memory usage question: Memory is the best value for money performance gain on the server, as it is them able to use the memory instead of reading from the HDD which can be up to 3000 times slower than memory

You shouldn't restrict the amount of memory being used

From a practical perspective these are the recommendations we make to our clients, this was for a 15 user site, this was to be a combined SQL and Application server,

---------------------------

1x Quad Core processor (Preferably 2)

– This directly affects the number of users that are able to work simultaneously, as the server is running SQL server as well as the NAV application server this means that each user will use a core when NAV is working on something for them and a code when NAV requests data from SQL to perform their task, adding additional cores is recommended as the user load grows and for more complex sites

12 Gigs RAM (More if possible here)

– The RAM is the single largest performance boost for a SQL server and continues to be until the amount of ram is greater than the size of the database + Temp tables, therefore 12 gigs is a good starting point but it can be grown later,

Expect the application servers to use up to 2 gigs of ram per 5 users, so this will provide 2 gigs of ram to the OS, 6 gigs of ram to 15 users and leave 4 gigs for the database, once the database grows beyond 4 gigs the amount of RAM in the server should be reviewed, this is dependent on the complexity of the site

(RAM is the best value for money performance improvement on a SQL server)

4x Hard drives (Speed of drives is much more important than the size of the drives)

– This becomes the next bottleneck after the RAM, as the performance of data retrieval from drives affects the speed at which the system can respond to client queries, a minimum of 4 drives are recommended in a RAID 10 setup,

(RAID 5 did not perform well on previous SQL editions, in the current editions it does now work however RAID 1+0 performs better when there has been a failure of a drive),

More drives (Added in sets of 2) will significantly improve drive performance, although servers have built in RAID controller, a separate battery backup raid controller is recommended for all sites but required for larger or more complex sites

Slower drives will also affect the performance of the processor as it waits for data retrieval from the drives

----------------------------

Hope this helps make everything a bit clearer

Cheers

Nev

Forum Post: RE: Standard Cost update

Neville Foyn — Thu, 23 May 2013 00:19:00 GMT

Yes as as said by Alexandar you will need to customize if you want to only update certain items, as per his post you can look at the way it updates, you could also create a tick on the items that are modified and use this to only populate the correct items onto the standard cost worksheet, you could also have the system process everything then delete all the items except the Finished goods you actually want to update before you press the implement button

My recommendation though is to see if you could rather update all when you run these updates, i have found in the past that items can end up only partially updated or missed entirely in the update when trying to only update certain items

On the SKU, if you are updating the item but not the SKU you are in effect not updating the items cost as the cost of the SKU is used when the system looks for a cost, not sure why you would want to leave that out?

Hope this all makes sense?

Blog Post: Live Thursday: Microsoft Dynamics NAV Roundtable

MSDynamicsWorld.com — Wed, 22 May 2013 19:16:00 GMT

With Wednesday's release of Update Rollup 2, Microsoft Dynamics NAV 2013 is now well into its release lifecycle. So what are Dynamics NAV implementers thinking about these days? With the profound changes rolled out in 2013 and a new release due later in 2013 as part of the new annual release cadence, we thought this would be a great time to chat with some NAV community veterans to discover what they a...

Blog Post: Nueva actualización para Microsoft Dynamics NAV 2013 (Update Rollup 2 - Build 34688)

Miguel Llorca — Wed, 22 May 2013 12:41:00 GMT

Ya está disponible el “Update Rollup 2 for Microsoft Dynamics NAV 2013 (Build 34688)”.

Es aplicable a todas las versiones de NAV 2013, es decir, para todos los paises, aunque se incluyen algunas actualizaciones específicas para:

DE - Alemania
DK - Dinamarca
NA - Norte América
NL - Holanda
UK - Reino Unido

Se espera que en Junio tengamos otra nueva actualización, que incluirá probablemente actualizaciones específicas para Francia e Italia.

En esta actualización se incluyen por separado tanto actualizaciones de Aplicación como de Plataforma.

¿Dónde encuentro más información?

Aquí está el enlace a la Knowledge Base…

Para ver una lista completa de las actualizaciones incluidas os dejo los siguiente enlaces:

CustomerSource

Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013

Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

PartnerSource

Overview of Released Application Hotfixes for Microsoft Dynamics NAV 2013

Overview of Released Platform Hotfixes for Microsoft Dynamics NAV 2013

Un par de recomendaciones finales:

Haz siempre una copia de seguridad antes de aplicar cualquier actualización.
Contacta con tu partner certificado si no estás completamente seguro de como realizar la actualización y sus repercusiones.

Forum Post: RE: 13th period accounting period

Jens Glathe — Wed, 22 May 2013 07:17:00 GMT

Hi,

for technical reasons you can't set up a 13th (or more) periods, but you can separate your adjustments with reason codes. The way to go would be to set up a general journal batch with the reason code, so all postings being entered there will have this reason code. For reporting it would be good to add reason code as filter for the chart of accounts, and account schedule (it also works on standard reports then). Unfortunately, Reason Code is not set up as a filter by default. This would have to be done by an (inhouse) NAV developer, but it's fairly easy to achieve.

I would suggest this as best practice :)

with best regards

Jens

Blog Post: Manufacturing and Costing Sessions Set for NAVUG Forum 2013

ArcherPoint — Wed, 22 May 2013 04:06:00 GMT

Manufacturing and Costing Sessions Set for NAVUG Forum 2013

It’s just a short five months until NAVUG Forum 2013 will be held in Tampa, Florida.

I just participated in a planning session for Forum 2013 to set the session content in the Microsoft Dynamics NAV Manufacturing and Costing areas. As it looks at this time, there will be a repeat of the popular sessions in the past, along with some new and informative content.

I will be presenting again and will be conducting a new two-hour session on “Manufacturing Accounting for non-Accounting Professionals.” As Manufacturing and Material Management Professionals, we are graded on key performance indicators like quality, delivery, and efficiency, but, in the end, our performance is ultimately graded on how our departments perform financially.

The session will be directed to Manufacturing and Material Management Professionals who may have had a course or two in accounting, but never got to the advanced courses in cost accounting.

This two-hour session will start with the fundamentals of accounting, then progress to manufacturing accounting. At the end of the session, attendees should have a good understanding of “where do these numbers come from?”

Don’t miss this and other informative sessions and an opportunity to network with others in the NAV community. Register for NAVUG Forum and be sure to become a member of NAVUG.

Blog Tags:

Bob Bergman's blog
Log in or register to post comments

Blog Post: Update Rollup 2 for Microsoft Dynamics NAV 2013 has been released

Microsoft Dynamics NAV Team — Tue, 21 May 2013 15:45:00 GMT

Today we have released update rollup 2 for Microsoft Dynamics NAV 2013.

Update rollup 2 includes all application and platform hotfixes that have been released for Microsoft Dynamics NAV 2013. The update rollup includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

DE - Germany
DK - Denmark
NA – North America
NL - Netherlands
UK – United Kingdom

Update rollup 3, which is scheduled for release in June, will include local hotfixes for France and Italy as well.

Where to find update rollup 2

You can download update rollup 2 from KB 2843305 - Update Rollup 2 for Microsoft Dynamics NAV 2013 (Build 34688).

The hotfixes that have been released since update rollup 1 are listed in this KB article. For a full list of all hotfixes included in update rollups for Microsoft Dynamics NAV 2013, see the following CustomerSource and PartnerSource pages:

CustomerSource:

PartnerSource:

More Information

For more information about the update rollup process for Microsoft Dynamics NAV 2013, see Announcement of new hotfix process for Microsoft Dynamics NAV 2013.

Blog Post: Microsoft Announces Winners of the 2013 Partner of the Year Awards

MSDynamicsWorld.com — Tue, 21 May 2013 12:16:00 GMT

Microsoft Corp. has announced the winners and finalists of 2013 Partner of the Year Award Winners and Finalists.

The annual awards honor Microsoft partners for delivering innovative solutions during the past year that directly address customer challenges. Award winners and finalists, chosen from global nominations, will be recognized at the 2013 Microsoft Worldwide Partner Conference, July 7-11 in Houston.

This year, there were 44 awards that celebrated each core partner competency, including Microsoft Dynamics, and 95 Country partner of the Year awards. More than 3,000 entries were collected from 106 countries; the award finalists and winners were selected from nominations based on their commitment to customers, their solutions' market impact and exem...

Forum Post: RE: Dynamic Nav MS BI Tools and Database & Support after implementation

Neetoo Sharma — Tue, 21 May 2013 09:47:00 GMT

Dear Hatem, you can write to us on neetoo.sharma@sharobitech.com

We can explore further on this.

Thank You

Forum Post: RE: Correct wrong unit cost from purchasing how

ahmed barbary — Tue, 21 May 2013 08:42:00 GMT

to more clear to you after i make revaluation to cost to 0 and adjustment quantity to 0

i see revaluation to item i found it as value entry

quantity cost amount actual

0 -40

and cost per unit in value entry is 40

40 is value cost of invoiced quantity and still found my problem how i remove this -40 and make to 0

this is example to thread above

thanks

Blog Post: The Effects of Inventory Setup in Microsoft Dynamics NAV

ArcherPoint — Tue, 21 May 2013 06:12:00 GMT

The Effects of Inventory Setup in Microsoft Dynamics NAV

I am often asked questions on the effects of Inventory Setup in Microsoft Dynamics NAV. The two most common questions are:

1) How do the settings affect system performance?

2) How do the settings affect what is posted to the General Ledger and when?

In this blog, I will discuss these questions in the context of Automatic Cost Posting, Expected Cost Posting to G/L, and Automatic Cost Adjustment in Dynamics NAV, saving Average Cost for a later blog.

Let’s start by going to Inventory Setup. Go to Warehouse->Inventory->Setup->Inventory Setup:

Inventory Setup Window in Microsoft Dynamics NAV Classic Client

Automatic Posting

To understand what Automatic Cost Posting does, it’s important to understand Dynamics NAV’s Value Entries. When an inventory transaction is recorded in Dynamics NAV, an associated Value Entry is automatically entered into the Value Entry Table. This Value Entry reflects the cost of that transaction, whether positive or negative. Additional Value Entries can be added later by the Adjust Cost program.

If Automatic Cost Posting is checked, every time a Value Entry is entered into the Dynamics NAV database, the corresponding General Ledger entries are automatically made.

Expected Cost Posting

The key to understanding how Expected Cost Posting to G/L works is being aware that there can be two types of Value Entries. For instance, when a purchase order is received but not invoiced, Dynamics NAV automatically enters a Value Entry with an expected cost. When that purchase is invoiced, NAV automatically enters a Value Entry that reverses the original expected entry with the expected cost and replaces it with one with the actual costs.

By checking Expected Cost Posting to G/L, the system will post expected values to the General Ledger. If this is not done, an accrual General Journal Entry should be posted at the end of an accounting period to bring the General Ledger into balance with the Inventory Sub Ledger.

Inventory Setup Window with focus on Automatic Cost Adjustment

Automatic Cost Adjustment

Automatic Cost Adjustment is a fairly complex process and will be covered in more detail in a later blog, but for now, I’ll explain it this way:

There are two types of inventory transactions: 1) those that add inventory (inbound) and 2) those that remove inventory (outbound). For each transaction type, NAV enters at least one Value Entry to represent the cost of that transaction. Outbound Value Entries get their cost from the Inbound Value Entry that supplied it, for instance, a purchase order lot is received and a sales order is shipped from that lot.

There are times, though, when the original cost that was entered for the purchase order receipt was incomplete and, therefore, the cost transferred to the sales order cost of goods sold is incomplete (i.e., freight costs were added later). When the added cost is made to the purchase receipt, the Adjust Item Entries Cost program finds the outbound entries that were supplied by the purchase order and adjusted to show the additional cost.

To explain Automatic Cost Adjustment, I have included the following from NAV Help:

In this field you can set the program up to adjust for any cost changes automatically every time you post inventory transactions. The adjustment process and its consequences are the same as for the Adjust Cost - Item Entries batch job.

Because potential cost adjustment during every inbound posting could slow down database performance, this setup field includes time options (see below) so that you can define how far back in time from the work date an inbound transaction can occur to potentially trigger adjustment of related outbound value entries.

When setting a time option for automatic cost adjustment, you should therefore select one that balances your requirements for cost accuracy with the performance level of your database. Generally speaking; the shorter the time setting, the less accurate the cost information, but the better the database performance during posting.

In my experience, I have always selected ‘Never’ or ‘Always.’ If you select ‘Never,’ however, you must run the batch job Adjust Cost – Item Entries.

Microsoft Dynamics NAV Financial Management Window

If you are experiencing system performance issues (locked tables), it probably means you have set up Automatic Cost Adjustment to Always and Automatic Cost Posting is turned on. To alleviate these performance issues, change the setting Automatic Cost Adjustment to Never and turn off Automatic Cost Posting. This means, however, that you will need to run the Adjust Cost and Post Cost batch jobs.

For a new implementation, I try to make a determination as to transaction volume. If there is a high transaction volume, then I recommend turning off the automatic features.

As for Expected Cost Posting, it is the choice of the financial team as to whether to use it or not. From a performance point of view, there is not much effect, but it does add a significant number of records to the General Ledger. My choice is to turn it on as it does provide valuable information and it does make reconciling the Inventory Sub Ledger to the General Ledger much easier.

If you are in doubt about which setting to use, the good news is that you can turn Automatic Cost Adjustment on or off without compromising costing accuracy.

If you would like to learn more or have questions about Inventory Setup for your company, contact ArcherPoint.

Blog Tags:

Bob Bergman's blog
Log in or register to post comments

Forum Post: RE: Recurring Journal problem

Aleksandar Totovic — Mon, 20 May 2013 22:04:00 GMT

Put 1D+1M-1D formula in Recurring Frequency

Forum Post: RE: Customize navigation pane

Aleksandar Totovic — Mon, 20 May 2013 20:37:00 GMT

At the bottom left of the screen, push Configure buttons->Customize Navigation Pane...->New

After that, you need choose name of navigation pane and select button icon.

Blog Post: Congratulations to the 2013 Microsoft Dynamics WPC Partner Award Winners

Jon_Rivers — Mon, 20 May 2013 18:36:00 GMT

Microsoft announced today its Microsoft Dynamics WPC 2013 award winners and finalists. This year, there were 44 awards that celebrated each core partner competency, including cloud technology, Windows 8, and Microsoft Office and SharePoint applications, as well as entrepreneurial spirit, citizenship and sales excellence. More than 3,000 entries were collected from more than 100 countries; the award finalists and winners were selected from nominations based on their commitment to customers, their solutions’ market impact and exemplary use of Microsoft technologies.

An extra special round of applause to Data Masons’ partners mcaConnect, Tribridge and Hitachi! We’re always happy to see the partners we support excel at solving their customers’ business challenges.

Award highlights:

Customer Relationship Management (CRM)
Winner: PowerObjects
Finalist: CRM Partners
Finalist: Customer Effective
Finalist: Navantis

Enterprise Resource Planning (ERP)
Winner: eBECS
Finalist: GMCS
Finalist: Hitachi Solutions America Ltd.
Finalist: Tribridge

Microsoft Dynamics Cloud
Winner: eSavvy
Finalist: SMB Suite
Finalist: Tribridge

Microsoft Dynamics Industry
Winner: mcaConnect
Finalist: V.R.P. Veri Raporlama Programlama Bilisim Yazilim ve Danismanlik Hizmetleri Ticaret A.S.
Finalist: INFOMA Software Consulting GmbH
Finalist: HSO International

For a complete list of all Microsoft Worldwide Partner Conference Awards 2013 winners and more information on our winning partners go to Digital WPC.

Well done everyone! See you at WWPC in July!

The post Congratulations to the 2013 Microsoft Dynamics WPC Partner Award Winners appeared first on EDI Integration with Microsoft Dynamics | Data Masons EDI Software Blog.

Forum Post: RE: Localization and CfMD

Jens Glathe — Mon, 20 May 2013 18:04:00 GMT

Hi Aleksandar,

ok, I'll bite ;-) I have commented on my experience with the CfMD procedures on mibuso (warning: explicit content): www.mibuso.com/.../viewtopic.php But it wasn't for NAV2013, so maybe this has changed for the better. We have our granules now.

with best regards

Jens

Forum Post: RE: Clinic Management Solution Add on for Microsoft Dynamics NAV

Aleksandar Totovic — Mon, 20 May 2013 16:43:00 GMT

Try to find at AddOn Solutions catalog:

www.dynamicswest.com/.../MicrosoftDynamicsNAVAdd-ons.pdf

Forum Post: RE: NAV 8

Aleksandar Totovic — Mon, 20 May 2013 16:17:00 GMT

I have a lot of existing clients who use classic client. But all new clients (at least most of them) prefer RTC.

Anyway, we expect NAV 8 on end of year. Microsoft sets the rules, and we can only adapt or give up.

I hope it will not be too many changes in code and we will do the localization easier than NAV2013.

Blog Post: SharePoint 2013 Outlook Calendar Integration

Ash Chandler — Mon, 20 May 2013 14:30:00 GMT

Microsoft SharePoint® 2013 Calendar Integration with Microsoft Outlook®

Two way SharePoint and Outlook calendar integration is still a great feature with SharePoint 2013. The feature has been around in a previous version of SharePoint, but I thought it was worth re-visiting it briefly for any new adopters of SharePoint 2013.

To connect your SharePoint 2013 calendar to Outlook (in this example I am connecting to Outlook 2010) all you have to do is click the ‘Connect to Outlook’ button in the Calendar ribbon.

You will then be prompted by Internet Explorer to allow the connection.

Click ‘Allow’. Then Outlook will ask you to confirm the connection too.

Click ‘Yes’. Outlook will then present the SharePoint 2013 calendar just like any other outlook calendar.

You can now work with the calendar from either Outlook or SharePoint and all your changes will be automatically synchronised between the two. For example, add an appointment in Outlook...

...and it will automatically appear in the SharePoint calendar.

Likewise, any changes you or anyone else makes to the calendar from SharePoint will appear back in Outlook.

By connecting your SharePoint 2013 calendars to Outlook you can use the familiar and powerful Outlook calendar tools for keeping your calendar up to date. You can also view a SharePoint calendar side by side with an Outlook calendar or view it as an overlay. You can even copy events among SharePoint and Outlook calendars, without leaving Outlook.

Blog Post: Connector for Microsoft Dynamics - integrating CRM with NAV5!

Ash Chandler — Mon, 20 May 2013 13:05:00 GMT

Connector for Microsoft Dynamics - Integrating CRM with NAV5!

The Dynamics Connector, despite its usability issues, is starting to gather a little momentum, due mainly to its flexibility and price tag. As the Connectors popularity grows, it is inevitable that you will sooner or later come up against something that it really was not designed to do, in my case this was to integrate with a version of Microsoft Dynamics® NAV prior to NAV 2009 or more specifically in this instance - NAV 5 but the same principles would apply to older NAV versions although with a little more work to get the Pages to fit.

You still need to be running the Dynamics NAV 2009 R2 client and middle tier as it is this that provides the architecture for the Connector to communicate with the Dynamics NAV data but providing you are up to date with your enhancement (BREP), or at least were at the time that NAV 2009 was released, then this is an FOC update and just requires installation of the new client and setup of the middle tiers. You then have a handful of Pages, a couple of Codeunits, an XMLPort, Form and Table or 2 to copy across as well as a few carefully chosen bits of code and you’re then pretty much ready to go.

Of course, you could just upgrade to NAV 2009 R2 or NAV 2013, click the enable connector checkbox and save the trouble and this is definitely the recommended (and supported) route, but if you don’t have the time or money for an upgrade or don’t see any other benefits for your business, then this is at least an option and should cost you no more than a couple of days of consultancy to get the Connector running maps against your old version of NAV.