Report Designer - Amend your customised invoice layout to show negative item lines
Description
In Sage 50 Accounts you can enter negative item lines on your invoices. If you print or email your invoices using a customised layout from Sage 50 Accounts v22 or below, you must edit the layout slightly to display the negative items correctly. Let's take a look.
NOTE: The standard invoice layouts available with Sage 50 Accounts v23 and above automatically show the negative item lines correctly.
Cause
Resolution
Open the layout in Sage Report Designer
We recommend you take a layouts only backup before you start editing your invoice layout.
On the navigation bar, click Invoices and credits, then select any invoice or credit note.
Click Print, then click the layout you want to amend, then click Edit.
Amend the net column items to show negative values
On the invoice layout, locate the ITEM_NUMBER header section.
In the net amount column, double-click the INVOICE_ITEM.FOREIGN_NET_AMOUNT variable, click Clear, then enter the following expression:
TIP:You can copy and paste the expressions from this article into the Expression Editor window.
Click OK, then in the Properties pane click Sign, then click the arrow then click Signed.
Click Formatting, click the finder button then click the Numeric tab.
On the Max. decimals list, click 2, then click OK.
On the invoice layout, locate the Details section, then repeat steps 2 to 5.
On the invoice layout, locate the ITEM_NUMBER footer section, then repeat steps 2 to 5.
TIP: If you can't see the INVOICE_ITEM.FOREIGN_NET_AMOUNT variable in the ITEM_NUMBER footer section, right-click the Description variable, point to Order, then click Send to Back.
Amend the VAT column items to show negative values
On the invoice layout, locate the ITEM_NUMBER header section.
In the VAT amount column, double-click the INVOICE_ITEM.FOREIGN_TAX_AMOUNT variable, click Clear, then enter the following expression:
Click OK, then in the Properties pane click Sign, then click the arrow then click Signed.
Click Formatting, click the finder button then click the Numeric tab.
On the Max. decimals list, click 2, then click OK.
On the invoice layout, locate the Details section, then repeat steps 2 to 5.
On the invoice layout, locate the ITEM_NUMBER footer section, then repeat steps 2 to 5.
TIP: If you can't see the INVOICE_ITEM.FOREIGN_TAX_AMOUNT variable in the ITEM_NUMBER footer section, right-click the Description variable, point to Order, then click Send to Back.
Amend the unit price column items to show negative values
On the invoice layout, locate the ITEM_NUMBER header section.
In the Unit Price column, double-click the INVOICE_ITEM.FOREIGN_UNIT_PRICE variable, click Clear, then enter the following expression:
Click OK, then in the Properties pane click Sign, then click the arrow then click Signed.
Click Formatting, click the finder button then click the Numeric tab.
On the Max. decimals list, click 2, then click OK.
On the invoice layout, locate the Details section, then repeat steps 2 to 5.
On the invoice layout, locate the ITEM_NUMBER footer section, then repeat steps 2 to 5.
TIP: If you can't see the INVOICE_ITEM.FOREIGN_UNIT_PRICE variable in the ITEM_NUMBER footer section, right-click the Description variable, point to Order, then click Send to Back.
Save your amended layout and close Report Designer
On the menu bar click File, then click Save.
On the menu bar click File, then click Exit.
TIP: If you'd also like negative values to appear in red, you can do this using conditional formatting. Read more >>
NOTE: The standard invoice layouts available with Sage 50 Accounts v23 and above automatically show the negative item lines correctly.
then click the Numeric tab.
then click the Numeric tab.
then click the Numeric tab.