Hi,
I added new flowfield at Customer card, the field name “Debit Note Amount” which i want to summary the “Amount” field from Sales Invoice Line for each customer.
For Sales Invoice document, I set up the Document no. format as following;
Normal Sales Invoice : INYYMMNNNN
Debit Note : DRYYMMNNNN
The "Debit Note Amount’ need to summary only document that start with DR (not include IN)
I Set filter as following;
Table Id: 18 Customer Card >> calculation formula;
Method : Sum
Table : Sales Invoice Line
Field : Amount
Table Filter : Sell-to Customer No.=FIELD(No.),Document No.=FILTER(=DR*)
But it doesn’t work when drill down this field it’s show message:
“Sales Invoice Header No. ‘DR*’ does not exist.”
(actually it’s have the data).
Thanks 
Hi,
Another solution could be to create a boolean field on the sales invoice line as ‘debit note’ which can be made yes if the Document No. starts with DR. Then create the flowfield with the Table Filter as Sell-to Customer No.=FIELD(No.),Debit Note=CONST(Yes)
That’s because there are no credit memos in the Sales Invoice Line table. Credit memos are in the “Sales Cr.Memo Header” and “Sales Cr.Memo Line tables”.
Hi DenSter,
it’s not credit memos, it’s debit note (additional Account Receivable) which we use Sales Invoice to create and separate from normal invoice by prefix “DR”.
To me an invoice is exactly the same as a debit note. I’ve had that discussion before though so you don’t have to explain. Using a part of the document number as the identifier of a different type of document is, in my opinion, not a good design. Instead, you should have a separate attribute that marks a document as one thing or the other. This would make the calcformula much easier too.
Having said that, you can define a filter in the calcformula, so in your shoes I would try to enter ‘DR*’ as a filter on the Document Number field, and see if that works. But I see that you’ve already tried that, so I don’t know how to make that work.
Hi all,
thank for everyone :), i think the code ‘DR*’ is not work for my version (5.0 SP1) which i don’t know why…
and just for you information that I have to use this code for make it work… :S
Sell-to Customer No.=FIELD(No.),Posting Date=FIELD(Date Filter),Document No.=FILTER(DR…DS00000)
Very Very bad progettare ( design?). this type of soluzioni gives bad name to producto.2 week ago we have to help a clientle with wrong display of amount,wrong riportare some devloper did same mistok… Pls stop this useage.
Risoluzione: Boolean on Sales header and Sales Involce header -Table 36 and 112 and use Trasnferfield in Code 80 (sales posting).then you set flow-field from customer (18) to 112,use this bollean filtre.
scuse per l’uso di parole forti:Idiota soluzioni dà cattiva reputazione di prodotto e comapnies