Applying One Sequence Format to Several Objects

You can add several targets to one sequence format to enable you to maintain a consistent format across your reference numbers. If your sequence format contains several target objects, the generated sequence number increases incrementally for all eligible records. This topic provides a summary of the behavior you can expect when generating sequence numbers for one format that contains several objects.

No Field Placeholder Parts Reset the Sequence Number

If no parts of the sequence format reset the generated sequence number, the number increases incrementally across all eligible records in the first object, followed by all eligible records in the second object, and so on.

Example

A sequence format contains the following information:

• A text part that contains BD, a text part that contains a hyphen, and one number sequence part (BD-00001)
• The starting value is 00001

When you generate sequence numbers, the number does not reset when applied to different target objects, as displayed in the Generated Sequence Number column.

Record ID	Object	Generated Sequence Number
1	Billing Document	BD-00001
2	Billing Document	BD-00002
3	Billing Document	BD-00003
1	Billing Document Line Item	BD-00004

One or More Field Placeholder Parts Reset the Sequence Number

If one or more of the fields reset the generated sequence number, the number resets whenever the value in the associated field changes, as described in Resetting Numbers and Hiding Parts in a Sequence Format.

The number can increase incrementally across objects if a placeholder part is associated with fields that can contain the same values, such as lookups or text fields. The number only resets when the value changes, even when the placeholder part relates to different fields on different target objects.

Example

A sequence format contains the following information:

• A field placeholder part, a text part that contains a hyphen, and one number sequence part (Placeholder-00001)
• The starting value is 00001
• Reset Sequence Number is selected on the placeholder part in the sequence format
• Two target rows exist for objects in Accounting (Sales Invoice and Payables Invoice)
• The placeholder part relates to a lookup to account name on both target rows

When you generate sequence numbers, the number resets to the starting value for each different account, even if the object changes, as displayed in the Generated Sequence Number column.

Record ID	Object	Account	Generated Sequence Number
1	Sales Invoice	Merlin	Merlin-00001
2	Sales Invoice	Merlin	Merlin-00002
3	Sales Invoice	Acme	Acme-00001
1	Payables Invoice	Merlin	Merlin-00003