Jump to content


Photo

new report


  • Please log in to reply
1 reply to this topic

#1 Flower_Farm

Flower_Farm

    Member

  • Members
  • PipPip
  • 11 posts

Posted 07 January 2008 - 05:38 AM

Hey everyone

Is it possible to create a report somehow that shows everything we have sold within a period of time?

any information would be great

Thanks

FF

#2 dseibold

dseibold

    Advanced Member

  • Moderators
  • PipPipPip
  • 137 posts
  • Gender:Male
  • Location:Stockton, CA

Posted 07 January 2008 - 09:34 AM

Hey everyone

Is it possible to create a report somehow that shows everything we have sold within a period of time?

any information would be great

Thanks

FF


Yes, it's possible. If you have MOM 5 you can use R&R or MS Access. If you have MOM 6 you are more limited.

An easy report is to list the items that shipped during a set time period.
Do a query of items.dbf and sort by the it_sdate field for the time period desired. You can have it calculate total quantities based on the item field.

If you want a report that lists all items sold, link cms.dbf to items.dbf. Sort by the odr_date field for the time period desired to select the orders created during that time period. Then list or calculate the items for those orders in the items.dbf.

Good luck!
David Seibold
Wild Horses, Inc.
Operations Manager




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users