Microsoft Dynamics NAV

Forum Post: RE: Jobs and GL Entry

Aleksandar Totovic — Fri, 24 May 2013 17:55:00 GMT

You are not in right. If the GL cost requires updating the GL Entry, it is recommended to use an Job G/L Journals instead of Job Journals. Job Journal do not make GL Entries.

This is a standard NAV process.

Blog Post: How to Handle Expense Items in Microsoft Dynamics NAV

ArcherPoint — Fri, 24 May 2013 15:27:00 GMT

How to Handle Expense Items in Microsoft Dynamics NAV

I am often asked how to set up Dynamics NAV to handle Expense Items. After searching the various NAV Forums, I thought it would be helpful to offer my solution.

The Scenario

You want to set up Expense Items in NAV so that it is easier to enter Purchase Orders without typing the description each time as you would if you charged all expense purchases to a General Ledger Account.
You want to be able to see the quantity on hand of all of the Expense Items.
When you purchase an Expense Item, you want to charge the Expense in the General Ledger as opposed to putting the cost in the Balance Sheet Inventory Account.
When the Expense Items are taken from inventory, you do not want to affect the balance in the Expense General Ledger Account.
When you run the Inventory Valuation Report, you do not want the Expense Items to be included in the total.

The Solution

Create a new General Product Group = Expense

Create a new Inventory Posting Group = Expense

For each Expense Item, go to the Invoicing Tab and set up as follows:

Set the Costing Method to FIFO.
Set the Purchases to be the Expense Account that you want to use.
Set the Inventory Adjustment Account to be the same Expense Account that you want to use.
Set the Direct Cost Applied Account to be the same Expense Account that you want to use.
Set the Inventory Account to be the same Expense Account that you want to use.
Set the Interim Inventory Account to be the same Expense Account that you want to use.

On the General Tab, check the “Inventory Value Zero” box.

Accounting Detail

You purchase an expense item for $1.00

Receive the item – There is No G/L Effect
Invoice the Receipt – There is a $1.00 debit to the Expense Account and a $1.00 credit to Accounts Payable. What you are left with is $1.00 in the Expense Account and $1.00 in Accounts Payable
Using the NAV Item Journal, remove the Expense Item from Inventory – There is no G/L Effect

This removes the Expense Item from inventory, but leaves the balance in the Expense Account the same, and because you checked the "Inventory Value Zero" box, the item will not show up on the Inventory Valuation Report.

I hope this scenario and its solution helps with your understanding of expense items. If you have any questions, I invite you to contact us at ArcherPoint.

Blog Tags:

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

Forum Post: RE: NAV 8

Benoit Delvaux — Fri, 24 May 2013 14:15:00 GMT

Microsoft wants to release a major update of NAV on a yearly basis. So indeed you can expect NAV 8 to be released by the end 2013/beginning 2014...

The code name for the next release is "Sicily" you can try to google for "Nav sicily" to get more information about it.

Anyway here is a recent blogpost about Sicily : saurav-nav.blogspot.nl/.../get-ready-for-new-version-of-nav-nav-8.html

Regards,

Forum Post: RE: Localization and CfMD

Aleksandar Totovic — Fri, 24 May 2013 13:12:00 GMT

I just sent the documents for CfMD to LionBridge. I prepared Appendix A-F and all related documents (hundreds of pages). Now I upload database.

Soon I will be able to give you a more experiences.javascript:void(0);

Forum Post: RE: Zetadocs Express for NAV 2013

Aleksandar Totovic — Fri, 24 May 2013 12:54:00 GMT

Whan version os SPP you use?

Have you sign in form on SPP home page where you choose login type (Windows Authentication or Form Authentication)?

Forum Post: RE: OLHandler.dll

kevj — Fri, 24 May 2013 11:28:00 GMT

Have instal this combination

Win 8, Office365 ,Nav 2009R2, OLHandler.dll

get error CL/A in OLHandler (not registrerad)

with communication with Outlook365

have test with NAV in same config in

Win 8, Office 2013 ,Nav 2009R2, OLHandler.dll

and

Win 7, Office 2013 ,Nav 2009R2, OLHandler.dll

In this config it works OK

witch OLHandler.dll are right for Office365

Forum Post: RE: ERP Mannual

Aleksandar Totovic — Fri, 24 May 2013 10:52:00 GMT

Standard PDF manuals for NAV are not a free. You can get it for free if you are partner.

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

Arturs Gedvillo — Fri, 24 May 2013 09:22:00 GMT

Thank you for your inputs.

Forum Post: RE: Production Forecast

Aleksandar Totovic — Thu, 23 May 2013 21:18:00 GMT

Maybe it's stupid, but there are reasons for it. As I said, you can make customization; it is not too complicated.

Blog Post: Manufacturers gain operational efficiency, sacrifice improvements in supply chain visibility: New report

MSDynamicsWorld.com — Thu, 23 May 2013 21:01:00 GMT

A new report from KPMG found that while global manufacturers are putting their supply chains at the center of their business strategies, a whopping 54 percent of domestic manufacturers admit that their supply chain visibility doesn't go beyond their Tier 1 suppliers (those direct suppliers to OEMs).

The findings are part of New York-based KPMG's 4th annual Global Manufacturing Outlook - Competitive Advantage - Enhancing Supply Chain Networks for Efficiency and Innovation. Survey participants included 335 global executives - 95 of which are in the U.S. Of those respondents, just 9 percent (7 percent domestically)...

Forum Post: RE: Base UOM

Savatage99 [MVP] — Thu, 23 May 2013 15:33:00 GMT

My (F1) help says:

You can only enter a unit of measure code that has the value "1" in the Qty. per Unit of Measure field in the Item Units of Measure window.

You can set up different units of measure for purchases and sales in the Item Units of Measure window and you can set up translations for various language codes in the Unit of Measure Translations window

You cannot change the unit of measure code if there are open ledger entries for the item.

Blog Post: NAV2013 Reporting: Things to be careful about

Magno — Thu, 23 May 2013 10:10:00 GMT

Let me start by excusing myself for an absence of posting lately. It has been very busy recently in my private life. Becoming a father certainly makes you more prone to setting priorities

Lately I have been making several NAV2013 reports, so maybe it is time to make another post with issues you might run into, or in general even certain methods which could be convenient for you to know about.

1. Building the dataset

When creating a document layout, I was using an Integer DataItem below my lines to show some more information (in case it was needed). Using PRS, I had a function in a CodeUnit which would build my temporary record used for the DataItem, and loop it accordingly with the code below

--- Integer - OnPreDataItem ---  SETRANGE(Number,1,TempRecord.COUNT);    --- Integer - OnAfterGetRecord ---  IF Number = 1 THEN    TempRecord.FINDSET  ELSE    TempRecord.NEXT;

The call to fill my TempRecord was also returning a Boolean, to add to my dataset and make the table visible altogether or not (otherwise my headers would be printed).

So I added the single line call to the columns filling the TempRecord and the Dataset with my Boolean…

When running my report, I was nicely presented with 2 records of my Integer DataItem, however both times containing the last record instead of 2 different records.

Debugging showed actually looping through the TempRecord nicely, until I noticed that everytime a row for the dataset needed to be created, NAV loops through all your columns and runs the business logic if it points to a function instead of a field. Meaning that for each time, it clears my TempRecord and fills it again, positioning it at the last inserted record at the same time…

This sort of made sense of course (well, I hoped it would have cached the data of the other DataItems…), but has the logical result that I could not make the single line call in my dataset, but in code, preserving the result of the function in a Report variable and add that one to my dataset…

So remember, try to buffer everything possible in your dataset, a lot of unnecessary code could be run otherwise for each record in your dataset, instead of just the times necessary.

2. Copying Tablixes

The TempRecord above also needed to be in a table, which almost looked like the table used for my document lines, so logically I copied that one. The source table however had a lot of logic about visibility in it, which gets copied nicely. I started changing sorting, filters, rows, … from my new table until I had what I wanted and started to test again, just to notice that no data whatsoever was printed…

This took some time to figure out as well, but running through the XML of my RDLC revealed that some hidden properties of deleted rows were actually not deleted in the XML and no longer accessible from the design view.

Again, another bullet point to our reminder list: Try not to copy Tablixes , since they might get corrupted. The only way to be sure your table is created the way you want it, is to start from a blank one, which is a bit more work. But let’s be honest… it’s still pretty much manageable and not that much more work (or even less work in the end/long run)

Forum Post: RE: Standard Cost update

Ian Fletcher — Thu, 23 May 2013 09:49:00 GMT

Hi Both, as said i'm an end user so do not know how to write code or if my license allows this?

RE SKU - We use SKU's for items that we hold for customers with Zero costs, as they use it several times a yearas a call off, so we do not want to post costs everytime it is on a sales order, the value is added by using resource codes for Labour - so we need to keep the SKU's the same costs which is £0.00 these items are identifed as different from manufactured finished goods by the fact they are in a different Location & dfferent Bin, so if we could limit an update to just Items from Location Main that would be good & should then ignore SKU's?

Blog Post: Component Flushing Methods in Microsoft Dynamics NAV

ArcherPoint — Thu, 23 May 2013 04:50:00 GMT

Component Flushing Methods in Microsoft Dynamics NAV

I get a quite a few questions related to Component Flushing Methods in Microsoft Dynamics NAV. After looking at the various NAV Forums, I thought a more in depth explanation of this function might be of some help.

First of all, we need to define flushing. The APICS Dictionary defines it as "A set of inventory bookkeeping methods that automatically adjusts computerized inventory records based on a production transaction. Examples of automatic relief methods are backflushing, direct-deduct, and pre-deduct processing." This concept is quite complex, so I have written a more detailed definition:

Flushing is the process of recording the movement of inventory items from a storage location to Work-in Process (WIP). Work-in-Process here means the production area where the material will be used. There can be three type of flushing:

Forward Flushing (pre-deduct processing)—An automatic flushing type in which the movement of inventory items to WIP is automatically recorded before the Production Order is started or a single Production Order Routing step is started.

Backward Flushing (backflushing)—An automatic flushing type in which the movement of inventory items to WIP is automatically recorded after the Production Order is completed or a single Production Order Routing step is completed.

Manual Flushing (direct-deduct)—The movement of inventory items is recorded to WIP as it happens

If this were not complicated enough, we also have to consider something called Routing Link Codes in Dynamics NAV.

First let’s define routing. I again went to the APICS dictionary to get this: "Information detailing the method of manufacture of a particular item. It includes the operations to be performed, their sequence, the various work centers involved, and the standards for setup and run. In some companies, the routing also includes information on tooling, operator skill levels, inspection operations and testing requirements, and so on."

Using the screen shots from Dynamics NAV 2013 for a Routing and Bill of Material and Item, we can see that the routing has Routing Link Codes 100 and 300 assigned for Operation 10 and Operation 40 and the Bill of Material has the Routing Link Codes assigned to components on the Bill of Material. The Flushing method is set up on each item card.

Dynamics NAV Routing

Dynamics NAV Production Bill of Material

Dynamics NAV Item Card

Following is how Dynamics NAV handles the timing for each flushing method:

Manual Flushing—A manual flush is performed when the consumption transaction is posted by the user using the Dynamics NAV Consumption Journal or the Production Journal.

Automatic Flush—The table below discusses timing for forward and backward flushing:

	Forward Flush	Backward Flush
With Routing Link Codes	The system will automatically deduct the component(s) with the Flushing Method of Forward on the BOM with the associated Routing Link Code when the Individual Routing Step is Started	The system will automatically deduct the component(s) with the Flushing Method of Backward on the BOM with the associated Routing Link Code when the Individual Routing Step is Completed
Without Routing Link Codes	The system will automatically deduct all of the components on the BOM with the Flushing Method of Forward when the Production Order is Released	The system will automatically deduct all of the components on the BOM with the Flushing Method of Backward when the Production Order is changed to the status of Finished

The choice of which flushing method to use is dependent on your situation, but here are some thoughts to keep in mind:

If you are using Lot or Serial Tracking, automatic flushing is not a choice.
If the items you actually consume and use in production are typically different from what is in the Bill of Materia, automatic flushing is not a choice. This may be particularly true in process manufacturing where the quantity of items consumed may be more or less than what the Bill of Material calls for.
If your production cycle is long (more than a week), you should consider Routing Link Codes so that consumption can be recorded when the Routing Step is started or completed.
If your production cycle is short (e.g., one day), you should consider back flushing without Routing Link Codes so that all of the items are consumed when the production order is Finished.

Blog Tags:

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

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

Jens Glathe — Thu, 23 May 2013 03:53:00 GMT

Hi,

thanks for the info, the download works now.

with best regards

Jens

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.