Account Schedule Transaction Type Error

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hello,

I recently imported an Account Schedule into another business unit via a Configuration Package. When I select "Export to Excel I receive this error: The transaction type cannot be changed after a transaction has started. A transaction starts when the first database operation, such as FIND, NEXT, INSERT, DELETE, MODIFY, SUM and COUNT, is run. The error occurred because the transaction type was change from UpdateNoLocks to Snapshot." The Account Schedule exported with no issues from the original business unit. I have made no changes to transaction type. I do not know where to make a change to transaction type. When I search within NAV on transaction type and select Transaction Type Setup, there are no transaction types set up. Any help to restore this functionality (export to Excel) is greatly appreciated.

Thank you,

Tammy

*This post is locked for comments

All responses (7)

Answers (0)

Suggested answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: Account Schedule Transaction Type Error

Try to debug the case and take help of developer to rectify this issue.
Michael Carr CPA 115 on at

Like (0)

Report

RE: Account Schedule Transaction Type Error

I'm Running NAV 13R2 and Excel 2013 ( desktop). FYI
Michael Carr CPA 115 on at

Like (0)

Report

RE: Account Schedule Transaction Type Error

I Just created an Account Schedule and have run into the same issue. Followed both the troubleshooting listed here and Bob Bergmann's listed elsewhere.

The report appears to be set to "UpdateNoLocks" in transaction type and no sign of "Snapshot".

Report runs in print mode and only show the error trying to Export to Excel in the Overveiw.

It work fine on a second machine in my office and on my personal laptop so it seems confined to a corruption on my PC.

Any other ideas anyone.?
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: Account Schedule Transaction Type Error

Open the report properties (from the Object Designer, select the design to design the report, select the last empty new line and press "Properties" from the View menu) and check the property "Transaction Type". I guess it has the "Snapshot" value. Put it back to "UpdateNoLocks" value.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Account Schedule Transaction Type Error

Thank you Jens & Vishal for your quick response and ideas.

A couple of other team members are able to run the report (customized from implementer) without error. Therefore it appears to be something specific with my account/machine. I restarted NAV and my entire system and am still experiencing an error. I have put in a ticket with our IT group to clear my cache. If that doesn't work, I will try uninstalling and reinstalling NAV.

Thank you,

Tammy
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Account Schedule Transaction Type Error

What, if you create any of the Account Schedule manually? Are you able to export the data in excel? It is not related to data, but seems related to report.

Also, check if you are running standard NAV report or customized one? "Transaction Type" property of your report should be <UpdateNoLocks> (not Snapshot).

Also check after restarting the NAV service and see the results?

Hope this helps.
Suggested answer

Jens Glathe 6,092 on at

Like (0)

Report

RE: Account Schedule Transaction Type Error

Hi Tammy,

this is a case for the debugger and a developer to have a look.

with best regards

Jens