Bookshelf Home | Contents | Index | Search | PDF

Siebel Life Sciences Guide > Managing Samples > End-User Procedures >

Reconciling an Inventory Period

---

At least once a year, end users are required to perform an inventory reconciliation to remain in PDMA compliance. Users might also need to perform an inventory reconciliation if they are receiving a promotion or leaving the company. For more information on reconciliation, see Inventory Reconciliation.

Prior to starting inventory reconciliation, users must perform the steps outlined in Figure 3.

Figure 3.  Inventory Reconciliation Prerequisites

These inventory reconciliation prerequisites must be performed in the following order:

Verify previous inventory periods are reconciled. End users must reconcile previous inventory periods in chronological order. This is only a concern if a company's configuration allows more than one inactive, unreconciled period. For more information, see About Establishing an Initial Inventory Count.
Acknowledge receipt of inventory transfers. End users must send acknowledgements for all received sample inventory shipments. For more information, see Acknowledging Receipt of a Samples Transfer.
Create transfer transactions for transferred samples. End users must create transfer transactions for any samples transferred to another representative or returned to the home office. For more information, see Creating a Samples Transfer.
Mobile users synchronize with server database. Mobile end users must synchronize their local database with the server database before submitting an inventory count. This is especially important if they are recording samples received in a prior period or to be received in a future period. For more information on synchronizing a local database, check with your Siebel administrator.

NOTE:  Counts for transferred and received samples are not reflected in the inventory count until their records have been submitted.

An inventory period cannot be reconciled if any discrepancy exists between the physical and electronic counts. If a discrepancy exists, it must be corrected before a user can reconcile the period. For more information, see the procedure To identify discrepancies in inventory counts.

The reconciliation process consists of the steps outlined in Figure 4.

Figure 4.   Inventory Reconciliation Process

These reconciliation steps must be performed in the following order:

Create and submit an inventory count. End users must create and submit an inventory count (either by product or lot number) of the products currently on-hand. For more information, see the procedure To create and submit an inventory count.

End users cannot submit a count differently from the way they submitted the previous period's count unless the previous period has been reconciled. For example, if they submitted the previous period's count by product name, they must reconcile that period before they can submit a subsequent count by lot number.

Correct physical and electronic count discrepancies. End users must correct any discrepancies between the physical counts and the electronic counts by:
Creating and submitting a sample adjustment transaction with one or more line items. For more information, see the procedure To adjust multiple quantities with a new adjustment transaction.

This method allows end users to adjust the inventory counts of multiple products with a single adjustment transaction (containing multiple line items). However, they may want to use this method if they need to adjust more than two or three counts.

Adjusting previous transactions. Adjusting line-item records of previously entered transactions. For more information, see the procedure To adjust a quantity in a samples transaction.

This method allows end users to adjust the quantity of a selected line item in a previously entered transaction. However, they may want to use this method if they only need to adjust one or two counts.

Reconcile the inventory period. For more information, see the procedure To reconcile an inventory period.

To create and submit an inventory count

Physically count all samples currently on-hand.
Navigate to the Samples screen.
From the Show drop-down list, select Inventory Count.

The Inventory Count list lists records for every product in your inventory.

NOTE:  Records in the Inventory Count view can be deleted only if the value of the On Hand Quantity field is zero. Do not delete records from this view unless you are certain that you will not need to enter adjustments to any transactions containing the product in the future or in a past unreconciled period.

In the Inventory Count list, enter a value in the Count field for all records.

The Difference field in some records may show a value other than zero.

Proceed in one of the following ways:

If the Difference field in any record shows a value other than zero, click Submit and follow the procedure To identify discrepancies in inventory counts.
If the Difference field in all records is equal to zero, click Submit and follow the procedure To reconcile an inventory period.

To identify discrepancies in inventory counts

Navigate to the Samples screen.
From the Show drop-down list, select Reconciliation.
In the Unreconciled Inventory Periods list, select the period that you want to reconcile.
In the Unreconciled Inventory List, scroll to determine how many product records show a value other than zero in the Difference field.

The number of discrepancies determines the adjustment method.

For every record in the Unreconciled Inventory List whose Difference field does not equal zero, write down the sample name, the lot number, and the value displayed in the Difference field.

A positive value in the Difference field means that your electronic count (the Stock Quantity field) is greater than your physical count (the Counted Quantity field). A negative value in the Difference field means that your electronic count (the Stock Quantity field) is less than your physical count (the Counted Quantity field).

Proceed in one of the following ways:

If only one or two records require adjustments, enter individual line-item adjustments for those transactions. In this case, write down the transaction numbers of the transactions you plan to adjust.

The Samples History list displays all transactions corresponding to the product selected in the Unreconciled Inventory List. You can find the transaction number in the Transaction # field of the Samples History list. Then proceed with the procedure To adjust a quantity in a samples transaction.

If more than two records require adjustments, enter a single adjustment transaction, with multiple line items, that adjusts all the quantities. Proceed to the following procedure, To adjust multiple quantities with a new adjustment transaction.

To adjust multiple quantities with a new adjustment transaction

Navigate to the Samples screen.
From the Show drop-down list, select My Samples Adjustments.
In the Samples Adjustments list, add a new record and complete the necessary fields.

Some of the fields in a Samples Adjustment record are described in the following table.

Field	Comments
Adjustment Reason	Follow your company's guidelines for what to select for this field.
Transaction #	The application automatically generates an unique identifier. You can change this value.
Transaction Date	The application automatically generates an unique identifier for this field.
Transaction Status	The value will be changed to Submitted when you submit the transaction.

In the Line Items list, add a new record and complete the necessary fields.

Some of the fields in a Line Items record are described in the following table.

Field	Comments
Expiration Date	Read-only. This field is automatically filled when you complete the Lot # field.
Item Status	The application changes value in this field changes to Submitted when you submit the transaction.
Item #	The number of this item in the transaction. Line numbers are automatically generated but can be edited. You might want to edit this value to have the items appear in a particular order (other than the order in which you entered them).
Lot Name	The lot number for this sample.
Quantity	The amount of the sample adjustment. The quantity you enter can be positive or negative, depending on the value you recorded in Step 5: If the value that you recorded was positive, enter a negative quantity. If the value that you recorded was negative, enter a positive quantity.
Sample	The product for which you want to enter a quantity adjustment.

Repeat Step 4 until you have entered a line item for each needed adjustment.

In the Samples Adjustments list, click Submit.

The values of the Transaction Status field (in the Samples Adjustments list) and the Item Status field (in the Line Items list) change to Submitted.

Reconcile the inventory period, as described in the following procedure.

To reconcile an inventory period

Navigate to the Samples screen.
From the Show drop-down list, select Reconciliation.
In the Unreconciled Inventory Periods list, select the inventory period that you want to reconcile.
Scroll through the records.
In the Unreconciled Inventory List, scroll through the records and verify that the value of the Difference field for each record is zero.
Click Reconcile.

The Samples Reconciliation view is cleared.

Bookshelf Home | Contents | Index | Search | PDF