Try deleting the following files in the company's data folder if you do not use the Action Item System in Peachtree:
Alarm.dat
Alert.dat
Eventlog.dat
When you open your Peachtree company, you will be asked if want to create a new Alarm or a new Alert or a new Eventlog.
Say "Yes" and create new...
So the prior post should have included two questions:
1) How do I get the report to only include the items I've asked for in my selection ({LineItem.ItemID} <> "M10920" and {LineItem.ItemID} in ["M10055" to "M999800"])?
2) How do I get the correct formula so the report displays the units sold...
Don't know if I should start a new post, or just post the additional question here, since it is the same report.
My report is not pulling the transactions for Last Year.
My selection formula:
{JrnlRow.Journal} = 3 and //this pulls sales transactions
{LineItem.ItemID} <> "M10920" and...
I am using Sage 50 (Peachtree) Quantum 2013, Crystal Reports 2008 and PSQL is the database engine.
I am designing a report to show Units Sold for Inventory Items for a specific date range and Units sold for Inventory Items Last Year (which is specific date range less one year).
I am getting an...
I've been supporting Peachtree since 1988. As far as I know you need a dedicated workstation in order for the remote user.
Peachtree should be able to install on the server where the data is stored. There are many times you may have to troubleshoot a problem and having the application on the...
I'm using Lytec 2010, a MS SQL database and Crystal Reports v9. I want to have reports I create for Lytec available for any practice. If I have created an ODBC connection with the default database as Lytec Tutorial, how do I make other databases or medical practices have the ability to run the...
I have created ODBC connections before, but not with Lytec.
I was hoping I could follow someone's step by step instructions. There are a lot of fields on each window for setting up a connection. I'm assuming I would use the System DSN tab to start creating, but after that I don't know...
Lytec 2010 is a medical specific software and uses Microsoft SQL as the database engine.
There are canned crystal reports that come with Lytec, but I want to create a new report.
Do you know how I can connect crystal reports v9 or crystal reports 2008 to the Lytec 2010 database?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.