Hello Everybody,
At our client isde there is one problem in transfer order posting..
Exactly,
1) After creating Transfer Order they are creating a Warehouse Shipment
Document...
2) From Warehouse Shipment Document they are posting that doc...
3) Whenever Posted Transfer Shipment doc. is created then at that time Problem is Going to be started "all the lines' Amount fields in Transfer Order get 0 value..."
So, why this is going to be happened?
Please Help me....
Ravi_Thakkar
Ahmedabad, Gujarat, India
E Mail :
ravi.thakkar@hotmail.com 0
Answers
Don't really know what you mean : Std. there is no amount field.
Did you mean Quantity that becomes 0?
System always takes all the line with Qty 0 to posted documents, even if only 1 line is shipped. (on that line normally shipped <>0)
You can code that away, or change the layout of the document that does showoutput (qty <> 0).
Same functionality with posted shipment for sales order.
This is a bug in NAV SP3.0. When we do partial shipment or receipts
line amount becomes zero and amount is posted in Unrealized profit/loss acoount.
Post the issue on Microsoft and they will send you the patch
Senior Consultan
AP Commerce, Inc. = where I work
Getting Started with Dynamics NAV 2013 Application Development = my book
Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
First of all Thank you very much for your Replies.
I think "Darshnm" has understood my problem properly...
I think Amount field is not shown just in Transfer Order.
But it is there. May be I m Wrong.
For your information Client is using Nav 4.00 SP3.
IF any solution or suggestion then please...[/b]
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com
I have found some changes in codeunit 5704 in NAV5.0 in comparision
with the NAV4.0 SP3.
I think in NAV4.00 in codeunit 5704 there is one function
named "DivideAmount(----)".
which cause this Amount to 0 value if Qty. To Ship is zero.
and after that 'function call', there is one statement
Transline.Modify.
So, it's also updating the Transfer Order Lines.
While in NAV5.00 the line "Transline.Modify" is Commented.
So, I think it will be the sollution.
So, please watch it out and say should i comment that statement
in Client's Database or any other changes required....?
Please help me out....
Thanks in advance....
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com
I got the below file from Microsoft fot this problem for CN 5704.
But you have to modify the in Cn 5705 also.
Because of this NAV is passing entries in "Unrealized profit/loss G/L"
instead of inventory adjustment G/L.
Please see the partnersource for more details
Change Log 11. April 2008
SA
Old Version OLD
New Version NEW
+
+
| OBJECT Codeunit 5704 TransferOrder-Post Shipment |
+
+
Before (OLD)
Codeunit 5704
Object Heading
OBJECT Codeunit 5704 TransferOrder-Post Shipment
{
OBJECT-PROPERTIES
{
Date=11-04-08;
- Time=[ 6:58:21 PM];
Modified=Yes;
Version List=NAVW14.00.03,NAVIN4.00.03.05;
}
PROPERTIES
{
After (NEW)
OBJECT Codeunit 5704 TransferOrder-Post Shipment
{
OBJECT-PROPERTIES
{
Date=11-04-08;
+ Time=[ 6:59:15 PM];
Modified=Yes;
Version List=NAVW14.00.03,NAVIN4.00.03.05;
}
PROPERTIES
{
Before (OLD)
Codeunit 5704
Properties
TransLine.VALIDATE("Quantity Shipped",TransLine."Quantity Shipped" + TransLine."Qty. to Ship");
TransLine.UpdateWithWarehouseShipReceive;
TransLine.MODIFY;
UNTIL TransLine.NEXT = 0;
END;
IF WhseShip THEN
After (NEW)
TransLine.VALIDATE("Quantity Shipped",TransLine."Quantity Shipped" + TransLine."Qty. to Ship");
TransLine.UpdateWithWarehouseShipReceive;
+ TransLine.VALIDATE(Quantity);
TransLine.MODIFY;
UNTIL TransLine.NEXT = 0;
END;
IF WhseShip THEN
Before (OLD)
Codeunit 5704
Properties
IF NOT HeaderDeleted THEN BEGIN
WhseTransferRelease.Release(TransHeader);
ReserveTransLine.UpdateItemTrackingAfterPosting(TransHeader,0);
END;
IF NOT InvtPickPutaway THEN
COMMIT;
CLEAR(WhsePostShpt);
CLEAR(InvtAdjmt);
Window.CLOSE;
After (NEW)
IF NOT HeaderDeleted THEN BEGIN
WhseTransferRelease.Release(TransHeader);
ReserveTransLine.UpdateItemTrackingAfterPosting(TransHeader,0);
END;
+ TransLine.LOCKTABLE;
+ TransLine.SETFILTER(Quantity,'<>0');
+ TransLine.SETFILTER("Qty. to Ship",'0');
+ IF TransLine.FIND('-') THEN BEGIN
+ REPEAT
+ TransLine.VALIDATE(Quantity);
+ TransLine.MODIFY;
+ UNTIL TransLine.NEXT=0;
+ END;
+
IF NOT InvtPickPutaway THEN
COMMIT;
CLEAR(WhsePostShpt);
CLEAR(InvtAdjmt);
Window.CLOSE;
Senior Consultan
Thanks.
Ahmedabad, Gujarat, India
E Mail : ravi.thakkar@hotmail.com