Resolution for Navigation List Error

Navigation Lists in GP are pretty powerful but often ignored for just a few simple reasons.  Either users are not aware of them, or they get errors when trying to open Navigation Lists, so they just give up and never circle back to them.

If you fall into the former group, Navigation Lists can be found by visiting a module within Microsoft Dynamics GP and looking in the left margin (Navigation Pane).  Navigation Lists can save you tons of valuable time by performing many tasks right from within the list itself.  For example, if you wanted to put a few vendors on ‘hold’, or approve multiple workflow documents at once, you could do this right from the list window.

“Focus Shawn!  Tell us more on Navigation Lists in another blog, for today, we want to learn how to fix that pesky error!”  Ok, Ok Onto the fix.

As I mentioned, if you have tried using Navigation Lists, you may have received an error – something like rsAccessDenied400The permissions granted to user ‘XXXX’ are insufficient for performing this operation. blah blah blah.

There is text for a link – I’m sure it does go ‘somewhere’ but the link is incomplete.

Oh well – either way, this error relates to the Reporting Services permissions from SQL Server.  Why is this happening?  Well, when opening a Navigation List, Business Analyzer (Think SSRS) wants to access a few KPI’s and you apparently do not have access to them!  NOOOOO PROBLEMO!!!

You can either resolve your user access to those KPI’s or just turn off Business Analyzer.  You can do this by clicking the Navigation List name (see my example below) and turning off Business Analyzer (CTRL+F2 will do the trick too!).  This setting applies to that specific list, for the user making the change.

Easy.  But wait. there are a lot of Navigation Lists, and that’s a painful workaround, for each user!  No problem.  Here is a script to turn off Navigation Lists for every user.  Run this against your system database (mine is currently set as ‘Dynamics’).  This script will turn off Business Analyzer for all users, for all lists, for all companies!

UPDATE DYNAMICS..SY07225 SET FactBoxVisible = 0

If at any time a user wants to use Business Analyzer, all they have to do is go into GP and check Business Analyzer for that list!

By default, any new Navigation List is going to be set to show Business Analyzer.  This can be resolved by creating a simple trigger to update the FactBoxVisible setting to 0 after a new list is created.  Run this script against your system database if you want new lists to automatically ‘hide’ the Business

Analyzer.  Name it what you’d like

CREATE TRIGGER
dbo.disable_BA_On_Nav_Lists on dbo.SY07225 AFTER INSERT
AS
Update SY07225 SET FactBoxVisible = 0
GO

Of course, you could also resolve the security access to the reports if you want to use the KPI’s… IMHO, KPI’s in the lists take up too much space and slow things down a little – if I need the KPI, I’d rather access them directly through SSRS.

 

 Fix Dynamics GP scaling and font size issues on high DPI displays

Save this text to a file called "Scaling.reg".

Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\SideBySide]
"PreferExternalManifest"=dword:00000001

Once you have created the "reg" file, double click on it to import it into the Windows registry on the machine where Dynamics GP is installed.

Then save the below xml text to a file called Dynamics.exe.manifest.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0" xmlns:asmv3="urn:schemas-microsoft-com:asm.v3">
<dependency>
  <dependentAssembly>
    <assemblyIdentity type="win32" name="Microsoft.Windows.Common-Controls" version="6.0.0.0" processorArchitecture="*" publicKeyToken="6595b64144ccf1df" language="*">
    </assemblyIdentity>
  </dependentAssembly>
</dependency>
<dependency>
  <dependentAssembly>
    <assemblyIdentity type="win32" name="Microsoft.VC90.CRT" version="9.0.21022.8" processorArchitecture="amd64" publicKeyToken="1fc8b3b9a1e18e3b">
    </assemblyIdentity>
  </dependentAssembly>
</dependency>
<trustInfo xmlns="urn:schemas-microsoft-com:asm.v3">
  <security>
    <requestedPrivileges>
      <requestedExecutionLevel level="asInvoker" uiAccess="false"/>
    </requestedPrivileges>
  </security>
</trustInfo>
<asmv3:application>
  <asmv3:windowsSettings xmlns="http://schemas.microsoft.com/SMI/2005/WindowsSettings">
    <ms_windowsSettings:dpiAware xmlns:ms_windowsSettings="http://schemas.microsoft.com/SMI/2005/WindowsSettings">false</ms_windowsSettings:dpiAware>
  </asmv3:windowsSettings>
</asmv3:application>
</assembly>

Then copy your new Dynamics.exe.manifest file to the GP application directory where the Dynamics.exe file is located.
(C:\Program Files (x86)\Microsoft Dynamics\GP2018)

After the Correction GP will appear Normal.

How to Unapply the Customer Payment in R/M

This can be done using the Receivables Management Transaction Unapply Tool in the Professional Services Tools Library.

GoTo PSTL Main Setup
Click on RM Transaction Unapply

Click on Next
You will see the window below (Receivables Transaction Unapply)



In the above window choose the customer and you will see the Transactions that are checked, if you want to unapply the transaction just uncheck the Checkbox and it will prompt



Click on Unapply and it will give you the report that the payment is Unapplied

Error “You can’t choose this document because it is part of a recovered batch or is still in the process of posting”

You also see the error below when you try to delete the Invoice from the application.


Looked into the Invoice and the Invoice seems to be right but somehow when you try to post and also apply gives the same error.

Looked into the SY00800, SY00801 and SY00500 tables nothing seems to work.

The only resolution is to delete the Invoices from the table and re-enter them POST and re apply them.

Below are the tables and the queries that the Invoice needs to be deleted from.

Begin Tran

Delete from RM20101
Where CUSTNMBR = ‘CUSTNMBR'
and RMDTYPAL = 1
and DOCNUMBR = 'DOCNUMBR'
Rollback Tran

Begin Tran

Delete from RM10301
Where CUSTNMBR = 'CUSTNMBR'
and RMDNUMWK = 'DOCNUMBR'
Rollback Tran

This Check has already been entered for this Customer.

In order to resolve this

Clear out the record from RM00401(RM Key Master) table 

This credit document already has been applied. You can't change the currency ID



In order to resolve the above issue

Run Checklinks on the Sales Modules by going to

Microsoft Dynamics GP-->Maintenance-->Check Links

Select Sales

Under Sales Select - Receivables Open Transaction Files

 

Creating Scheduled Payments in GP

You can choose the interest rate, payment frequency, and other information when you create a payment schedule, and you can create a payment schedule using any posted document. Payment schedules are created from documents. Payment schedules may vary based on the vendor or the kind of goods or services that are being purchased. You can edit any information on unposted payment schedules, as well as the interest and number of payments for posted payment schedules.
When you create payment schedules, you select specific accounts to distribute the interest and principal portions between. The following chart shows what accounts to use and how they are debited and credited.

Account	Debit	Credit
Accounts Payable posting account	Debited with the scheduled payment amount, including principal and interest, when an individual payment is posted using the Post Payables Scheduled Payments window.	Credited with the total schedule amount, not including interest, when the payment schedule is posted using the Payables Scheduled Payments Entry window.
Payables Offset posting account	Debited with the total schedule amount, not including interest, when the payment schedule is posted using the Payables Scheduled Payments Entry window.	Credited with the scheduled payment amount, not including interest, when an individual payment is posted using the Post Payables Scheduled Payments window.
Interest Expense posting account	Debited when you post a payment schedule.	Credited with the interest portion of the scheduled payment amount when an individual payment is posted using the Post Payables Scheduled Payments window.

For example, if you use the Payables Scheduled Payments Entry window (Purchasing à Transactions à Scheduled Payments) to enter a scheduled payment with a schedule amount of $2,400.00 using 10% simple interest and 12 monthly payments, the amount due each month is $220.00.

When you post the payment schedule, your accounts will be updated using the following debits and credits.

Account	Debit Amount	Credit Amount
Accounts Payable	$2,400.00
Payables Offset		$2,400.00

When you use the Post Payables Scheduled Payments window (Purchasing à Routines à Post Scheduled Payments) to post one of the 12 individual payments for $220.00, your accounts will be updated using the following debits and credits.

The Schedule Number defaults, Enter the Schedule Description, Choose the Interest Type

Simple - Calculate interest only on the initial principal.
Compound - Calculate interest on the initial principal and also any accumulated unpaid interest.
Choose the Original document number which is the voucher that you created for the full payment. This will populate all the fields (Document type, vendor id, name, Scheduled amount)
If you are charging interest which is based on interest type you can add the Interest rate.
Add the Number of payments it will be divided into
Select the payment frequency

Click on Calculate Button which will calculate the Payment amount

First Invoice Document Date (Enter the invoice date for the first scheduled payment invoice.)
First Invoice Due Date (Enter the due date for the first scheduled payment invoice.)

When you click on the Amortization button (Opens the Payables Amortization Schedule window, where you can view a payment schedule’s amortization schedule. Any unposted lines of the payment schedule can be viewed. If there is no interest, you can edit the due date and the payment amount for each line in the scrolling window.)

Account	Debit Amount	Credit Amount
Accounts Payable		$220.00
Payables Offset	$200.00
Interest Expense	$20.00

When you pay the vendor $220.00 and use the Payables Manual Payment Entry window (Purchasing à Transactions à Manual Payments) to enter the payment, your accounts will be updated using the following debits and credits.

Account	Debit Amount	Credit Amount
Accounts Payable	$220
Cash		$220

Example:

Let’s first create a voucher for the full amount for the total cost.



Once the voucher is created this needs to be posted. After this is posted it prints out various posting journals.

The above is the first step in creating a scheduled payments, next is to create the scheduled payment for the above voucher. GoTo (TransactionsàPurchasingàScheduled Payments)



Check for the posting accounts if all look good. The interest Expense account can be populated once we have a schedule interest rate.

Post button

Creates a credit memo for the schedule amount and applies it to the original document.

Finally you POST the scheduled payment by click on the POST button on the top ribbon

Once the above step is done you go to Microsoft Dynamics GPàToolsàRoutinesàPurchasing à Post Scheduled Payments.

Use the Post Payables Scheduled Payments window to individual invoices for a payment schedule. You can post a single invoice or multiple invoices.

Due Date Cutoff

Enter a date to further restrict the range restrictions; the payment schedules will be restricted to those with due dates less than or equal to the cutoff date

Mark the payment that you want to POST and click on POST.