Raw Material Inventory

Epicor ERP 10
21

I got it all sorted out. Now we will be waiting for the Comptroller to bless it. Thank you for all your help :blush:

2 Likes
22

Sorry for the blush. I don’t even know how it got there.

23

I am having a meeting with our comptroller. Hope something will come out of that. Thanks

24

We are well on the way to implement Heat Number tracking. Thank John for giving me direction. Do you by any chance know where all the attributes like heat numbers and others reside. I looked thru all the BAQs and can’t find them there.

25

All of the lot info is in PartLot.

26

I see these 4 BAQs. I don’t see the data related to Attributes. There is PO related, Lot related, but no Attributes. Wouldn’t they be in another BAQ/Table since, and it is just my understanding, number of attributes varies per company.

27

I am not sure what BAQs you are referencing. If you were to create your own BAQ, the data you want is in the PartLot table.

28

Yeah, unfortunately I don’t create the BAQs. Wish I could. So I only use what is ready made.

29

Certainly not trying to be rude, but you really need to learn, at least the basics.
Otherwise you are always going to be at the mercy of what’s available, or what a
consultant or generous forum user will provide.

None of those options are guaranteed :frowning:

The field on PartLot is called “HeatNum”.

30

Hi John,

Quick question.

Right now, in Epicor the relation between location and material is one to one(at least that’s how our Epicor works). If there are several pieces of same forging in given location, Epicor sums it up. I would be good to know if 20 inches of forging was 2, 10 inches or 5, 4 inches, as an example.

Do you know if that can be done Epicor?

31

Yes, you gain that functionality with AUOM.

32

Hi John,

Just wanted to thank you for giving me a direction with the heat number. I will be able to keep all the tracking in our ERP instead writing .ne application. Makes is simpler for me.

33

Hi John,

I am not sure if you do development, but you know anything about reading BAQ data from .net application?

34

No, I do not. I know how to write BAQs, create RDDs, create Report Styles, and create SSRS Reports. But I have not tried what you asked.

35

Have you even seen anything similar to that code within Epicor. Like scripts or something like that?

DataRow _fil1 = _dsDynamicQueryData.ExecutionFilter.NewRow();

_fil1[“DataTableID”] = “UD39”;

_fil1[“FieldName”] = “Key1”;

_fil1[“CompOp”] = “=”;

_fil1[“RValue”] = “=”;

_fil1[“Neg”] = “???”;

_fil1[“RowMod”] = “???”;

_dqAdapter.ExecuteByID(baqName, _dsDynamicQueryData);

This is .net code to execute BAQ with the filter. Some filter fields are self-explanatory. But last two I can’t figure out?

Do you know where to find support for coding like that?

~WRD000.jpg

36

Have you considered using the REST endpoint (BAQSvc)? This eliminates the need for the Epicor .NET code at the client making upgrades much simpler. There are examples here on the forum.

37

I was going for that at first, but I was not given rights. So I do what I can, all on the client. That’s why .net solution with no service access.

38

You can certainly access the REST endpoints (https) with the same rights as an ordinary user. There is nothing extra to grant. You still write your .NET client but call the BAQSvc service instead of using the client DLLs from Epicor - which you would have to update with any patch or upgrade. Using REST removes that dependency making your .NET client more resilient.

Try it out on your browser:

https://<server>/<instance>/api/v1/BaqSvc/<BaqName>?param='2016-12-01'&param2='FilterValue'

The Params above map to BAQ parameters.

Try it out. Here’s an example: Epicor Rest Helper (Nuget) Updated V2 - Experts’ Corner - Epicor User Help Forum (epiusers.help)

39

Thanks Mark,

I certainly will try. I must have been doing something wrong since I couldn’t get it working. One question. Is it possible for a service not to be running at all. Just turned off?

40

Yeah, is asking me for credentials when going to that URL. I think it probably is setup like that on IIS.