New Inventory Ledger Reports (Summary and Detailed View)

New Inventory Ledger Reports (Summary and Detailed View)

The Inventory Ledger Report is a vital tool for efficiently managing your FBN inventory. It offers a detailed overview of stock movements and transactions within Noon fulfillment centers, allowing you to monitor your inventory effectively. The report comes in two distinct views—Summary and Detailed—giving sellers flexibility to access the information they need.

Key Highlights of the Inventory Ledger Report

  • The report tracks all stock movements, including inbounded stock, customer returns, disposals, and more.
  • Applicable only to items listed and sold on the Noon marketplace (excludes Noon subsidiaries like Sivvi, Noon Grocery, etc.).
  • Reports are available for download starting July 2022 through your specified end date.

How to download the Inventory Ledger Reports

You can download the Inventory Ledger Reports in either Summary or Detailed view by following one of these two methods:

Method 1: Using Custom Reports

  1. Navigate to Reports in the navigation bar and select Custom Reports.
  2. Click on the Generate Report button.
  3. From the drop-down, select the desired report type:
    • FBN Inventory Ledger Report - Detailed View
    • FBN Inventory Ledger Report - Summary View
  4. Choose the date range for which you want the report.
  5. Click on Generate Report.
  6. Once generated, click the Action button to either Download or View the report in Seller Lab.

Method 2: Using FBN Reports

Follow the steps outlined in the Accessing FBN Reports on Seller Lab guide to download the report from the FBN Reports section.

Tabulated explanation of the Detailed View.

The following table gives the description of each column you will find on the Inventory Ledger Report (Detailed View)

Column 

Definition 

country_code

The country code indicates the country in which the stock transactions happened.

Posted_date

The date of the transaction. 

transaction_type

Type of transaction impacting the inventory. 

warehouse_code

noon warehouse where the inventory transaction took place. 

title

Title of the product.

sku

noon system-generated SKU - Stock Keeping Unit - which is linked to each product listed by a partner.

barcode

Barcode used in noon warehouse to track the inventory.

barcode_box

The barcode of the box where the item is placed in case of quality check failure.

Pbarcode

The barcode created by the seller for the item.

psku 

The SKU generated by the partner. 

document_number

The document associated with a transaction impacting the inventory. 

reason

Reason for noon’s quality check rejection of inbounded stocks through ASN.

item_nr 

The unique reference number for the customer ordered unit. 

awb_nrs 

The shipment reference number/s of stocks returned to the partner.

quantity

Numerical value that represents the number of units impacted in the transaction

Tabulated explanation of the Summary View

The following table give the description of each column you will notice on the Inventory Ledger Report (Summary View)

Column 

Definition 

id_partner

A unique identifier (numerical value) to differentiate one partner from another. 

country_code

The country code indicating the country in which the stock transaction happened.

warehouse_code

noon warehouse where the inventory transaction happened. 

pbarcode

The barcode created by the seller for the item. 

opening_stock

The quantity of the stocks in a particular noon warehouse for a particular partner barcode at the report's start date.

in_transit

Stock pending update. 

inbound_received

The inventory received from partner in noon warehouse through an advanced shipping note (ASN).

customer_shipment

The inventory shipped to customers.

return_reinbound

The inventory returned  from customer/s that passed noon’s quality check and is put back into FBN stocks.

qc_fail_return

The inventory returned from customer/s that failed noon’s quality check.

vendor_return

The inventory returned to partners from noon warehouses. 

liquidation

The inventory liquidated due to defects.

dispose

The inventory disposed of upon the partner’s request/Expiry.

relabel

The stock quantity undergoing/resulting from the renaming/relabelling process at noon warehouses.

warehouse_transfer

The inventory transferred to or from the warehouse.

lost_and_found

Inventory lost or found in noon’s warehouses.

unknown_transactions

The inventory impacted by unknown or in searching transactions.

closing_stock

The total quantity of available stocks at noon warehouse on the report’s end date.

 FAQs

Question: What happens to lost inventory?

Answer: Lost inventory gets compensated through noon’s Automated Reimbursement Process for Lost & Damaged Items

 

 

That’s it!

Got questions?

Contact us at seller@noon.com

 

 



    • Related Articles

    • Reports & Analytics Comprehensive Overview

      Understanding Your Sales About the Sales View: Start here to get a grasp of your sales overview. This article introduces you to the sales dashboard where you can access comprehensive sales views, filter sales data by item status, and get consolidated ...

    • Accessing FBN Reports on Seller Lab

      The FBN Reports in Seller Lab provide a centralized and streamlined solution for tracking and analyzing your Fulfilled by Noon (FBN) inventory. These reports cover everything from stock levels to returns and inbound processes, enabling better ...

    • Inventory Removal Comprehensive Overview

      Optimizing Inventory Management and Enhancing Dispute Resolution on Noon This guide helps Noon sellers with managing their inventory removal, learning about Return to Vendor (RTV) processes, and handling disputes easily. It covers Noon's rules and ...

    • New Statement Detail Report

      The Statement Detail Report provides a concise overview of fees and payments in a statement generated by you. It offers a detailed breakdown of fees at both the item-level and shipment/AWB level. Note: The Statement Detailed Report is only applicable ...

    • Inventory Removal Policy

      What Is Inventory Removal? Inventory removal refers to the process of removing a seller's saleable and non-saleable inventory stored in noon’s warehouses. Types Of Inventory: At noon, we have 2 different types of types of inventory. The following ...