Microsoft Dynamics AX (Archived)

AmountCur is zero in CustTransOpen Table

(0) Share

Report

Posted on by sevenq

these recore can delete from custTransOpen table directly?

why these recore exists ?

how to resolve it?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

sevenq 12 on at

Like (0)

Report

RE: AmountCur is zero in CustTransOpen Table

use custTransOpen's RefRecId can find custTrans,

but the AmountCur is not equal,such as :

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,669 Moderator on at

Like (0)

Report

RE: AmountCur is zero in CustTransOpen Table

Is RefRecId from custTransOpen not found in CustTrans for these records?

Was this reply helpful? Yes No
sevenq 12 on at

Like (0)

Report

RE: AmountCur is zero in CustTransOpen Table

HI,Ludwig ,

Thanks for your reply

Was this reply helpful? Yes No
sevenq 12 on at

Like (0)

Report

RE: AmountCur is zero in CustTransOpen Table

Hi Satish ,

Thanks for you reply!

There are only 46 records like the screenshot, and all custTrans are closed which the custTansOpen reference,

in custTrans, no similar records were found

these issues are found by our accountant when checking each custom's statement.

i will transfer your advise to them.

Thanks.

Sevenq

Was this reply helpful? Yes No
Verified answer

Satish Panwar 14,669 Moderator on at

Like (1)

Report

RE: AmountCur is zero in CustTransOpen Table

Hi Sevenq,

Based on your screenshot, all records have value in ExchAdjUnrealized field. Can you check if these records have corresponding custTrans invoices still open? If yes, is the amount same as what's in ExchAdjUnrealized column? suggest not to delete unless it's creating any issue for you. Are there more records like these or just what you have shown above. Are you running into any issues because of this.. e.g. invoice showing open in statement/aging etc. If not , just ignore these records.

Thanks,

Satish Panwar

Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

RE: AmountCur is zero in CustTransOpen Table

Hello sevenq,

I cannot tell you why those records exists but would recommend not deleting anything from this table unless you have double checked with your accountants why the amount is zero and what happened there exactly.

Most of them are already very old and data more than 3 years back.

If you have only those 19 records that 'bother' you, I would recommend doing anything unless you are currently stopped from doing something in AX.

Best regards,

Ludwig

Was this reply helpful? Yes No