SALES REPORT (AR INVOICE LESS CM)

[Former Member]

Hi Expert,

My Client wants me to create a query report AR INVOICE less CM Already.

But seems I need a lot of help can anyone help me how can I build the query?

I really Need It badly.

Thanks u in advance.

soc

[Johan_H · Accepted solution]

Hi,

B1's system report Sales Analysis (Sales A/R > Sales Reports > Sales Analysis) gives you exactly what you need: Sales - Credit Memos.

You do not need to create a query.

Regards,

Johan

[former_member312729]

Hi,

Can you explain " AR INVOICE less CM Already".

[Former Member]

if i generate sales the CM is automatically deducted

[former_member312729]

You mean CM commission . Please give the fields needed for the report

[Former Member]

CREDIT MEMO SIR

[former_member312729]

Hi ,

The below gives Invoice linked to credit memo. Based on fields needed we can enhance the query

SELECT T0.DocNum from OINV T0 INNER JOIN INV1 T1 on T0.DocEntry=T1.DocEntry

WHERE T1.TargetType = '14'