Change Location before Qty Invoiced in Purchase

casanova

Hi All,
i have a question regarding purchase receipt
so lets say i create purchase order for 1 item
Item A Qty Order = 10
I receive this item partially
1st Receipt --> Location BLUE
2nd Receipt --> Location GREEN
3rd Receipt --> Location SILVER

note : we cant invoiced this receipt regarding company policy, so is there a way to this?
maybe we can create as 3 different lines, but the problem here is... we dont know this item will be distributed to which location until we receipt

I just imagine, i change the code in Table 39 (Purchase Line)
on user validate "Location Code", i block this code

Location Code - OnValidate()
//TestStatusOpen;
IF xRec."Location Code" <> "Location Code" THEN BEGIN
  IF "Prepmt. Amt. Inv." <> 0 THEN
    IF NOT CONFIRM(Text046,FALSE,FIELDCAPTION("Direct Unit Cost"),FIELDCAPTION("Location Code")) THEN BEGIN
      "Location Code" := xRec."Location Code";
      EXIT;
    END;
  //TESTFIELD("Qty. Rcd. Not Invoiced",0);
  //TESTFIELD("Receipt No.",'');
  //TESTFIELD("Return Qty. Shipped Not Invd.",0);
  //TESTFIELD("Return Shipment No.",'');
END;

i tried it, and it works... but is there any implication for the future if i do this?
thanks for the advice

thegunzo

The "correct" way of doing this is to receive all items in a single location and then use Transfer Order to distribute the items from that location to the others.

casanova

yes that what i'm thinking
but it's make users double job
they must input all the items 1 more time
and then select the lot no.

thegunzo

You can create an interface for the user to input all needed information in the purchase order and then in the posting process you can create and post the transfer order automatically.

Everything is possible with NAV