Skip to main content

Notifications

Announcements

Share Your Journey with Power Pages and Help Shape Its Future!
News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Vendor invoice posting...
Finance forum
Answered

Vendor invoice posting with serious error in batch job using parametters button

(1) ShareShare
ReportReport
Posted on by Bill Ngo 67
Dear All,

Our installed product version of D365FO: 10.0.31. And our PO quantity is usually larger than 1000 lines.

When posting vendor invoice with large number of lines (>500) through batch job. At batch job form with status Executing, if click the parameters button,

the system will display vendor invoice form for us to see/check and then if we close this parameters form before batch job has finished executing (not END yet).

 
Batch job continues to run until End, then if we open Log of this Batch job we will see errors because it could not update invoice status to invoiced.

 
It updated status from Received back to Open order status but invoice journal has been posted successfully.

Conclusion: The big issue is the consequence of POs like this that cannot be fixed by normal reverse/cancel invoice/receipt methods. And causes serious errors by the system (already invoiced but header and lines status are still Open orders. 
 


Be noted that: if we do not click parameters button on Batch Job form and close parameter form after then, the system will post and update invoice status successfully.

This issue occured with posting vendor invoices with both Product receipt quantity/Receive now quantity.

At first we thought it was a bug on PROD only, but after simulating it on Contoso the error was similar, you can try this case in Contoso as follows:
- Entity: USSI (no customization and ISV solutions)
- Create a PO > copy lines from another PO (ensure the number of lines are large (e.g > 400lines), purpose to ensure there is enough time to press the parameters button and close the parameters form before the batch job ends.
- Confirm and post product receipt as normal
- Click invoice button in invoice action pane > Click and complete Match product receipt + Click and complete Batch in Process action pane (add specific task description for easy filter in batch job form later) > Click Post      
- When see a message below, immediately open Batch job form and find out this batch job by specific task description above.  
- In Batch job form: check batch is still in Excecuting status > click batch job number > click parameters button > close parameters form
- Back to Batch job form make sure Batch job is still Executing and running, wait for it completed/ended, then check Log button, also check status of Vendor invoice. Then we can see these errors. 

Can anyone to help to simulate this case and verify that is a bug of MS or not? thanks in advance. 

Best rgds,
Bill
Categories:
Administration and Setup
Financial Management
  • Verified answer
    Bill Ngo Profile Picture
    Bill Ngo 67 on at
    Vendor invoice posting with serious error in batch job using parametters button
    The solution to work around is the following:
     
    1. In Batch job form: select batch job number > click parameters button to check the invoice information.
    2. To exit the parameters form: Don't use the close form button, instead we refresh the form (F5). 
     
    Then check Log button: the Btach job is posting fine, there are no error for status of Vendor invoice.
     
     
  • Bill Ngo Profile Picture
    Bill Ngo 67 on at
    Vendor invoice posting with serious error in batch job using parametters button
    Hi André,
     
    Thank you for you notes. I have agreed with your first point to upgrade. 
     
    But for sencond point, I completely disagree with the opinion because readers may misunderstand. I knew that you have not simulated this case on Contoso yet, so you have such this opinion. As I mentioned in my noted statement above, if we do not click on the parameters button in the Batch job form and close the this form, everything will be posted completely and without any error. Not for other reasons such as: large number of lines, delivery remainder, so on. 
     
    Best Rgds,
    Bill
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,435 Super User 2024 Season 2 on at
    Vendor invoice posting with serious error in batch job using parametters button
    Hi Bill,

    You mentioned you are using version 10.0.31. This is an old version not supported anymore by Microsoft. In the meantime, a lot of features have been added, enhanced and bugs were fixed. I would suggest trying to reproduce this on a 10.0.40 or 10.0.41 environment and see if the issue still persists. 
     
    It can be the case that due to the large number of lines there is a bug where not all lines were updated. In case the status of an order goes back to Open order, then usually there is a delivery remainder for the order. So, maybe not all lines were (fully) received.

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

News and Announcements

Share Your Journey with Power Pages and Help Shape Its Future!

Quick Links

Dynamics 365 Community Update – Sep 16th

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

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,435 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,317 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans