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?

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

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.

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

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.