View Single Post
  #3 (permalink)  
Old May 4th, 2008, 10:56
cool_brat cool_brat is offline
Member
 
Join Date: Dec 2007
Location: Mumbai
Posts: 92
Thanks: 10
Thanked 2 Times in 2 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
cool_brat is on a distinguished road
Send a message via AIM to cool_brat Send a message via Yahoo to cool_brat Send a message via Skype™ to cool_brat
Re: why Order_release_line_GID should be unique?

Hi Ravi,

I am mentioning Order release line GID, not order base. I understand your point that many tables would be referring to order release line GID and i may not enter it since system may take this value as default.

But whenever you are receiving an order then it will come with multiple line items and if you define a business number rule for defining the value of this field then in every order the values will be starting from a new no whereas these values should start from 1 since the line would be first for new order coming.

Lets say you have Order-1 as order release in OTM and it has 3 line items.

Now when I receive order-2 with 3 line items then if the business number generator rule is applied then new order will begin with order release line no as 4 instead of 1. here, not entering the value will not solve the purpose.

I hope i have explained my question.

regards
Vipin
Reply With Quote