Small and medium business | Business Central, N...

Error - The field No. of table Sales Line contains a value (RREN) that cannot be found in the related table (Resource)

(0) Share

Report

Posted on by joshlabtech

662

Hi all,

One of my users in Finance department experience this error when trying to close.

Please advise.

Thank you!

I have the same question (0)

All responses (15)

Answers (0)

Suggested answer

Gulshan Shubham 2,210 on at

Like (0)

Report

Hi,

It seems that you are trying to select a Resource on your Sales Line which actually doesn't exist in the Master. So, please make sure the related resource (RREN) exist in your Resource Master.

Thanks. Hope it helps.

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report

You need to define your Resource master with this PREN code, and then try to select on Line TAB. Hope it will help you.

Was this reply helpful? Yes No
Suggested answer

jerome77 on at

Like (0)

Report

Hi

Is this resource exists?

Kind regards

Was this reply helpful? Yes No
joshlabtech 662 on at

Like (0)

Report

Hi Gulshan,

Thank you.

May I know where and how can I find this related resource?

Was this reply helpful? Yes No
joshlabtech 662 on at

Like (0)

Report

Hi Jerome,

Thank you.

May I know where and how can I find this related resource?

Was this reply helpful? Yes No
Anik22 85 on at

Like (0)

Report

Go to the resource Master & create the new resource. Create a new code with RREN

Was this reply helpful? Yes No
joshlabtech 662 on at

Like (0)

Report

The Resource List already has the RREN.

Was this reply helpful? Yes No
Suggested answer

jerome77 on at

Like (1)

Report

Hi

I just tried to enter a resource that does not exist using NAV 2018 last update, error message is different:

You may need to debug or ask your partner to debug that

As a test, if you select another resource name, does it work? Or is it same issue with all resources?

If all resources are failing, then... maybe permission access but I would expect a different error message.

Is it first time user tries to use a resource?

Jerome

Was this reply helpful? Yes No
Anik22 85 on at

Like (0)

Report

If your type is resource...you can only use those names which are there on the list. You cannot type any name which is not there is the resource list

Was this reply helpful? Yes No
joshlabtech 662 on at

Like (0)

Report

Hi,

So apparently, she was able to create that field for every other customers. All the fields being same except that all other customers don't have the Special Service ticked. I tried to untick that but I was not able to unticked.

1. Any idea where I can go to untick it?

2. Also what does Special Service means?

Appreciate all your help rendered.

Was this reply helpful? Yes No