Stonefield Query
 
Stonefield Site Map
 
 You are here: Support * Support Forums   Search

 Stonefield Query Support Forum

Welcome to the Stonefield Query Support Forum. Please note that in order to participate in the support forums, registration at our site is required. If you are already a member of our site, please sign-in.

 
Forums > Stonefield Query Solutions > Sage Pro ERP Reporting - Support
Subject: Credit notes show as postve number

You are not authorized to post a reply.   

Author Messages
kjc@xitron.com
Posts:1
07/17/2008 2:49 AM Alert 

I am trying to run a report showing sales by state that includes all document types. Invoices and Debit Memo totals show correctly as a positive number but Credit Notes also show as a positive number,  I have tried the expression builder and everything else I can think of to get the Credit Note to show as a negative number.

Any ideas?
tmansuy
Posts:153
07/17/2008 9:18 AM Alert 

Hi,

If by default it is showing up as a positive number, that means it is being stored in the database as one. However, you can enter the advanced report designer (click the edit button after turning on the advanced layout checkbox in step 5). For each of the fields that you want to appear as negative, multiply it by -1. So, if the old expression was:

fieldx

Change it to:

fieldx * -1

 

Trevor
You are not authorized to post a reply.
Forums > Stonefield Query Solutions > Sage Pro ERP Reporting - Support > Credit notes show as postve number


ActiveForums 3.6

 
 
   Privacy Statement  |  Terms Of Use
© 1996-2008 Stonefield Software Inc. All rights reserved.