Vendor payment settlement with code

(0) Share

Report

Posted on by vicky1234

Hi,

Recently I got the requirement to settle customer so I used the below code for example taken from blog

CUSTTABLE originator = CustTable::find(‘CAHM-1066’);
CustVendOpenTransManager SettleManager;
Custtransopen custtransopenfrom, custtransopento;
;
SettleManager = custVendOpenTransManager::construct(originator);

The originaor will be custtable however it gives me an error saying that it is expecting ledgerjournaltrans record

//finding debit amount record
select firstonly1 custtransopenfrom
where custtransopenfrom.AccountNum == originator.AccountNum
&& custtransopenfrom.RefRecId == 5637165579;

SettleManager.updateTransMarked(custtransopenfrom, true);
SettleManager.updateSettleAmount(custtransopenfrom, 200);

SettleManager.settleMarkedTrans();

This is not creating any transaction in the customer transaction table
Has anyone worked on such thing.

I need to do same thing for the vendors too.

I have the same question (0)

All responses (4)

Answers (0)

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report
First of all, let me make your code easier to read by using Insert > Code and fixing a few things:

CustTable originator = CustTable::find('CAHM-1066'); CustTransOpen custTransOpenFrom; //finding debit amount record select firstonly custTransOpenFrom where custTransOpenFrom.AccountNum == originator.AccountNum && custTransOpenFrom.RefRecId == 5637165579; CustVendOpenTransManager settleManager = CustVendOpenTransManager::construct(originator); settleManager.updateTransMarked(custTransOpenFrom, true); settleManager.updateSettleAmount(custTransOpenFrom, 200); settleManager.settleMarkedTrans();

When you say "it gives me an error", which method are you talking about? You seem to suggest that CustVendOpenTransManager can handle only LedgerJournalTrans records, which isn't true, as far as I know. Using a CustTable record looks correct to me.

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

Thanks Martin for the code part .

The thing is when I actually run the code it throws error saying Cannot cast from ledgerjournaltrans to custtable sort of error .

I have debug this and on passing the ledgerjournaltrans it does not gives an error,

However the major concern is that this piece of code is actually not doing anthing even after execution with ledgerjournaltrans.

I want to settle the payments that is the main part that i am looking for.

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

Like (0)

Report

Which line of code does throw this error?

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

Hi MArtin.

We found some custom code in the envirornment and I will check on that and update . Most probably it must be because of the customizations.

I will update once I debug again.

thanks for the reply.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Vendor payment settlement with code

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Vendor payment settlement with code

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates