Got Error When Get Return Receipt Lines in Sales Credit Memo

bestianhow

Hi Experts,
I have encountered an error when i try to Get Receipt Lines in Sales Credit Memo.

I'm using Version NAV 2009 SP1.

Step as below:

Sales Return Order
==============
1. Create a Sales Return Order, fill in Sell-to Customer No.
2. Function -> Get Posted Doc&ument Lines to Reverse.
3. Post Receive.

Sales Credit Memo
==============
1. Create a Sales Return Order, fill in Sell-to Customer No.
2. Function -> Get Return Receipt Lines
3. Select Return Receipt Lines and press OK button.
4. Received Error message. Please refer to attachment file.

Thanks.

bestianhow

Is it bug?
In version 5.00 SP1 not this problem

Belias

the text of the error sounds like a personalization...activate the debugger and see where does it stop...

bestianhow

I found the coding got different between Version 5.00 SP1 and Version NAV2009 SP1.
I replace the NAV500SP1's coding to NAV2009SP1, then will solved the error.

The coding will change in Table 6661's InsertInvLineFromRetRcptLine() function

//6.01-NAV001 Start
//SalesLine."Return Qty. Received" := 0;
//SalesLine."Return Qty. Received (Base)" := 0;
SalesLine."Return Qty. Received" :=  Quantity - "Quantity Invoiced";
SalesLine."Return Qty. Received (Base)" := "Quantity (Base)" - "Qty. Invoiced (Base)";
//6.01-NAV001 End

Thanks.

Ravi_Thakkar

Hello All,

I also got the same problem while doing Get Return Receipt Lines in Sales Credit Memo.

I refer above solutions also.
I found on OnValidate trigger in Quantity field in "Sales Line" table in NAV 5.00 and 6.00 SP1.

there is one line of code

CheckApplFromItemLedgEntry(ItemLedgEntry);

which might be a reason of an error.

So, I did some change in code as below,

IF "Document Type" <> "Document Type"::"Credit Memo" THEN   //New Line Added
    CheckApplFromItemLedgEntry(ItemLedgEntry);

My Problem also solved by above change.
Just want to make confirm, whther it's a Feasible change or not?
Please, suggest.