Vendor Post Dated Check Status Open after Posting

(0) Share

Report

Posted on by Community Member

Hi,

i am facing an issue with vendor post dated check for some of the journals which is already posted but still the status is showing post dated check status is open due to which i can not able to settle or cancel the PDC. Can anyone help in this?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Community Member on at

Like (1)

Report

RE: Vendor Post Dated Check Status Open after Posting

Dear Yasar,

I believe it is a bug in AX2012 , when ever you will post the journal from the main header screen the PDC status will be open but if you will post the journal from the journal lines screen the PDC status will automatically change to posted.

A small fix for the solution to let it work from the header screen as well, put the following code on the click event of button "Post"

Form Name : "LedgerJournalTable"

Button : "Post"

Method : "clicked"

//code to post the PDC

if(ledgerJournalTable.Posted == NoYes::Yes )
{
CustVendPDCManager::postDatedCheckPost(ledgerJournalTable.JournalNum);
}

The above solution work for me.

Regards,

Rizwan Khan.

Was this reply helpful? Yes No
Suggested answer

Syed Sheheryar 22 on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

Despite of creating a batch job for it. I believe that creating a job for such functionalities would become a bottleneck whenever there is any issue with the batch server.

You can do a similar work by just creating a method on LedgerJournalTable and calling it after the posted super() function.

//The logic for be made in a method in LedgerJournalTable:
//1. Declare the tables instances

LedgerJournalTrans journalTrans;

VendPaymModeTable paymMode;

CustVendPDCRegister custVendPDCRegister;

//2. Write the logic by joining the tables and correct filters

While Select JournalNum,PaymentStatus from journalTrans

where

journalTrans.JournalNum == this.JournalNum && //This will be our input from the form

journalTrans.PaymentStatus == CustVendPaymStatus::Sent

join PaymMode from paymMode

where paymMode.PaymMode == "PDC" //For the sake of understanding; I've hardcoded this value.

join forUpdate PDCStatus from custVendPDCRegister

where

custVendPDCRegister.LedgerJournalTrans == journalTrans.RecId

{

//3. Finally update the field PDCStatus; each iteration means a PDC line LedgerJournalTrans

ttsBegin;

custVendPDCRegister.PDCStatus = PostDatedCheckStatus::Posted;

custVendPDCRegister.update();

ttsCommit;

}

Was this reply helpful? Yes No
Suggested answer

AXSHAH 528 on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

/*

Create a job, copy paste this code and run this on daily basis

if satisfied create a run base batch

Note make custPDC.PDCStatus editable at table property

*/

static void Update_VendPdc_Posted(Args _args)

{

LedgerJournalTable _table;

LedgerJournalTrans _trans;

CustVendPDCRegister custPDC;

int i;

while select * from _table where _table.Posted==NoYes::Yes

if(_table)

{

select * from _trans where _trans.JournalNum==_table.JournalNum;

if(_trans)

{

select forUpdate custPDC where custPDC.LedgerJournalTrans==_trans.RecId && custPDC.PDCStatus==PostDatedCheckStatus::Open;

if(custPDC)

{

custPDC.PDCStatus=PostDatedCheckStatus::Posted;

ttsBegin;

custPDC.update();

ttsCommit;

i++;

}

}

}

info(strFmt("Total records updated: %1 via www.axshah.com",i))

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

In this case another solution is that we have created a job which updates all the pdc status as posted from open on daily basis if that journal is posted.

Was this reply helpful? Yes No
Muhammad Omar Shahid 50 on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

Hi did you get the solution for this issue..?

Was this reply helpful? Yes No
Muhammad Omar Shahid 50 on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

Hi Am facing the same issue and the users are also linked with the worked ID, can you please suggest what could be the reason for this? as customer Posted dated Checks are still showing open status, where as the journal for them is also posted. Please suggest.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

Hi, I am also facing similar issue. Can someone please suggest how to resolve it.

Thanks

Was this reply helpful? Yes No
Suggested answer

AXSHAH 528 on at

Like (0)

Report

RE: Vendor Post Dated Check Status Open after Posting

Link the user with Worker ID

Was this reply helpful? Yes No