Microsoft Dynamics AX (Archived)

AX 2012 - number sequence does not work (projects)

(0) Share

Report

Posted on by Community Member

Hello,

I have problem with automatic numbering - seems that:

- when creating new project, Project ID is not being automatically assigned:

7608.12.png

- I've checked how it looks in numbering sequence for projects, and there is seems ok:

5444.13.png

- RBO_1 has no 'manual' checked, and this sequence defined as to be used for 'Project ID' field:

- unfortunatelly, still - when trying to create new project (first picture above), number for 'Project ID' is not being automatically generated :(

Tried to mark 'manual' and clear it again - no result; tried also to regoot server - unfortunately also not any change. Could anyone advice where the problem may be?

regards

Tomasz

*This post is locked for comments

I have the same question (0)

All responses (25)

Answers (0)

UmesH@ 810 on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Generate Number Sequence Per Company or Shared.

and after

-->Create Method from DataSource to generate Auto Number Sequence

-------------------------------------------------------------------------------

public void create(boolean _append = false)

{

str strNumberSequenceName;

super(_append);

strNumberSequenceName=numberSeq::newGetNumFromCode('YourNumberSequenceCode',NumberSeqScope::find(NumberSequenceScope::findByNaturalKey('',0,0,0).RecId)).num();

DataSourceName.FieldName=strNumberSequenceName;

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Hi Hasan,

I had the same problem.

I set the nuber sequence for Job Identification (Human recources/Setup/Time and attendance/Time and attendance parameters/ <Number sequences>) and the problem was solved.

R.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Hi all,

Case has been closed now.

I have successfully create project.

I don't know for sure what is the root cause.

But what I do is:

1. Unassigned the number sequences in the proejct parameter

2. Delete the number sequences

3. Generate number using wizard

4. Restart AX

After that there is no error again.

Then I recareate the number sequences for my Project ID and assign again to my project parameter.

Many thanks guys for the helps and feedback.

Really appreciate for that.

THanks,

M.H.

Was this reply helpful? Yes No
André Arnaud de Cal... 298,959 Super User 2025 Season 2 on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Hi M. Hasan,

Can you check the Segment configuration? Organization administration > Common > Number sequences > Segment configuration.

Can you confirm if the Company check box is enabled for the Project ID?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Hi Hasan,

Now, you have to debug the below code with only one step and you can easily find the root cause instead of multiple query. during debugging you can check all above value is coming correct or not easily. we are very near. i am stuck here now without debugging i can't tell what exactly issue in your setup or data.

\Data Dictionary\Tables\ProjParameters\Methods\numRefProjId

Thanks

Bhaskar

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Below is the screen shot:

Project ID - Transaction

Project ID - Error

The transaction is run in company 1100

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

you can get number sequence reference table with below recid

Scope:last three digit of recid 331

Table:last three digit of recid 576

Data Type:last three digit of recid 909

Hope you are creating project under company "1100".

Please confirm above detaisl.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

Above is all number sequence scope talble

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

I think, number sequence Scope table having issue.

can you check with below query are u getting any recid or not.

select firstonly scope

where

scope.DataArea == '1100' &&

scope.LegalEntity == 0 &&

scope.OperatingUnit == 0&&

scope.FiscalCalendarPeriod == 0&&

scope.OperatingUnitType == OMOperatingUnitType::None

Or send me details screen with this record.

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

RE: AX 2012 - number sequence does not work (projects)

community.dynamics.com/.../number-sequence-xxxx-has-been-exceeded

Was this reply helpful? Yes No