Item Location

artur+1

Hello experts,

Firstly sry for my English, but my English skills are very basic.

I have a ques about how to send item in some Location. After Posting of Purchase Order (and choosing Received), the Items from that Order should be delivered in some Location. My question is where should the code (about giving location) to be written? In a CodeUnit 90 (Purch.-Post) or Purchase Line Table...or..? I need those items to be send in location only if user click Post button and choose Received (which is proper object(trigger/function)) for placing the code, in order to this functionality to be enable). Is there some standard code for something like this?

One more thing : How can I check if Status of that order is Open and after completion of the acquisition the status to be regains to Released? (is a standard function for this

Maybe this is very beginner question but I am new in Navision and I am so confused.
Thanks in Advance

postsaurav

Hi,

Welcome to Mibuso...

I am not sure about this things but someone else may confirm, here is what i think.

If you want to Transfer item (withing organization) from one location to another then you should use Transfer Order.

In case of Purchase order you don't need to write code for same, just specify the location code in lines as you can see in attached image how i received quantity to a specific location.

Let me know if you have any queries.

artur+1

Thanks Postsaurav, but I have two New custom fields(qty) added in purchase line table. One is "Qty to receive ok", and "Qty to Receive not ok". So ok qty should go in a one location ( that from purchase line, location code), but "qty not ok" in a another (in the quarantine location for that location code). So I should split them in a different locations. Am I understandable, or should I explain more comprehensive?
Thanks again.
Reqards

kine

Now it is more clear what you want. You need to change the codeunit 90 to receive in standard way the "Qty to receive ok", and through new item journal line the rest to different location. I think you will find the correct point in the codeunit where you need to split the logic. Of course, you need to think about different situations, like undo receive quantity. You than need to change the undo functionality too, to get correct items from correct locations. Or situation when you have tracked items, how you will decide which tracked item is going as OK, and which is not ok.

Savatage

instead of doing all that, say you order an item with qty 10.
and 5 of it is "ok" & 5 is "not ok" why not just add another line of the same item.

change the original line qty from 10 to 5 with location "ok"
add a second line with qty 5 location "not ok"

then you can recieve the full qty 10 and both go to different locations.
being seperate you can control them and all the standard functionality still works.

artur+1

Thanks Savatage and Kine
so your proposal is : when user creates new purchase order line, automatically to be create one more line

1. first one (the original one)- to be modified (qty to receive = qty ok)
2. second one (the new one) to be copy from original line but with changed values for "location code" and "qty to receive" :
"qty to receive" = "qty not ok", and "location code" = "quarantine location"
And all this will happens before posting, so posting will be on a standard way, but will be posted 2 lines instead 1?

Am I understood well?

kine

And you do not need to do it automatically, you can just teach users to do that... ;-)

artur+1

yes but system should do that not user

kine

Why? :-) Because user tells you?

Best system for users is the one, which will do all what is needed by pressing one button. The system must know what I want to do, the system must do that automatically, the system must... but than the user have no work, no job, no money... :-D

I do not want to tell that it is wrong or good. Just want to show that not each time is doing something automatically the best way, and there must be reasons. Many changes which are limiting the system and making it rigid could kill the copetitive advantage of flexible system, which could be used in different way just by changing setup and processes. Changing processes are cheaper than changing the system in most cases.

But this is just a hint and slightly off-topic...

Savatage

coping the line automatically makes no sense here.
how will the second line know the correct qty. it sounds like it need user intervention anyway.
I assume you find out the qty to be "not ok" once the the item has arrived.
then you can add a second line "if" some of it has to be moved to a diferent location.
but you say you want to automatically add a second line. if that's the case you must know before hand that some must be "not ok". and if that's true just have the user add a second line when creating the po from the beginning. all those new fields don't seem necessary to me.

artur+1

So, the User filled "qty ok" and "qty not ok", manually while he is creating the purchase order line, and after Posting that quantities should be delivered in а appropriate location:

- "Qty ok" in a Location Code that is stated in the corresponding Purchase Line
-"Qty not ok " - to be delivered in Quarantine Location

artur+1

I have this kind ow error when I am creating purchase order line:

Warehouse Receive is required for Line No. = ....
The entered information will be disregarded by warehouse operations.

Would You tell me what to be done, for avoiding this error

Thanks