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/09 08:22:14 UTC
[jira] Created: (OFBIZ-2713) Invoice generation from Commission Run
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.
[jira] Assigned: (OFBIZ-2713) Invoice generation from Commission
Run
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya reassigned OFBIZ-2713:
------------------------------------------
Assignee: 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
>
>
> 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.
[jira] Updated: (OFBIZ-2713) Invoice generation from Commission Run
Posted by "Amit Sharma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amit Sharma updated OFBIZ-2713:
-------------------------------
Attachment: Commission_Invoice_OFBIZ-2713.patch
Written logic to fetch data for commission run.
Thanks to Rishi Solanki and Awdesh Parihar.
> 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, 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.
[jira] Assigned: (OFBIZ-2713) Invoice generation from Commission
Run
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anil K Patel reassigned OFBIZ-2713:
-----------------------------------
Assignee: Anil K Patel (was: 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: Anil K Patel
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: Commission_Invoice_OFBIZ-2713.patch, Commission_Invoice_OFBIZ-2713.patch, Commission_Invoice_OFBIZ-2713.patch, 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.
[jira] Updated: (OFBIZ-2713) Invoice generation from Commission Run
Posted by "Amit Sharma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amit Sharma updated OFBIZ-2713:
-------------------------------
Attachment: Commission_Invoice_OFBIZ-2713.patch
Here is the patch for CRUD service of InvoiceItemAssoc entity.
Thanks Awdesh!
> 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, Commission_Invoice_OFBIZ-2713.patch, 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.
[jira] Closed: (OFBIZ-2713) Invoice generation from Commission Run
Posted by "Anil K Patel (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anil K Patel closed OFBIZ-2713.
-------------------------------
Resolution: Fixed
Patch in r798854. Thanks team for contribution.
> 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: Anil K Patel
> Priority: Minor
> Fix For: SVN trunk
>
> Attachments: Commission_Invoice_OFBIZ-2713.patch, Commission_Invoice_OFBIZ-2713.patch, Commission_Invoice_OFBIZ-2713.patch, 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.
[jira] Commented: (OFBIZ-2713) Invoice generation from Commission
Run
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (OFBIZ-2713) Invoice generation from Commission
Run
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12734504#action_12734504 ]
Ashish Vijaywargiya commented on OFBIZ-2713:
--------------------------------------------
Thanks Amit!
Done at r796972.
--
Ashish
> 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, Commission_Invoice_OFBIZ-2713.patch, 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.
[jira] Updated: (OFBIZ-2713) Invoice generation from Commission Run
Posted by "Amit Sharma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Amit Sharma updated OFBIZ-2713:
-------------------------------
Attachment: Commission_Invoice_OFBIZ-2713.patch
Here is the patch for Commission Run service with test case.
Thanks to Rishi Solanki , Sumit Pandit and Awdesh Singh Parihar.
> 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, Commission_Invoice_OFBIZ-2713.patch, Commission_Invoice_OFBIZ-2713.patch, 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.
[jira] Updated: (OFBIZ-2713) Invoice generation from Commission Run
Posted by "Ashish Vijaywargiya (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashish Vijaywargiya updated OFBIZ-2713:
---------------------------------------
Attachment: Commission_Invoice_OFBIZ-2713.patch
Patch from Amit Sharma.
-- Initial screen for sales invoice search and list form.
> 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.