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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

General Ledger Entries

Status
Not open for further replies.

ldunn

IS-IT--Management
Jul 26, 2005
17
US
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.
 
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.
Edgar
 
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!
 
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:
SET CENTURY ON
Open the cooresponding table,(apdistxx,icdistxx,ardistxx)
type the following command for example:
USE f:\pro50\ardata\ardistxx SHARED
type the following command:
SET FILTER TO EMPTY(glper)
This will give you records with missing data. Fill the corresponding fields, GLPER,GLFYEAR,TRANDTE

EMC
 
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
 
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.
 
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.

emc
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top