Purchase receipt. Posting problem. Navision 2.6. Migration to SQL Server.

[Leon]

Hi,
I just migrated Navision 2.6 from native database into MS SQL Server. I have only my user connected to database. I’m trying to post a Purchase Receipt. The system gives me error that
==================
Another user has modified the record for this Purchase Header after you retrieved it from database.
==================
I made backup of this database and restored it into native database. I made an attempt to post the same purchase receipt. I have not had any problem. It wa posted successfully.


I checked the code in CodeUnit Purch.-Post 90.

// Modify/delete purchase header and purchase lines
IF NOT RECORDLEVELLOCKING THEN
PurchLine.LOCKTABLE(TRUE,TRUE);

IF Receive THEN BEGIN
"Last Receiving No." := "Receiving No.";
"Receiving No." := '';
END;
IF Invoice THEN BEGIN
"Last Posting No." := "Posting No.";
"Posting No." := '';
END;

There is a line that gave me this error:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
IF ("Document Type" = "Document Type"::Order) AND (NOT EverythingInvoiced) THEN BEGIN
MODIFY;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Please help if anybody else had this problem before.
Thank you,
Vic

[Polar]

I had the same problem...

This error apears when you have two objects of the same record.

PurchaseHeader1 and PurchaseHeader2 for instance.

PHP код:

PurchaseHeader1.GET("Document Type"::Order,'PH00001');
PurchaseHeader2.GET("Document Type"::Order,'PH00001');

PurchaseHeader1.SomeField:=SomeValue;
PurchaseHeader1.MODIFY;
// after this you'll have problems with PurchaseHeader2
// 'cause in cache PurchaseHeader2 differs quite from 
// Purchase Header in SQL database
//therefore you should make 
PurchaseHeader2.GET("Document Type"::Order,'PH00001');
//and then error will disappear 


I suppose the problem is in your local modifications