ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> ABusiness Status balance off
http://www.istechforum.com/YaBB.pl?num=1155826015

Message started by BEEJAY2766 on 08/17/06 at 06:46:55

Title: ABusiness Status balance off
Post by BEEJAY2766 on 08/17/06 at 06:46:55

I have been checking the Business Status balances for A/R and A/P and the receivable balance is fine, but the A/P balance is low. It remains low by a certain dollar amount that never changes. I have been checking for months now and it always remains low by this figure compared to the aging balance in the Accounts Payable.
Anyway to fix this error

Beverly

Title: Re: ABusiness Status balance off
Post by cathyh on 08/17/06 at 08:12:51

I have successfully corrected a balance that is consistently off from month to month by using Maintain Database. The file is ISBSF.Bxx where xx is the company code.
First you have to figure the amount off. And which month it started in or how far back you care to go in months. I always run the Business status to make sure the balances are up to date before I start editing the balances. To edit the balances, go to maintain database open up the ISBSF file and choose only the end date and the file you are interested in, in this case APBAL. Add the amount off to the current balance for each month and enter that into the APBAL field. YOu might want to do this in a spreadsheet before you start editing.
Hope this helps.

-----
PS -- Sometimes the dates in the ISBSF file are not in order. Make sure you are entering the right number into the right date.