Item Cost in Transfer Order/Shipment/Receipt

jacky10

hi guys

Is there any way to insert 'Item Cost' in the Transfer Order so that the users in multiple location can view it while shipping it and receiving it during warehouse ship / receive operations..? i couldnt find any cost field in Transfer Line table.....

any help?

regards

Malajlo

I suggest to only show cost using FlowField to Item (average, last cost, unit cost).

jonsan21

Hi,

At the Transfer Order Subform, OnAfterGetRecord trigger, pickup the 'Cost' from the Item Card that you want to show.

Item.RESET;
IF Item.GET("Item No.") THEN BEGIN
ItemCostMgt.CalculateAverageCost(Item,AverageCostLCY,AverageCostACY);
END;

Then you can all the costs by pulling a few textbox, and set the SourceExpr property to AverageCostLCY, or Item."Unit Cost", or Item."Standard Cost", or Item."Last Direct Cost" depending on which cost you want to see.

System should pick up the "Unit Cost" from the Item Card, but if the "Unit Cost" has not been 'adjusted' yet, it will be adjusted when you run 'Adjust Cost-Item Entries' batch process.

Rgds,

Jon.