Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The inventory profile is intended for the implementation of and accounting for movements and on-hand inventory as they are related to a kind of activity. The kind of activity defines the way that the item was received by the organization and the restrictions that are imposed on the handling of the item. Here are some examples of kinds of activity:
In all these cases, the movements and on-hand inventory of the same item that is received by the organization as a result of different kinds of activity should differ in the following aspects:
The inventory profiles functionality lets you perform these tasks:
There are four kinds of activity:
The inventory profile is used for the separate accounting of item movements and balances in the context of activities. You can define a set of possible values for the inventory profile. For each inventory profile, the kind of activity that the profile belongs to is specified. The type of activity in the inventory profile can't be changed.
When an inventory profile is active in a group of inventory dimensions, the following check boxes on the Tracking dimension groups page are selected: Primary stocking, Physical inventory, Financial inventory, and Transfer. Additionally, when an inventory profile is active for a product, it must be specified on the document lines and can't differ in the corresponding inventory transactions.
For more information, see Set up an inventory profile.
The inventory profile compatibility setting is used for these purposes:
For more information, see Set up compatible inventory profiles.
To set up and use inventory posting ledger accounts in the context of inventory profiles, you must activate the inventory transaction combinations for inventory profiles.
For more information, see Activate transaction combinations for inventory profiles.
You can specify the inventory profile when you set up inventory posting. The ledger account that an item movement is posted to is determined by the value of the inventory profile that is specified for the movement.
Inventory posting can be set up for the following inventory profile values:
The ability to set posting for a specific kind of activity and inventory profile is controlled by the settings for activating combinations of inventory transactions.
For more information, see Set up inventory posting in the context of an inventory profile.
The kind of activity and inventory dimension can be specified in the purchase order, sales order, and transfer order header. If a kind of activity is specified in an order, only inventory profile values that correspond to that kind of activity can be specified in the order header, on the order lines, and in the inventory transactions for the order. If you specify an inventory profile in the sales order header and on the sales order lines, only that inventory profile and compatible inventory profiles can be specified on the order lines and in the inventory transactions. For more information, see Set up a default inventory profile for purchase orders.
The kind of activity and inventory profile can be specified in a vendor, customer, or agreement master record. If a kind of activity and inventory profile are specified, they are considered the default dimension values for purchase order and sales order headers. If a kind of activity is already specified for the vendor, customer, or agreement master record, you can specify only the inventory profile value that corresponds to the kind of activity in that master record. For more information, see Set up a default kind of activity and inventory profile for vendors, customers, agreements, and warehouses.
In other types of documents, such as inventory journals and production orders, the inventory profile, like other inventory dimensions, is specified on the document lines. For more information, see Set up a default inventory profile for BOMs.
You can't change the inventory profile value during inventory picking or registration. The inventory profile value that is specified on the document line remains the same on inventory transactions until financial posting occurs.
When you create sales order lines, if you specify the quantity but don't specify an inventory profile, the system can automatically pick up physically available on-hand inventory in the context of inventory profiles.
Some inventory profile values might also indicate that they can't be used for automatic line splitting. To post an outgoing inventory transaction that has this type of inventory profile, you must specify the inventory profile value on the sales order line or inventory journal line.
If a kind of activity is specified in the sales order, the sales order line can be split only by the inventory profile values that are related to that kind of activity.
For more information, see Create sales order lines.
Posted packing slips, product receipts, invoices, and invoice-factures for purchase orders and sales orders are divided into separate documents, based on the kinds of activity that correspond to the inventory profiles from the order lines, and on the corresponding customer and vendor posting profiles.
The value of the kind of activity is stored in the invoices and invoice-factures.
Posted documents are divided based on the number of unique combinations of a kind of activity and a customer or vendor posting profile. Items that aren't accounted for in the context of inventory profiles are included in invoices, and the Basic kind of activity and the customer or vendor posting profile are specified in the order header. Splitting by kinds of activity and customer or vendor posting profiles is done regardless of the summary update settings.
For more information, see Set up a default inventory profile for purchase orders, Set up a default inventory profile for sales orders, Purchase orders, and Sales orders.
You can specify an inventory profile on the BOM line. The inventory profile will be further specified in the following places:
The Inventory profile field on the BOM journal lines is filled in from one of two places:
The Inventory profile field on the BOM order lines is filled in from one of two places:
For more information, see the Set up a default inventory profile for BOMs section.
When you generate a cash flow forecast for purchase orders or sales orders, the inventory profiles that is specified on the order lines are considered when the posting accounts of inventory movements and customer and vendor transactions are determined. Ledger accounts for customer and vendor transactions are defined from the posting profiles that correspond to the inventory profiles that are specified on the order lines. For order lines where an inventory profile isn't specified, the Basic kind of activity and the posting profile that is specified in the order header are used.
For more information, see the Cash flow forecasts on purchase and sales orders section later in this article.
When you generate a cash flow forecast for planned sales and purchases, the inventory profiles that are specified on the supply forecast lines and in planned orders are considered.
Find more details in the following topics:
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn more