Physical Stock Verification
Branch* Warehouse*
Display Select
Scan Item/Bar Code þ Update Closing Value
Item Name Item Code Parent Location Stored Location Batch
Cup Ct002 RACK1 BIN102 B11
Cup Ct002 RACK2 BIN103 B12
Cup Ct002 RACK2 BIN105 B13
Box Ct005 RACK3 BIN109 B341
Select
+Add
Remarks
All Draft Pending Approval Approved Void
Listing
Number Date Warehouse Verification Date Action
Edit/View/Delete/Void
Notes
Branch List of Branch of the company, based on branch selection item list appear
Warehouse List of Warehouse associated with branch and based on warehouse selected, item list will be ap
Date Posting Date
Number Auto-series can be generated
Display Option to show item list - Item wise/Group Wise/Category wise
If 'All items' selected then load all the items as per the applicable batch/attribute/location etc.
If Item list is more than specified limit (Say, 200) option to download excel can be provided and
Select If Display - Group wise/Category Wise - show list of group/category
Verification as On Physical Verification Date. This date cannot be earlier than last verification Date
Lock Inventory TranOnce Verification is done, back dated entry shall not be allowed for that inventory.
Date* Number
Verification as On* Stock Adjustment ▾
Mfg Date Expiry Attribute1 Attribute2 Avail Qty Phyiscal Value
Stock
4/1/2023 4/30/2023 Red xl 8 3 Auto/Edit
4/1/2023 4/30/2023 Black l 3 4 Auto/Edit
4/1/2023 4/30/2023 Maroon xl 9 6 Auto/Edit
4/1/2023 4/30/2023 12 15 Auto/Edit
if Update Closing Value is On.
em list appear
rehouse selected, item list will be appear
cable batch/attribute/location etc.
ownload excel can be provided and user can download the same and upload it here.
ast verification Date
wed for that inventory.
Download Import
Physical Stock Adjustment
Difference Remarks/ Self Self Wastage/ Scrap Qty Scrap Item Scrap Value
Comment Consumption Consumption Abnormal
Value Loss Qty
5 2 =Self Consume 3 3 select =Scrap Qty * SP
Qty*Rate(as per
method)
-1
3 1 select
-3
Update Closing Value is On.
Save ▾ Cancel
Save as Draft
Save & Submit for Approval
Approve
Wastage/ Adjustment
Abnormal Account
Loss Value
=(Difference select
Qty)*Rate(as Account
per the
method)
x
x Difference Based on Physical Stock, Auto Adjustment entry will be post
x Negative In case of Auto- Adjustment, Decrease Value (Qty*Cost as pe
x In case of Manual
Self-Consumption Qty*Rate (As per Method) will be expense of, con
Wastage/Loss Decrease Value [(Qty*Cost as per Method) - Scrap
Scrap Item Increase Qty [Value as entered]
Positive Auto- Adjustment, increase value (Qty*Avg Rate/Cost)
Adjustment entry will be post for difference.
ecrease Value (Qty*Cost as per method)
ethod) will be expense of, consumption entry will be posted. Consumption Account(Selected)
y*Cost as per Method) - Scrap Value)] Purchase Account
ue (Qty*Avg Rate/Cost)
Debit
Credit
Item Name Item Code Stored Location Batch Mfg Date Expiry Attribute1 Attribute2
Cup Ct002 BIN102 B11 4/1/2023 4/30/2023 Red xl
Cup Ct002 BIN103 B12 4/1/2023 4/30/2023 Black l
Cup Ct002 BIN105 B13 4/1/2023 4/30/2023 Maroon xl
Box Ct005 BIN109 B341 4/1/2023 4/30/2023
Avail Qty Phyiscal Stock
8 7
3 4
9 8
12 15
Inventory Closing
Inventory Closing As on Date
Notes
IF this date is entered/updated, then user cannot perform any transaction on or before this date where inventory g
This setting/action need to be defined under the Global Setting (Currently, Financial Setting) and same is available u
efore this date where inventory got impacted. Means inventory cannot be change on or before this date.
al Setting) and same is available under the user management - Role Permission Mapping. Defaul - Admin can define this change/update thi
define this change/update this.
