Accoxi's Consolidated Stock Ledger: Unified record of stock transactions across branches.
A consolidated stock ledger report provides a unified record of stock transactions and movements across multiple branches or locations within an organization. This report amalgamates and organizes stock-related data, offering a comprehensive view of inventory activities. It typically includes details such as stock inflows, outflows, current stock levels, and transaction dates. The consolidated stock ledger report is valuable for monitoring stock movements, identifying trends, and ensuring accurate and up-to-date inventory information across the organization.
In Accoxi, the consolidated stock ledger report provides a detailed overview of inventory transactions, offering insights into the inflow and outflow of inventory across different branches. To access the report, navigate to the Head Office (HO) section under the report module.
MENU AVAILABLE IN CONSOLIDATED STOCK LEGER REPORT
|
Field |
Description |
|
Customize |
The user has the flexibility to tailor the report data by clicking on this button. Data filtration is possible based on the product and branch. |
|
Export to Excel |
By clicking this button, users can export the report to Excel. |
|
Export to PDF |
Clicking this button allows the user to export the report to PDF. |
|
|
This button enables users to print the consolidated stock ledger report. |
|
|
To send the report via email, simply click this button. The report in PDF format will be attached to the email, and you can input the recipient's email address, CC address, subject, and any additional details for the email. |
|
Pagination |
The pagination control offers the capability to navigate from one page to another. |
|
Exit |
Clicking the 'Exit' button allows the user to exit from the report. |
DATA AVAILABLE IN CONSOLIDATED STOCK LEDGER REPORT
|
Field |
Description |
|
# |
The symbol '#' represents the number of lines in the given context. |
|
Date |
The date of the transaction made with the selected product is displayed in this section |
|
Branch Name |
The branch name where the transaction occurred is displayed in this section |
|
Voucher Type |
The voucher type of the transaction is displayed in this section |
|
Voucher No |
The voucher number of the transaction is mentioned in this field |
|
Batch Code |
The batch code of the item is displayed in this field |
|
Particulars |
The particulars related to the transaction are displayed in this field. For instance, If the voucher type is sales, the particulars will be the customer name. If the voucher type is stock outward, it will be shown as "outward." |
|
UOM |
The Unit of Measurement (UOM) of the item is displayed in this field |
|
Qty |
The quantity of the item used in the transaction is mentioned in this field |
|
MRP |
The Maximum Retail Price (MRP) specified for the item in the transaction is displayed in this field of the consolidated stock ledger report. |
|
Rate |
The purchase rate of the selected batch in the transaction is displayed in this field |
|
Taxable Amount |
The taxable amount in the transaction is displayed in this column |
|
Tax |
The tax amount in the transaction is displayed in this column. |
|
Discount |
If there is any discount applied within the transaction, it will be displayed in this column |
|
Total |
The total of the transaction is showing here. |
|
FIFO Cost |
The value calculated using the FIFO cost method is displayed in this field |
|
Qty On Hand |
The stock in hand for the item is shown in this field |
|
Closing Value |
The closing value of the stock available in hand is displayed in this field |