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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0011216

Openbravo ERP

07. Sales management

public

2009-11-02 17:30

2009-11-04 00:00

Reporter

nsaleh

Assigned To

rafaroda

Priority

normal

Severity

critical

Reproducibility

always

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

2.40

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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.

Additional Information