Funny how it works when you do it correctly. Thanks for the help
Yes, I have a bunch with USA in them already. Not a silly question at all.
I found the number but it didn’t like that either. I will see what I can find about DMT.
Thank you…. I will look at that. No I haven't used DMT. Not even sure what it is. I am very new to Epicor
I finally got it to work. I was using the group as the scope in the row number expression. When I changed it to dataset it worked like I intended.
Appreciate the quick reply. Unfortunately that didn’t solve the problem. I am using the PartDtl table and Grouping by Part Number. Within that group I have the detail records. When I use any expression. rownumber, count, etc. it just returns the value of 1. Its like it is resetting after every record in the detail section of the group.
Are there any special licensing requirements from Epicor to use MES on tablets? Does it just run the regular MES client? Is there anything I should be aware of before we start testing?
No we are on the cloud. I finally got it figured out though. Thanks for everyones help.
I am pretty new to Epicor but everything I have read says not to use the “sync”. Everyone says it screws things up more than it help. I don’t know if that is true just telling you what I have read. I finally got mine to work. I added it to the query in Report Builder but I didn't have brackets [ added field] around it. You also have to manually add it in the field list. Once I added the brackets the report returned the value I was anticipating.
I had the same issue. What I found was that it was something to do with the grouping. If there is only one order for the specific group it didn't show up.
Sorry I guess I wasn’t clear enough. There are multiple threads on this site that reference a repository that people have uploaded and downloaded BAQ’s, etc for other users to download and test. Links are broken now and I was curious if they were still on the site somewhere.
Yeah I tried that and it didn’t work. Appreciate the feedback
Thanks again. That will get me started. I greatly appreciate all the insight.
Thanks you so much Glen. The company I am working with is in need of some serious process updates. Could you please expand on you Capture process each night. I think that is a great idea but after it is captured and processed what do you do to verify that everything that is posting has posted correctly.I don’t want to start that process without having something in place for verification.
I appreciate everyones input. This is starting to get me to where I want to be. My two main problems are that one, I am very new to Epicor and two, this is my first go round with a job shop. So I printed out the WIP report just for one job and I see how the MFG Variance is calculated but I don't really understand the rows I guess. For example, this job had $28,879.35 of material in the To date row but only 28,222.98 to Inventory/to job row. I see exactly where the 28,879.35 comes from but I have no idea where/or why the To Inventory/To Job is different. Maybe I am just missing the forest for the trees. Sorry If this is a stupid question.
I have a top level and an innersubquery. When I click on the sub query button nothing appears.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.