Inventory Movement Analysis/Report

Question

I am looking for reporting that shows both purchases and sales with quantities and $ CR/DB. 
 Found reports do not show data on items with Current O/H of zero or do not show the desired detail. Working with LIFO inventory and would also like to be able to show this in action.

bottomline · Accepted Answer

You can use the Item Management Screen to see everything related to an items history. If you go to the Inventory & Services on the left and then you will see Inventory/Service Management. I typically choose the customize for clients and add relevant transaction tiles to the screen then you can modify the tiles columns as needed. I usually set this up for clients and then they can pick the item and get any information they would need and it is all drillable. Another very useful tool for what you are asking is under Lists Pulldown menu, Inventory & Services, Item Sales History by Customer. You can pick an item and see who all bought, when and how much plus can filter by any selected column. Take a look and if you need any other reporting tips just let me know. John@Bottomline-acctg.com

Sage 50 US

Inventory Movement Analysis/Report

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING