cjhusky
09-06-2002, 01:53 AM
A company that I do "jack of all trades" IT work for uses Peachtree 7.0.05.109. I have become semi-proficient in its use, but do not claim to be an expert.
I am doing Report "Exports" as I always have for them (Saved Reports with Filters), but for some reason I am now getting duplicate results for some of the data. The custom report I have always used is for viewing customer Accounts Receivable on a month by month basis. I do the standard export and choose ONLY the fields for Sales-Period End 01/02, 02/02, 03/02...etc up to 08/02. This enables them to see the Accounts Receivables, by month, by customer. The only problem is, for July and August (07/01/02 to 07/31/02 & 08/01/02 to 08/31/02), the report is strangely combining the results of 2001 and 2002 data. The other months are fine, but from July on, it is adding the cumulative results of 2001 and 2002. Thus, if I run an Accounts Receivable report export, exactly the same way for 12/02, which has not yet occurred, I get the results for 12/01. Sales-period ending 12/01 is "unchecked." All the months prior to July, retunr perfect data (both 01 & 02)
I do not think the data is corrupted, because everything else seems to look perfectly normal. Is there another way to check and see if the data has been appended? I get the same thing when I run a Sales Report from the reports pulldown.
Has anyone else seen this behavior? Have I erroneously changed an option somewhere that would cause this? Is there something i did to accidently append the data (I am NOT selecting "append data"...my export option is to overwrite). Please help!
if in fact the data is corrupt, what is the recommended way to "rebuild" the company?
Any help would be appreciated.
Thanks,
Chris
CJHusky@hotmail.com
I am doing Report "Exports" as I always have for them (Saved Reports with Filters), but for some reason I am now getting duplicate results for some of the data. The custom report I have always used is for viewing customer Accounts Receivable on a month by month basis. I do the standard export and choose ONLY the fields for Sales-Period End 01/02, 02/02, 03/02...etc up to 08/02. This enables them to see the Accounts Receivables, by month, by customer. The only problem is, for July and August (07/01/02 to 07/31/02 & 08/01/02 to 08/31/02), the report is strangely combining the results of 2001 and 2002 data. The other months are fine, but from July on, it is adding the cumulative results of 2001 and 2002. Thus, if I run an Accounts Receivable report export, exactly the same way for 12/02, which has not yet occurred, I get the results for 12/01. Sales-period ending 12/01 is "unchecked." All the months prior to July, retunr perfect data (both 01 & 02)
I do not think the data is corrupted, because everything else seems to look perfectly normal. Is there another way to check and see if the data has been appended? I get the same thing when I run a Sales Report from the reports pulldown.
Has anyone else seen this behavior? Have I erroneously changed an option somewhere that would cause this? Is there something i did to accidently append the data (I am NOT selecting "append data"...my export option is to overwrite). Please help!
if in fact the data is corrupt, what is the recommended way to "rebuild" the company?
Any help would be appreciated.
Thanks,
Chris
CJHusky@hotmail.com