SAP Business One Hana - Query AR Credit Memo's

[bbranco]

Hi,

Can someone help me with this issue?
I am trying to create a query that ties out the AR Sales Analysis by item to the Sales Analysis in the system.

I am having a problem with the AR Credit Memo's.
I have a AR Credit Memo that is linked to a AR DownPayment, in looking at the Sales Analysis in SAP, this credit is not included in the data.
I have another AR Credit memo that is NOT linked to an AR DownPayment, in looking at the Sales Analysis in SAP, this credit IS included in the data.

My question is in my query, how do I EXCLUDE the AR Credit Memo that is linked t an AR DownPayment?

I dont see any differences in ORIN or RIN1 that I can filter this, unless I missed something.

Any help would be greatly appreciated.

If anyone has a completed query that ties out, I would like to have that also, if possible.

I have been struggling for days with this.

[vinicius_dezan]

Olá, você chegou a checar os campos BaseRef e BaseType?