Microsoft Dynamics AX (Archived)

AX 2012 R2 CU7 - Free text invoice error

(0) Share

Report

Posted on by Andy Adamak

4,074

We are in the process of testing our CU7 update, and have come across something rather strange...

When trying to open a free text invoice, I get the following error:

"You are not authorized to access table ‘Intercompany free text invoice lines for project’ (CustInvoiceLineInterProj). Contact your system administrator."

Even when logging in as administrator this error comes up. I looked at the table in the AOT, and it is set up under a Project configuration key (Timesheet). We do not have ANY of the project configuration keys turned on. I looked at our current live AX 2012 R2 environment and this table doesn't exist.

So.. what's the deal? Why can't I open invoices, anyone know? Or can verify they have same error with similar setup?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Take a look at the table properties. Has MaxAccessMode been set to NoAccess? if so tweaking that back to Delete should work for you.

Other properties to look at: AOSAuthorization, ConfigurationKey

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 305,643 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Andy,

In CU7 there is some new support for intercompany project invoicing between lending and borrowing companies. This table is indeed part of this extension.

Within the form CustFreeInvoice it seems that they tried to avoid calls when the configuration key 'ProjTimesheet' is not turned on.

I cannot disable the configuration key in my test environment as we are preparing some functionalities with intercompany invoicing at this moment. So I cannot verify this behaviour.

As it also occurs when you log in as the administrator, it should be possible to debug this error. Another option: Turn on the configuration key and use the security to disable the features. I guess you did not grant the Project Timesheet user to any of your users in the system.

Was this reply helpful? Yes No
Andy Adamak 4,074 on at

Like (0)

Report
Copy link

Link copied!

ANGELSBADILLOS,

As I said the ConfigurationKey on the table is ProjTimesheet, which is the "Timesheet" option under "Project 1" in the license configuration editor. AOS Authorization is set to "None", but most other tables I see are set to the same, so I'm not sure that's an issue. As for MaxAccessMode, I see no such property on the table. Where would this be set?

ANDRE,

I can confirm that turning on the aforementioned configuration key gets rid of the error, so it's something not wired right with the way this table sits in AX without the Project Module on. I am thinking about trying to debug it and disable bad code, or just leaving on the key and not giving people access as you suggest.

I would prefer a solution that doesn't require turning on the key, as I get synchronization ERRORS, where before I only got warnings.

Was this reply helpful? Yes No
Andy Adamak 4,074 on at

Like (0)

Report
Copy link

Link copied!

I was able to make this error go away with the Project 1 -> Timesheet configuration key off by deleting the CustInvoiceLineInterProj datasource from the CustFreeInvoice Form from the CUS layer. Nothing else seemed to be working, but pulling the datasource actually allowed the form to compile. I also set the "Visible" property of the related tab page (Design -> Tab:TabMain -> TabPage:TabPageDetails ->Tab:TabDetails ->TabPage:CombinedViewTabPage -> Tab:CVFastTab ->TabPage:CVLineDetailsFastTab -> Tab:CVInvoiceDetailsTab -> TabPage: TabPageLinesProjIntercompany) to "No" to ensure the related fields wouldn't show up blank on the form.

So in the end either: Turning on the configuration key OR deleting the datasource from the form got rid of the error. I'll have to have our testers click around Free Text invoices more to ensure nothing else odd comes into play related to this new feature.

Was this reply helpful? Yes No
André Arnaud de Cal... 305,643 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Andy,

The synchroniztion errors are probably environment specific. I did not had a problem with this table and CU7.

You resolved your problem, but I wonder if it is a broader problem. When I have some time left, I will try to create a backup and then temporary disable the timesheet configuration.

Was this reply helpful? Yes No
Verified answer

Gabriel de Castro 25 on at

Like (0)

Report
Copy link

Link copied!

Hi Andy,

In CustFreeInvoice form, you can change the property AllowCheck to "no" in the data source CustInvoiceLineInterProj. That will fix the issue.

Regards,

Gabriel.

Was this reply helpful? Yes No
Andy Adamak 4,074 on at

Like (0)

Report
Copy link

Link copied!

Yup, that'll do it :)

Thanks!

Was this reply helpful? Yes No