Replies posted by mdewey

4 Replies

M
Michaela.HKnown Participant
asked in Kinetic & Epicor ERP

Creating a BAQ to compare warehouse on hand balance with site balance

I’ve done something like this by creating a subquery that summarizes the on-hand qty in PartWhse by site or by company.  Then join it back to your original query by part.  Let me know and I can put something together

7
M
1 year ago
rfreeman
rfreemanKnown Participant
asked in Kinetic & Epicor ERP

PO Line/Release Ordered to Job - Simple (?) Query

I did one that looks like this:for each JobMtl no-lock  where  JobMtl.BuyIt = True  ,  each JobHead no-lock  where (JobHead.Company = JobMtl.Company and JobHead.JobNum = JobMtl.JobNum ) and  JobHead.JobClosed = False And JobHead.JobReleased = True  ,  each PORel no-lock  where  PORel.OpenRelease = True  outer-join where (JobMtl.Company = PORel.Company and JobMtl.JobNum = PORel.JobNum and JobMtl.AssemblySeq = PORel.AssemblySeq and JobMtl.MtlSeq = PORel.JobSeq ).

2
M
3 years ago
G
glenn.owersBrainy
asked in Kinetic & Epicor ERP

Dashboard and BAQ Issue for a Single User

It probably has to do with their workforce ID.  If they don’t have the rights to see the customers that are being listed then they don’t see the data and there is no error message.  Perhaps the others that do see the data have no workforce ID at all.  I find that if I create a workforce ID for myself then I can’t see certain information until I delete it

6
G
3 years ago
D
dinmanBrainy
asked in Kinetic & Epicor ERP

How to handle DMR material not processed in same day

We have this same problem.  For now what I did was to create a BPM that gets triggered when the buyer clicks buy on the suggestion.  It looks for any open DMR’s for that part and gives a warning to the buyer.  I believe I did the same thing if they try to create a PO manually.  I also created a Suggestion dashboard that shows them open DMRs and open inspection records plus a lot of other data.  We’re still on E9 right now and are in the process of going to E10

2
M
3 years ago
Terms & Conditions