Temp Job Budget Line already exists

(0) Share

Report

Posted on by Community Member Microsoft Employee

In NAV 3.7, In Job Budget Line Table we add some new fields and changed the primary key of the table, and now I am upgrading the systen to NAV 2013 R2.
But now I am unbale to transfer the data in Temp Job Budget Line Table.Getting the below error.
Old Primary Key in Job Budget Line :-Job No.,Phase Code,Task Code,Step Code,Type,No.,Variant Code
New Primary Key in Job Budget Line :Job No.,Phase Code,Task Code,Step Code,Type,No.,Variant Code,Eff Start Date,Eff End Date

The Temp Job Budget Line already exists.

Identification fields and values:

Job No.='L10-C55-WI17-03-022',Phase Code='',Task Code='',Step Code='',Type='Item',No.='NEW SHAFT',Variant Code=''

Please let me know, if any one have any idea.
Thanks in Advance

*This post is locked for comments

All responses (2)

Answers (1)

Suggested answer

keoma 32,675 on at

Like (0)

Report

RE: Temp Job Budget Line already exists

that means, that there is already a line with the same key values at this run time. so check your code and ensure, that each line has its unique key values, eg. by testing if line with current key exists before inserting the new one.

other option: change your current key by adding line no. to key.
Verified answer

mmv 11,465 on at

Like (0)

Report

RE: Temp Job Budget Line already exists

Hi,

Ideally, you must not change the Primary Key of a Standard Table. I feel this is not a right approach.

As you have already modified it, you may check the primary key of Temp Job Budget Line also. Please ensure that both are inline and try again.