web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Help toubleshooting intermittent print/email failures during invoice processing... Ax 2012 R2 CU6

(0) ShareShare
ReportReport
Posted on by

Hello!

I'm hoping to find some assistance diagnosing a problem where our AR specialist is seeing intermittent print failures during invoice processing.

We are using AX 2012 R2 CU6.  The AX clients are installed locally on workstations.  Our invoice process is run manually (not via batch processing).

Our invoice process posts the sales order invoices and utilizes print management to either print a copy for mailing or to send a copy via email (per the customer setup) via the local computer's Outlook 2013.  Our AR person has issues every day with a random percentage of the invoices failing to both print and send (today 6 out of 64 invoices processed failed).  

There doesn't seem to be any pattern to which invoices fail.  I every case, we get the invoices to print/send by determining which invoices failed to print and then reprocessing the associated sales order... we don't make any changes to the account or to the invoice.  

The common thread seems to be that in every failure, both the print and email functions are not done for that particular invoice (we never seem to have an invoice that doesn't print but does email, or vice-versa).  AX doesn't inform the user that the print jobs fail--she only finds out when she goes to file the invoices with the sales orders and finds she is missing copies.

I've searched the event logs on the client workstation, the print server, and the AOS, but no messages are being logged that point to the issue.  This morning I set up a new print server and updated printer object for her to print to, but the problem remained the same.

I've tried clearing all usage data for the AR specialist, but that didn't help with the issue, either.

There has been no customizations done to either invoicing or to the print management, with the exception of some customization of the actual printed invoice (adding our logo and such).


Can anyone offer a suggestion for further problem determination?  One suggestion that I've heard is move to batch processing and thereby be able to obtain some AOS logging of the process, but I'm told that we tried that a few years ago and abandoned it in favor of manual processing of the invoices.  I'm not certain why.

I'm at a dead-end here... I'd appreciate any thoughts anyone might have.


Thanks,

Scott

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    I forgot to mention... as part of the troubleshooting, I also had the AR specialist separate out the process into two distinct steps... first posting all sales order invoices, then going to the invoice journal and using print management to print/send the invoices.  The problem remained.

    sm

  • Suggested answer
    Vilmos Kintera Profile Picture
    46,149 on at

    Verify AX client binary version, Ax32.exe should match the version of the AX AOS service to rule out communication protocol issues. Also it is advised to be on the latest kernel version of your major version.

    When an invoice "fails" to print I assume your user does not get any error messages - but do you have an entry on the ReportServer databases' ExecutionLog SQL View?

    What can you see in the SSRS log file at the time when the report is printed and swallowed?

    technet.microsoft.com/.../cc512029.aspx

    If there are no entries in there, either AX code is at fault or the communication between the AOS and the SSRS instance.

    If the entry is there, but with error, it could be a problem with the report or the SSRS instance. Maybe try refreshing WCF services in the AX configuration you are using whether it is registry or in an AXC file in the report server folder.

    Also check the SMTP logs on the mail server.

  • Community Member Profile Picture
    on at

    Thank you Vilmos, for the detailed response.

    Our client AX32.exe version and AOS AX32serv.exe versions match (6.2.3000.2032).

    Today, the AR specialist processed 50 invoices, and 5 of the 50 failed to print the first time.  She went back and reprocessed them a few minutes later, and the remaining 5 printed successfully.

    I looked through the ReportServer database's ExecutionLog SQL view, although I'm not exactly sure how to interpret what I'm seeing there.  I sorted the entries by the AR specialist's username and the timeframe that she first ran the invoices at, and found 98 entries.  All entries had a status of 'rsSuccess'.

    I would have hoped to see the number of entries match the number of invoices processed (meaning that the report got to SSRS but something happened to the 5 failures after that), or to see only 45 entries (meaning that the five failures were never processed by SSRS).  The 98 entries confuses me.

    When I rerun the SQL query against the ExecutionLog view for the next 15 minute timeframe, to catch the reprocessing of the 5 failed invoices, I have 9 entries, again all with Status = rsSuccess.

    I also looked at the ReportServerService logs.  Unfortunately, no errors are being posted to this log during the invoice processing timeframe.

    My next task will be to work out viewing the SMTP logs... we use O365, so I'm not certain how detailed a log file will be available to me.  I'll update the discussion with the results.

    Scott

  • Community Member Profile Picture
    on at

    Hi

    @smilner1971 - We are facing a similar problem on our side. Did you find a solution to the problem ?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans