Guest
Guest
All of our Blanket Orders have been canceled. Is there any way to determine who did this and how?
Thanks for any suggestions,
Mike
OW XE
Thanks for any suggestions,
Mike
OW XE
Jorge_Cabrera
Member
Go to the F4211 and F4311 (with SQL or UTB) and look for the SDUSER =
(PDUSER)
field. You can also use the SDPID (PDPID) and SDJOBN (PDJOBN) to see =
what
program and in what workstation the last update to every record was =
made.
Also, if you have the ledger option activated for both purchase order =
and
sales order document types/line type combination (see order activity =
rules,
field Ledger Y/N) , you can audit the history of changes of an ordeer
detail. You can find a row exit in the P4310 and P4210 that wll take =
you to
the ledger. Just make sure you are inquiring on the detail revisions =
form,
not the header revisions. Use menu G43a112 for purchase order - the =
Open
Order option. Use option Sales Order Detail on menu g4211 for Sales =
orders.
Regards,
Jorge Cabrera
The Premier Group =20
(PDUSER)
field. You can also use the SDPID (PDPID) and SDJOBN (PDJOBN) to see =
what
program and in what workstation the last update to every record was =
made.
Also, if you have the ledger option activated for both purchase order =
and
sales order document types/line type combination (see order activity =
rules,
field Ledger Y/N) , you can audit the history of changes of an ordeer
detail. You can find a row exit in the P4310 and P4210 that wll take =
you to
the ledger. Just make sure you are inquiring on the detail revisions =
form,
not the header revisions. Use menu G43a112 for purchase order - the =
Open
Order option. Use option Sales Order Detail on menu g4211 for Sales =
orders.
Regards,
Jorge Cabrera
The Premier Group =20
david_mallory
Well Known Member
Mike,
Look in table F4301 (PO header) and F4311 (PO detail) at field USER which is
last person to change the record. See field DOCO for the order number. Field
PID is the program that changed the record. Field JOBN is the computer that
was used to make the change. UPMJ is the date of the change and TDAY is the
time. TORG is the transaction originator, not to be confused with USER. (Add
prefix PH for F4301 and prefix PD for F4311 to above field aliases.) We have
used this feature.
Dave Mallory Denver Water
Look in table F4301 (PO header) and F4311 (PO detail) at field USER which is
last person to change the record. See field DOCO for the order number. Field
PID is the program that changed the record. Field JOBN is the computer that
was used to make the change. UPMJ is the date of the change and TDAY is the
time. TORG is the transaction originator, not to be confused with USER. (Add
prefix PH for F4301 and prefix PD for F4311 to above field aliases.) We have
used this feature.
Dave Mallory Denver Water
Mike Dupaix
VIP Member
Mike,
Were the quantities completely consumed? If so, the
lines automatically cancel. You can check the program
ID, user, date and time stamp using a table viewer on
F4211. This should show who and when. Also, if you
have the ledger turned on in the order activity rules,
you should be able to reset the information.
--- mskibyak <[email protected]> wrote:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=29652
__________________________________________________
World, OW B733X and Xe
Were the quantities completely consumed? If so, the
lines automatically cancel. You can check the program
ID, user, date and time stamp using a table viewer on
F4211. This should show who and when. Also, if you
have the ledger turned on in the order activity rules,
you should be able to reset the information.
--- mskibyak <[email protected]> wrote:
http://www.jdelist.com/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=29652
__________________________________________________
World, OW B733X and Xe
Guest
Guest
Gentlemen:
Thank you all for your help! We examined the tables and learned that a new employee had not been trained on the Blankets. She had been instructed to print the Blanket POs and she printed them using our normal PO Print program, which changes Status Next to 999.
Thanks again,
Mike
OW XE
Thank you all for your help! We examined the tables and learned that a new employee had not been trained on the Blankets. She had been instructed to print the Blanket POs and she printed them using our normal PO Print program, which changes Status Next to 999.
Thanks again,
Mike
OW XE
