Net Value Discount not showing on invoice

[james.brown33]

Hi

I am using Report Designer on Sage 50 Accounts Pro 2008, v 14.

I am trying to show the discount amount on a product and the discount value of the product in a report.

In my footer, the discount value is showing correctly using - INVOICE.FOREIGN_ITEMS_NET

But in the specific line for the product, I have INVOICE_ITEM.FOREIGN_DISCOUNT_AMOUNT and INVOICE_ITEM.FOREIGN_NET_AMOUNT, but the discount amount is showing £0 and the net amount is showing £125 (the full net product price rather than the discount net product price).

Within Sage, I have applied a Net Discount Value of £5.

I've un-ticked a box for the discount that said if value = £0 then don't show, now it shows £0 suggesting the expression is the wrong one.

Any recommendations greatly appreciated.

Thanks

[brucedenney]

INVOICE.FOREIGN_ITEMS_NET is not the discount, it is the net amount

INVOICE_ITEM.FOREIGN_DISCOUNT_AMOUNT is the discount amount.

Can you attach the report to a post so we can see what you have done.

[james.brown33]

Thanks.

INVOICE_ITEM.FOREIGN_DISCOUNT_AMOUNT is in the report which is whats throwing me. Just to check, is this the Net Value Discount. Only checking since they are called different things so wondering if I have actually applied the discount correctly.

I'll add the design file, presume thats whats best to see?

Thanks

[brucedenney]

I think you need to attach the layout / report because it is not clear from you description