10.2.300.8 Row Has Been Modified

Epicor ERP 10
21

I was hoping you would say that. SO I have a Psot MEthod Directive on Erp.SalesOrder. Here is a pic of it.

Method%20Directive%20SalesOrder
Method Directive SalesOrder.JPG1506×827 78.6 KB

Where do I add in the GetByID() at?

22

@josecgomez Thank you for the info! I played around with it and figured out where to put it. I’ve only done 1 BPM in the past 1.5 years and only 1 customization that had code. So, not very much experience. My last question is, I see where you are using Erp.Contracts.etc for the the example you told me to view. Where can I find that info for other fields like Update or Job entry screen BPM? Hope this makes sense. I am trying to figure out where to find the info and what each named piece you have represents so I can replicate as I need too.

23

The Erp.Contracts.XXX is in the DLL for each of the business Objects
image

And the format is always Erp.Contracts.SvcContract
or if its an Ice framework Contract it would be
Ice.ContractsSvcContract

24

Ok, so using the format i saw in the post you provided, and editing it for the update to SalesOrder that I have that is Post Proc, how bad am I off here:

using(Erp.Contracts.SalesOrderSvcContract quoteSvc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.SalesOrderSvcContract>(Db))
{
 OrderHedTableset OrderHedDs = SalesOrderSvc.GetByID(OrderNum);
 this.dsHolder.Attach(OrderHedDs);
}
25

That’s pretty good, right on the money I’d say. Make sure you only do this IF there was a change to the data (Db) in the post processing

26

How would i word/code that in?

27

@josecgomez So I put that code into the BPM and had it check the Syntax. Her are the three errors I am getting:

  1. The type or namespace name ‘OrderHedTableset’ could not be found (are you missing a using directive or an assembly reference?)
  2. The name ‘SalesOrderSvc’ does not exist in the current context
  3. The name ‘OrderNum’ does not exist in the current context
28

Found one error and fixed it to this:

using(Erp.Contracts.SalesOrderSvcContract SalesOrderSvc = Ice.Assemblies.ServiceRenderer.GetService<Erp.Contracts.SalesOrderSvcContract>(Db))
{
OrderHedTableset OrderHedDs = SalesOrderSvc.GetByID(OrderNum);
this.dsHolder.Attach(OrderHedDs);
}

So 1 and 3 are left.

29

It would be SalesOrderTableset not OrderHedTableset

and OrderNum you’ll have to find… or pull from somewhere it doesn’t just exist without being declared. So you’ll have to find that OrderNum from… your record?

30

Gotcha. So OrderNum is not int he tableset of SalesOrder? Sorry, just trying to understand. Or is it that everything must be declared, even if it does exist?

31

Well some method have OrderNum , some don’t. If you don’t have it you have to get it from your ttTable (record)

32

Ok, I understand that. So my table is ttOrderHed. Would it be as simple as ttOrderHed.OrderNum?

33

Not ttOrderHed is a table you have too loop through (or index access) the record.

34

This has happened to us in 8.03.x and in 10.0.x. It also happens to us in our Kronos application. The common link to all of these is SQL server. Kronos doesn’t have any customizations. However, our Epicor screens do.

35

So, I used the sales order code mentioned in the article from @polydamas. But I am not sure what it all says, it just doesn’t through any errors.:roll_eyes::thinking:

36

What was your fix for the issue?

37

I haven’t been able to find a fix. It doesn’t happen frequently enough that it’s a major problem.

The biggest problem it has caused for us is when someone pastes many parts into job entry materials. The users stopped doing this.

Thanks,

Sharon Pulsifer

(o) 318-371-6347

Ext 223

38

Ok, curious, does a refresh on the page, after the parts are pasted in, fix the issue you think?

39

Yes, a refresh fixes the issue. However, the users have difficulty determining where they need to begin again. Our users typically paste about 400 parts. If the issue happens at 300, our users find it too difficult to re-copy and paste
rows 301-400.

Thanks,

Sharon Pulsifer

(o) 318-371-6347

Ext 223

1 Like