Looking for field controlling "Don’t show corrections"

Question

Hello everyone, 
 I have exported data from Sage 50 to Microsoft Access through ODBC. In Sage, whenever we produce reports, for example Project Income, we have an option to check or uncheck show "Corrections". Which field controls for this boolean switch and in which table? I figured it has something to do with the ntype field in tJourEnt table because its function is to show journal entry type but this doesn't account for the whole inclusion/exclusion from reports. Anybody can help with this? Thanks so much.

Marc Adjami · Accepted Answer

I was referring to Sage 50. Your answer above helps out a lot for what I need to get done right now. Thanks so much Richard! :)

Richard S. Ridings · Answer

Sorry, I read you original message that you were looking for the flag itself, which I indicated was in the trptopts table. 
 Marc Adjami said: when we run a report like Project Income and check off "show corrections" so that they are not included, we still see 32s and 64s and so on? 
 First, because you are now talking about two different programs, you must tell us which program you are referring to. Help us help you. 
 Now I have to assume you mean Sage 50. And if I am correct, you are using the checkbox incorrectly. Think of Show Corrections as the statement, I want to see corrections. If it is checked, then Yes, I want to see corrections. If it is unchecked, then I do not want to see corrections. 
 If blnCorrections Then
	strCorr = " AND `nType` >= 0"
Else
	strCorr = " AND `nType` < 30"
End If 
 The above code is part of what I use in one of my programs to build a WHERE clause of my SQL statement that either shows or does not show corrections. This is not the whole statement as I have other parameters being added in (eg. Date range) but it is how I build the clause. There are other ways to do this including hard-coded selection to always ignore or always show, but it sounds like you need the option and this is one way to do it. 
 The checkbox in your Access program should feed into something like my blnCorrections boolean variable and you can build your SQL statement in the same manner.

Sage 50 Canada

Looking for field controlling "Don’t show corrections"

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING