Profit and Loss Statement Screwy After Upgrade
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
Profit and Loss Statement Screwy After Upgrade
by sunshine33777
::
Rate this Message:
I just upgraded from 3.0.71 to 3.11 on October 8th.
I just ran a P&L for October and noticed this discrepancy in the Sales section (numbers have been changed) Sales total 0 0 0 Revenue Account Account Name Period Actual Period Budget Last Year 4100 Product / Service Sales 9,807 0 8,978 4200 Sales Exchange Gains/Losses -7,530 0 0 4500 Consulting Services 0 0 0 4600 Rentals 0 0 0 4700 Finance Charge Income 0 0 0 4800 Sales Returns & Allowances 0 0 0 4900 Sales Discounts -1,285 0 -931 Revenue total 991 0 8,047 Notice the 4200 posting of -7,530. That didn't get posted last year. Revenue should have been close to the year before, not 991. I did a check through the MySQL gltrans and noticed that payments were posting to 1040 and 1100 accounts as a type 12. After October 8th gltrans payments were posting to 4200 and 1100 as a type 12. I went though my company configuration settings and don't see anything out of the ordinary. What's wrong here? |
|
|
Re: Profit and Loss Statement Screwy After Upgrade
by sunshine33777
::
Rate this Message:
Any hints?
On Thu, Nov 5, 2009 at 1:58 PM, sunshine33777 <tronno22556@...> wrote:
-- Sunshine Locksmith Team -Tampa Bay Area Locksmiths http://www.sunshinelocksmith.com ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
|
Re: Profit and Loss Statement Screwy After Upgrade
by Tim Schofield
::
Rate this Message:
Hi,
3.071 to 3.11 is a big jump. Can you give me some idea of the transaction(s) that created the -7530. (send them to me off list if you want). Do you trade in multi currencies? I know a lot of multi currency changes have been done to the code since 3.071 but I dont remember exactly what. Lets try to narrow the problem down first. Tim 2009/11/5 sunshine33777 <tronno22556@...>: > > I just upgraded from 3.0.71 to 3.11 on October 8th. > > I just ran a P&L for October and noticed this discrepancy in the Sales > section (numbers have been changed) > > Sales total 0 0 0 > Revenue > Account Account Name Period Actual Period Budget Last Year > 4100 Product / Service Sales 9,807 0 8,978 > 4200 Sales Exchange Gains/Losses -7,530 0 0 > 4500 Consulting Services 0 0 0 > 4600 Rentals 0 0 0 > 4700 Finance Charge Income 0 0 0 > 4800 Sales Returns & Allowances 0 0 0 > 4900 Sales Discounts -1,285 0 -931 > Revenue total 991 0 8,047 > > Notice the 4200 posting of -7,530. That didn't get posted last year. > Revenue should have been close to the year before, not 991. > > I did a check through the MySQL gltrans and noticed that payments were > posting to 1040 and 1100 accounts as a type 12. > > After October 8th gltrans payments were posting to 4200 and 1100 as a type > 12. > > I went though my company configuration settings and don't see anything out > of the ordinary. > > What's wrong here? > -- > View this message in context: http://old.nabble.com/Profit-and-Loss-Statement-Screwy-After-Upgrade-tp26217380p26217380.html > Sent from the web-erp-users mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > web-ERP-users mailing list > web-ERP-users@... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ web-ERP-users mailing list web-ERP-users@... https://lists.sourceforge.net/lists/listinfo/web-erp-users |
| Free embeddable forum powered by Nabble | Forum Help |
