Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Business Central forum

Error when applying a bank payment against a "posted purchase invoice"

(1) ShareShare
ReportReport
Posted on by 645

I sent 3 vendor invoice pdf's to Lexmark for OCR recognition.  I received all 3 of these back successfully.  On the OCR import, I selected the appropriate G/L accounts to which the amounts should apply.  I then used the "create invoice" button on the first two of these to create purchase invoices.  On the third import, I created a G/L entry, instead.  It looks to me as though D365FF shouldn't have allowed me to create purchase invoices for the first two imports.  the "Item" on each import is actually a G/L account.  When I try to manually create a purchase invoice, I can only select from inventory items for the "Item" field.

In any event, I am now trying to apply 2 online payments I made from my bank account.  The payment that is applicable to the third import gives me no problems.  The other payment is for the total amount of the other two invoices.  I've applied this payment to both purchase invoices via the "Edit - Payment Application" screen.  I then return to the "Edit - Payment Reconciliation Journal" screen, and click on the "Post Payments and Reconcile Bank Account" button.  At this point, I get the following error message"Open must have a value in Vendor Ledger Entry: Entry No.=216. It cannot be zero or empty."

I go to "Posted Purchase Invoices" and pull up entry number 216.  When I navigate to the "View - Vendor Ledger Entries", I can see where the "Open" field has a check mark in it.  This would generally indicate a Boolean value of "1".

Since we really don't have any documentation to speak of, this would appear to be a bug in D365FF.  Consequently, I've gone to the "View - Posted Purchase Invoice" screen with the intention of either cancelling or correcting these two purchase invoices.

When I click on "Correct", I get the following error message: "You cannot correct this posted purchase invoice because the purchase invoice line for 68100 Telephone Expense is of type G/L Account, which is not allowed on a simplified purchase invoice."

When I click on cancel, I get the following error message: "You cannot cancel this posted purchase invoice because the purchase invoice line for 68100 Telephone Expense is of type G/L Account, which is not allowed on a simplified purchase invoice."

When I click on "Create Corrective Credit Memo", I get the following error message: "Invoice Rounding Account must have a value in Vendor Posting Group: Code=DOMESTIC. It cannot be zero or empty."

I now go to "Search for Page or Report" and pull up the "Vendor Posting Groups".  All of the fields for "DOMESTIC" are populated with a valid G/L account number.  I am displaying all of the columns, and I do not see any column entitled "Invoice Rounding Account".  BTW, I do see "Debit Rounding Account" and "Credit Rounding Account".  Once again, both of these are populated.

It looks to me like you Microsofter's have created the software equivalent of the Gordian Knot.  Unfortunately, I don't have a sword to cut through this.  Next, I would try manually creating two "Purchase Credit Memos" (actually debit memos in A/P) and applying these against the two "Posted Purchase Invoices" that appear as though they never should have been created to begin with.  I would then bring my "Incoming documents" in to D365FF again, and this time strictly use these to create G/L journals.

Before I embark on this part of the journey, is there a better way to deal with this?  Also, D365FF certainly looks like it has its share of bugs and loose ends...

Categories:
  • Community Member Profile Picture
    on at
    RE: Error when applying a bank payment against a "posted purchase invoice"

    Hi,

    We can verify that this error also occurs at NAV 2017 CU 2.

    Have Microsoft corrected this error in a CU newer than CU 2?

    34.PNG

  • Dave Boehm Profile Picture
    645 on at
    RE: Error when applying a bank payment against a "posted purchase invoice"

    Thanks for submitting the bug reports to the dev team, Theresa.  I hope you included the "When I click on "Create Corrective Credit Memo", I get the following error message: "Invoice Rounding Account must have a value in Vendor Posting Group: Code=DOMESTIC. It cannot be zero or empty."" portion.  I think this would probably be a problem no matter how the invoices were created.

    As a postscript, I manually added two "Purchase Credit Memos", etc., etc., and had no further problems with the entire process.  Nothing in the OCR import or in A/P flagged my re-imported invoices as duplicates, though.  The warning popped up when I posted the G/L entries.  Just something to be aware of...

  • Verified answer
    Theresa Nistler Profile Picture
    551 on at
    RE: Error when applying a bank payment against a "posted purchase invoice"

    Hi Dave,

    Thanks for the information. Unfortunately, it looks like you've run into 2 issues here.  One of these I am already aware of, this is the error when you choose the Post and Reconcile.  It has been written up and is in our development queue to be fixed.  The other issue, which is the OCR change bringing the line type= GL Account into the purchase invoice, I will work with our support team to get written up.  Thanks for letting us know.  As with all software, there is the potential for bugs, but we are committed to work through them as quickly as we can.  The nice thing with the Saas structure, we can release any fixes to the end user much more quickly.

    Regards,

    Theresa

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central forum

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans