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!

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

sbt ending balance

Status
Not open for further replies.
Jul 22, 2014
8
PH
Hi Sir,


im newbie on sbt pro 5.0, can you please help me, i am wondering why the two account in GL is not been forwarded as the beginning balance OF january since we already close
in year end period

the ending balance of December is not fully forwarded to the beginning balance of January?


Any Idea on this?

I really appreciate you help



Thanks
Woundedxoul (M.I.S HEAD)
 
If the accounts are income statement accounts, then this is correct behavior. Income statement accounts are zeroed at the end of the year. The profit (or loss) for the company from the income statement is moved to the Retained Earnings account on the balance sheet.

If they are balance sheet accounts, this is wrong.

Matthew Lefkowitz
Lefkowitz Systems, Inc.
 
Hi woundedxoul

Good day!

That was happening in our sister's company but never been happening in us.

Obviously, you meant to a Real Account other than a Nominal Account because P&L will eventually summarized/closed to your Retained Earnings while Real Account will submit ending balance, as beginning balance of the new fiscal period.

As I thorough review the database, I noticed that the fictitious account has two records in "glbalsxx.dbf" (I mean two account title in the accounting period. Normally, only one account title per accounting period). This is the result of the direct intervention of the programmer to edit something in the SBT database. This is a bad practice but for some other reasons, programmer are opted to do this to correct something but unintentionally worsen some part of the recording.

Solution requires the expertise of the programmer to terminate the other account with zero (0.00) "glbalsxx.fybgbal". This cannot be corrected by using the Journal Voucher to adjust balance. If so, you might correct it but just reclassify it in the other account.



FarEast...
 
Also.... please double check the ending balance of December and this will be the balance for January. Implement the beginning balance, glbalsxx.fybgbal in database from January to December.

I appreciate that our SBT Pro5.0i is still working in other part of the world.

Good Luck.

FarEast...
 
There is a GLFIXBAL utility program for SBT Pro 5.0 that checks for various discrepancies in the SBT Pro GL. I think it looks for duplicate account numbers. It certainly checks for account-period continuity problems in GLBALS such as the one you describe with FYBGBAL.

The program can be run in "report" mode where it only identifies discrepancies but does not fix them, and in "update" mode where it fixes problems it finds.

The program has saved me and my clients on many occasions.

Matthew Lefkowitz
Lefkowitz Systems, Inc.
 
Hi Sir mlefkowitz and Mandarigit,


Thanks for the response, just i though , Mandaragit is right, and i already solve it,. the double entry on the databases who having zero value are the reason why the account is not
fully forwarded, By the the way what is GLFIXBAL sir mlefkowitz?, where i can find those utility program?


Thanks
Woundedxoul (M.I.S HEAD)
 
I think that this "glbalfix" is a custom program and not part of the SBT package. Just like the program I created that if any of my staff tried to do something or can intentionally destroy the SBT Bookkeeping, or worse case scenario "zap" accounting bookkeeping, it will restore everything in the file(bookkeeping). Although I prohibit them to do support in any general ledger reports, but for some curiosity, somebody are doing so. Of course no IT job request (no control) for this so its hard to trace the root cause of the recurring problem as a result of what they did.

There is a utility program in SBT(log-on as system manager to go transaction.system recovery.recalculate application balances). In some other issue, may be helpful but not at all time. Problem originated from system hang-up, power failure, network problem and internal consistency error (especially company using the windows vista and up, because this usually buffers your records in the server). Problems caused as stated, will generally requires your in-house IT or development team to aids you.

I my office, I created various audit programs to improve confident level of our Accountants and Management as a whole. Like...

1] Validating that whatever for SO are 100% transfered(no addition/no deduction) to Sales Book and Inventory Book
2] That Receivable MUST be the same with your Sales Report.
3] That your SL must be equal to AR and must be equal to GL.
4. That your General Ledger report must be the same as what is reflected in the FS (Trial balance, P & L and Balance Sheet Report)

I mentioned this to you as your reference to do some improvements for the future if any of this is not yet existing in your Routine. In this way, I believed I can help SBT community stay long in the future.

There are also some good people I see here supporting SBT community. Let us listen them and ask their expertise anytime...

Good luck and have a blessed day everyone...



FarEast...
 
..."internal consistency error". I am referring to "internal INconsistency error"...

FarEast...
 
GLFIXBAL was written by a programming at SBT a long time ago and made available to SBT consultants. It looks for and, optionally, fixes discrepancies in the SBT General Ledger for a single company.

You put it into the SBT root folder and start Foxpro. Type DO GLFIXBAL from the Command window to start it.

You can run it in "report-only" mode in which the program reports all discrepancies to a text file. And you can run it in "update" mode in which the program fixes the discrepancies it finds.

The utility is public domain and carries no warranty or any other protection. Use it at your own risk!

Make a back-up before running it.

There are two versions, one for SBT Pro 5.0, 6.0 and 6.5 and another for Pro 7.x.

You can find both here in my Box FTP site:

Matthew Lefkowitz
Lefkowitz Systems, Inc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top