[Erp5-dev] Deeper containers consumption

[Jean-Paul Smets]

Hi,

Let me clarify.

Luke: are talking about the resource of the container (ex. parcel, box,
bag, etc.) or the resource contained in the container (ex. book, pen, meat).

Regards,

JPS.



Yoshinori Okuji a écrit :
> On Wednesday 11 June 2008 16:14:41 Łukasz Nowak wrote:
>   
>> Hello,
>>
>> On 2008-06-11, 15:58:30
>>
>> Łukasz Nowak <lukasz.nowak at ventis.com.pl> wrote:
>>     
>>> Hello,
>>>
>>> On 2008-06-06, 14:18:17
>>>
>>> Yoshinori Okuji <yo at nexedi.com> wrote:
>>>       
>>>> On Thursday 29 May 2008 11:42:59 Łukasz Nowak wrote:
>>>>         
>>>>> Hello,
>>>>>
>>>>> While packing Sale Packing Lists Resources' related to Container
>>>>> on top level are consumed. But no there is no consumption of
>>>>> Resources' related to lower level containers.
>>>>>
>>>>> Eg:
>>>>>
>>>>> SPL-1
>>>>>  Container 1 resource: A
>>>>>  Container 2 resource: B
>>>>>    Container 1 in 2 resource: C
>>>>>
>>>>> resource A, resource B - there are movements
>>>>> resource C - no movements.
>>>>>
>>>>> Is it wanted behaviour? Is it possible to configure it?
>>>>>           
>>>> I hardly believe that this is desired. Someone must investigate
>>>> Container handling thouroughly.
>>>>         
>>> Got something.
>>>
>>> In movement table there is movement for both resources, which looks
>>> like:
>>>
>>> +-------+-----------------+------------+-----------------+--------------+
>>> ----------+---------------------+---------------------+
>>>
>>> | uid   | explanation_uid | source_uid | destination_uid |
>>>
>>> resource_uid | quantity | start_date          | stop_date           |
>>> +-------+-----------------+------------+-----------------+--------------+
>>> ----------+---------------------+---------------------+
>>>
>>> | 12901 |           12903 |       NULL |            NULL |
>>>
>>> 8395 |        1 | NULL                | NULL                | | 12902
>>>
>>> |           12903 |       5430 |            6520 |         8396
>>> |        1 | 2008-06-09 00:00:00 | 2008-06-09 00:00:00 |
>>>
>>> +-------+-----------------+------------+-----------------+--------------+
>>> ----------+---------------------+---------------------+
>>>
>>> resource with uid 8396 is higher level (like resource A), resource
>>> with uid 8396 is on lower level (like resource B).
>>>
>>> Am I wrong is it associated with acquisition of categories? Because
>>> invking getSource[Uid] on 8396 returns proper value, and on 8395
>>> returns None.
>>>
>>> Trying out more :)
>>>       
>> Proposed workaround:
>> Add portal.getPortalContainerTypeList() to:
>>   * portal_categories/source Acquisition Portal Types
>>   * portal_categories/destination Acquisition Portal Types
>>   * acquisition_portal_type of ERP5/PropertySheet/Task.py start_date
>> property
>>   * acquisition_portal_type of ERP5/PropertySheet/Task.py stop_date
>> property
>>
>> And now all containers are in movement table.
>>
>> Is it acceptable solution?
>>     
>
> Thank you for your effort. However, I don't know if this works well. Are all 
> values indexed correctly (especially for the inventory)? IIRC, the 
> computation of the amounts of resources with deep container trees was quite 
> complicated, so I am not sure if it is working appropriately.
>
> For example, suppose this:
>
> - A packing list contains two containers 1 and 2.
>
> - Container1 delivers 5 units of Resource A.
>
> - Container2 delivers 1 unit of Resource B, and another container Container3.
>
> - Container3 delivers 2 units of Resource C, 3 units of Resource A, and other 
> containers Container4 and Container5.
>
> - Container4 delivers 1 unit of Resource D, and 4 units of Resource A.
>
> - Container5 delivers 3 units of Resource B, and 1 unit of Resource C.
>
> Then, even think of packing multiple units of the same containers.
>
> Does the Inventory API still work perfectly for all resources? I think it was 
> working more or less in the past, but I don't know if it is currently, as we 
> lack tests with complicated containers.
>
> Regards,
> YO
>   


-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 62 05 76 14
ERP5 Enterprise: Free / Open Source ERP for Critical Applications
http://www.erp5.com
ERP5 Express: Hosted Open Source ERP for small companies
http://www.myerp5.com
Nexedi: Consulting and Development of Free / Open Source Software 
http://www.nexedi.com