Prev: Nested Transactions error
Next: Nav Add-On or 3rd Party Solution for Mail/catalog Order Business
From: Tim on 24 Apr 2007 09:56
Thanks Savatage - that is a very useful report although it doesn't age the
existing inventory.

"Savatage" wrote:

> have you looked at report #10146 Item Turnover
>
> "Tim" wrote:
>
> > Is anyone aware of a standard report or other means by which we could
> > determine the age of inventory? We are incentivized to move inventory off
> > our manufacturing floor if it is over 30 days old regardless of the type
> > (finished goods, WIP, raw materials, etc.).
> >
> > Thank you
From: Tim on 24 Apr 2007 10:02
Thanks Manish - both are good reports are great and the 5807 appears to
provide what I'm looking for. I just wish there was a way to quickly export
to Excel!

"Manish Sharma" wrote:

> Try Report ID 5807 for Item Age Composition - Qty. &
> 5808 for Item Age Composition - Value
> Try giving filters as per requirement.
> "Tim" wrote:
>
> > Is anyone aware of a standard report or other means by which we could
> > determine the age of inventory? We are incentivized to move inventory off
> > our manufacturing floor if it is over 30 days old regardless of the type
> > (finished goods, WIP, raw materials, etc.).
> >
> > Thank you
From: Manish Sharma on 11 May 2007 03:29
Yes there is
Each and every report can be opened in excel.
When you Preview the report on the screen,go to file & save the report as
HTML on any location, after that open the same saved HTML report in or with
Excel,and that's it.
But you will have to do some work in excel of formating,there is on problem
in the HTML report if opened in excel the last page need much formating.
Try for this.
Reply me

"Tim" wrote:

> Thanks Manish - both are good reports are great and the 5807 appears to
> provide what I'm looking for. I just wish there was a way to quickly export
> to Excel!
>
> "Manish Sharma" wrote:
>
> > Try Report ID 5807 for Item Age Composition - Qty. &
> > 5808 for Item Age Composition - Value
> > Try giving filters as per requirement.
> > "Tim" wrote:
> >
> > > Is anyone aware of a standard report or other means by which we could
> > > determine the age of inventory? We are incentivized to move inventory off
> > > our manufacturing floor if it is over 30 days old regardless of the type
> > > (finished goods, WIP, raw materials, etc.).
> > >
> > > Thank you
From: Tim on 11 May 2007 15:52
Thanks Manish...

Yes - this is useful - formatting in Excel is a pain sometimes but it is the
end all result to this problem!

Tim

"Manish Sharma" wrote:

> Yes there is
> Each and every report can be opened in excel.
> When you Preview the report on the screen,go to file & save the report as
> HTML on any location, after that open the same saved HTML report in or with
> Excel,and that's it.
> But you will have to do some work in excel of formating,there is on problem
> in the HTML report if opened in excel the last page need much formating.
> Try for this.
> Reply me
>
> "Tim" wrote:
>
> > Thanks Manish - both are good reports are great and the 5807 appears to
> > provide what I'm looking for. I just wish there was a way to quickly export
> > to Excel!
> >
> > "Manish Sharma" wrote:
> >
> > > Try Report ID 5807 for Item Age Composition - Qty. &
> > > 5808 for Item Age Composition - Value
> > > Try giving filters as per requirement.
> > > "Tim" wrote:
> > >
> > > > Is anyone aware of a standard report or other means by which we could
> > > > determine the age of inventory? We are incentivized to move inventory off
> > > > our manufacturing floor if it is over 30 days old regardless of the type
> > > > (finished goods, WIP, raw materials, etc.).
> > > >
> > > > Thank you
From: Manish Sharma on 14 May 2007 06:18
You are Welcome.

"Tim" wrote:

> Thanks Manish...
>
> Yes - this is useful - formatting in Excel is a pain sometimes but it is the
> end all result to this problem!
>
> Tim
>
> "Manish Sharma" wrote:
>
> > Yes there is
> > Each and every report can be opened in excel.
> > When you Preview the report on the screen,go to file & save the report as
> > HTML on any location, after that open the same saved HTML report in or with
> > Excel,and that's it.
> > But you will have to do some work in excel of formating,there is on problem
> > in the HTML report if opened in excel the last page need much formating.
> > Try for this.
> > Reply me
> >
> > "Tim" wrote:
> >
> > > Thanks Manish - both are good reports are great and the 5807 appears to
> > > provide what I'm looking for. I just wish there was a way to quickly export
> > > to Excel!
> > >
> > > "Manish Sharma" wrote:
> > >
> > > > Try Report ID 5807 for Item Age Composition - Qty. &
> > > > 5808 for Item Age Composition - Value
> > > > Try giving filters as per requirement.
> > > > "Tim" wrote:
> > > >
> > > > > Is anyone aware of a standard report or other means by which we could
> > > > > determine the age of inventory? We are incentivized to move inventory off
> > > > > our manufacturing floor if it is over 30 days old regardless of the type
> > > > > (finished goods, WIP, raw materials, etc.).
> > > > >
> > > > > Thank you
 | 
Pages: 1
Prev: Nested Transactions error
Next: Nav Add-On or 3rd Party Solution for Mail/catalog Order Business