Monday, August 29, 2016

Expense Workflow Error

We have an expense report workflow setup and a auto posting sub workflow.  
Suddenly, we started to receive the following error:

Failed to find workflow version.

The wording here appears to be important as 'version' could be replaced with 'instance' which would mean something else.

After looking in the history of this workflow, this error has been 'on and off' for about 10 days.  With that inconsistency, an AOS restart seemed to be the best option (and was recommended on a few posts).

The AOS restart did it.  Resumed all the error workflows and everything worked. 

Wednesday, August 24, 2016

SSRS Error with large report

 Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.

The request failed with the error message: 

At the moment, I'm not sure why my report is doing this.

Friday, June 3, 2016

Can't e-mail MS Excel from AX

I can run a report and e-mail every report format EXCEPT Excel.  I keep getting a permission error:

The permissions granted to user '(user)' are insufficient for performing this operation.


Such a simple answer for this...  The DAX service account, and other user accounts, must be set up as 'Browser' in the Report folder.

Add a 'New role assignment' and give your DAX service account, user accounts, or user groups access as 'Browser'.

And it works!

Wednesday, May 11, 2016

Error when running large report to batch

When one of my users runs a larger report (500k+ lines) to batch, they receive the following error after about 2 hours:

Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 552994. Maximum rows: 65536.

Not sure why this is happening at this point.  My SysAdmin can run the same report and batch it to the exact same location (C:\Temp on the AOS machine) and it works fine.

I forgot to post the solution here!  Turns out that my user's client was automatically adding a .xls extension to the excel file name for the batch.  Once we changed that to .xlsx, everything worked peachy!

Wednesday, March 16, 2016

Reverse a Customer reimbursement

In AX 2012, the Customer reimbursement functionality was introduced.  Recently, my customer had done a reimbursement by accident and wanted to reverse it.  Here is one way I found to do that.

Customer setup

To use this functionality you must create a vendor and tie that vendor to the customer. Open the Customer Details and go to the Miscellaneous details fast tab and set your vendor.


For this sample, I am going to make a payment, using a payment journal, against a customer for $100 which will give them a balance of -100.00 (A credit in essence). If you look at the Customer transactions, you can now see the credt of 100.00 with a balanace of -100.00.  This customer is now eligible for a reimbursement.

Accounts receivable -> Periodic -> Reimbursement
**** NOTE ****
You MUST, MUST, MUST put a customer in the query.  If you leave it blank, it will pick up all customers that have a < 0 balance!

If you have successfully created a reimbursement, you will then receive the following infolog:

Now, if you open up your Customer Transactions, you will see the original payment AND the new Reimbursement.  These are automatically settled and you now have a balance of 0.00

Next, open up the Vendor transactions for the related vendor.  You will now see the same Reimbursement on the vendor side with a balance of -100.00.

From here, you can create a Vendor payment proposal in your Vendor payment journal and cut a check for this vendor.  In our case, we want to undo this reimbursement.
One of the problems here is that we can't 'Reverse' this reimbursement transaction like we would normally do with other Vendor and Customer transactions.

This means we need to do a General Journal and manually fix it.
The first line is a Credit of $100.00 to the customer which is the same thing we did for the customer payment.  The offset account will be the bank account originally used.
The second line is a Debit of $100.00 to the vendor with the same offset account. At this point you can also settle the vendor Reimbursement transaction to this Vendor journal line by using Functions -> Settlement. Post.

If you didn't settle in the Journal, then go to Vendor open transactions and settle the 2 $100 transactions against each other.

Now, take a look at our Customer transactions.  We have the extra $100 from the Journal that return us to a $-100.00 balance. This could now be applied to a customer invoice.

Also, look at your Vendor Transactions.  You are now settled back to 0.00.