#637 Adding Activity field to Invoice Line (similar to Project)

closed-fixed
nobody
None
7
2006-12-06
2006-06-29
Mete Kural
No

Based on our previous support request for adding an
Activity field in the Invoice Line level, you suggested
to create a request for enhancement and submit our
contribution. This was support request 1507585 please
refer here:
http://sourceforge.net/tracker/?func=detail&aid=1507585&group_id=29057&atid=410216

We propose to contribute the below contribution and ask
you if it sounds good to you to incorporate this into
Compiere core once we complete the below procedure. Do
you see any problems that might arise from the below?

1. Modify existing Compiere table c_invoiceline to
include the activity field using the AD, so the user
can select it from a pull-down list in the same way you
salect an organization at the invoice Header.
2. Have Compiere save this field in the same way it
saves a charge at the invoice line
3. Just when the user completes this (vendor)
invoice, we could have compiere run a sort of callout
procedure to modify the account combination of the
current charge at the invoice line.
* For instance, if the charge is pointing at
account combination 01_6100_XXXXXX, this procedure
would modify the charge's current combination and will
actually post 01_6100_INVOICE LINE'S ACTIVITY_XXXXX to
the accounting facts.
4. End of procedure

I think the described procedure above would not alter
the logic of the accounting functionality in Compiere
at all, and on the other hand will allow users to
effectively register the activity field at the invoice
line, therefore will prevent them from a lot of
repetitive work since with the current functionality,
the user has to define previously a set of charges for
each activity and expense account combination.

Thank you.

Discussion

  • Mete Kural
    Mete Kural
    2006-07-03

    • priority: 5 --> 7
     
  • Jorg Janke
    Jorg Janke
    2006-07-03

    • status: open --> pending
     
  • Jorg Janke
    Jorg Janke
    2006-07-03

    Logged In: YES
    user_id=87038

    I know how to do this technically - the question is what is
    the bsuiness case?

     
  • Mete Kural
    Mete Kural
    2006-07-04

    Logged In: YES
    user_id=1443283

    The business case is that in a vendor invoice, different
    invoice lines may be associated with different activities.
    For example the organization could purchase some office
    supplies in one invoice, but computer desks may be purchased
    for one area of the business and hence associated with a
    specific activity whereas printing paper may be for a
    different area of the business and hence potentitally
    associated with a different activity. It is currently
    possible to do this with "Projects" in Compiere. We can have
    one invoice and associate different invoice lines for
    different projects rather than having the whole invoice
    associated to one project. Our new customer absolutely needs
    this functionality since they frequently make purchases and
    pay invoices where different invoice lines will be
    associated with different activities. So we need to be able
    to associate different activities for different lines of
    purchase orders, vendor invoices and material receipts.
    Please let me know what you think.

     
  • Mete Kural
    Mete Kural
    2006-07-04

    • status: pending --> open
     
  • Jorg Janke
    Jorg Janke
    2006-07-06

    • labels: 676694 -->
     
  • Kathy Pink
    Kathy Pink
    2006-12-06

    Logged In: YES
    user_id=329831
    Originator: NO

    If you have enabled activity as an element you can select it on an Invoice Line

     
  • Kathy Pink
    Kathy Pink
    2006-12-06

    • status: open --> closed-fixed
     
  • Kathy Pink
    Kathy Pink
    2006-12-06

    Logged In: YES
    user_id=329831
    Originator: NO

    If you have enabled activity as an element you can select it on an Invoice Line

     
  • Kathy Pink
    Kathy Pink
    2006-12-06

    Logged In: YES
    user_id=329831
    Originator: NO

    ** Feature included in next release **