RE: [ubl-dev] Modeling question re: multifaceted price calculation

[Fulton Wilcox <fulton.wilcox@coltsnecksolutions.com>]

Ken,

In all likelihood, the best arrangement would be to stay with the
mainstream, with the invoice line item including unit price (daily rent
rate, in absolute terms) and quantity (number of days charged). 

In your line item 1 and 3 examples, you are implicitly expressing unit price
as a function: daily rental unit price = rented item value * rental charge %
of item value* 1/30 days in a month). What you put into unit price (2.5%)is
in fact not unit price, and it is a monthly rather than daily figure. Absent
customization, most payables system will try to multiply whatever number is
in the unit price field (in your line item 1 example 2.5%) times the number
of units (5 days) and of course the result will be meaningless.

Presumably the unit rental rate is determined by a function of asset value
was previously expressed in quotes, orders, etc. If not (e.g., it is a
floating value related to, say, LIBOR, or as a reminder to the accounts
payable organization, putting it into a comments field is more appropriate.


					Fulton Wilcox
					Colts Neck Solutions LLC 

-----Original Message-----
From: G. Ken Holman [mailto:gkholman@CraneSoftwrights.com] 
Sent: Friday, April 25, 2008 12:49 AM
To: UBL-Dev
Subject: [ubl-dev] Modeling question re: multifaceted price calculation

Fellow UBL-Dev'ers,

I'm trying to determine which UBL constructs to use to model the 
invoice line items in the following information:

Invoice period:    April 1, 2008 to April 30, 2008

Item:              1
Description:       Thing-one
Quantity:          7
Base cost:         $1000.
Rental rate each:  2.5% per month
Shipped to site:   April 15, 2008
Removed from site: April 20, 2008
Days on site:      5
Rental fee:        $29.17      (=1000*.025/30*5*7)

Item:              2
Description:       Thing-two
Quantity:          3
Base cost each:    $2000.
Rental rate:       $30 per month
Shipped to site:   April 10, 2008
Removed from site: N/A (still on site)
Days on site:      20
Rental fee:        $60         (=30/30*20*3)

Item:              3
Description:       Thing-three
Quantity:          1
Base cost each:    $5000.
Rental rate:       1% per month
Shipped to site:   N/A (was on site)
Removed from site: N/A (still on site)
Days on site:      30
Rental fee:        $50         (=5000*.01/30*30*1)

I'm tempted to put a lot of the line item detail into an extension, 
but I would rather find UBL constructs that express the many facets 
of the price calculation.  All of the items need to be found in the 
instance since the printed invoice needs to reflect all the fields.

Thanks for any guidance on which UBL business objects to use!

. . . . . . . . Ken

--
Upcoming:  UBL Apr.22,24; genericode code lists Apr.23; Rome,Italy
World-wide corporate, govt. & user group XML, XSL and UBL training
RSS feeds:     publicly-available developer resources and training
G. Ken Holman                 mailto:gkholman@CraneSoftwrights.com
Crane Softwrights Ltd.          http://www.CraneSoftwrights.com/u/
Box 266, Kars, Ontario CANADA K0A-2E0    +1(613)489-0999 (F:-0995)
Male Cancer Awareness Nov'07  http://www.CraneSoftwrights.com/u/bc
Legal business disclaimers:  http://www.CraneSoftwrights.com/legal


---------------------------------------------------------------------
To unsubscribe, e-mail: ubl-dev-unsubscribe@lists.oasis-open.org
For additional commands, e-mail: ubl-dev-help@lists.oasis-open.org