05-02-06 12:17 PM
Hi mnet123,
I have sent you mail.
What I was trying to explain is that in the default orderform against every
line item you keep a field which stores the quantity shipped against each
shipment. So everytime you'd need to run through each lineitem to check
whether it has been completely shipped or not.
The option to this is that everytime a item has been completely shipped
(required quantity = supplied quantity) you remove the lineitem from the
default orderform. So for every item completely shipped you'll have less
lineitems to iterate through.
For every such partial shipment you create you create a new orderform and
add attributes related to shipment to the orderform. I've tried to represent
it as a hierarchical example. Hope it is clearer now.
OrderGroup (Status=4 (New Order), Order No=12345, Dt=01/01/2006, Party
ID=XYZ Co.)
|
|---Orderforms
|
|---(default)
|
|---(lineitems)
|
|-- Item 1 - SKU=ABCD, Qty (req) = 5
|-- Item 2 - SKU=DEFG, Qty (req) = 10
After the first Partial Shipment
OrderGroup (Status=16 (Partial), Order No=12345, Dt=01/01/2006, Party ID=XYZ
Co.)
|
|---Orderforms
|
|---(default)
| |
| |---(lineitems)
| |
| |-- Item 1 - SKU=ABCD, Qty (req)=5, (supp)=5
| |-- Item 2 - SKU=DEFG, Qty (req)=10, (supp)=5
|
|---(Shipment X) (Invoice No=98765, Dt=05/01/2006, Delivery
Note=87876, Amount=$$$$$)
|
|---(lineitems)
|
|-- Item 1 - SKU=ABCD, Qty (supp)=5
|-- Item 2 - SKU=DEFG, Qty (supp)=5
After the subsequent shipment
OrderGroup (Status=32 (Complete), Order No=12345, Dt=01/01/2006, Party
ID=XYZ Co.)
|
|---Orderforms
|
|---(default)
| |
| |---(lineitems)
| |
| |-- Item 1 - SKU=ABCD, Qty (req)=5, (supp)=5
| |-- Item 2 - SKU=DEFG, Qty (req)=10, (supp)=10
|
|---(Shipment X) (Invoice No=98765, Dt=05/01/2006, Delivery
Note=87876, Amount=$$$$$)
| |
| |---(lineitems)
| |
| |-- Item 1 - SKU=ABCD, Qty (supp)=5
| |-- Item 2 - SKU=DEFG, Qty (supp)=5
|
|---(Shipment Y) (Invoice No=98776, Dt=10/01/2006, Delivery
Note=87886, Amount=$$$$$)
|
|---(lineitems)
|
|-- Item 2 - SKU=DEFG, Qty (supp)=5
--
Ravi Shankar
"mnet123" wrote:
[vbcol=seagreen]
> Hi ravi
> I think i need to talk or email more with you on this. Can you give me you
r
> contact email/phone.
> Heres mine: green72guy@yahoo.com
>
> Things like 'if there is no difference between required
> and supplied move this line item to a new orderform called "shipment X" '
> didnot make sense
> --
> Regards
>
>
> "Ravi Shankar" wrote:
>
[ Post a follow-up to this message ]
|