Показать сообщение отдельно
Старый 26.08.2004, 02:28   #1  
Leon is offline
Leon
Участник
 
4 / 10 (1) +
Регистрация: 05.12.2002
Адрес: Канада
Purchase receipt. Posting problem. Navision 2.6. Migration to SQL Server.
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