Item Reservation Restrict to Customer

hansika · 2010-01-11

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 · 2010-01-11

Use reservations.

rajatkalia · 2010-01-11

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 · 2010-01-11

AFAIK that depends on how you implement reservations.

Have you read the whitepapers? What is your setup?

rajatkalia · 2010-01-11

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 · 2010-01-11

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 · 2010-01-12

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 · 2010-01-13

Experts,

throw some help about this.

ara3n · 2010-01-13

It's the same solution I mentioned above.

rajatkalia · 2010-01-14

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.

Item Reservation Restrict to Customer

Comments

Categories