Skip to Content
0
May 23, 2020 at 01:53 PM

Request list of BusinessPartners incl CashDiscounts

53 Views

Hello,

I like to receive a list of all BusinessPartners included all Rows of CashDiscount lines.

I only manage to get the BusinessPartner/PaymentTermsTypes/CashDiscounts

Now I like to get the CashDiscounts/DiscountLines because I need to no the Discount for the less NumOfDays

Example:
NumOfDays = 10, Discount = 3
NumOfDays = 20, Discount = 1,5

I need to now the first row, because 10 is less than 20

I have now idea how to manage that.

Please F1

Regards Carsten

My actuall test:
HTTPS://192.168.6.10:50000/b1s/v2/$crossjoin(BusinessPartners,PaymentTermsTypes,CashDiscounts) ?$expand=BusinessPartners($select=CardCode,CardName,CardType,Address,ZipCode,City,Country,EmailAddress,IBAN,FederalTaxID,EmailAddress,Website,Notes,ValidFrom,ValidTo,UpdateDate,CreateDate) ,PaymentTermsTypes($select=GroupNumber,PaymentTermsGroupName,NumberOfAdditionalDays,DiscountCode) ,CashDiscounts($select=Code,CashDiscounts/DiscountLines/Discount) &$filter=BusinessPartners/PayTermsGrpCode eq PaymentTermsTypes/GroupNumber and PaymentTermsTypes/DiscountCode eq CashDiscounts/Code