Skip to main content

Save your time, Save your Business

Helping your, help your business

Comments

Post a Comment

Popular posts from this blog

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV

RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS in NAV …nice reporting functions are available from NAV 2015:  EX: RUNREQUESTPAGE, EXECUTE, PRINT, SAVEAS MY BEST FUCTION IS:  “RUNREQUESTPAGE” -> “ This function lets you run a request page for a report, without actually running the report. When the user clicks OK, the function simply returns a text value , which is an XML document describing the user’s selection and filters of the request page.”; you can use this function also to schedule a report on Job Queue (OnDemand report schedule) ex: a reports launcher page, scope of this page is run selected reports and generate PDF files after reports printing (or after preview mode report printing) The system use fiunction REPORT.RUNREQUESTPAGE to read and retrieve reports parameters RUNREQUESTPAGE XmlParameters:= REPORT.RUNREQUESTPAGE(intIDReport); … after you get the following XML document as a result: EXECUTE Now is time to run report with EXECUTE f...
Post a Comment
Read more

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV

Purchases and Direct Cost Applied Accounts in Microsoft Dynamics NAV When working on new Dynamics NAV implementations (and for that matter, existing NAV solutions), we get a lot of questions about the Purchases and Direct Cost Applied Accounts—namely, what are they used for? We were trained in accounting that, when an inventory purchase receipt is invoiced (vouchered), we would debit the Inventory Account and credit the Accounts Payable Account and be done with it. Dynamics NAV doesn’t handle it that way. When we look at the General Posting Setup in Dynamics NAV 2013 (see below), we see that there is a column for the Purchases Account and the Direct Cost Applied Account. Figure 1 - General Posting Setup in Dynamics NAV 2013 When a purchase receipt is invoiced (vouchered) in NAV, we get the following General Ledger entries: Dr Purchases Account for the Actual Invoice Amount Cr Accounts Payable Account for the Actual Invoice Amount Dr Inventory Account for the Ac...
Post a Comment
Read more

How to Determine Who Has a Table Locked in Microsoft Dynamics NAV

How to Determine Who Has a Table Locked in Microsoft Dynamics NAV I recently fielded a support call from a frantic customer that went something like this: “Help! Nobody can post anything! All we get is a message that Item Ledger Entry is locked by another user! AAAAAAHHH!!!” Very useful. The system knows enough to realize there is a block, but won’t bother to tell you which user is causing the problem. The usual fix is to restart the service tier, SQL service, or to reboot the whole SQL server. Why yes, as a matter of fact, everyone would love to stay an extra 20 minutes late today because of a server reboot. Awesome! If you’re looking for a better alternative, there are two ways of figuring out who has the lock. You can do so from inside of NAV depending on the version, or you can tell from SQL regardless of the version. Finding the Guilty Party from Inside NAV If you are using Version 4.0 through 2009 R2 (it went away in 2013), then you can use Database Sessions. (...
Post a Comment
Read more