UD field on PartTran - Performance Drag?

Kinetic ERP
1

Hey,

I’m looking at the possibility of adding a UD field to PartTran so I can capture a bit of info on the handheld version of Job Receipt to Inventory.

Wondering what kind of performance hit that will be on this notoriously slow-to-query table. Anyone have experience with this?

Thanks,

Joe

2

I try to stay away from the PartTran table all together for customizations. Is there another way you can achieve your results via a UD table? When I do have to hit the PartTran, I do it via a BO rather than a DD.

3

@jdtrent I don’t write to PartTran in a customization, but on End Activity I accumulate data in a json and put that into Callcontext Character01 which Epicor carries to the bpm in which I update PartTran post processing on the server side.

The write is still relative quick as it is only a couple of fields, but even if it was slow the user would be unaware.

4

Doug,

I need to transfer some data on the handheld job receipt to inventory to the PartLot record. I’ll probably go the call context route that Greg mentioned.

Thanks,

joe

2 Likes