Duration (Pacific Standard Time):
To (Pacific Standard Time):
Impact:
User Action:
Microsoft Dynamics AX 2012

Best before as of date (form) [AX 2012]

Updated: February 5, 2014

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Click Inventory management > Inquiries > Batches > Best before as of date.

Use this form to view inventory batches with a best before date, which is the date before which the inventory batch is best used. Process manufacturing production and logistics calculates this date by subtracting the number of best before period in days for the product from the expiration date of the batch.

To have appropriate errors messages issued when attempts are made to reserve, pick, or ship inventory from batches that exceed their best before date, you can use the best before or expiration date selection with first in, first out (FIFO) date-controlled items.

The following tables provide descriptions for the controls in this form.

Tabs

Description

Overview

View a list of inventory batches that will expire on the best before date, or select an inventory batch to view additional information or perform related functions.

General

View general information, such as on-hand and physical quantities, about the selected inventory batch.

Button

Description

Transactions

Open the Inventory transactions form to view a list of inventory transactions for the inventory batch.

Functions

Open the Reset shelf life dates form to change any of the following dates for the inventory batch:

  • Manufacturing date

  • Shelf advice date

  • Best before date

  • Expiration date

Inquiries

Open a menu and select an option:

  • Non conformance ─ View details for a related non conformance record.

  • Quality order ─ View details for a related quality order record.

Reset batch disposition

Open the Reset batch disposition code form to change the disposition code and status for the inventory batch.

Dimensions display

Open the Dimensions display form to select the dimensions you want to display in the Best before as of date form. You can select Save setup to display these dimensions every time that you open the form.

Units

Open a menu and select an option:

  • Purchase unit – View details for a related purchase order.

  • Inventory unit – View details for a related inventory item.

  • Sales unit – View details for a related sales order.

Field

Description

As of

Select or enter a date to display all inventory batches with a best before date that is earlier than the as-of date you specify.

Item number

The identification for the item.

Batch number

The identification for the inventory batch.

Manufacturing date

The date on which the inventory batch was produced or entered into inventory.

Best before period in days

The number of days that were subtracted from the Expiration date of the inventory batch to calculate the Best before date. You specify the number of best before days the Item data field group on the Manage inventory FastTab in the Released product details form.

Best before date

The date before which a batch is best used. This date is calculated by subtracting the Best before period in days from the Expiration date of the inventory batch.

Physical inventory

The total on-hand physical quantity in the inventory batch.

Physical reserved

The total on-hand quantity of the item that was physically reserved for the inventory dimension.

Available physical

The available on-hand quantity of the item that is not reserved from the physical inventory.

Ordered in total

The total on-hand quantity of ordered items.

Ordered reserved

The total on-hand quantity of the item that is reserved on ordered receipts for the inventory dimension. Amounts appear in this field when you total all issue transactions with the status Ordered reserved. Because items that are reserved as ordered are not physically available in inventory, they cannot be directly picked and delivered from inventory.

Available for reservation

The total on-hand quantity that is available for reservation.

On order in total

The total on-hand quantity that is currently on order.

Total available

The total on-hand available quantity of the item.

Physical non-nettable

The physical quantity for a batch if the disposition code status is Unavailable and the Nettable flag for Master Planning is not selected. This non-nettable inventory cannot be allocated for planning purposes.

Physical expired

The physical expired quantity for a batch that has passed either the Best before date or Expiration date. This depends on which date is specified as Pick criteria on the Setup FastTab in the Item model groups form for the item. The Shelf life period in days for the item must be greater than zero.

  • If Best before date is specified, any batch for the item with a Best before date that occurs earlier than or on the current date (through midnight) is included in the physical expired total.

  • If Expiration date is specified, any batch with an expiration date that occurs earlier than the current date is included in the physical expired total. If the expiration date is not specified for the item, the batch is not considered to be expired. If the FEFO date-controlled setting is not configured for the shelf life item, the expiration date will be used as the default for determining the expiration status of the batch.

Adjusted total

The adjusted available quantity from the physical inventory. This quantity is calculated as follows: Total available (less) Physical non-nettable (less) Physical expired = Adjusted total.

Physical cost amount

The inventory value for the physically updated quantity.

Financial cost amount

The total inventory value of the financial updates for the item that was posted in the General ledger module.

Cost price

The average cost price for the item, which is calculated as follows: Total Financial cost amount / Total Posted quantity.

This price represents the value at which one unit of the item is picked from inventory the next time that the invoice is updated. You can choose to include physically updated quantities and values in the average cost price calculation by selecting Include physical value field on the Inventory model FastTab in the Item model groups form.If you also select the Fixed receipt price check box, the standard cost price is used.

Posted quantity

The quantity that was posted financially for the item.

Received

The physical quantity received, but not posted.

Deducted

The quantity deducted, which indicates that all order lines have been delivered to the customer.

Registered

The quantity that has been registered with the item reception.

Picked

The quantity that has been updated on the pick list to Picked status.

Arrived

The quantity of the item that arrived in item reception.

Ordered

The quantity of the item that was ordered.

On order

The quantity from the selected order line that has been ordered.

Quotation receipt

A sales quotation with a negative quantity has been sent to the customer for approval. The sales quotation is not yet a credit note.

Quotation issue

The sales quotation has been sent to the customer for approval. However, the sales quotation is not yet a sales order.

Dimension No.

The identification of dimensions for the item.

Closed

If selected, the inventory batch is closed. The batch is closed when it has no quantity or value.

Product name

The product name for the item.

Unit

The unit of measure for the item.

Configuration

The product dimension that describes the configuration of the item.

Size

The product dimension that describes the size of the item.

Color

The product dimension that describes the color of the item.

Site

The storage dimension that identifies the site for the warehouse where the item is maintained.

Warehouse

The storage dimension that identifies the warehouse where the item is maintained.

Batch number

The tracking dimension that identifies the unique batch number.

Location

The storage dimension that identifies the location in the warehouse where the item is maintained.

Pallet ID

The storage dimension that identifies the pallet to which the item is assigned.

Serial number

The tracking dimension that identifies the unique serial number assigned to the item.

Quality order status

The status of the quality order, if any, that is attached to the inventory batch. The status values are as follows: Open, Pass, and Fail.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).