Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Alan Hyde]

We are testing NAV 2018 in a “play” database, intending to move soon from NAV5.  When we try to post check payments we get an error message if credit memos as well as vendor invoices comprise the check amount.  The error for the credit memo line of the payment journal says “Warning! Amount must be positive.”  We do not have this problem in our old NAV, and I have looked to see that we have checked the toggle boxes in the same manner in NAV 2018:  On the Suggest Vendor Payments screen, the box for Summarize per Vendor is NOT checked and the box for New Doc. No. per Line is NOT checked, and on the Print Checks screen, the box for One Check per Vendor per Document No. IS checked.  Any ideas on why we are getting blocked by this error message?

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————

[Carrie Wiles]

?If you change the ‘Document Type’ for the credit line to “Refund” then you should be able to process.

——————————
Carrie Wiles
GEMKO Information Group, Inc.
Amherst NY
——————————
——————————————-

[Marlene Mankin]

?Hi Alan,

I have run into this and have discussed with Microsoft about the change from the older versions of NAV and now the newer versions.

MS changed the CheckGenJnlLineDocType in order to keep the “amount sign” rule clear and simple. The new ‘rule’ is that a Payment and a Credit Memo must be of the same amount sign. Therefore, an Invoice or a Refund can be applied to a Payment or a Credit Memo. But it is not possible to apply a Payment to a Credit Memo or an Invoice to Refund.

The temp workaround was to check the Summarize per Vendor flag during Suggest Vendor Payments.

Please verify that you have the ‘One Check per Vendor per Document No’ selected.  I can recreate your issue by not selecting this.
Also, are you giving it a starting document number when doing the Suggest Vendor payments?  This makes it easier to see if the CM is being lumped together with the invoices on the same document.

——————————
Marlene Mankin
Application Consultant
Innovia Consulting
Onalaska WI
——————————
——————————————-

[Marlene Mankin]

——————————————-

[Alan Hyde]

Thank you for the responses.
Our problem was that after printing the check, we were unable to post because a credit was included along with the invoices being paid.  I tried the workaround Marlene mentioned (select the Summarize per Vendor box during Suggest Vendor Payments), and I was then able to post the payment after printing the check.  We were thus able to complete the process, but this solution is not satisfactory because it didn’t give us the opportunity to de-select individual invoices from the list of suggested payments.

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————
——————————————-

[Telka Clem]

HI Alan,

 

This will seem like a basic question, but is the amount for the total check positive?  I have seen this error when the Invoices to be paid did not cover the amount of the Credit Memo.

 

Telka Clem / NAV Senior Consultant/Solution Architect
Telka.Clem@WesternComputer.com

Western Computer
Office: 805-581-5020 | Direct: 805-830-5807 | Mobile: 903-244-1396
http://www.WesternComputer.com

         

 

——Original Message——

We are testing NAV 2018 in a “play” database, intending to move soon from NAV5.  When we try to post check payments we get an error message if credit memos as well as vendor invoices comprise the check amount.  The error for the credit memo line of the payment journal says “Warning! Amount must be positive.”  We do not have this problem in our old NAV, and I have looked to see that we have checked the toggle boxes in the same manner in NAV 2018:  On the Suggest Vendor Payments screen, the box for Summarize per Vendor is NOT checked and the box for New Doc. No. per Line is NOT checked, and on the Print Checks screen, the box for One Check per Vendor per Document No. IS checked.  Any ideas on why we are getting blocked by this error message?

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————

[Kim Dallefeld]

This has been a problem for years. Its time Microsoft fixed this!!

My normal solution is the change the journal template from requiring document numbers to balance. When you do NOT summarize by vendor, you can change the document type on the credit memo lines to blank, then print and post.

Also, you stated that you could not select invoices to pay if you summarized by vendor, but you absolutely can. You just need to ‘set applies-to id’ on the lines you want to pay and make sure it’s blank on the ones you do not want to pay.

——————————
Kim Dallefeld
Kim@Dallefeld.com
Dallefeld Consulting, LLC
2019 NAVUG Board of Advisors
Past NAVUG Board Chairman
NAVUG Programming Committee
——————————
——————————————-

[Alan Hyde]

Thank you, Kim, for your input.  I tried your “normal solution” in which the journal does not require the document numbers to balance, and was able to print and post.  This method came with a NAV warning that we would lose the ability to financially void the check.

I also tried to select invoices to pay with Summarize by Vendor, but was not successful.  Apparently I’m not doing the “set applies-to ID” in the correct screen or in the correct manner.  The check still showed payment for every invoice for the vendor.

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————
——————————————-

[Amanda Mayer]

Alan,

A couple of thoughts on the payment process.

1. Is there a particular reason you don’t want to pay all invoices suggested?
2. After running Suggest Vendors (as Summarized), you can review the application and remove lines by un-selecting them. You will also have to update the amount in the journal so as not to overpay.
3. By not summarizing, besides the issue with the negative amounts that you’ve discovered, you will get the same number of payment lines in the Vendor Ledger Entries as invoices and credit memos settled. Meaning, if you pay a total of 10 invoices and credit memos for a Vendor, you will get 10 payment lines, instead of 1. This makes puts a lot of excess transactions in your Ledger Entries.

Hope this helps!

——————————
Amanda Mayer
New View Strategies
Milwaukee WI
——————————
——————————————-

[Alan Hyde]

Thank you for the help.  Today we were able to successfully test the payment process using Summarize by Vendor and de-selecting an invoice in the Apply window.

We haven’t been using the feature of putting purchase invoices on hold, but that could be an alternative way of keeping an invoice off the Suggested Vendor Payments.

——————————
Alan Hyde
Controller
National Azon
Troy MI
——————————
——————————————-