Sometimes it may happen that the actual stock in warehouse is more or less than the inventory on-hand entered in the system. In such cases, it is important to correct this discrepancy, by adjusting the inventory on-hand quantity with actual quantity. This function is done through Miscellaneous Entries (Receipt or Issues).
Prerequisites
- The users' role must have access to the Add app operation in the Miscellaneous Entries feature in Inventory - Operations - Requisitions through Roles in Ginesys Web - Admin - Security to Add entries.
- The users' role must have access to the Edit app operation in the Miscellaneous Entries feature in Inventory - Operations - Requisitions through Roles in Ginesys Web - Admin - Security to Edit entries.
- The users' role must have access to the Delete app operation in the Miscellaneous Entries feature in Inventory - Operations - Requisitions through Roles in Ginesys Web - Admin - Security to Delete entries.
- The users' role must have access to the Release app operation in the Miscellaneous Entries feature in Inventory - Operations - Requisitions through Roles in Ginesys Web - Admin - Security to Release / Post entries.
- The users' profile must have the Miscellaneous Entry Operation Mode marked as Issue, Receipt or Both (Issue and Receipt).
- The user must also have sites allocated to him.
- The Inventory Month must be open for the entry date.
- The Document Numbering Scheme must be created and tagged for Miscellaneous Entry.
- The Items must be created in the Item Master.
- The Item Groups must be defined.
- The Articles, if in use, must be defined.
- The Stock Points must be created in the Stock Point Master.
Step-by-step guide
Add Miscellaneous Entries
Follow the given steps to create Miscellaneous Entries -
- Go to Inventory > Operations > Requisitions > Miscellaneous Entries.
- Then click on Add. The Add Miscellaneous Entry window opens.
The connected site is auto-populated as the Owner Site and the System Date is populated as the Date.
Now the Misc. Entry No. (Document Numbering Scheme for Miscellaneous Entry) has to be selected from the drop-down.
- General Doc. No. is actually any reference document number the user may need to record. It is an optional field.
Miscellaneous issue is a way to adjust the physically lost items with their records in the system.
Cost Center records the location of the untraceable items. It is an optional field.
The Stock Point is a mandatory field and must be selected from the drop-down which displays only stock points assigned to the Owner Site.
The item display grid of the Issue tab, has four (4) options for item selection - Scan Item, Select Item, Import barcode and Requisition Entry.
- The item display grid of the Receive tab, has three (3) options for item selection - Scan Item, Select Item, and Import barcode.
- Once the items are populated, the Quantity has to be provided.
- The Rate is picked automatically by calculating the Last-in Rate -
Last-In Rate
Last-In Rate is the most recent purchase price for the item. At any point of time, whenever any of the following entries happens this will be captured in a separate table for each item and site. For same site and item, only one rate will be available at one point of time as each record updates the previous one.
The following entries allow to capture Last-In Rate of an item -
- Opening Stock
- Goods Receive
- Conversion - Bundle/Split/Production
- Production Receipts (PC)
- Miscellaneous Receipt
Any required Remarks must be put in the Others section.
- Related Documents (like GRC, Purchase Invoice, Sales Invoice or Transfer Orders etc.) may be attached to the Miscellaneous Entries. Users can attach any reference documents to the Miscellaneous Entries. Document Attachment is disabled for authorized Miscellaneous Entries.
- Then the Save button must be clicked.
Edit Miscellaneous Entry
A Miscellaneous Entry may be edited following the given rules -
- Owner Site cannot be edited.
- The document numbering scheme cannot be edited.
- A Miscellaneous Entry which has already been posted for Managed Site cannot be modified.
The Document Date may be edited -
- The stock point can be edited.
- All items can be edited.
Quantity of items can be altered, but a negative check has been implemented. The Negative Stock check alert is activated only when the stock in hand is less than the Issue Quantity. When stock-in-hand quantity is insufficient, the Negative Stock check alert will also be activated if the Receive Quantity of a Miscellaneous Entry is deleted or any modification of values of Receive Quantity or Issue Quantity, provided Issue Quantity - Receive Quantity > 0.
Application of Negative Stock Check
Negative Stock Check will be applied and based on what value is given for it in the Item definition / User Profile. Item definition for Negative Stock Check can be set to Profile, Warn, Ignore or Stop. User Profile for Negative Stock Check can be set to Warn, Ignore or Stop.
Setting | Effect |
Ignore | User will not know if stock goes to negative |
Warn | User will get a warning and may choose to ignore or cancel. |
Stop | User will not be able to proceed. |
To illustrate,
- Stock-in-hand – 10
- Issued quantity – 25
- Received quantity – 12
- Negative Stock check is set to Warn in both User Profile and Item Definition.
Scenario (Basic rule : Issue value - Receive value > 0) | Result | Action |
---|
The Current Stock (Stock-in-hand + Received quantity = 10 + 12 = 22) < the Issued Quantity (25) | User gets a warning about negative stock of the item. | User selects to ignore and saves the document. |
The Current Stock (Stock-in-hand + Received quantity = 10 + 10 = 20) < the Issued Quantity (25) {Received Quantity has been deleted} | Again the Negative stock check will be re-activated and user will receive warning. | User selects to ignore and saves the document. |
The Current Stock (Stock-in-hand + Received quantity = 10 + 12 = 22) < the Issued Quantity (27) {Issued Quantity has been increased} | Again the Negative stock check will be re-activated and user will receive warning. | User selects to ignore and saves the document. |
Delete Miscellaneous Entry
There are two ways a user may delete Miscellaneous Entries
- Individual Delete
Open the document to be deleted and then click on the Delete symbol.
- Collective Delete
From the list view, select one or more Miscellaneous Entry Documents and select Delete from the Action menu.
In both cases, the system will ask for confirmation as documents once deleted cannot be retrieved.
Release Miscellaneous Entry
There are two ways a user may Release or Post a Miscellaneous Entries
- Individual Release or Post
Open the document to be Released and then click on the Post symbol.
- Collective Release or Post
From the list view, select one or more Miscellaneous Entry Documents and select Release from the Action menu.
In both cases, the system will ask for confirmation as documents once released or posted cannot be modified.
To go back to the main page click on Managing Operation - Inventory in Ginesys Web
Related articles
-
Page:
-
Page:
-
Page:
-
Page:
-
Page: