Acknowledgement Misc Charge Description 10.0.700.4

Well yes and no.. The query below is actually a query to the SSRS database. What fills in the SSRS database is driven by the Report Data Definition and the thing that’s happening on that RDD the charge description is a calculated field and what’s when the look up is happening and the one that’s probably doing what you don’t want.   If you look at the RDD there’s a Description Field that is hidden in the OHOrderMSC . You can try modifying the RRD then change the SSRS report to bring in the new field and display it.

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 17, 2016 11:59 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Acknowledgement Misc Charge Description 10.0.700.4

 

 

That is what I figured but according to the query below it isn’t even touching the MiscChrg table correct?

 

="SELECT T1.OrderLine,

T1.DocMiscAmt,

T1.FreqCode,

T1.SeqNum,

T1.MiscCode,

T1.OrderNum,

T1.Calc_ChargeDesc,

T3.RptLanguageID,

T3.RptLiteralsLORMSC,

T3.RptLiteralsLQty,

T3.[Description] as RptLiteralsDescription,

T3.FreqCode as RptLiteralsFreqCode,

T3.UnitPrice as RptLiteralsUnitPrice,

T3.Calc_ExtPrice as RptLiteralsCalc_ExtPrice

FROM OHOrderMsc_" + Parameters!TableGuid.Value + " T1

JOIN OrderHed_" + Parameters!TableGuid.Value + " T2

  ON T1.OrderNum = T2.OrderNum          AND T1.Company = T2.Company

JOIN RptLabels_" + Parameters!TableGuid.Value + " T3

  ON T2.RptLanguageID = T3.RptLanguageID"

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 17, 2016 1:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Acknowledgement Misc Charge Description 10.0.700.4

 

 

It looks what Epicor is doing on the SSRS report is pulling the misc charge description assigned to the code and not looking at what you specifically put on the order. If you want it to pull what’s on the order and not necessarily the  code, you’ll have to change the query on the sub report.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 17, 2016 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Acknowledgement Misc Charge Description 10.0.700.4

 

 

In the sales order miscellaneous charge help screens it says that you can override the description of the charge.  We have changed it and if you go out of the order and back in the changes are still there but they do not print on the Acknowledgement.  For example, the default description is "Freight" and we change it to "Estimated Freight to Canada".  The revised description shows in order tracker but Freight will print on the acknowledgement.  The problem exists on both header and line misc charges.

 

I am new to SSRS but it looks like it is sending the correct information from the OrderMsc table.  I ran a BAQ against that table and "Estimated Freight to Canada" is in that table.

 

I called it in to Epicor and they are "researching it".  Anyone else tackle this problem?

_____________________________________________________________________________________________________



Mark Tellefson | Information Technology | www.rapat.com

Phone: (218) 483-3344 | Toll Free: (800) 325-6377

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient and received this in error, please contact the sender by reply e-mail. You are hereby notified that the copying, use or distribution of any information or materials transmitted in or with this message is strictly prohibited.

In the sales order miscellaneous charge help screens it says that you can override the description of the charge.  We have changed it and if you go out of the order and back in the changes are still there but they do not print on the Acknowledgement.  For example, the default description is "Freight" and we change it to "Estimated Freight to Canada".  The revised description shows in order tracker but Freight will print on the acknowledgement.  The problem exists on both header and line misc charges.


I am new to SSRS but it looks like it is sending the correct information from the OrderMsc table.  I ran a BAQ against that table and "Estimated Freight to Canada" is in that table.


I called it in to Epicor and they are "researching it".  Anyone else tackle this problem?

It looks what Epicor is doing on the SSRS report is pulling the misc charge description assigned to the code and not looking at what you specifically put on the order. If you want it to pull what’s on the order and not necessarily the  code, you’ll have to change the query on the sub report.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 17, 2016 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Acknowledgement Misc Charge Description 10.0.700.4

 

 

In the sales order miscellaneous charge help screens it says that you can override the description of the charge.  We have changed it and if you go out of the order and back in the changes are still there but they do not print on the Acknowledgement.  For example, the default description is "Freight" and we change it to "Estimated Freight to Canada".  The revised description shows in order tracker but Freight will print on the acknowledgement.  The problem exists on both header and line misc charges.

 

I am new to SSRS but it looks like it is sending the correct information from the OrderMsc table.  I ran a BAQ against that table and "Estimated Freight to Canada" is in that table.

 

I called it in to Epicor and they are "researching it".  Anyone else tackle this problem?

That is what I figured but according to the query below it isn’t even touching the MiscChrg table correct?

 

="SELECT T1.OrderLine,

T1.DocMiscAmt,

T1.FreqCode,

T1.SeqNum,

T1.MiscCode,

T1.OrderNum,

T1.Calc_ChargeDesc,

T3.RptLanguageID,

T3.RptLiteralsLORMSC,

T3.RptLiteralsLQty,

T3.[Description] as RptLiteralsDescription,

T3.FreqCode as RptLiteralsFreqCode,

T3.UnitPrice as RptLiteralsUnitPrice,

T3.Calc_ExtPrice as RptLiteralsCalc_ExtPrice

FROM OHOrderMsc_" + Parameters!TableGuid.Value + " T1

JOIN OrderHed_" + Parameters!TableGuid.Value + " T2

  ON T1.OrderNum = T2.OrderNum          AND T1.Company = T2.Company

JOIN RptLabels_" + Parameters!TableGuid.Value + " T3

  ON T2.RptLanguageID = T3.RptLanguageID"

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 17, 2016 1:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Acknowledgement Misc Charge Description 10.0.700.4

 

 

It looks what Epicor is doing on the SSRS report is pulling the misc charge description assigned to the code and not looking at what you specifically put on the order. If you want it to pull what’s on the order and not necessarily the  code, you’ll have to change the query on the sub report.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, May 17, 2016 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Acknowledgement Misc Charge Description 10.0.700.4

 

 

In the sales order miscellaneous charge help screens it says that you can override the description of the charge.  We have changed it and if you go out of the order and back in the changes are still there but they do not print on the Acknowledgement.  For example, the default description is "Freight" and we change it to "Estimated Freight to Canada".  The revised description shows in order tracker but Freight will print on the acknowledgement.  The problem exists on both header and line misc charges.

 

I am new to SSRS but it looks like it is sending the correct information from the OrderMsc table.  I ran a BAQ against that table and "Estimated Freight to Canada" is in that table.

 

I called it in to Epicor and they are "researching it".  Anyone else tackle this problem?

_____________________________________________________________________________________________________



Mark Tellefson | Information Technology | www.rapat.com

Phone: (218) 483-3344 | Toll Free: (800) 325-6377

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient and received this in error, please contact the sender by reply e-mail. You are hereby notified that the copying, use or distribution of any information or materials transmitted in or with this message is strictly prohibited.