Skip to main content
Question

Is there any report to see the "Available Credit Limit" of Customers ?

  • 10 May 2024
  • 1 reply
  • 93 views

Forum|alt.badge.img

Hi All,

Is there any report to see the customers’ available credit limits ? Under the “Customers Profile” report, we only can see the credit limit. Unfortunately available/remaining credit limit is not captured to that report.

Thank you

 

1 reply

ejmillar
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • 58 replies
  • May 10, 2024

There is a generic inquiry named AR-CreditLimitCustomers that will be of help.

The GI should be in your Acumatica instance but I’ve attached it case it’s not.

The following tables will need to bring into the report.

PX.Objects.AR.ARBalancesSharedCredit

PX.Objects.AR.CustomerSharedCredit

Relationship will be on the CustomerID.

 

Remaining Credit within the GI uses the following formula:

=[CustomerSharedCredit.CreditLimit]-([ARBalancesSharedCredit.CurrentBal]+[ARBalancesSharedCredit.UnreleasedBal]+[ARBalancesSharedCredit.TotalOpenOrders]+[ARBalancesSharedCredit.TotalShipped]-[ARBalancesSharedCredit.TotalPrepayments]) 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings