Save Modified Date for Requisitions

Yahoo Archive
1
Lissette,



There may be a number of options you can do. One option would be to have a
post processing directive with no conditions, it will fire every time the
update method is called. You'd have a 4GL line that reads the ReqHead
(likely based upon a parameter if there's one, otherwise you may need to do
a FIND FIRST ttReqHead with no "rowmod"). Then, assign the date to the
current date.



The reason I recommend this method is you may not always have the ttReqHead
available with the RowMod = "U". I've had varied results in the past of
setting ttReqHead.RowMod to "U" and having it actually update.



HTH.

Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
liss_c
Sent: Wednesday, July 28, 2010 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Save Modified Date for Requisitions





I am trying to keep track of the changes made in a requisition. requisition
dont have the Change Action log option like the Purchase Orders, so I added
a date UD field in the Requisition that saves the dates that the requisition
has been last modified. I think I got the Action of my BPM but I am trying
to figure it out the condition.The condition should recognize when at least
one change is made in the requisition. I am using the Req.Update BO.

4GL Action:

For each ttReqhead where ttReqhead.Rowmod = "A" or where
ttReqhead.Rowmod = "U" .

Assign ttReqHead.date03 = Today.

End.

Thanks,





[Non-text portions of this message have been removed]
2
I am trying to keep track of the changes made in a requisition. requisition dont have the Change Action log option like the Purchase Orders, so I added a date UD field in the Requisition that saves the dates that the requisition has been last modified. I think I got the Action of my BPM but I am trying to figure it out the condition.The condition should recognize when at least one change is made in the requisition. I am using the Req.Update BO.


4GL Action:

For each ttReqhead where ttReqhead.Rowmod = "A" or where
ttReqhead.Rowmod = "U" .

Assign ttReqHead.date03 = Today.

End.


Thanks,
3
I would use the 'there is at least one modified row in the ttReqHed
table'. I'd also look at ttReqDetail.



One thing you'll want to test for is whether when you modify and save
a detail line in an existing Req if ttReqHead is populated with anything
in that transaction. In some BOs, if you modify an existing record the
tt<whatever>Head table isn't populated in the transaction, only the
Detail record, so you'll need to deal with both cases.



There's a table called ReqLog that looks like it might track changes
to requisitions so maybe you don't need to do this. We don't use this
feature at the moment so I'm not sure what data this will contain but it
might be worth writing a BAQ.



-bws



mfgsys.ReqLog

ReqLog

________________________________


Table details

Area

Schema Area <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-area.html>

Dumpname

reqlog

Label

?

Val.exp

?

Val.msg



Triggers

Event

Procedure

Overridable

Check CRC

WRITE

db/trg/ReqLog/write.p

________________________________


Fields

Order

Field Name

X

Label

Datatype

Format

Initial

Mand

Description

100

Approved

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-a.html#Approved>


Approved

logical

yes/no

no

V: tb
D: This filed is ONLY used for a Mandatory Requisition Action. If a
Requisition Action is tagged as Mandatory and this action is not yet in
the log for a given requisition OR the last occurrence of this action
has Approved equal to NO then this Requisition cannot be sent to
Purchase Management.

80

ChangeDate

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#ChangeDate
>

Date

date

99/99/99

?

D: System date when this change was made.

70

ChangedBy

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#ChangedBy>


Changed By

character

x(20)

D: UserID who made the changes. Not maintainable by the user.

90

ChangeTime

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#ChangeTime
>

Time

integer

>>>>>9

0

D: System time (seconds since midnight) of when the changes were made.

10

Company <file:///J:\erp\DataDictionary\Output2\Mfgsys\apsyst.html>

x <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#Company>


?

character

x(8)

D: Company Identifier.

40

CurrDispatcherID

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#CurrDispat
cherID>

Dispatcher

character

X(30)


140

CurrentAction

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#CurrentAct
ion>

Current Action

logical

yes/no

y

V: tb

110

OldActionID

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-o.html#OldActionI
D>

Old Requisition Action ID

character

X(8)


30

ReqActionID

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-r.html#ReqActionI
D>

Requisition Action ID

character

X(8)


130

ReqLogType

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-r.html#ReqLogType
>

Req Type

character

X(1)

D: "A" Action, "N" Notify

20

ReqNum

x <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-r.html#ReqNum>


Requisition

integer

>>>>>>9

0

D: Requisition number that uniquely identifies the requisition.

150

StatusType

x
<file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-s.html#StatusType
>

Status

character

X(1)

D: "A" - Approve, "O" - Ordered, "P" - Pending, "R" - Reject, ""
- for Notifications (No status).



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of liss_c
Sent: Wednesday, July 28, 2010 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Save Modified Date for Requisitions



I am trying to keep track of the changes made in a requisition.
requisition dont have the Change Action log option like the Purchase
Orders, so I added a date UD field in the Requisition that saves the
dates that the requisition has been last modified. I think I got the
Action of my BPM but I am trying to figure it out the condition.The
condition should recognize when at least one change is made in the
requisition. I am using the Req.Update BO.





4GL Action:



For each ttReqhead where ttReqhead.Rowmod = "A" or where

ttReqhead.Rowmod = "U" .



Assign ttReqHead.date03 = Today.



End.





Thanks,













------------------------------------



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



http://groups.yahoo.com/group/vantage/



Individual Email | Traditional



http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)



vantage-digest@yahoogroups.com

vantage-fullfeatured@yahoogroups.com



vantage-unsubscribe@yahoogroups.com



http://docs.yahoo.com/info/terms/





[Non-text portions of this message have been removed]
4
Thanks Brian I will check on the ReqLog. Seems to be an easier way to approach it.

--- In vantage@yahoogroups.com, "Brian W. Spolarich " <bspolarich@...> wrote:
>
> I would use the 'there is at least one modified row in the ttReqHed
> table'. I'd also look at ttReqDetail.
>
>
>
> One thing you'll want to test for is whether when you modify and save
> a detail line in an existing Req if ttReqHead is populated with anything
> in that transaction. In some BOs, if you modify an existing record the
> tt<whatever>Head table isn't populated in the transaction, only the
> Detail record, so you'll need to deal with both cases.
>
>
>
> There's a table called ReqLog that looks like it might track changes
> to requisitions so maybe you don't need to do this. We don't use this
> feature at the moment so I'm not sure what data this will contain but it
> might be worth writing a BAQ.
>
>
>
> -bws
>
>
>
> mfgsys.ReqLog
>
> ReqLog
>
> ________________________________
>
>
> Table details
>
> Area
>
> Schema Area <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-area.html>
>
> Dumpname
>
> reqlog
>
> Label
>
> ?
>
> Val.exp
>
> ?
>
> Val.msg
>
>
>
> Triggers
>
> Event
>
> Procedure
>
> Overridable
>
> Check CRC
>
> WRITE
>
> db/trg/ReqLog/write.p
>
> ________________________________
>
>
> Fields
>
> Order
>
> Field Name
>
> X
>
> Label
>
> Datatype
>
> Format
>
> Initial
>
> Mand
>
> Description
>
> 100
>
> Approved
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-a.html#Approved>
>
>
> Approved
>
> logical
>
> yes/no
>
> no
>
> V: tb
> D: This filed is ONLY used for a Mandatory Requisition Action. If a
> Requisition Action is tagged as Mandatory and this action is not yet in
> the log for a given requisition OR the last occurrence of this action
> has Approved equal to NO then this Requisition cannot be sent to
> Purchase Management.
>
> 80
>
> ChangeDate
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#ChangeDate
> >
>
> Date
>
> date
>
> 99/99/99
>
> ?
>
> D: System date when this change was made.
>
> 70
>
> ChangedBy
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#ChangedBy>
>
>
> Changed By
>
> character
>
> x(20)
>
> D: UserID who made the changes. Not maintainable by the user.
>
> 90
>
> ChangeTime
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#ChangeTime
> >
>
> Time
>
> integer
>
> >>>>>9
>
> 0
>
> D: System time (seconds since midnight) of when the changes were made.
>
> 10
>
> Company <file:///J:\erp\DataDictionary\Output2\Mfgsys\apsyst.html>
>
> x <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#Company>
>
>
> ?
>
> character
>
> x(8)
>
> D: Company Identifier.
>
> 40
>
> CurrDispatcherID
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#CurrDispat
> cherID>
>
> Dispatcher
>
> character
>
> X(30)
>
>
> 140
>
> CurrentAction
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-c.html#CurrentAct
> ion>
>
> Current Action
>
> logical
>
> yes/no
>
> y
>
> V: tb
>
> 110
>
> OldActionID
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-o.html#OldActionI
> D>
>
> Old Requisition Action ID
>
> character
>
> X(8)
>
>
> 30
>
> ReqActionID
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-r.html#ReqActionI
> D>
>
> Requisition Action ID
>
> character
>
> X(8)
>
>
> 130
>
> ReqLogType
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-r.html#ReqLogType
> >
>
> Req Type
>
> character
>
> X(1)
>
> D: "A" Action, "N" Notify
>
> 20
>
> ReqNum
>
> x <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-r.html#ReqNum>
>
>
> Requisition
>
> integer
>
> >>>>>>9
>
> 0
>
> D: Requisition number that uniquely identifies the requisition.
>
> 150
>
> StatusType
>
> x
> <file:///J:\erp\DataDictionary\Output2\Mfgsys\00-cross-s.html#StatusType
> >
>
> Status
>
> character
>
> X(1)
>
> D: "A" - Approve, "O" - Ordered, "P" - Pending, "R" - Reject, ""
> - for Notifications (No status).
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of liss_c
> Sent: Wednesday, July 28, 2010 12:10 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Save Modified Date for Requisitions
>
>
>
> I am trying to keep track of the changes made in a requisition.
> requisition dont have the Change Action log option like the Purchase
> Orders, so I added a date UD field in the Requisition that saves the
> dates that the requisition has been last modified. I think I got the
> Action of my BPM but I am trying to figure it out the condition.The
> condition should recognize when at least one change is made in the
> requisition. I am using the Req.Update BO.
>
>
>
>
>
> 4GL Action:
>
>
>
> For each ttReqhead where ttReqhead.Rowmod = "A" or where
>
> ttReqhead.Rowmod = "U" .
>
>
>
> Assign ttReqHead.date03 = Today.
>
>
>
> End.
>
>
>
>
>
> Thanks,
>
>
>
>
>
>
>
>
>
>
>
>
>
> ------------------------------------
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
>
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
>
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
>
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
> http://groups.yahoo.com/group/vantage/
>
>
>
> Individual Email | Traditional
>
>
>
> http://groups.yahoo.com/group/vantage/join
>
> (Yahoo! ID required)
>
>
>
> vantage-digest@yahoogroups.com
>
> vantage-fullfeatured@yahoogroups.com
>
>
>
> vantage-unsubscribe@yahoogroups.com
>
>
>
> http://docs.yahoo.com/info/terms/
>
>
>
>
>
> [Non-text portions of this message have been removed]
>