Inventory movement

Posted By Trudy G. over 10 years ago

I'm using MAS 200. I'm looking for a simple way to check inventory movement, ie how many of a certain inventory item have we sold and/or issued in a period of time. I know that I can run inventory sales history reports and inventory issue history reports, but I don't find a way to choose a date "range" and have a total number. The report shows the inventory by period and doesn't give you a total. So right now, if I want to know how many widgets I used in the last 6 months, I have to print both reports, then add together the 6 periods in each report. Does anybody know of a better way to accomplish this?

Parents

brnicholas over 10 years ago

What I would do is select Data Only Export as my printer and then then export the report to Excel, select application rather then file for where it should go. The report will open in excel and you can use the sum functions to get the totals you want. You may need to play with the export options to get it formated so this is easy but I think it will work.

Nicholas
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

brnicholas over 10 years ago

What I would do is select Data Only Export as my printer and then then export the report to Excel, select application rather then file for where it should go. The report will open in excel and you can use the sum functions to get the totals you want. You may need to play with the export options to get it formated so this is easy but I think it will work.

Nicholas
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Trudy G. over 10 years ago in reply to brnicholas

Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 100

Inventory movement

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING