• alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Topic: Help with a stock location report

I would like a stock location report,  I need help with the sql statement.  I just don't know enough to do it myself.

I have Repgen loaded and I can make simple reports, but...  I need a stock check report that shows the qty for that location, something like this:

stock_id | stock_master.description | qty. loc_code =10 | qty .loc_code =20 | qty. loc_code =30 |

five columns with each qty column to show data for that location.

if someone has a little time to help with an sql statement...

Thanks for your help!!!

AM

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.
  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Help with a stock location report

While this is a typical 'own' report, you can use the same technique as the reports on the download Reports page. You have probably 3 fixed locations and this make sense for you to have such a report.
Hopefully someone have the resource to help you.

/Joe

  • alvin
  • Senior Member
  • Offline
  • From: USA, Guatemala, Honduras
  • Registered: 05/20/2008
  • Posts: 301

Re: Help with a stock location report

Thanks Joe,

If there were any reports to download dealing with inventory management, I would already have them.

The day will come when more and more users need inventory management features.

AM

"The roots of education are bitter, but the fruit is sweet."  - Aristotle.