{"id":8767,"date":"2023-03-01T08:30:26","date_gmt":"2023-03-01T03:00:26","guid":{"rendered":"https:\/\/support.unicommerce.com\/?post_type=ht_kb&p=8767"},"modified":"2023-03-01T08:30:26","modified_gmt":"2023-03-01T03:00:26","slug":"export-report-transaction-ledger","status":"publish","type":"ht_kb","link":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/","title":{"rendered":"Export Report: Transaction Ledger"},"content":{"rendered":"

This Inventory Transaction Ledger<\/strong> 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.<\/p>\n

\n
<\/div>\n
\n

Note: This is different from the inventory ledger report that contains the Inventory on the opening and closing of the day.<\/p>\n<\/div>\n<\/div>\n

Applicability<\/strong><\/span><\/p>\n

Version:<\/strong> Enterprise only\u00a0 Traceability<\/strong>: None, SKU<\/p>\n

\n
\n

Procedure<\/strong><\/span><\/p>\n<\/div>\n<\/div>\n

Export Type Selection<\/p>\n

Navigate to the following path:<\/p>\n

\n
\n

UI Navigation<\/strong>: Dashboard > Other Reports>{Select the report named: \u201cTransaction Ledger<\/strong>\u201d}<\/p>\n<\/div>\n<\/div>\n

Report Columns Selection
\n<\/strong>Select the columns headers as per the need, here we use \u201cALL<\/strong>\u201d (checkbox) that will select all column headers and give full reports. For selected columns,<\/strong> you can choose one by one.<\/p>\n

\n
\n
\"\"<\/div>\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

Entity<\/strong><\/p>\n<\/td>\n

\n

Entity Type<\/strong><\/p>\n<\/td>\n

\n

From_facility<\/strong><\/p>\n<\/td>\n

\n

To_facility<\/strong><\/p>\n<\/td>\n

\n

Transaction<\/strong><\/p>\n<\/td>\n

\n

Inventory_Adjusted_At<\/strong><\/p>\n<\/td>\n<\/tr>\n

\n

GRN<\/p>\n<\/td>\n

\n

PUTAWAY_GRN_ITEM<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Closed<\/p>\n<\/td>\n<\/tr>\n

\n

INBOUND_GATEPASS<\/p>\n<\/td>\n

\n

STOCK_TRANSFER<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Closed<\/p>\n<\/td>\n<\/tr>\n

\n

RETURNABLE<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Closed<\/p>\n<\/td>\n<\/tr>\n

\n

PUTAWAY_RTO<\/p>\n<\/td>\n

\n

PUTAWAY_RECEIVED_RETURNS<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Closed<\/p>\n<\/td>\n<\/tr>\n

\n

PUTAWAY_CIR<\/p>\n<\/td>\n

\n

PUTAWAY_RECEIVED_RETURNS<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Closed<\/p>\n<\/td>\n<\/tr>\n

\n

PUTAWAY_CANCELLED_ITEM<\/p>\n<\/td>\n

\n

PUTAWAY_CANCELLED_ITEM<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Closed<\/p>\n<\/td>\n<\/tr>\n

\n

PARTIAL_PUTAWAYS<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Putaway_Item Complete & Putaway Open<\/p>\n<\/td>\n<\/tr>\n

\n

INVENTORY_ADJUSTMENT<\/p>\n<\/td>\n

\n

ADD<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Inventory_Adjustment.created<\/p>\n<\/td>\n<\/tr>\n

\n

REPLACE (-ve\/+ve values present)<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Inventory_Adjustment.created<\/p>\n<\/td>\n<\/tr>\n

\n

REMOVE (-ve values present)<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

IN<\/p>\n<\/td>\n

\n

Inventory_Adjustment.created<\/p>\n<\/td>\n<\/tr>\n

\n

OUTBOUND_GATEPASS<\/p>\n<\/td>\n

\n

STOCK_TRANSFER<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

OUT<\/p>\n<\/td>\n

\n

Outbound_gatepass_item.created<\/p>\n<\/td>\n<\/tr>\n

\n

RETURNABLE<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

OUT<\/p>\n<\/td>\n

\n

Outbound_gatepass_item.created<\/p>\n<\/td>\n<\/tr>\n

\n

BARCODED_UNINVOICED_SOI<\/p>\n<\/td>\n

\n

SOI<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

OUT<\/p>\n<\/td>\n

\n

Barcode present but not Invoiced<\/p>\n<\/td>\n<\/tr>\n

\n

INVOICES<\/p>\n<\/td>\n

\n

SALE INVOICE<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n

\n

\n<\/td>\n

\n

OUT<\/p>\n<\/td>\n

\n

Invoice.created<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n<\/div>\n<\/div>\n

Filters Selection
\n<\/strong>Select and control the data in report file as per the selected report. The description is provided below:<\/p>\n

\"\"<\/p>\n\n\n\n\n
Field Name (M: Mandatory)<\/strong><\/td>\nDescription\/Notes<\/strong><\/td>\n<\/tr>\n
Added In Date Range (M)<\/strong><\/td>\nDD\/MM\/YYYY, to extract the data basis on inventory creation in uniware .<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n
\n
<\/div>\n
<\/div>\n<\/div>\n<\/div>\n

Email Confirmation
\n<\/strong>Select this field to send the report file to any selected user mail id (from added User in system<\/strong>). Click on \u201cCreate Export<\/strong>\u201d to generate the selected report.\"\"<\/p>\n

Result & Errors
\n<\/strong>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.\"\"<\/p>\n

Click on the \u201cView Export<\/strong>\u201d icon, to check the Export status.\"\"<\/p>\n

In case of incorrect data, in the export file, update the checkboxes and value in the appropriate fields and re-export the file.<\/p>\n","protected":false},"excerpt":{"rendered":"

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…<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_eb_attr":""},"ht-kb-category":[17],"ht-kb-tag":[],"yoast_head":"\nExport Report: Transaction Ledger - Unicommerce Support Portal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export Report: Transaction Ledger - Unicommerce Support Portal\" \/>\n<meta property=\"og:description\" content=\"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...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/\" \/>\n<meta property=\"og:site_name\" content=\"Unicommerce Support Portal\" \/>\n<meta property=\"og:image\" content=\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/\",\"url\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/\",\"name\":\"Export Report: Transaction Ledger - Unicommerce Support Portal\",\"isPartOf\":{\"@id\":\"https:\/\/support.unicommerce.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png\",\"datePublished\":\"2023-03-01T03:00:26+00:00\",\"dateModified\":\"2023-03-01T03:00:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#primaryimage\",\"url\":\"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png\",\"contentUrl\":\"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png\",\"width\":1249,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.unicommerce.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Export Report: Transaction Ledger\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/support.unicommerce.com\/#website\",\"url\":\"https:\/\/support.unicommerce.com\/\",\"name\":\"Unicommerce Support Portal\",\"description\":\"Know more about Uniware\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/support.unicommerce.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Export Report: Transaction Ledger - Unicommerce Support Portal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/","og_locale":"en_US","og_type":"article","og_title":"Export Report: Transaction Ledger - Unicommerce Support Portal","og_description":"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...","og_url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/","og_site_name":"Unicommerce Support Portal","og_image":[{"url":"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/","url":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/","name":"Export Report: Transaction Ledger - Unicommerce Support Portal","isPartOf":{"@id":"https:\/\/support.unicommerce.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#primaryimage"},"image":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#primaryimage"},"thumbnailUrl":"http:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png","datePublished":"2023-03-01T03:00:26+00:00","dateModified":"2023-03-01T03:00:26+00:00","breadcrumb":{"@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#primaryimage","url":"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png","contentUrl":"https:\/\/support.unicommerce.com\/wp-content\/uploads\/2023\/03\/TL_010323_1.png","width":1249,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/export-report-transaction-ledger\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.unicommerce.com\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/support.unicommerce.com\/index.php\/knowledge-base\/"},{"@type":"ListItem","position":3,"name":"Export Report: Transaction Ledger"}]},{"@type":"WebSite","@id":"https:\/\/support.unicommerce.com\/#website","url":"https:\/\/support.unicommerce.com\/","name":"Unicommerce Support Portal","description":"Know more about Uniware","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/support.unicommerce.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/8767"}],"collection":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/comments?post=8767"}],"version-history":[{"count":1,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/8767\/revisions"}],"predecessor-version":[{"id":8774,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/8767\/revisions\/8774"}],"wp:attachment":[{"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/media?parent=8767"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=8767"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.unicommerce.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=8767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}