I looked into the adapters list and I could not find it … sorry … I added UD field (Route_c) for a counter I need to increment in code. Tought of using that table instead of a UD table… :thinking: What would be proper syntax to access ? Thanks Pierre

Use the AutoIncrement functions built in to Epicor. [image] BPM to Update or Create Method Directive for JCSyst ERP 10 WARNING… This is not for the faint of heart… but doing it with Business objects is better than directly upda…

Thanks Jose question in the example I assume the following: “NextJobNumber” is the name of the field. What table does it access ? Calling this function “creates the counter for you” ? if so that is a nice feature! If I need to create a new one, company wide access… I would call the function…

As well tried to add the reference specified via the reference manager /Add custom reference and it was not available… Company Specific next values //Add Reference: Erp.Internal.Lib.Shared.dll not found //Add Using: Using Erp.Internal.Lib; Using Ice.Common;

Yes it creates a counter for you. nv is the Next value Class.

And I understood from the post that if it is DB related you call it this way var nv = new NextValue(Db); Int CurrentValue = nv.GetSequenceCurrentValue(Inputs.NextValueKey_chr.Value); but for a company related sequence I would think it would be different? var nv = new NextValue(CompanySequence) …

[image] Auto Sequence Customer ID ERP 10 bpm There a couple of threads on here about making the ID’s go consecutively . @timshuwy has some good info out there, se…

I just noticed your examples were for BPM’s…where I have access to the dll’s, they are on the server. I was trying to add this in my customization, where the mentionned dll’s are not. I am updating multiple rows with the same Counter value, then need to increment it. … I will need to think of a…

You can use an Updatable BAQ to get the next sequence (from the BPM side) (same principle) In your BAQ Bpm get the next sequence value, return it as part of the result set. Then use that in your customization.

[image] Hogardy: I just noticed your examples were for BPM’s…where I have access to the dll’s, they are on the server. I was trying to add this in my customization, where the mentionned dll’s are not. If you EVER decide to run this transaction outside the UI (REST, Service Connect), the BPM w…

How can I access the XaSyst table record in code?

Epicor ERP 10

josecgomez (Jose C Gomez) January 17, 2019, 4:28pm 8

Topic		Replies	Views
BPM to Update or Create Method Directive for JCSyst Epicor ERP 10	8	3752	August 25, 2021
Using Ice.SysSequence table Epicor ERP 10	8	3234	March 15, 2018
Auto Numbering - Customer ID Epicor ERP 10	104	39131	December 15, 2025
Increment Key for UD table in BPM Epicor ERP 10	14	5214	July 31, 2020
Auto increment a UD field on LaborDtl Epicor ERP 10 e10	56	9134	October 2, 2019

How can I access the XaSyst table record in code?

Related topics