Transaction report treating JC/JD transaction differerntly

Question

Hi 
 
 When running a transaction report I understand that the signs are switch for the 'normal balance' rule so anything crediting an income code would appear as a positive number in the transaction report. 
 
 On the reports i've been running recently This seems true of all transactions EXCEPT JC/JD transactions whose sign does not change so a credit to a revenue code stayed as a minus throwing out the numbers completely for any sort of summarisation. 
 
 Why would Sage be doing this and if it must for some reason - is there anyway around this to make all the line items to be treated consistently? 
 
 Thanks 
 Helene

Michael Goossens · Answer

Hi Helene, 
 Thanks for using Sage City. 
 Which report are you specifically talking about that is treating these differently? 
 The sign usually wouldn't change on JC and JD as this is determined by the nominal area your posting too, so this may change for example a JC is a credit. But this would not act the same in Sales and Purchases for Example. 
 
 Regards, 
 Michael Sage UKI

Michael Goossens · Answer

Hi Helene, 
 Thanks for using Sage City and for your reply. 
 
 Yes this report is completely unsigned as how it acts is dependant on the transaction type column, This is by design so when you export using these reports, they import directly back into the program without having to make any changes. 
 What are you using this report for? if for reconciling figures i would be looking at using another report as this report is mainly just used for export and import. 
 Regards, 
 Michael Sage UKI

Michael Goossens · Answer

Hi Helene. 
 This report is just one of many many reports in Sage, This report is specifically designed for export of transactions to CSV files which we would not recommend to use for for reconciliation purposes. 
 When you say none of the management reports work, is this for previous Financial Years or the current Year you are in just the previous has not been closed down? 
 If this is the case you will be able to use the Transactional Management Reports. 
 These are found in Nominal Codes > Reports > Balance Sheet/Profit and Loss/Trial Balance > These should then give you the live to date figures if needed. 
 If your looking If your looking for a correct listing of Transactions i would use either the Nominal Activity reports. or the Customer and Supplier Day-book Reports these will then give an accurate transaction listing. 
 If you have specific questions i would contact our telephone team on 0191 479 5955 or come to our live chat online here . We can then guide you to the best reports for exactly what you need. 
 Kind Regards, 
 Michael, 
 Sage UKI

Sage 50 Accounts

Transaction report treating JC/JD transaction differerntly

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING