Creating a report for stock, purchasing and sales information

Question

Hi all, 
 I have been asked by my boss if I can create a report that shows the following information:

Stock Item 
 Description 
 On shelf quantity 
 On purchase orders qty 
 On sales orders qty 
 Allocated

Basically he want me to create a "simple" supply and demand report, but I am really not sure how to link the Stock, POP and SOP tables together. 
 I don't know if it can be done in a simple report of if i just need to create 3 different ones and squish them together manually. 
 Not sure if this is possible using SQL, he will just need it all exported to a spreadsheet, so a Sage report doesn't need to look pretty. 
 Help?

Keith Carver · Answer

Hi Derrick 
 If you're after a report to be created using the report designer application within the program then our Sage 200 Report Design service may be a solution. 
 Follow the process here to book an appointment so time can be allocated with a Sage 200 Reporting colleague. 
 Regards, Keith 
 Sage 200 Report Design Team

Sage 200 UKI

Creating a report for stock, purchasing and sales information

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING