This Inventory Transaction Ledger report file is used to analyze your inventory movements to and from all warehouses, including products that are sold, returned, removed, disposed of, damaged, lost, and found on a particular date. You can view all historical movements of your inventory for a maximum 92 days of interval backwards.
Note: This is different from the inventory ledger report that contains the Inventory on the opening and closing of the day.
Applicability
Version: Enterprise only Traceability: None, SKU
Procedure
Export Type Selection
Navigate to the following path:
UI Navigation: Dashboard > Other Reports>{Select the report named: “Transaction Ledger”}
Report Columns Selection
Select the columns headers as per the need, here we use “ALL” (checkbox) that will select all column headers and give full reports. For selected columns, you can choose one by one.
|
Entity |
Entity Type |
From_facility |
To_facility |
Transaction |
Inventory_Adjusted_At |
|
GRN |
PUTAWAY_GRN_ITEM |
|
Yes |
IN |
Putaway_Closed |
|
INBOUND_GATEPASS |
STOCK_TRANSFER |
|
Yes |
IN |
Putaway_Closed |
|
RETURNABLE |
|
Yes |
IN |
Putaway_Closed |
|
|
PUTAWAY_RTO |
PUTAWAY_RECEIVED_RETURNS |
|
Yes |
IN |
Putaway_Closed |
|
PUTAWAY_CIR |
PUTAWAY_RECEIVED_RETURNS |
|
Yes |
IN |
Putaway_Closed |
|
PUTAWAY_CANCELLED_ITEM |
PUTAWAY_CANCELLED_ITEM |
|
Yes |
IN |
Putaway_Closed |
|
PARTIAL_PUTAWAYS |
|
|
Yes |
IN |
Putaway_Item Complete & Putaway Open |
|
INVENTORY_ADJUSTMENT |
ADD |
|
Yes |
IN |
Inventory_Adjustment.created |
|
REPLACE (-ve/+ve values present) |
|
Yes |
IN |
Inventory_Adjustment.created |
|
|
REMOVE (-ve values present) |
|
Yes |
IN |
Inventory_Adjustment.created |
|
|
OUTBOUND_GATEPASS |
STOCK_TRANSFER |
Yes |
|
OUT |
Outbound_gatepass_item.created |
|
RETURNABLE |
Yes |
|
OUT |
Outbound_gatepass_item.created |
|
|
BARCODED_UNINVOICED_SOI |
SOI |
Yes |
|
OUT |
Barcode present but not Invoiced |
|
INVOICES |
SALE INVOICE |
Yes |
|
OUT |
Invoice.created |
Filters Selection
Select and control the data in report file as per the selected report. The description is provided below:
| Field Name (M: Mandatory) | Description/Notes |
| Added In Date Range (M) | DD/MM/YYYY, to extract the data basis on inventory creation in uniware . |
Email Confirmation
Select this field to send the report file to any selected user mail id (from added User in system). Click on “Create Export” to generate the selected report.
Result & Errors
If report is generated successfully, system gives a message. In case of incorrect selection, the export will not generate and show error. In such case, update the checkboxes and values in the appropriate fields and re-export the file.
Click on the “View Export” icon, to check the Export status.
In case of incorrect data, in the export file, update the checkboxes and value in the appropriate fields and re-export the file.