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

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 25th March 2016, 05:26
tracylee tracylee is offline
Join Date: Sep 2011
Posts: 71
tracylee is on a distinguished road
Baan: ERP LN 6.1 - DB: MYSQL - OS: ERP LN
How to generate the Purchase Order No. with AFS


I want using AFS to insert data into Purchase Order. How can i use AFS to create the New Purchase Order and then insert all data into this New PO?

My data show as below:
Order Type : LOC
Series No. : CWH
Business Partner : SP001A
Reference A : Test A
Item : 123456
Quantity : 50 pcs

In LN system, the Purchase Order already until CWH000005.
So have any function for AFS to generate PO "CWH000006".

The running number need get it from First Free Number? Or AFS will auto detect the running number from First Free Number?

Please advise.
Reply With Quote
Old 25th March 2016, 06:56
Ajesh's Avatar
Ajesh Ajesh is offline
Join Date: Feb 2009
Posts: 590
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
You need to study the existing working when you try to create a new PO. Put the whole script into Debug, then see what specific actions are carried out while creation of a new PO. For example, if a certain dll is called to fill out the Purchase Order number then the same exact sequence of steps need to be replicated in the AFS.
Reply With Quote
Old 25th March 2016, 17:37
soumya093's Avatar
soumya093 soumya093 is offline
Join Date: Apr 2014
Location: Banglore
Posts: 32
soumya093 is on a distinguished road
Baan: BAAN IV,LN 10.4, - DB: Oracle - OS: Windows 7
You need to know the purchase cycle and all the validations.
In love with DAL
Reply With Quote
Old 25th March 2016, 22:35
mark_h's Avatar
mark_h mark_h is offline
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,219
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Also search this forum and you might find code for what you are looking for. Typically I search by session name to see what others have done and the issues they have run into.

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
Sponsored Links

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
Generate Purchase Order advice from sales order SoerenH Distribution, Transportation & Warehousing 2 5th March 2012 12:46
Generate Purchase Order Subcont Agus Mujtahid Manufacturing & Supply Chain 10 5th September 2009 14:48
AFS : Purchase Order Generate nileshsamsonite AFS/DDC/OLE: Function servers 5 1st January 2007 08:20
Can not generate MRP purchase Order huozhenguo Manufacturing & Supply Chain 0 23rd May 2005 17:32
purchase order activity skipped rcitra Distribution, Transportation & Warehousing 8 21st February 2005 03:30

All times are GMT +2. The time now is 07:46.

©2001-2018 - -