Jump to content


Photo

Trying to R&R


  • Please log in to reply
7 replies to this topic

#1 anythinggi

anythinggi

    Member

  • Members
  • PipPip
  • 15 posts

Posted 06 April 2005 - 06:25 AM

Hello,

I need to see if anyone knows of a field that contains the item entry date. I'm trying to do a report where lets say I want to see only items created since March 1st. I just cant seem to find the field that contains the item entry date.

The only other option would to see if we could get foxpro to write a timestamp.

Any one know of a item entry date field in MOM?



Michael

#2 dseibold

dseibold

    Advanced Member

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

Posted 11 April 2005 - 07:49 AM

What specifically are you trying to identify? Orders since March 1st or items sold since March 1st?
If you want a list of items, go to the items table and look at the it_sdate field for the date the item was shipped. Since we try to ship the same day we receive the order, this usually works.

There is no specific item entry date that I am aware of for each individual item. Give me a little more info and I might be able to help you with a work around.

David
David Seibold
Wild Horses, Inc.
Operations Manager

#3 anythinggi

anythinggi

    Member

  • Members
  • PipPip
  • 15 posts

Posted 12 April 2005 - 06:47 PM

David,

These would be items that have never been shipped or put on order before. As an example, we make new stock items (let's say 200-300 of them within a given month) with all different information (different items, different suppliers etc). We'd like to be able to identify those items because we'll be sending them out of state to a photographer (not within our company).

The only other option we could think of was to manually mark a field within the stock # & do a report based on the items that were particularly flagged (like putting an "X" in ISBN/Alternate ID (which we don't use for our items) --- that seems to be the ONLY solution that we have come up with (other than trying to get foxpro to write a timestamp).

Also, those items are not showing physical in MOM - they are on memo & never even get received which is even more reason to need the report (to see what items they are).

Sorry if I'm rambling.



Michael

#4 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 12 April 2005 - 08:01 PM

Hello,

I need to see if anyone knows of a field that contains the item entry date. I'm trying to do a report where lets say I want to see only items created since March 1st. I just cant seem to find the field that contains the item entry date.

The only other option would to see if we could get foxpro to write a timestamp.

Any one know of a item entry date field in MOM?
Michael

View Post



in the cms dbf you have 2 x the order entry date "ord_date" , "entrytime"
the entrytime field will also have a time stamp
then you should link it to items dbf , the order # is the prim. key


hope this helps
joe

#5 dseibold

dseibold

    Advanced Member

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

Posted 13 April 2005 - 07:48 AM

Michael,

That looks like a great solution. The ISBN field in the stock table allows up to 15 characters which will give you lots of room to enter dates or other codes to search for.

Good luck and let us know if you come across any problems.
David Seibold
Wild Horses, Inc.
Operations Manager

#6 dseibold

dseibold

    Advanced Member

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

Posted 13 April 2005 - 07:53 AM

in the cms dbf  you have 2 x the order entry date "ord_date" , "entrytime"
the entrytime field will also have a time stamp
then  you should link it to items dbf  , the order # is the prim. key
hope this helps
joe

View Post


Joe,
The cms.dbf only works if an order has been generated. In this situation, the items are new, no orders have been generated and no stock is available.

But thanks for mentioning this, I was not aware of this feature. It may come in handy some day.
David Seibold
Wild Horses, Inc.
Operations Manager

#7 ypf1258

ypf1258

    Advanced Member

  • Moderators
  • PipPipPip
  • 101 posts
  • Gender:Male
  • Location:ny

Posted 13 April 2005 - 04:13 PM

Joe,
The cms.dbf only works if an order has been generated. In this situation, the items are new, no orders have been generated and no stock is available.

But thanks for mentioning this, I was not aware of this feature. It may come in handy some day.

View Post

what do you mean by saying "no orders has been generated" it might not be saved but it should show up in the "entrytime " field

#8 dseibold

dseibold

    Advanced Member

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

Posted 14 April 2005 - 07:44 AM

what do you mean by saying "no orders has been generated" it might not be saved but it should show up in the "entrytime "  field

View Post


Michael said,

"These would be items that have never been shipped or put on order before. As an example, we make new stock items (let's say 200-300 of them within a given month) with all different information (different items, different suppliers etc). We'd like to be able to identify those items because we'll be sending them out of state to a photographer (not within our company)."

According to this, NO ORDERS HAVE BEEN GENERATED. The item was entered as a stock item in the stock.dbf. If he looks at the entrytime field in cms.dbf before an order is generated, he won't find anything.

Hope this helps.

David
David Seibold
Wild Horses, Inc.
Operations Manager




1 user(s) are reading this topic

0 members, 1 guests, 0 anonymous users