Jump to content


Photo

Stock Item Creation Date


  • Please log in to reply
4 replies to this topic

#1 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 03 August 2006 - 10:39 AM

Hello,

Does anyone know if mom stores the date that a stock item is first created? I looked in STOCK.DBF but no luck.

Best,

David
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#2 CDI Fulfillment

CDI Fulfillment

    Advanced Member

  • Members
  • PipPipPip
  • 43 posts

Posted 04 August 2006 - 07:40 AM

Dave - I don't think that MOM keeps a reocrd anywhere of when an item was created. The closest we can get is to see when stock was first added to inventory, so as long as you add stock in the day it was created you will have the date. That info is in the INVTRANS datadase.
Jay Snelgrove
Fulfillment Manager
CDI Media, Inc.

http://www.cdimedia.com

#3 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 11 August 2006 - 12:48 PM

Thanks CDI -

I appreciate the feedback.
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.

#4 planetdj

planetdj

    Advanced Member

  • Members
  • PipPipPip
  • 109 posts
  • Location:Reno, NV, USA

Posted 14 August 2006 - 10:20 PM

Though no creation date is "stamped" for a SKU, when opening the STOCK database in DBUWIN you will notice that it's default sort order is by creation. So... if you know anything about what dates certain items are being entered, you may be able to narrow it down.

CAUTION using DBUWIN if you never have. Your actions are permanent. (NO BACK BUTTON!)
Chris Whybrew
PLANET DJ, INC
www.planetdj.com

#5 Videoflicks2004

Videoflicks2004

    GLOBAL MODERATOR

  • Moderators
  • PipPipPip
  • 241 posts
  • Gender:Male
  • Location:Canada
  • Interests:~ DVD ~ BLUE RAY ~ HD DVD ~ HOLOGRAPHIC DVD ~ Quantum Computing.

Posted 17 August 2006 - 05:52 PM

Hey Planet DJ -

first things first -- you can change your avator by clicking on My Controls on the top left nav - then select

. Edit Avatar Settings

on the lower right nav.

---

Also -- You are right - - you can create an RR report that looks for the last Nth records -- I was just hoping to create something more reliable.
David Narciso
Ecommerce Operations Manager CVS Inc

dnarciso@cvsinc.ca

mobile: 4168238175

DISCLAIMER: Always backup your MOMWIN folder before attempting to perform any updates, testing, etc. Once you blast the data away it's gone forever.
My advice is based on my 8 years of experience with MOM and Dydacomp. If you are not comfortable with data manipulation then hire someone who is.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users