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
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.