[OFBiz] Users - data model : order and payment

[N Kurniawan]

hi all,

i need your suggestion.

when i looked into ofbiz data model (ofbiz 5810), i found invoice and
invoice_item in the invoicing system, but i didnt find the same thing
in ordering system. i only find order_item and order_item_type
(purchase order, work order, etc) and also order_type.

my question is, where is the information about supplierID (party) for
the purchase order stored?

i plan to create order table based on invoice table. is it the best
solution for my problem? it will handle purchase order and work order.
the work order will transfer items from warehouse to other facilities.

about supplier payment, my user want to pay them using something
called voucher. there is two type of it. type 1, only contains
description for each purchase order and their values. type 2, only
contains description for other vouchers and their values in summary.

what is the best solution, regarding the current ofbiz data model?
should i create payment_item table, i dont see it exists, and add 2
voucher type to payment_type?

thanks in advance,

regards,
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Si Chen-2]

N Kurniawan wrote:

>hi all,
>
>i need your suggestion.
>
>when i looked into ofbiz data model (ofbiz 5810), i found invoice and
>invoice_item in the invoicing system, but i didnt find the same thing
>in ordering system. i only find order_item and order_item_type
>(purchase order, work order, etc) and also order_type.
>
>my question is, where is the information about supplierID (party) for
>the purchase order stored?
>
>  
>

order_header

>i plan to create order table based on invoice table. is it the best
>solution for my problem? it will handle purchase order and work order.
>the work order will transfer items from warehouse to other facilities.
>
>  
>
it's already there.  What you call work order is the ofbiz "work effort."

>about supplier payment, my user want to pay them using something
>called voucher. there is two type of it. type 1, only contains
>description for each purchase order and their values. type 2, only
>contains description for other vouchers and their values in summary.
>
>what is the best solution, regarding the current ofbiz data model?
>should i create payment_item table, i dont see it exists, and add 2
>voucher type to payment_type?
>
>  
>

Payment is a master payment, and PaymentApplication can be used to
detail how it is broken out.

>thanks in advance,
>
>regards,
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[N Kurniawan]

On 11/15/05, Si Chen <[hidden email]> wrote:

>
>
> N Kurniawan wrote:
>
> >hi all,
> >
> >i need your suggestion.
> >
> >when i looked into ofbiz data model (ofbiz 5810), i found invoice and
> >invoice_item in the invoicing system, but i didnt find the same thing
> >in ordering system. i only find order_item and order_item_type
> >(purchase order, work order, etc) and also order_type.
> >
> >my question is, where is the information about supplierID (party) for
> >the purchase order stored?
> >
> >
> >
> order_header

i can't find field that has supplier (party_id) information in
order_header. the closest field can be used is origin_facility_id. but
i dont think this is what i need.

regards,
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[Si Chen-2]

order_roles has the parties of an order.  Try creating a purchase order
and look at it.

N Kurniawan wrote:

>On 11/15/05, Si Chen <[hidden email]> wrote:
>  
>
>>N Kurniawan wrote:
>>
>>    
>>
>>>hi all,
>>>
>>>i need your suggestion.
>>>
>>>when i looked into ofbiz data model (ofbiz 5810), i found invoice and
>>>invoice_item in the invoicing system, but i didnt find the same thing
>>>in ordering system. i only find order_item and order_item_type
>>>(purchase order, work order, etc) and also order_type.
>>>
>>>my question is, where is the information about supplierID (party) for
>>>the purchase order stored?
>>>
>>>
>>>
>>>      
>>>
>>order_header
>>    
>>
>
>i can't find field that has supplier (party_id) information in
>order_header. the closest field can be used is origin_facility_id. but
>i dont think this is what i need.
>
>regards,
>
>_______________________________________________
>Users mailing list
>[hidden email]
>http://lists.ofbiz.org/mailman/listinfo/users
>
>  
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users

[N Kurniawan]

thanks si. i found the relation in order_role.

regards,

On 11/16/05, Si Chen <[hidden email]> wrote:

> order_roles has the parties of an order.  Try creating a purchase order
> and look at it.
>
> N Kurniawan wrote:
>
> >On 11/15/05, Si Chen <[hidden email]> wrote:
> >
> >
> >>N Kurniawan wrote:
> >>
> >>
> >>
> >>>hi all,
> >>>
> >>>i need your suggestion.
> >>>
> >>>when i looked into ofbiz data model (ofbiz 5810), i found invoice and
> >>>invoice_item in the invoicing system, but i didnt find the same thing
> >>>in ordering system. i only find order_item and order_item_type
> >>>(purchase order, work order, etc) and also order_type.
> >>>
> >>>my question is, where is the information about supplierID (party) for
> >>>the purchase order stored?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>order_header
> >>
> >>
> >
> >i can't find field that has supplier (party_id) information in
> >order_header. the closest field can be used is origin_facility_id. but
> >i dont think this is what i need.
> >
> >regards,
> >
> >_______________________________________________
> >Users mailing list
> >[hidden email]
> >http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
> >
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users