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