Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What table for P&L account balances from previous years 2

Status
Not open for further replies.
johnhugh

johnhugh

Technical User
Mar 24, 2010
702
SG
Hi, In Accpac 6, which table can I use to retrieve P&L Balances for previous years?
GLAFS only holds the balances of the current financial year for P&L accounts.
 
Sort by date Sort by votes
Balances are not available for P&L accounts - only net movement per period.
 
Upvote 0 Downvote
Ah, got it now.
Mistake in my SQL qery.
Thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

vbdbcoder
  • Locked
  • Question
Day End Error (POLINEZ table)
Replies
3
Views
611
vbdbcoder
vbdbcoder
vbdbcoder
  • Locked
  • Question
"Ship All" function does not work for 1 customer
Replies
2
Views
360
vbdbcoder
vbdbcoder
Ilia Deviatov
  • Locked
  • Question
C# COMAPI Create Cashbook batch with entry type Accounts Payable
Replies
1
Views
344
Ilia Deviatov
Ilia Deviatov
hushman
  • Locked
  • Question
Deleting quotes from Sage 300
Replies
2
Views
281
ettienne
ettienne
Hemanth3526
  • Locked
  • Question
80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG))
Replies
2
Views
500
Hemanth3526
Hemanth3526

Part and Inventory Search

Sponsor

Back
Top