FrontAccounting forum — Help with a stock location report

Re: Help with a stock location report

null@example.com (alvin) — Sun, 16 May 2010 21:41:04 +0000

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

null@example.com (joe) — Sun, 16 May 2010 20:42:18 +0000

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

null@example.com (alvin) — Sun, 16 May 2010 03:58:45 +0000

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