GL Being Duplicated When Posting a Supplier Bill Fix

Interprise Suite Community

Home

Members

Calendar

Who's On

Welcome Guest ( Login | Register )

GL Being Duplicated When Posting a Supplier...

Rate Topic

Display Mode

Topic Options

Message

Posted 5/21/2009 3:42:59 PM

Post #108

BJ Dimes

There is a bug in the stored procedure that posts the supplier bills in the 5.3.1 Version. If you put in a supplier bill and on that bill there is anything in the 'Expense' tab, the general ledger activity for that expense will be duplicated (usually happens when you put in a regular expense bill or if you have other expenses on an invoice linked to a GRN). You will see two detail lines for that expense item be created as well as the accounts payable account be doubled in the general ledger.

A fix has been created. You will need to do the following to install this fix:

1) Download the following SQL Script from http://www.dimesoftinc.com/PostVendorBill.zip
2) Get everyone out of IS and the website (if you have one)
3) Open SQL Management Studio
4) Backup your SQL Database(s)
5) Unzip the zip file into a location your SQL Server can access
6) Open the SQL Script
7) Make sure you select your SQL Database(s)
8) Execute the SQL Script.

This script will replace your existing PostVendorBill Stored Procedure.

If you have run across any supplier bills that had GL Activity Duplicated, the only way to fix this is to do a Journal Entry between the duplicated account and the accounts payable account. This will bring everything back in line. If correct, your AP Aging should match whats on your Trail Balance.

BJ Dimes
Software Development & Support Engineer
DimeSoft Business Solutions, Inc.
Interprise Suite Plugins
Interprise Suite Blog