FrontAccounting forum — Help with a stock location report

Re: Help with a stock location report

2010-05-16T21:41:04Z

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.

Re: Help with a stock location report

2010-05-16T20:42:18Z

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

Help with a stock location report

2010-05-16T03:58:45Z

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:

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!!!