Invoice generation from Commission Run
--------------------------------------
Key: OFBIZ-2713
URL: https://issues.apache.org/jira/browse/OFBIZ-2713
Project: OFBiz
Issue Type: New Feature
Components: accounting
Affects Versions: SVN trunk
Reporter: Ashish Vijaywargiya
Priority: Minor
Fix For: SVN trunk
In OFBiz you can create single commission invoice for each sales order.
Provide option so that more then one Sales Invoice can be associated to single
Commission Invoice for a particular agent.
The changes will be done in "AP" section.
Implementation Details:
Find Form:
Include fields: fromDate, ThruDate & Party in the role of Sales_Rep (Provide
option so that we could select more then one party)
List Form:
List of sales invoice that are not associated with the commission invoice for a
particular party along with the date range provided.
In the list form provide option to select more then one Sales_Invoice and then
create the commission invoice for the selected sales invoice for the
Sales_Representative selected in the find form. More then one Sales
Representative can be selected here in the find form.
Two new entities will be introduced here:
InvoiceItemAssoc -
This entity will help to search the invoices that has not been associated with
the commission invoice.
Fields for this table can be:
invoiceIdFrom * String, VARCHAR(20) (sales invoice Id)
invoiceItemSeqIdFrom * String, VARCHAR(20)
invoiceIdTo * String, VARCHAR(20) (commission invoice Id)
invoiceItemSeqIdTo * String, VARCHAR(20)
invoiceItemAssocTypeId * String, VARCHAR(20)
fromDate *java.sql.Timestamp, TIMESTAMP
thruDate java.sql.Timestamp, TIMESTAMP
quantity java.math.BigDecimal, NUMERIC(18,6)
amount java.math.BigDecimal, NUMERIC(18,3)
InvoiceItemAssocType - Type could be "COMMISSION_INVOICE" & "WITHDRAW_INVOICE"
In OFBiz we have createCommissionInvoice service present in
InvoiceServices.java. This service can be used for reference.
Thanks Jacopo for your help in discussing things prior to implementation.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
