Hi there - newbie to accounting and the software packages... work as a techie and I need to extract journal entries from Sage 50 UK (v20.04) , database table (AUDIT_JOURNAL) - is there a way to determine if a journal entry has been reversed ? is there a column in the AUDIT_JOURNAL that determines this ...
or is there a way to work it out by analysing the entries
Thanks in advance.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
how to determine if a Journal entry has been reversed
-
johnsonpaine
- User
- Posts: 1
- Joined: 23 Aug 2014, 16:39
- Sage Version: Other
-
brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: how to determine if a Journal entry has been reversed
There is no easy way to tell if a journal has been reversed.
The first step would be to clarify what you mean by "reversed" Journals can be manually reversed, reversed on a future date, reversed in journal reversals and so on. The journal could be the whole journal or just one part of a journal.
I guess the question is why do you want to know/ what is the objective? as there may be another way.
The first step would be to clarify what you mean by "reversed" Journals can be manually reversed, reversed on a future date, reversed in journal reversals and so on. The journal could be the whole journal or just one part of a journal.
I guess the question is why do you want to know/ what is the objective? as there may be another way.
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: Google [Bot], Semrush [Bot] and 1 guest