Monday, September 10, 2007

Transfer Orders - "Receive Remain" show weird value after multiple shipments and received (2)

Just debugged and found it was caused by following code under InventPickingListJournalRegistrate class - updatePickingListJournal method.

It seem like used to handle over-delivery but I'm wonder how to get the calculation method.

//handle potential overdelivery for transfer orders
if (inventPickingListJournalLine.InventPickRequesterType ==
InventPickRequesterType::Transfer)

{
inventTransferLine = inventMovement.buffer();
if (inventTransferLine)
{
if (inventTransferLine.QtyRemainReceive < abs(inventTransferLine.QtyShipped - inventTransferLine.QtyRemainShip))
{
inventTransferLine.QtyRemainReceive = abs(inventTransferLine.QtyShipped - inventTransferLine.QtyRemainShip);
inventTransferLine.updateEstimatedReceipt();
}
}
}


For me, over-delivery should be:
Over-delivery quantity = total received quantity - total transfer quantity

//handle potential overdelivery for transfer orders
if (inventPickingListJournalLine.InventPickRequesterType ==
InventPickRequesterType::Transfer)

{
inventTransferLine = inventMovement.buffer();
if (inventTransferLine)
{
if (inventTransferLine.QtyTransfer < abs(inventTransferLine.QtyShipped + inventTransferLine.QtyRemainShip))
{
inventTransferLine.QtyRemainReceive = abs(inventTransferLine.QtyShipped + inventTransferLine.QtyRemainShip - inventTransferLine.QtyReceived);
inventTransferLine.updateEstimatedReceipt();
}
}
}


Note:
  1. I have tried to use the over-delivery function and configured TO Line\Setup tab. It seems like not working. Probably someone can enlighten to me how to activate the function.

Wednesday, September 5, 2007

Transfer Orders - "Receive Remain" show weird value after multiple shipments and received

I was come across the standard bug in TO that will increase "Receive Remain" value when user tried to do multiple shipments and receive posting.

Let said we try to transfer item A 200 pcs from Warehouse GW to MW.

By using partial transfer, we are going to ship 8 times (each time 25 pcs) through Picking List, Picking List registration, Shipment, and Receive Posting.

We have encountered the "Receive Remain" value increased in the 7th times when we update picking list registration.

Below is the simulation chart (Refer to TO Line\Receive Now tab) after update picking list registration process:
NoShipped quantityReceived quantityReceive remain
1 00200
22525 175
35050150
47575125
5100 100100
612512575
7150150100 (shoule be 50)
8175175150 (should be 25)


It was applicable to AX4.0 SP1 and SP2.

To be continue... for solution...