Business Partner credit limit

[Former Member]

Hi Experts,

I want to know all of the business partners credit limit. Are there any credit limit informations available in SAP B1 ? Please help

Thanks,

John

[julie_jamieson2 · Accepted solution]

Hi John,

Credit limits can be set either directly on the Business Partner record (OCRD.CreditLine) or using the payment terms (OCTG.CredLimit).

It depends how you use them as to how to get the detail out

[azeemhafeez]

Hi John,

This query will help you finding Credit Limit & other particulars of business partners.

SELECT T0.[CardCode], T0.[CardName], T0.[CreditLine], T0.[LicTradNum], T0.[VatIdUnCmp], T0.[CntctPrsn], T0.[Cellular], T0.[City], T1.slpname

FROM OCRD T0  INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode

WHERE T0.[SlpCode] = T1.[SlpCode] and  T0.[CardType] ='C'

ORDER BY T0.[CardCode]

Regards,

Azeem

[Former Member]

HI John

    Refer the attached screen shot file for the credit limit information.

    From DB side use OCRD -- crditline column, octg- Creditlimit column to retrive the information.

Regards,

Venki .A

[former_member184718]

Hi John,

Try this:

select t1.cardcode [Code], t1.cardname [Name], t1.creditline [Credit Limit] from ocrd t1

Thanks.

Hari

[KennedyT21]

HI John Eduard

Try This,

select  T0.cardcode,T0.CardName, T0.creditline ,T1.credlimit

--,CASE WHEN T0.creditline IS not null THEN T0.creditline else  T1.credlimit  END as Creditlimit

from ocrd T0

inner join octg T1 on T0.groupnum = t1.groupnum

where T0.CardType='C'

Regards

Kennedy

[Former Member]

Hi John.....

Open Business Partner Mater Data Window and Take it in Find Mode

Put * and display the list of business Partner and go to form setting and enable the credit limit column and again find the list of BP you can find one more column of Credit Limit.....

Regards,

Rahul

[former_member186095]

Hello John,

You can get the BP credit limit information using query generator.

Here is the query :

select distinct ocrd.cardcode, ocrd.creditline from ocrd

you can also use this other query below:

select distinct ocrd.cardcode, octg.credlimit from ocrd inner join octg on ocrd.groupnum = octg.groupnum

Regards,

JM