Invoice document expenses

Lars Pelzer

Hi all,

I've build a layout and the values don't match when I count them al together (see screenshot). Can I add the expenses (that are displayed in the document) to the layout?

Hope that you can help me! Thank you in advance!

Greetz

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/descecrator/Expenses(1).JPG]Expenses(1).JPG[/url]

Lars Pelzer

Hi all,

I found the answer. The field "Netto Sum" needs the have the following formula as it's "Value":

DocumentRowDetail.Sum("RunningSum") - (iif (isFC,DocumentFooter("DiscSumFC"),DocumentFooter("DiscSum"))) _
+ iif (isFC,DocumentFooter("TotalExpFC"),DocumentFooter("TotalExpns")) - iif(isFC,DocumentFooter("DpmAmntFC"),DocumentFooter("DpmAmnt"))

I put a screenshot with it.

Greetz

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/descecrator/netto.JPG]netto.JPG[/url]