Transaction report treating JC/JD transaction differerntly

SUGGESTED

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

Parents
  • 0
    SUGGESTED

    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

  • 0 in reply to Michael Goossens

    HI Micheal,

    I'm using the Transactions - Transaction Report - Transactions CSV (extended) report and an example of what is happening is this:

    So on the nominal activity screen on one of our income codes it looks like 2 line items - one JC transaction and one CR transaction both showing as credits on the nominal income code.

    But when you export to excel from the Transaction report in Transactions - Transaction Report - Transactions CSV (extended) the CR transaction shows as a positive value and the JC as a negative value.

    So it makes it very difficult to follow what the values actually are for each code on the excel report.

    Regards

    Helene

  • 0 in reply to Helene Jaumotte
    SUGGESTED

    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

  • 0 in reply to Michael Goossens

    Hi Micheal,

    I have to admit i'm rather shocked by this reply. I really don't understand why a system would be designed to produce such a useless report, especially with not warnings on the report that it treats transactions in this inconsistent way. Especially as it's one of the few that work when the previous year is not rolled forward.

    Surely if you imported the export i've just made then you would end up with loads of debits which should be credits on the CR transactions? If not, then the import is on transaction type then why can't it recognise the the JC transaction is also a credit that should be flipped as well given that JC = Credit Journal?

    I'm trying to get a transaction listing report to get around another problem with the sage system in that non of the management reports work until the previous year has been closed which doesn't fit with the concept of audit timelines and audit adjustments as neither of the two solutions offered there, (either constantly closing the year, doing the report and then restoring from a backup or doing manual entries to correct both c/f and b/f entries) i find at all acceptable practice.

    I am new to Sage and had heard good things about it but I would never recommend it based on what i've seen so far as it doesn't seem to have been designed with accountants in mind at all.

    Are there any other reports that would give me a sensible transaction listing that work without previous year close down? and if not, some sort of guide to how this one treats all of the transaction types so I can adjust for it in the working paper?

    Kind Regards

    Helene

  • 0 in reply to Helene Jaumotte
    SUGGESTED

    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

Reply
  • 0 in reply to Helene Jaumotte
    SUGGESTED

    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

Children
No Data