Finance | Project Operations, Human Resources, ...

Assign value to custom field in VendTrans table on insert()

(1) Share

Report

Posted on by Ariba Mehdi

166

Hi,

I have created a custom field(purchId) in vendTrans table.

When I post journal through vendor payment journal, I want to assign value to purchId based on the transaction through insert() method of vendTrans table,

Any suggestions on how this could be done?

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Martin Dráb 239,118 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Assigning a field value is trivial, but do you have the PurchId value in insert() method? If not, your design is wrong. You should analyze the scenario and then selecting the right place for your modification, rather then selecting a method and then wondering whether it can be done there at all.

To me, the whole idea is suspicious. I would start by finding out what is the business requirement that someone wants to address by this particular code change. There may be a better solution.

The relation between vendor transactions and orders isn't straightforward. For example, you may have a transaction for an invoice, but the invoice will include several orders. Or you receive a payment that isn't linked to any order at all.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Arbia,

There are method in LedgerJournalCheckPost class.

Ithink you can create a COC and add your business logic inside

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Martin Dráb 239,118 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

That's a relation to a general ledger journal line, not to a purchase order.

Was this reply helpful? Yes No