previous year data added

[yukik]

We're using PeachTree8 Complete Accounting from 2001.

After Jul 2004 data, we encountered some corrupted data as follows.

1) In�h Maintain Inventory Items", "#Units Sold" field does not much the correct data. It affects the same field on Inventory Unit Activity Report.
2) In "Maintain Customer Prospect", history amount does not much the correct data.

It seems that both case added the previous year's data of each field.
For example,

Item#0000
Jul 2003 Unit Sold 22 (correct data)
Jul 2004 Unit Sold 87
(The qty of Jul 2004 should be 65 which is calculated from the BegQty and Qty on Hand.)

Once again, this problem started from Jul 2004 data and Jun 2004 or before data are all OK.

Please give me some advice to fix this problem, or let me know the possible cause of this corruption.

[TheWolf]

Run the Integrity Check, Inventory Journal Sync. Search this forum for instructions on that. I also recommend you upgrade and run a purge so that the old year data will be removed.

[yukik]

Thanks for your advice.
I already run a purge but it didn't work.
I'll try to run the Integrity Check.

[brentsalwasser]

What do I do if I've tried the integrity check? I'm having the same issues as yukik and we're using PT Complete 2003. I tried the steps below as outlined in another post here:

1) Back up data
2) Change period to first available period
3) Under file, select Integrity Check (I had to run exe -i to get this to appear as an option)
4) In that screen, select reindex files, and then reindex the following, one by one, in this order:
-line item
-inv cost
-journal header
-journal row
5) Run the following Data Synchronization test:
Inventory/Journal synch test

The inventory history is still off. I've also tried this procedure on a test upgrade to 2005 with the same results. Do I need to get it repaired?

thanks

[TheWolf]

You need to get it repaired then. Often a damaged transaction will keep the inventory/journal sync from completing. Click on the Data Damaged banner above.

[CnadineE]

I am currently running PT Complete 2005 and have upgraded yearly for over 5 years. I also noticed over a year ago that report totals for "inventory sold" were not accurate. They are showing activity as a TOTAL for more than one year than for the time period selected. I opened a trouble ticket with PT (history lost due to data crash) and was told that "this column shows what most users want" and they closed the ticket. This is very frustrating for me as I used this data often. I currently export more data than I need to Excel and manipulate from there to get what I am looking for.

I have run year-end purges every year without a change. I have not done the Integrity check referenced in this posting.

Thank you.

[Sue Seibert]

If, in fact, you don't get the information you are looking for, you should consider using Crystal or PAWCOM to design a new report. Check out the Crystal forum and www.multiwareinc.com

[CnadineE]

I have not heard of PAWCOM but I have an eval copy of Crystal Reports that I have not had time to try out. After the holidays, I will install and test it. Until then, we are VERY busy with our Choose & Cut tree farm. The "sold" numbers are an intregal part of our planning for future planting and seasons.

Thanks for the prompt reply and information.

[sbpressman]

I'm on PCAW 2004, and have noticed this problem for at least the past 8 years and countless versions. The "history" screen on the maintain inventory page, as well as inventory unit activity reports, pick up sales from prior years (always the same period). Thus, an item that has been out of stock for 3 years will show a sale of 3 in sold in a Unit Activity Report for 2004. If I narrow it down, I'll see the sale in November, for example -- when I know full well there was no sale. If I run a unit activity report, I'll see that 3 were sold in November 2001.

I've called, written, emailed, etc. to Peachtree support dozens of times over this issue. They refuse to admit there is a system bug. They insist my data is corrupt, suggest running integrity check, etc. None of this works, and the problem crops up in multiple companies -- so I know there isn't a data problem.

They are no help.

[TheWolf]

Originally posted by sbpressman
I'm on PCAW 2004, and have noticed this problem for at least the past 8 years and countless versions. The "history" screen on the maintain inventory page, as well as inventory unit activity reports, pick up sales from prior years (always the same period). Thus, an item that has been out of stock for 3 years will show a sale of 3 in sold in a Unit Activity Report for 2004. If I narrow it down, I'll see the sale in November, for example -- when I know full well there was no sale. If I run a unit activity report, I'll see that 3 were sold in November 2001.

I've called, written, emailed, etc. to Peachtree support dozens of times over this issue. They refuse to admit there is a system bug. They insist my data is corrupt, suggest running integrity check, etc. None of this works, and the problem crops up in multiple companies -- so I know there isn't a data problem.

They are no help.

Run regular purges and this should not occur. Since it cannot be duplicated in a controlled environment, it is not technically a bug but I do consider it a "weakness". Maybe they should force purges and an inventory/journal sync during the close process to prevent this.

[CnadineE]

I have run the Year-End Wizard and Purge for 2003. My inventory sales numbers STILL show more than one year of activity (in some cases up to 3 years!). As I mentioned before, I opened a ticket with PT support and was told "the report shows what the average user wants to see". Obviously, as shown by this thread, that is not accurate. I purchased Crystal Reports, as suggested, but have not been able to find a way to change the date range for the 'inventory items sold' report. It is using the "as of date", not a start/end range. I run several companies but only one has an inventory. The numbers sold is an important part of our planning/forcasting process. Having to export to Excel and manipulate the numbers there is an added and unnecessary use of my time!

[sbpressman]

I don't see how this is a "weakness" and not a "bug." It should be duplicatable in a controlled environment, inasmuch as there are so many users who are reporting it. I would venture to say that Peachtree simply has not identified the set of conditions required to duplicate the error. If they had, the error would show up in a controlled environment.

The bottom line is, they know this is an error that crops up in their program; it is not the fault of the user. Moreover, it affects critical data. Fixing it should be a top priority.

[TheWolf]

I have come across the error before but been unable to duplicate it. If Peachtree cannot duplicate it, then there is no way for them to fix it because you need to know what causes it. I have seen hundreds of data sets with this error when I was at Peachtree. What I have found is: all data sets had alot of unpurged data, had a lot of adjustments and went into negative on hands quite often.

[CnadineE]

I perform the following steps at every year-end:

Inventory physical count and associated adjustments - no negative numbers for quantity on hand.
Run year-end wizard.
Purge all inactive accounts/inventory items.

I STILL get totals that include more than one year of data! OR no data at all!!

Example:
If I run an inventory status report for Jan 2004 ONLY for an item with a year-end count of zero, the report "shows no data", which is correct. However, if I run the report for the full year, I get over 3 years worth of data in the number sold AND a large negative number for quantity on hand! Which, by the way, does NOT match the actual number sold in 2004. Some items which had items year-end 2003 and activity in 2004, show as "no data" when I run the full-year report!

As an aside, any new items created in 2004 are accurate. At least, the ones I have checked so far. I will know more when I do the full year-end count and update.

I am just going to use my tried and tested method - export sales detail to Excel and manipulate from there.

[TheWolf]

1) The purge until recently did not remove very many records. Have you checked to see how many old records are still left?

2) Does your system ever generate what is called a syscost adjustment?

3) How many years have you been using Peachtree?

4) Have you contacted Peachtree and offered for them to look at your data when it is exhibiting this problem?