Need to add ReceiptDate to Receipt Inventory Movement Report

Epicor ERP 10
21

What is the name of the menu item for this report?

where can I launch this from?

22

It is run from within Receipt Entry under Actions

23

Marc,

I went in and added that join, typing it all out by hand carefully and it is working. I suggest trying the same thing.

When I am this twisted up I usually start by copying the base report and then adding this single join to make sure it is working.

I didn’t add the rest of your logic in the report query. I did try it in SSMS and it works fine, even the join to the PO table in the ERP database.

24

hmm it runs fine for me from SSMS as well.

Also tried adding just that join to the base report and receive the same error

25

Was able to find the following error on the report server log:

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword ‘Join’.

1 Like
26

I found the issue. I was editing the query in Notepad++ and pasting it into SSRS. When SSRS read the query it removed the carriage returns causing some of the words to bump into each other. Saving the report and opening it again and looking through the query I was able to correct the spacing issues and it works now

1 Like
27

Yeah Marc, I was about to say that last night, you can’t just copy and paste things into that query editor.

I kinda did say it but not explicitly:

I went in and added that join, typing it all out by hand carefully and it is working. I suggest trying the same thing.

28

Where was the log? I think it is a text file now that I recall and it’s on the SSRS server and actually has some really nice logging… Someone showed me it a long time ago and I completely forgot about it.

29

This was the path for ours on the SQL server
D:\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\LogFiles

1 Like
30

Yes, that is it. Thanks.

To anyone that stumbles on this thread, the log file is extremely helpful.

31

THANK YOU. This has haunted me for forever, and never could understand why some reports work and some don’t. Just mysterious errors of “Incorrect syntax near” despite the syntax looking fine. Never in a million years did I expect it to be this, I thought Epicor was just buggy between RDD and the style.

1 Like