Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 26th October 2016, 10:02
IndoTech's Avatar
IndoTech IndoTech is offline
Member
 
Join Date: Jul 2005
Posts: 72
IndoTech is on a distinguished road
Baan: Baan IV, Infor LN 10.4 - DB: SQL-Server2000, Oracle, Informix - OS: Windows NT, Unix
Modify payment term field on PO header
Baan: Baan IVc4
C/S: Client

Hi,

I have a situation where I need to change the payment term for no. of POs for a specific supplier.

what are the things I need to take care if we do it by a update query?

Code:
select tdpur040.*
from tdpur040 for update
where tdpur040._index1 = {:v.po}
and tdpur040.suno = :v.suno
selectdo
tdpur040.cpay = v.cpay
db.update(ttdpur040, db.retry)
commit transaction
endselect

Regards
Kedar

Last edited by bhushanchanda : 26th October 2016 at 12:28. Reason: Added code tags
Reply With Quote
  #2  
Old 26th October 2016, 12:31
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Looks like Baan4. Not sure about the functional tables involved on this version but you need to take care of the history tables, order lines, if the order is invoices then you can check for purchase invoice table, receipts table etc. Payment terms affect the Ageing Analysis reports and hence you need to take precautions else it might leave financial impacts.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 26th October 2016, 15:25
IndoTech's Avatar
IndoTech IndoTech is offline
Member
 
Join Date: Jul 2005
Posts: 72
IndoTech is on a distinguished road
Baan: Baan IV, Infor LN 10.4 - DB: SQL-Server2000, Oracle, Informix - OS: Windows NT, Unix
Hi Bhushan

thanks, one thing if we use AFS of tdpur4101m000 to modify the payment term then what are the things needs to be taken into consideration.

Regards
Kedar
Reply With Quote
Sponsored Links
  #4  
Old 26th October 2016, 17:50
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
If the PO is modifiable, you should always go with AFS or DAL(In case of LN). Prefer db.* functions if you don't have any other options left.

With AFS, you don't need to worry. Related table updates will be handled automatically.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
Reply


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
Wrong Payment Term in Purchase Invoices kyle1907 Finance, Invoicing and Integration 8 8th November 2012 06:57
Audit file structure baan_user Tools Development 8 4th May 2007 15:32
Payment term at Purchase Order teddybear Distribution, Transportation & Warehousing 0 20th September 2005 08:10
modify S.O.line field tools123 Tools Development 2 6th April 2005 17:33


All times are GMT +2. The time now is 13:51.


©2001-2017 - Baanboard.com - Baanforums.com