General
   >> Reports
Thread views: 30625 Previous threadView all threadsNext thread*Threaded Mode

Pages in this thread: 1 | 2 | (show all)
windquest
(stranger )
10/14/06 07:25 AM
Inventory total  

Hi

Which inventory report can I use to get the total value of my inventory and if it has to be modified how do I do that.

Thanks

Alex

bluepennylady
(addict)
10/14/06 08:14 AM
Re: Inventory total new [re: windquest]  


Alex,

Customize the Inventory list report. Use the selection fields"Item #'s x to x " Add the DBcal of ItemCost. Now the total does not appear in decimal value. It is an integer value. But it does give you a total value of the Qty in Stock x the Item cost.

See if that works for you.

Judy/blue



windquest
(newbie)
10/14/06 08:46 AM
Re: Inventory total new [re: bluepennylady]  

Judy

Worked like a charm.

Thanks

Alex

windquest
(newbie)
10/14/06 09:00 AM
Re: Inventory total new [re: bluepennylady]  

I spoke too soon. I got a total but it doesn't take into consideration the quantity." Use the selection fields "Item #'s x to x " . I don't totally understand that.

Thanks

Alex

bluepennylady
(addict)
10/14/06 09:29 AM
Re: Inventory total new [re: windquest]  

Alex,

I'm sorry I wasn't clear. Let me try again.

When the Customized Inventory List report window opens. on the right hand side are all the report filters. Try using Item 1 to 50 or whatever Inventory Item numbers you wish to pull a report for.

In order for a total to display, the Item cost field must contain a value. The DBCal you used is the qty in stock x the ItemCost.

You can also display the qty committed to an auction lot x the start price, if you want. Just add the DBCal of StartPrice. Or BuyPrice. Does that make better sense?

Judy/blue





windquest
(newbie)
10/14/06 09:51 AM
Re: Inventory total new [re: bluepennylady]  

Well I don't see any report filters on the right side, am I overlooking something?



Alex

bluepennylady
(addict)
10/14/06 09:58 AM
Re: Inventory total new [re: windquest]  

Alex,

humm, Perhaps I am not explaining what you need to do correctly. I will try again

When you go to Tools | Reports | Report Type>Inventory Reports. When you click on the Inventory Report the Inventory Report all the available Standard reports will display below. If you select Inventory list, then all the report filters become visible on the right hand side. It actually reads "Report Selection Options" intead of filters. But in reality it is a filter.

If you use Item x to Item x instead of all the other report options, if I understand what you are wanting, you will get the correct report.

Is that clearer?

Judy/blue



windquest
(newbie)
10/14/06 10:41 AM
Re: Inventory total new [re: bluepennylady]  


Hi
I wanted to use the inventory report "stock item qty" and at the end of the last page I wanted a grand total cost of all my inventory items . I guess any of the inventory reports would be ok for this.

Thanks

Alex

bluepennylady
(addict)
10/14/06 10:46 AM
Re: Inventory total new [re: windquest]  

Alex,

Yes that report will work. You might try the Inventory list report and add the DBCal for ItemCost. The you can select the records from the very first Inventory Item to the last. There are more Record selection options with that report than the Stock Item Qty report. That is why I suggested to try it.

Just a thought. But you are right as far as the reports.

Judy/blue



bluepennylady
(addict)
10/14/06 10:50 AM
Re: Inventory total new [re: windquest]  

Alex,

I will say the Stock Item Qty report requires less paper to print as it is a line item only report whereas the Inventory List displays lots of information.

And you can customize the Stock Item qty report to also total up the qty in stock x the start price as well as the qty in stock x ItemCost.

Judy/blue



windquest
(newbie)
10/14/06 10:59 AM
Re: Inventory total new [re: bluepennylady]  

Ok I used "Inventory list report" and used Total Value and that's exactly the results I wanted. These reports are cool.

Thanks

Alex

windquest
(newbie)
10/14/06 11:06 AM
Re: Inventory total new [re: bluepennylady]  

Yes That line item is why I was looking at it. I will play around with it some.

Thanks

Alex

bluepennylady
(addict)
10/14/06 11:07 AM
Re: Inventory total new [re: windquest]  

Alex,

I am so glad. That is great! I thought perhaps you might be happier with that report than the other one.

Happy reporting!!!!

Judy/blue



windquest
(newbie)
10/14/06 11:18 AM
Re: Inventory total new [re: bluepennylady]  

Well I went back and got the other one working also so now I can use the single line item or the expanded one depending.

Thanks

Alex

bluepennylady
(addict)
10/14/06 11:22 AM
Re: Inventory total new [re: windquest]  

Alex,

That's cool!

Judy/blue



bluepennylady
(addict)
10/14/06 02:19 PM
Re: Inventory total new [re: windquest]  

Alex,

The Inventory List report can be customized so it is more Line Item as you like. You just delete all the fields that you don't want. Then move theDBcal sum up closer to the "header" . Click on the little "Up" caret next to "Details" and drag the band upwards. Then that report will display more like the Stock Item Qty report with not as much information displaying.

Judy/blue




Pages in this thread: 1 | 2 | (show all)
Previous threadView all threadsNext thread*Threaded Mode
Jump to

www.AuctionWizard2000.com | Contact Us Forums powered by WWWThreads