7 replies to this topic

[anythinggi]

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

[dseibold]

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

[anythinggi]

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

[ypf1258]

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

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

[dseibold]

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.

[dseibold]

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

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.

[ypf1258]

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.

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

[dseibold]

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

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