I am quite baffled by this inventory profitability report which once again seems to b

[swaco]

I am quite baffled by this inventory profitability report which once again seems to be in error. CurrentlyI am quite baffled by this inventory profitability report which once again seems to be in error. Currently it shows units sold as being about twice as many units as I would normally sell for these five item descriptions but it also shows sales to be for the most part about twice as much, a little more then twice as much for each of the five items I that I sell. What is causing erroneous report, where does the information come from? What is derived to compile the inventory profitability for this one month? This is not the first time this is happened. I did run rebuild company and that didn’t change anything. I sure would like the right quantities, for example instead of selling 9,000 units sold for this one item why can’t we just show the correct amount which is right around 4,000. Just curious as to what your thoughts might be as to this problem. Thank you for your valuable input.

[GeorgeRichardso]

Steve,
I would suspect this has to do with the inventory/history "feature" where any search seems to apply to a month across all years. In short, I would bet that your report combines the questioned month this year and last year. I hope this has been addressed in the 2003 release. ( Can any beta tester confirm this?).

No work around that I know of.

Good luck,

George

[TheWolf]

THis sounds more like a sync problem to me as my reports show fine. I dug up an old email sent to me that has directions on how to run an inventory/journal sync test:

Inventory/Journal Sync Test

Please change to accounting period one before doing the following.

Loading Peachtree with Integrity Check


In Windows 95, 98, or NT:

Go to the Start Menu and Choose Run
Type in c:\peachw\peachw.exe -i

This will load Peachtree with two new options under the FILE menu. Never choose these options without being instructed to do so by a Peachtree Technical Support Person.

Choose File and Integrity Check.

Choose to make a Backup. Choose Simple Copy and for the destination type in today's date.
For instance if today was April 1, 1998, I would type in 040198

In the Integrity Check Screen, run these tests:

Check off Reindex Files on the left and choose Chart on the Right and click OK
Go back into File->Integrity Check. Click Continue.
Check off Reindex Files on the left and choose Journal on the Right and click OK
Go back into File->Integrity Check. Click Continue.
Check off Reindex Files on the left and choose Lineitem on the Right and click OK
In Release 8 the Journal file has been split into two different files, Jrnl Header and Jrnl Rows. Only reindex Jrnl Header and do not reindex Jrnl Rows. If you have the 8.02 Update you should go ahead and reindex Jrnl Rows.
Go back into File->Integrity Check. Click Continue.
Check off Inventory/Journal under the Data Synchronization Tests and click OK

This test will take a while. Take note of any errors encountered along the way.

Once the test is done, check your reports to make sure the problem is resolved.


Hope this helps.