Enable Batch Attributes D365 Finance and Operations with Attribute-Based Pricing and Configuration

Author

Reads 310

Close-up of a hand interacting with a touchscreen displaying dynamic graphs.
Credit: pexels.com, Close-up of a hand interacting with a touchscreen displaying dynamic graphs.

Attribute-Based Pricing and Configuration is a powerful feature in D365 Finance and Operations that allows you to assign specific attributes to batches of products, enabling more accurate pricing and configuration.

This feature is particularly useful for companies with complex pricing structures or those that need to accommodate various product configurations. It streamlines the process of managing different product variations and ensures that the correct pricing is applied.

By enabling batch attributes, you can create a more efficient and scalable pricing system that adapts to changing market conditions and customer needs. This can lead to increased revenue and improved customer satisfaction.

In D365 Finance and Operations, batch attributes can be assigned to batches of products during the production process, allowing for real-time pricing and configuration updates.

Enabling Batch Attributes

To enable batch attributes in D365 Finance and Operations, you need to assign them to a released product. This can be done by navigating to Product information management / Products / Released products, clicking on Manage inventory, and then selecting Product specific.

Credit: youtube.com, EPISODE 87: Batch Attributes in Microsoft Dynamics 365 Finance and Operations

You'll then have the option to choose from Attribute codes: Table, Group, or All. Table gives you the option to specify an exact batch attribute, Group allows you to pick a batch attribute group, and All makes all batch attributes available to be assigned to a batch number.

For example, if you've created a batch attribute group called "Paint param", you can assign it to a product, such as item A01.

Assigning Attributes

Assigning Attributes is a crucial step in enabling batch attributes in D365 Finance and Operations. To create new batch attributes, navigate to Product information management / Setup / Categories and attributes / Batch attributes.

We have 5 types of attributes: String, Integer, Fraction, Enumerate, and Date. For our case, we'll pick Enumerate type, name it "Paint thickness", and assign some values. To do so, click Attribute enumerate values and create 4 records that represent some ranges of thickness.

Credit: youtube.com, EPISODE 4 | Product Attribute Types, Product Attributes in Microsoft D365 Finance and Operations

To assign batch attributes to released product, navigate to Product information management / Products / Released products and from Manage inventory tab click Product specific. Inside product specific form, pick A01 item and assign previously created Group called "Paint param.".

Here's a quick summary of the attribute types and their features:

By assigning batch attributes to released product, we can specify previously created batch attribute or batch attribute group against batch number.

A fresh viewpoint: H B L Power Share Price

Assigning Attributes to Released Products

To assign previously created batch attributes to a released product, you need to navigate to Product information management / Products / Released products and click on the Manage inventory tab.

From the Product specific form, you can select the Attribute codes to assign batch attributes. You have three options: Table, Group, or All.

You can pick a specific batch attribute, a batch attribute group, or all batch attributes for the product. In our case, we picked the A01 item and assigned the previously created Group called "Paint param."

Additional reading: Class B Shares Private Company

Credit: youtube.com, Build a SimEvents Model Assigning Attributes (4 of 7)

To assign a batch attribute, you need to click on the Product specific form and select the attribute type you want to assign. You can choose from Table, Group, or All.

Here are the options for assigning batch attributes:

By assigning batch attributes to a released product, you can specify previously created batch attribute or batch attribute group against batch number.

Specifying Attributes for Exact Numbers

You can specify attributes for exact batch numbers by displaying the Batch number dimension, which allows you to click on each batch number and access the form to specify batch attributes.

To do this, navigate to Inventory management / Inquiries and reports / Tracking dimensions / Batches, and from there, you can open the Inventory batch attributes form from the View tab.

In the Attribute field list, you'll only see the batch attributes that have been set up for the item, limited to the attributes you've specified in the Product specific form.

Business man using headset for a collaborative work session, placing sticky notes on a board.
Credit: pexels.com, Business man using headset for a collaborative work session, placing sticky notes on a board.

For example, if you've set up a batch attribute called "Paint thickness" with Enumerate as the type, you'll see a drop-down list with predefined values in the Attribute values field.

To ensure that you can reserve and release sales order lines with exact batch numbers, you'll need to repeat these steps for all other batch numbers.

Fortunately, there's a feature that can help you achieve this: Flexible warehouse-level dimension reservation. To enable it, navigate to System administration / Workplaces / Feature management and search for the feature called Flexible warehouse-level dimension reservation.

When it's enabled, you'll see a new field called Allow reservation on demand in the Reservation hierarchy, which you can select on a Batch number level to use Batch reservation even when operating with a batch number below location.

Additional reading: Redress Number

Purchasing and Receiving Active Ingredients

Purchasing and Receiving Active Ingredients is a crucial process that requires attention to detail. You can purchase items from an approved supplier with a specific active ingredient, and it may be necessary to track its potency at a specific value.

Top View of a Batch of Dried Black Vegetables
Credit: pexels.com, Top View of a Batch of Dried Black Vegetables

As you receive the item batch, you'll enter the batch attribute value along with the vendor batch details. This information will be used to alter the unit price and net amounts based on the potency value of the batch.

Purchase prices for active ingredient purity or potency can be maintained in the attribute-based pricing details section. This ensures that the pricing is accurate and reflects the actual value of the item.

You can view the different batches in inventory with specific batch attributes in the Batch Tracking screen. This allows you to easily track and manage your inventory.

Additional reading: Petrodollar Value

Attribute Configuration

To assign batch attributes to released products, you need to navigate to Product information management / Products / Released products and click on Manage inventory, then Product specific. From there, you can pick an option from Attribute codes: Table, Group, or All.

In the Product specific form, you can assign a previously created Group called "Paint param." to an item, as seen in Example 1. This is done by picking the Group option.

Credit: youtube.com, EPISODE 10 | How to set up attribute types and Product attributes D365 Finance & Operations

You can also assign a previously created Table to an item, which will later be available to be assigned to a batch number. This is another option available in the Attribute codes dropdown.

To specify batch attributes on exact batch numbers, you need to display the Batch number dimension and click on each of them to get to the form where you can specify batch attributes. This is done from the Inventory management / Inquiries and reports / Tracking dimensions / Batches level.

In the Attribute field list, the options are limited to the batch attributes that were assigned earlier in the Product specific form. For example, if you assigned the Group "Paint param." to an item, the Attribute field list will only show the two batch attributes that are part of that group.

If one of the batch attributes has a type of Enumerate, you will see a drop-down list with earlier predefined values in the Attribute values section. This is seen in Example 2, where the Paint thickness batch attribute has a drop-down list with earlier predefined values.

To enable the feature that allows you to reserve and release to warehouse sales order lines with exact batch numbers, you need to navigate to System administration / Workspaces / Feature management and search for the feature called Flexible warehouse-level dimension reservation. When this feature is enabled, you will see a new field called Allow reservation on demand in the Reservation hierarchy.

Credit: youtube.com, D365 F&O Product attribute setup & Product attribute search

Here are the available options for Attribute codes in the Product specific form:

  1. Table - gives an option to specify exact batch attribute
  2. Group - an option to pick batch attribute group
  3. All - all batch attributes will be available to be assigned to batch number

By selecting the Group option and assigning a previously created Group, such as "Paint param.", you can limit the Attribute field list to only show the batch attributes that are part of that group.

Working with Attributes

You can create new batch attributes and attribute groups to manage product information in D365 Finance and Operations. To create a new batch attribute, navigate to Product information management / Setup / Categories and attributes / Batch attributes.

There are five types of attributes: String, Integer, Fraction, Enumerate, and Date. For our case, we'll pick Enumerate type, name it "Paint thickness", and assign some values.

Here are the five types of attributes:

Batch attribute groups can be used to group multiple batch attributes together, reducing time spent assigning them to released items.

Credit: youtube.com, Product Information Management Batch Attributes

To assign batch attributes to a released product, navigate to Product information management / Products / Released products and click on Manage inventory. From there, click on Product specific and select the Attribute codes to pick the batch attribute or group.

You can assign batch attributes to an item by picking the A01 item and assigning the previously created Group called "Paint param."

Active Ingredient Attribute-Based Pricing can also be active during the sales process and within customer billing. This allows for auto-adjusting billing based on the potency or purity selected.

Sales Order Reservation

Sales Order Reservation is a crucial process in D365 Finance and Operations, and it's made easier with batch attributes. You can search for a batch number with specific batch attributes from the Sales and marketing > Sales orders > All sales orders page.

To do this, click on Inventory > Batch reservation from the line level, and enter the Batch reservation form. This form allows you to make a reservation against an exact batch number.

Expand your knowledge: What Is Sales Tax

Credit: youtube.com, Batch Disposition Codes in #microsoftdynamics365 #financeandoperations #d365talks #batch

You can either check batch by batch or use the Batch attribute search option, which is more convenient, especially when you have multiple batch numbers on stock. The Batch attribute search allows you to apply a query using batch attributes that you assigned to your product.

You can limit the list of presented batch numbers in the Overview section to those that meet your criteria by specifying minimum and maximum values and clicking OK. This is especially useful when dealing with recurring requirements.

If you frequently search for specific batch attributes, you can save the attributes query as a template using the "Save template" option. Next time, you can quickly load the template using the "Get template" option.

Remember, even though you've limited the list of batch numbers, you still need to manually enter the quantity in the Reservation field when making a reservation.

Why and How

Enabling batch attributes in D365 Finance and Operations is a game-changer for streamlining processes. Batch attributes allow you to group similar tasks together, reducing manual effort and increasing efficiency.

Credit: youtube.com, 041- Batch attributes and batch disposition codes | D365FO | [Arabic]

This feature is particularly useful for companies with complex manufacturing or distribution operations, as it enables them to manage large volumes of inventory and production efficiently. By grouping similar tasks, you can automate tasks and reduce errors.

To enable batch attributes, you need to configure the batch management module, which involves setting up batch types, batch numbers, and batch attributes. This requires a good understanding of your business processes and how they can be optimized.

Active Ingredient Attribute-Based Pricing

Active Ingredient Attribute-Based Pricing is a game-changer for businesses that deal with active ingredients in their products. It allows you to track the potency of these ingredients at a specific value, which can impact pricing.

You can purchase items with active ingredients from approved suppliers and track their batch attributes, including potency values. This information is used to derive attribute-based pricing that alters unit prices and net amounts based on the potency value of the batch.

See what others are reading: Value of Money

Credit: youtube.com, Configuring Attribute Based Pricing

This approach is not limited to purchasing; it can also be applied to customer billing. The same Caustic Soda example illustrates how potency-based pricing can auto-adjust billing based on the purity or purity selected.

Microsoft Dynamics 365 provides the ability to capture multiple attributes for an item, such as the purity of Na2O and the purity of Caustic Soda itself. This information is used to calculate prices based on specific attributes.

Product information management in the system allows you to maintain attribute-based pricing from trade agreements, which include journal entries to maintain sales and purchase prices. This can include algebraic equations that adjust prices based on the purity or potency of the batch being sold.

The invoiced sales order shows the adjusted price for the batch based on the purity of Caustic Soda. This is just one example of how attribute-based pricing can be applied to customer billing.

Why Use Parameters?

Using parameters in the SysOperation Framework gives you a lot more flexibility and control over what data is processed. This is because the values in the parameter table can be changed each time you set up and run the job.

Batch of Dried Black Vegetables
Credit: pexels.com, Batch of Dried Black Vegetables

Developers can create a batch job without sending in any parameters, but this means the values in the parameter table will affect all instances of the batch job.

Multiple instances of the batch job can be set up at the same time to process different pieces of data. This allows you to have different recurrence for each instance if desired.

By adding D365 SysOperation Framework parameters, users can change what data is processed each time they set up and run the job.

Tasha Kautzer

Senior Writer

Tasha Kautzer is a versatile and accomplished writer with a diverse portfolio of articles. With a keen eye for detail and a passion for storytelling, she has successfully covered a wide range of topics, from the lives of notable individuals to the achievements of esteemed institutions. Her work spans the globe, delving into the realms of Norwegian billionaires, the Royal Norwegian Naval Academy, and the experiences of Norwegian emigrants to the United States.

Love What You Read? Stay Updated!

Join our community for insights, tips, and more.