You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org> on 2009/07/10 15:25:14 UTC

[jira] Commented: (OFBIZ-2713) Invoice generation from Commission Run

    [ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729635#action_12729635 ] 

Ashish Vijaywargiya commented on OFBIZ-2713:
--------------------------------------------

Thanks Amit.
Done at r792939.

--
Ashish Vijaywargiya

> 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
>            Assignee: Ashish Vijaywargiya
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: Commission_Invoice_OFBIZ-2713.patch
>
>
> 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.