0011216: Sales Invoice Dimensional Report displays sales rep. from C_BPARTNER table rather than C_INVOICE table

Description

In the sales invoice dimensional report when the Sales Rep. is selected as a dimension, the value '**' is displayed in the printout despite the fact that sales invoices are capturing values in the salesrep_id column.

It seems that the report is NOT displaying the sales rep. from the table c_invoice, but instead it is displaying the sales rep. assigned to the customer in c_bpartner table.

This won't work for our business. We can't specify a sales representative for each customer because more than one sales representative can sell a specific customer. So we can only specify the sales rep. at invoice time.

Steps To Reproduce

* Create a Sales Invoice for a business partner that has no sales rep. defined.
* select a Sales Representative in the invoice from the drop down list.
* Enter all other fields and save the header, also create lines and complete the invoice.
* Go to Sales Management>Analysis Tools>Sales Invoice Dimensional Report.
* Select the date of the invoice.
* Select the dimension "Sales Rep." and print the report.

You will notice that the sales rep. value displayed is "**".

* Go to Master Data Management>Business Partner window.
* Select the business partner record that was used in the Invoice.
* Go to the Customer tab and select a Sales Representative from the list and save.
* Go to Sales Management>Analysis Tools>Sales Invoice Dimensional Report.
* Select the date of the invoice.
* Select the dimension "Sales Rep." and print the report.

You will notice that the sales rep. value displayed is the name of the assigned Sales Rep. for the customer.

Proposed Solution

Modify the report to print the sales rep. from C_INVOICE table rather than C_BPARTNER table.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

duplicate of

defect

0007057

closed

rafaroda

"Sales Invoice Dimensional Report" does not take Sales rep. information from the current transaction

Notes
(0021524) rafaroda (developer) 2009-11-03 08:19	Hi Nadia, This issue is duplicated of 0007057. You can find its fix at https://dev.openbravo.com/websvn/openbravo/?op=comp&compare[]=%2F@12107&compare[]=%2F@12108 [^] This fix is included both in Openbravo ERP 2.50 and Openbravo ERP 2.40 maintenance branch. Thanks for your feedback.

Issue History
Date Modified	Username	Field	Change
2009-11-02 17:30	nsaleh	New Issue
2009-11-02 17:30	nsaleh	Assigned To	=> rafaroda
2009-11-03 08:19	rafaroda	Relationship added	duplicate of 0007057
2009-11-03 08:19	rafaroda	Status	new => closed
2009-11-03 08:19	rafaroda	Note Added: 0021524
2009-11-03 08:19	rafaroda	Duplicate ID	0 => 7057
2009-11-03 08:19	rafaroda	Resolution	open => duplicate
2009-11-04 00:00	anonymous	sf_bug_id	0 => 2891549