Based on the Item Ledger Entries - How to know which is Fast moving and non moving items

(0) Share

Report

Posted on by MANJUNATH DHANAPAL

175

Based on the Item Ledger Entries - How to know which is Fast moving and non moving items

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

MahGah 15,529 on at

Like (0)

Report

You need to filter item ledger entry for activities that you want (purchase, sales, consumption, etc) for the date range you want to. Then take it to Excel and do some calculation to determine activities for each item during that time period and that can give you some idea.

Was this reply helpful? Yes No
MANJUNATH DHANAPAL 175 on at

Like (0)

Report

Can you please help me with an example ? I am unable to find it

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

I do my best but it is hard report.

Go to Item Ledger Entry and filter it based on your criteria. Then take it to Excel.

I Excel for each item you need to calculate a few things

1) Add to inventory (purchase / output) of the item during that period.

2) Left the inventory ( consumption/sales).

Then you can see how many of one item you brought in and how many left the inventory. then sort of determine the slow/fast moving. you can do it for $ or QTY.

I hope this help

Was this reply helpful? Yes No
Ashish0386 75 on at

Like (0)

Report

On item table there are field Purchase qty, Sales qty , Negative Adjt qty and Positive Adjmt qty you can use these with date filter to find non moving items

Was this reply helpful? Yes No
Suggested answer

MANJUNATH DHANAPAL 175 on at

Like (0)

Report

Thank you. This answered my question

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Also, you can go to Item List -> Report -> Inventory -> Item Turn Over and run this report. it should give you some good info.

Was this reply helpful? Yes No