Yeah thought of that too. If you create a part from another part save as
new, it keeps the old parts priceupdate date. I think....
On 10/26/2011 12:29, Jean Pierre Guillou wrote:
Dear Jeff
There is a field in the parts table called 'priceupdate'.
When a part is created, the date is inserted in this field.
Not sure what other events trigger this field to be updated.
Regards
Jean-Pierre
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Jean-Pierre Guillou
Director
*DCDM Management Services Ltd*
Tel PABX : (230) 202 3000
Tel Direct : (230) 202 3057
Fax : (230) 208 0086
Web :www.dcdm-ms.com <http://www.dcdm-ms.com>
Business Registration Number : CC07051938
********************************************************************
Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message (or responsible
for delivering the message to the intended recipient), you should not
read it, nor copy or deliver this message to anyone. In such case, you
should destroy this message and kindly notify the sender by reply
E-mail. Opinions, conclusions and other information in this message
that do not relate to the official business of any member firm of the
DCDM Organisation shall be understood as neither given nor endorsed by
the firm.
On 26 October 2011 23:14, Jeff Kaminsky <[email protected]
<mailto:[email protected]>> wrote:
Is there any way in SQL to run a report to see what day a part
number was created? I need to review new parts created for
accuracy and I have not otherwise been informed by actual people
when that happens.
--
Jeff Kaminsky
Sr. Accountant / Logistics
IX Systems
408-943-4100 ext 122
408-943-4101 fax
_______________________________________________
SQL-Ledger mailing list
[email protected] <mailto:[email protected]>
http://lists.ledger123.com/mailman/listinfo/sql-ledger
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
--
Jeff Kaminsky
Sr. Accountant / Logistics
IX Systems
408-943-4100 ext 122
408-943-4101 fax
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
