News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Can i see Customer Ava...

Microsoft Dynamics GP (Archived)

Can i see Customer Available Credit Limit Balance in Dynamics Gp Console and Respective database tables ?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Can i see Customer Available Credit Limit Balance in Dynamics Gp Console and Respective database tables ? If Not Tell me How to Calculate the available credit limit balance of customer by using database tables?

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

L Vail 65,271 on at

Like (0)

Report

RE: Can i see Customer Available Credit Limit Balance in Dynamics Gp Console and Respective database tables ?

Hi Mallesh,

Almas is spot on. The RM00101 is the customer master, the credit limit is field CRLMTAMT. The RM00103 is the customer summary table, the field is CUSTBLNC.

Kind regards,

Leslie
Suggested answer

Almas Mahfooz 11,004 User Group Leader on at

Like (0)

Report

RE: Can i see Customer Available Credit Limit Balance in Dynamics Gp Console and Respective database tables ?

You can get available balance by using table RM00103 and RM00101.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2

Martin Dráb 230,458 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans