offline inventory report

I would like to show offline stock and non-offline stock together on a report with the value. Is it possible to combine the two together? Ideally I would like live stock in one list and below that the offline stock, similar to the Item Value List.

Thanks

Richard

Reply to
RichyRich
Loading thread data ...

Reply to
Akber Alwani

Thanks, I would basically like to have the standard headquaters item value list but with the offline stock listed at the bottom. I would like it to be an expandable tab at the bottom just like the overall tab. I would need the same same data, category,departent,qty value etc.

Thanks

"Akber Alwani" wrote:

Reply to
RichyRich

HI Richy, Do you know how to customized the .grp (active report) of RMS HQ if so you can do it easily, however if you not know let me know If I have time I will do this for you. actually give you concept you will use the union query to join 2 different queries data into one row set. if you have idea of programming and SQL you can easily do this else I will be free on Saturday and may look at your issue. Regards

"RichyRich" wrote:

Reply to
Akber Alwani

Nope, don't know how to customise the grp, I have good knowledge with sql though. If you have the time, then please look in to the report...

Thanks in advance

"Akber Alwani" wrote:

Reply to
RichyRich

Reply to
RichyRich

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.