[jira] Created: (OFBIZ-2713) Invoice generation from Commission Run
Locked
[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
|
|
[ 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
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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. |
[jira] Commented: (OFBIZ-2713) Invoice generation from Commission Run
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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] Updated: (OFBIZ-2713) Invoice generation from Commission Run
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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] Updated: (OFBIZ-2713) Invoice generation from Commission Run
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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] Commented: (OFBIZ-2713) Invoice generation from Commission Run
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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] Assigned: (OFBIZ-2713) Invoice generation from Commission Run
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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] Closed: (OFBIZ-2713) Invoice generation from Commission Run
|
|
In reply to this post by Nicolas Malin (Jira)
[ 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. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |