Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


General Ledger Entries

General Ledger Entries

General Ledger Entries

We're using SBT Pro 5.0 and I am needing to know if there is another way to add a year/period besides going in through ProFox. I'm not familiar with General Ledger so any information would be helpful. Thanks.

RE: General Ledger Entries

I am afraid there is no other way, however, the process is very simple.
If you need guidance, let us know. You must have the correct version of visual fox pro and determine what module (AR, AP,IC) is/are causing problems.

Integrated Bar Code systems, Inc.

RE: General Ledger Entries

I do need help doing this process. I've never done this, I have access to FoxPro and the accountant has done this several times so I know it can be done. Please Help!! Thanks so much!

RE: General Ledger Entries

This applies to ar,ic,ap.
For AP check the APDISTxx file fields GLPER,GLFYEAR,trandte
For AR check the ARDISTxx file fields GLER,GLFYEAR,trandte
For AR check the ARDISTxx file fields GLPER,GLFYEAR,trandte
Open foxpro and in the command window:
type the following command:
Open the cooresponding table,(apdistxx,icdistxx,ardistxx)
type the following command for example:
USE f:\pro50\ardata\ardistxx SHARED
type the following command:
This will give you records with missing data. Fill the corresponding fields, GLPER,GLFYEAR,TRANDTE


RE: General Ledger Entries

It is possible to do it throught VFP but it is definitly the wrong way, the hard way and the dangerious way.  Use the standard procedure described.  It takes and experenced programmer trained in accounting, SBT/ACCPAC methodology and VFP to do it the other way.  Only time I'd attempt it is if I had a customer really mess up the system and then I don't guarantee results.  I've been doing SBT since 88 and have several associates who are equally expierienced and have unlimited ACCPAC tech support because of the amount of product they sell.

Bill Couture

RE: General Ledger Entries

There is nothing wrong with our system currently. We're closing the month at the end of today and I didn't know how to start a new period. I haven't seen any errors or anything like that if that's what you mean. I'm trying to see if our accountant needs admin rights to the system. She says she does because she starts a new period through ProFox and I wanted to see if there was another way. Let me know what you guys think.

RE: General Ledger Entries

I have seen this problem with several of my customers.
They can't release to GL because of blank physical periods.
All the account data is intact, but the mentioned fields are blank. I don't know why.
As a warning, i should mentioned that if the accounts and amounts are correct, then by all means fill the blanks with the correct periods and date, otherwise consult a SBT /AccPac reseller.


RE: General Ledger Entries

You need to contact someone like me.  The accountant should not be closing through "PROFOX".  I assume you mean VFP or FoxPro 2.6.  This indicates your system has serious errors.  It should be looked at by a specialist.  It is likely there are other problems.

Sorry if this comes close to advertising can't figure any other way to say it.

Bill Couture

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close