Additional Actions
Here are some actions that you can perform on formulas:
- Copy and Paste: Copy a cell and paste it into one or more cells within the same column.
- Spotlight: Save a formula to Spotlight to view all associated ingredients and products. When you add them as formula components, they default to ingredient.
- Clipboard: Add ingredients and products to the clipboard for easy reuse.
- Change Control: Change ingredients and products, including some attributes of
the primary product, and track changes using redlining.Note: When the Engineering flag is set to:
- Yes, the formula item can be included in an engineering change order where you can redline revision attachments.
- No, the formula item can be included in a commercialization change order where you can't redline revision attachments.
For more information, see the link provided for Data for Change Orders Across Pending Item Revisions topic in the Related information section of this topic.
- Create a new formula by copying an existing one: In the New formula drawer, select Create from existing to copy a formula from the same or another organization into a different formula header.
- Create a common formula: In the target organization, you can reference an
existing formula when creating a new formula. Any updates made to the existing
formula are automatically reflected in the referenced formula. The referenced
formula itself can’t be edited.
In the New formula drawer, select Create from common to select an existing formula to be referenced in a new formula.
- Replace ingredients, co-product or by-product.
Import Formula
You can import a formula along with its ingredients when the structure item type is set to Formula. If the items don’t already exist in the application, they're created automatically, followed by their formula structure.
- Completion Type
- Contribute to Yield
- Component Type
- Basis
- Product Type (applicable only for formulas)
Integrations
REST: Create a Formula item with the Structure Item Type set to Formula, and then add its component items. The Items V2 and Item Structures REST APIs support the creation of Formula item types and their associated structures.
SOAP: Create a Formula item with the Structure Item Type set to Formula, and then add its component items. The Item and Item Structures V2 SOAP services are now enhanced to support the creation of Formula item types and their associated structures.
- Create a Formula item with the Structure Item Type set to Formula (Code = 6), along with its ingredients before creating the Formula structure.
- Item FBDI supports creating new items with the Structure Item Type set to Formula (Code = 6).
- Item Structure FBDI supports creating a Formula structure. You must create a primary product before you create its structure.
- Use import to define the values for the following attributes:
- Completion Type
- Contribute to yield
- Component Type
- Basis
- Product Type (only applicable for formulas)