dear all,

where I can find session in BAANIVc4 for history about user do session generated outbound (tdilc4201m000).

thank you very much.

Rgds,
Robby

Robby,
There is no place where Baan keeps who generated the o/b. Only thing is there is run number. However, it can be acheived by modifying it. And you don't need a source code. You can modify the generate o/B report. This is based on assumption that user will always print a report.

Arvind Patil

can you tell me, how modify that report.
I need this cause I want to know who doing Generated Outbound.

thank you.

rgds,
Robby

You can modify the generate o/b report and in the detail section try to update a table. You can either create a new table or modify tdilc401. It should be very straightfoward.

Arvind Patil
avpatil@hotmail.com

the session that show the history about users is the ttaad2402m000, you should put the name session and more values

i hope to be clear

For the above step to work, you have to enable the checkbox named "History" in Maintain User Data for the particular user. The downside of this procedure is that the file that stores the history grows at an alarming rate and unless its purged periodically, you might even run out of diskspace. Once you purge the whole purpose of logging the history is gone..So i doubt the usefulness of the above step...But its a start..

sk

print user history is okay for found history user.
but I want history is about specific order.
for example I have sales order with number order is 150500 then I want to know who generated outbound this order number.

thanks

Hi,
can u try the following
1. Create an AFS to call session "tdilc4101m000" and copy the standard table "tdilc401" and add a field user name.
2. Generate outbound through AFS, it rus as per standard "tdilc4101m000" then it updates the field username along with.

try it out, and let me know the result.

regards

dear baan1612,

what is AFS ?
i'm newbie in BAANIVc4.

thank you.

Rgds,
Robby

AFS stands for Application Function Server. You could get it from Infor but as a packaged software in the name of OpenWorld.

sk

Robby,

That is true that you can not use the session Print user history for a specific sales order number. If u want this for a specific order, you can create a SQL Query in which you have to use these two tables: Outbound Advice (whinh225) and Runs (whinh400). First search the run number for that order number in whinh225 and then go to table whinh400 & find the login name for that run number. on the form level, just input the order number.

Try this, hope it will work for u.

Shalini

Hello, we did a customization to trap all changes (add \ modify \ delete) to outbound data. We debated doing this through the oracle level using triggers, or to add it through the baan tools.

We ended up doing it through baan. We modified :
- generate outbound,
- maintain outbound
- delete outbound
(plus a bunch of custom sessions that affect outbound)

to insert records into our history table.

We wanted this logging to be able to track who was changing outbound.

Hope this helps.
John

If you have no development license, i dont think you could customize the sessions(enough to put your own codes in it i.e). In which case, i think the triggering option is not bad at all. You could place a trigger on insert/update/delete on the outbound table and update a local table with the information you need as and when any of the update event takes place.

sk

If the Run Number generated by system then u can lookup the user at session RUNS (in LN the session#: whinh4500m000). Then u can create a report, Linked the information between RUNS and Outbound Advice Session to get the user.

dear all,

I will do as Beni Abdullah suggest cause this easy way to see history for generated outbound.
thank you everyone for help me.

Rgds,
Robby

Think his suggestion is based on LN.

sk

sorry I think the idea is make report between table outbound and run number.
but I don't realize this for LN.

so what I should sukesh ???
I need suggestion

btw, where I can find history for who do sales invoice ?

Rgds,
Robby

Hi Robby,
The easiest, by which i mean to say the simplest, solution would be to initiate auditing. By having the audit turned on for a table(of your choice) you could record who does what on it and could be helpfull in your cause. Since the audit creates a lot of files, you can have a piece of software read those files and store the necessary info in some table outside baan. This will let you delete the audit files to save space on the server. I have not implemented audit management and so you would have to check Baan for the documentation part or even search baanboard.

The same applies to Sales Invoicing. Sls051 table would have been a great source for your requirement, unfortunately it only stores the user who processes the invoiced orders and not who invoices it. Turning on Audit on the Sls045 table could help you in this regard, unless ofcourse if someone out here knows a table that stores the info you seek...

Sk