Cash Book Bank Management Posting Error

(0) Share

Report

Posted on by Community Member Microsoft Employee

Stored Procedure error while trying to post the Cash Book Bank Management entry in Payables Management. This appears in Dynamics GP10 SP3

"Cannot insert the value NULL into column 'TRXDATE' , table GL20000, column does not allow nulls. UPDATE fails and then The stored procedure Update_BM_PM_Date returned the following results DBMS: 515 and Dynamics: 0”

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: Re: Cash Book Bank Management Posting Error

Dear :

Thanks for your replay and your effort

but I want to clear three points,before two days every think going without errors , this error came suddenly yesterday,

this error on all client machines and this error coming with all "CBM batch Entry" batches .

after posting I checked GL20000 table I founded it correctly posted without nulls;
Richard Whaley 25,195 on at

Like (0)

Report

Re: Cash Book Bank Management Posting Error

I would guess the batch being posted has a bad record. The error occurs when blank fields occur in required data points. You will need to examine the data that is to be posted using MS SQL Management Studio, compare the fields with those in other records, find and correct the missing data. Based on the error, look at the TrxDate column, of course. You could simply have a complely blank record.

MAKE A BACKUP OF YOUR DATABASE BEFORE MANUALLY DELETING OR EDITING ANY SUCH RECORDS.