You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Todd Blum <to...@toddblum.org> on 2015/08/03 20:32:15 UTC
Can I add custom fields to inventory items?
Hello,
I do outsourced IT where I support multiple clients. Each device
in each office (workstations, printers etc) has a monthly charge for
support.
Besides serial numbers, I need to keep track of the following:
monthly support charge
install date
manufacturer warranty ID
manufacturer warranty expiration
manufacturer warranty type
upstream vendor
upstream vendor invoice number
PO number
receive date
internal invoice and quote numbers
I'm assuming I would need to add custom fields in Ofbiz to keep
track of all this?
Also, would there be a way to generate monthly invoices, based on
the monthly support charges?
Thanks,
Todd
--
Todd Blum
http://www.toddblum.org
Re: Can I add custom fields to inventory items?
Posted by ttblum <to...@toddblum.org>.
OK, thanks.
Would my devices be considered products located in different warehouses?
What is the best way to go about doing this?
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Can-I-add-custom-fields-to-inventory-items-tp4671266p4671297.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Can I add custom fields to inventory items?
Posted by Adrian Crum <ad...@sandglass-software.com>.
No, there is nothing unique about your requirements. All of the
functionality exists. It would be best to obtain a copy of The Data
Model Resource Book, so you can have a better understanding of the data
model.
Adrian Crum
Sandglass Software
www.sandglass-software.com
On 8/3/2015 11:32 AM, Todd Blum wrote:
> Hello,
>
> I do outsourced IT where I support multiple clients. Each device
> in each office (workstations, printers etc) has a monthly charge for
> support.
>
> Besides serial numbers, I need to keep track of the following:
>
> monthly support charge
> install date
> manufacturer warranty ID
> manufacturer warranty expiration
> manufacturer warranty type
> upstream vendor
> upstream vendor invoice number
> PO number
> receive date internal invoice and quote numbers
>
> I'm assuming I would need to add custom fields in Ofbiz to keep
> track of all this?
>
> Also, would there be a way to generate monthly invoices, based on
> the monthly support charges?
>
> Thanks,
>
> Todd
>
> --
> Todd Blum
> http://www.toddblum.org
>
RE: Can I add custom fields to inventory items?
Posted by damon henry <da...@hotmail.com>.
Hi Todd,
You extend database entities (database tables) in ofbiz using the entitymodel.xml files. These are found in the entitydef folders of different components.
You can either update the original xml files in your ofbiz installation, or if you are building a brand new component you can extend an existing entity as part of your new component. I prefer the latter method as it leaves the original ofbiz untouched. Here is an example of extending the InventoryItem entity that I recently did in a project I am working on.
<extend-entity entity-name="InventoryItem"> <field name="htgAssetTag" type="value"/> <field name="htgType" type="value"/> <field name="htgManufacturer" type="value"/> <field name="htgModelNumber" type="value"/> <field name="htgCondition" type="value"/> <field name="htgDescription" type="value"/> <field name="htgInfo1" type="value"/> <field name="htgInfo2" type="value"/> <field name="htgInfo3" type="value"/> <field name="htgInfo4" type="value"/> <field name="htgInfo5" type="value"/> <field name="htgInfo6" type="value"/> <field name="htgNotes" type="value"/> <field name="htgHDD" type="value"/> <field name="htgFormFactor" type="value"/> <field name="htgLeaseReturn" type="indicator"/> <field name="htgRedeployable" type="indicator"/> </extend-entity>
When you restart ofbiz, it reads these files and automatically adds the new fields to the database tables for you. Take a look in the applications/accounting/entitydef/entitymodel.xml. If you do not have your own component that you are already working with you can update the FixedAsset entity here.
damon
> From: todd@toddblum.org
> Date: Mon, 10 Aug 2015 13:29:02 -0400
> To: user@ofbiz.apache.org
> Subject: Re: Can I add custom fields to inventory items?
>
> Hello,
>
> OK.
>
> How do I add additional fields to Fixed Assets?
>
> Todd
>
> --
> Todd Blum
> http://www.toddblum.org
>
>
> On Sat, 8 Aug 2015, Jacques Le Roux wrote:
>
> > Hi,
> >
> > You are on the right way, facilities with fixed assets seems more appropriate
> > to me. Look also at the assetmaint component...
> >
> > Jacques
> >
> >
> > Le 07/08/2015 22:27, Todd Blum a écrit :
> >> Hello,
> >>
> >> OK, thanks.
> >>
> >> Is there any other documentation on how to set this up also? Would the
> >> client offices be set up as warehouses with products, or maybe as
> >> facilities with fixed assets?
> >>
> >> Thanks,
> >>
> >> Todd
> >>
> >> --
> >> Todd Blum
> >> http://www.toddblum.org
> >>
> >>
> >> On Mon, 3 Aug 2015, Todd Blum wrote:
> >>
> >>> Hello,
> >>>
> >>> I do outsourced IT where I support multiple clients. Each device in
> >>> each office (workstations, printers etc) has a monthly charge for support.
> >>>
> >>> Besides serial numbers, I need to keep track of the following:
> >>>
> >>> monthly support charge
> >>> install date
> >>> manufacturer warranty ID
> >>> manufacturer warranty expiration
> >>> manufacturer warranty type
> >>> upstream vendor
> >>> upstream vendor invoice number
> >>> PO number
> >>> receive date internal invoice and quote numbers
> >>>
> >>> I'm assuming I would need to add custom fields in Ofbiz to keep track
> >>> of all this?
> >>>
> >>> Also, would there be a way to generate monthly invoices, based on the
> >>> monthly support charges?
> >>>
> >>> Thanks,
> >>>
> >>> Todd
> >>>
> >>> --
> >>> Todd Blum
> >>> http://www.toddblum.org
> >>>
> >>>
> >>
> >
Re: Can I add custom fields to inventory items?
Posted by Todd Blum <to...@toddblum.org>.
Hello,
OK.
How do I add additional fields to Fixed Assets?
Todd
--
Todd Blum
http://www.toddblum.org
On Sat, 8 Aug 2015, Jacques Le Roux wrote:
> Hi,
>
> You are on the right way, facilities with fixed assets seems more appropriate
> to me. Look also at the assetmaint component...
>
> Jacques
>
>
> Le 07/08/2015 22:27, Todd Blum a écrit :
>> Hello,
>>
>> OK, thanks.
>>
>> Is there any other documentation on how to set this up also? Would the
>> client offices be set up as warehouses with products, or maybe as
>> facilities with fixed assets?
>>
>> Thanks,
>>
>> Todd
>>
>> --
>> Todd Blum
>> http://www.toddblum.org
>>
>>
>> On Mon, 3 Aug 2015, Todd Blum wrote:
>>
>>> Hello,
>>>
>>> I do outsourced IT where I support multiple clients. Each device in
>>> each office (workstations, printers etc) has a monthly charge for support.
>>>
>>> Besides serial numbers, I need to keep track of the following:
>>>
>>> monthly support charge
>>> install date
>>> manufacturer warranty ID
>>> manufacturer warranty expiration
>>> manufacturer warranty type
>>> upstream vendor
>>> upstream vendor invoice number
>>> PO number
>>> receive date internal invoice and quote numbers
>>>
>>> I'm assuming I would need to add custom fields in Ofbiz to keep track
>>> of all this?
>>>
>>> Also, would there be a way to generate monthly invoices, based on the
>>> monthly support charges?
>>>
>>> Thanks,
>>>
>>> Todd
>>>
>>> --
>>> Todd Blum
>>> http://www.toddblum.org
>>>
>>>
>>
>
Re: Can I add custom fields to inventory items?
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi,
You are on the right way, facilities with fixed assets seems more appropriate to me. Look also at the assetmaint component...
Jacques
Le 07/08/2015 22:27, Todd Blum a écrit :
> Hello,
>
> OK, thanks.
>
> Is there any other documentation on how to set this up also? Would the client offices be set up as warehouses with products, or maybe as
> facilities with fixed assets?
>
> Thanks,
>
> Todd
>
> --
> Todd Blum
> http://www.toddblum.org
>
>
> On Mon, 3 Aug 2015, Todd Blum wrote:
>
>> Hello,
>>
>> I do outsourced IT where I support multiple clients. Each device in each office (workstations, printers etc) has a monthly charge for support.
>>
>> Besides serial numbers, I need to keep track of the following:
>>
>> monthly support charge
>> install date
>> manufacturer warranty ID
>> manufacturer warranty expiration
>> manufacturer warranty type
>> upstream vendor
>> upstream vendor invoice number
>> PO number
>> receive date internal invoice and quote numbers
>>
>> I'm assuming I would need to add custom fields in Ofbiz to keep track of all this?
>>
>> Also, would there be a way to generate monthly invoices, based on the monthly support charges?
>>
>> Thanks,
>>
>> Todd
>>
>> --
>> Todd Blum
>> http://www.toddblum.org
>>
>>
>
Re: Can I add custom fields to inventory items?
Posted by Todd Blum <to...@toddblum.org>.
Hello,
OK, thanks.
Is there any other documentation on how to set this up also?
Would the client offices be set up as warehouses with products, or maybe
as facilities with fixed assets?
Thanks,
Todd
--
Todd Blum
http://www.toddblum.org
On Mon, 3 Aug 2015, Todd Blum wrote:
> Hello,
>
> I do outsourced IT where I support multiple clients. Each device in
> each office (workstations, printers etc) has a monthly charge for support.
>
> Besides serial numbers, I need to keep track of the following:
>
> monthly support charge
> install date
> manufacturer warranty ID
> manufacturer warranty expiration
> manufacturer warranty type
> upstream vendor
> upstream vendor invoice number
> PO number
> receive date internal invoice and quote numbers
>
> I'm assuming I would need to add custom fields in Ofbiz to keep track
> of all this?
>
> Also, would there be a way to generate monthly invoices, based on the
> monthly support charges?
>
> Thanks,
>
> Todd
>
> --
> Todd Blum
> http://www.toddblum.org
>
>