Welcome, Guest. Please Login.
05/30/25 at 22:46:00
News:
Home Help Search Login


Pages: 1
Send Topic Print
ABusiness Status balance off (Read 305 times)
BEEJAY2766
Browser
*


I love YaBB 1G -
SP1!

Posts: 3
ABusiness Status balance off
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
Back to top
 
 
  IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: ABusiness Status balance off
Reply #1 - 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.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print