Go Back > Forum > Baan SIGs > AFS/DDC/OLE: Function servers

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 45

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 25th July 2003, 04:57
rohan_rege's Avatar
rohan_rege rohan_rege is offline
Join Date: Aug 2002
Location: Bridgeton , MO , US
Posts: 82
rohan_rege is on a distinguished road
how to change FIND

hi ,

i am using AFS for a session tfacp1131s000 Match Receipts

the problem is that out of the two forms...
the first form allows to do a find only on tdpur045.orno and tdpur045.pono

while the same sessions form 2 allows the find on
tdpur045.orno , pono and srnb .

how do i customise the sessions form 1 so that it also allows the find for the above three fields instead of two.

curr the find with only two fields gets me the wrong record

doing this customisation i will be able to use the find in my AFS program to do what i need and get the correct record help....

any suggestions ..ideas ..r most welcome

Reply With Quote
Old 25th July 2003, 08:39
MariaC's Avatar
MariaC MariaC is offline
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
The srnb is set to be display on form 1 that is why it does not come up in the find. On form 2 it is input.
Reply With Quote
Sponsored Links
Old 25th July 2003, 15:01
mark_h's Avatar
mark_h mark_h is online now
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,074
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Two Choices...

I looked at the form and as Maria suggested the field is display only on the form. So the way I see things you have two options. The first is to change the session and its forms, so the srnb field is part of the find. I admit I do not know how Baan has two different find keys for the two forms. I have never attempted or tried this, so I am not sure how they did that.

The second option is to use the stpapi.change.view using the orno and pono fields. Then use the stpapi.browse.set to find the correct srnb record you are looking for.

Reply With Quote
Old 25th July 2003, 22:26
rohan_rege's Avatar
rohan_rege rohan_rege is offline
Join Date: Aug 2002
Location: Bridgeton , MO , US
Posts: 82
rohan_rege is on a distinguished road
hi all ! problem solved !

hi everyone !

thanks to all , i got the find working finally !

actually i was already trying the option which maria suggested...
but for some reason it wasnt doing any good...
it was still giving me only two fields on the first form..

i did a little research ...and found that in the first form there was
additonal field "tdpur045.srnb" put in to the form again at the end after the Invoice amount.

I deleted the sneaky extra field ,changed the actual tdpur045.srnb field to Input and ran the session again.... and it finally started giving the three fields req for the FIND.

so its done finally :-)

thanks to Maria, mark , lisa and gordan for ur prompt help !

Rohan Rege
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fixed Assets- change in date of first use. Kotharu Narayan Finance, Invoicing and Integration 0 22nd March 2004 13:19
how to change collation name on baandb database (SQL 2000 Server) nopadon Operating Systems & Databases 0 10th November 2003 11:30

All times are GMT +2. The time now is 17:58.

©2001-2017 - -