Item Reservation Restrict to Customer

hansika

Hi All,

I am working on nav 2009.


One of my client requirement is if allocate the reservation for any item against the sales order to customer , then item should not sale for another customer.


But navision will allow to sale that item to another customer.


How to solve this problem.


Thanks in Advance

David_Singleton

Use reservations.

rajatkalia

Hi David

But the user can still post the sales to another customer even though it is reserved for some other customer. Could you please explain if we are missing something.


Regards,
Rajat.

Marije_Brummel

AFAIK that depends on how you implement reservations.

Have you read the whitepapers? What is your setup?

rajatkalia

Hi Mark

On the Item card, Reserve=Optional,
After creating SO for Item A, qty=6; (available Inventory message=6) functions>>Reserve, got the Item reserved so that Total Reserved Qty comes.
Make another SO for a different customer for Item A, (available Inventory message=0). When I post the sales Order system does not stop me from posting or gives any error message that Item is reserved.

Is there something that I am missing.

Regards,
Rajat.

ara3n

Reserve needs to be set to always on Item Card in order to respect the reservation of the item.

You cannot have it customer specific. You have to do a mod.

The mod would involve. Setting customer Reserve to always. Set on Item Card Reserve To optional. That way the sales order is automatically reserved for that customer.

Then in CU 22. InsertItemLedgEntry(ItemLedgEntry,TransferItem)

add code in the following section

F (Item.Reserve = Item.Reserve::Always) AND
       (ItemLedgEntry.Quantity < 0)
    THEN
      ERROR(Text012,ItemLedgEntry."Item No.");

Add code to look at sales line that are have reserve to always. And make sure the total ILE for that location does not go below total outstanding qty of all the sales line that have reserve set to always.

hansika

ara3n wrote:

You cannot have it customer specific.

Thanks Rashed.


Mr. RaJ may be u r alsi working on the same issue, but i dont know wht is u r scenerio.

when it come to my scenerio my reservation is always based on the Sales order wise (not based on item wise , Customer wise)

for Example customer X placed a sales order No - SO 111 Item A - qty - 50

Same customer X placed another sales order No - SO 115 Item A - qty - 120.

Now i request the advance from customer for both orders.

if he pay the advance against which sales order then for that sales order i will reserve the items.

so let me know how to do this scenerio.

hansika

Experts,


throw some help about this.

ara3n

It's the same solution I mentioned above.

rajatkalia

Thanks Rashed...

Hansika I actually did not have any issue, I saw ur post, tried a dummy scenario and had given an example since I also wanted to know if it's possible somehow because lot of clients wants this and base does not support it without a customisation.


Regards,
Rajat.