From ed244221e01981722b721cb461fa8fb38ec8a7d0 Mon Sep 17 00:00:00 2001 From: garyhgohoos Date: Mon, 14 Jul 2014 10:55:58 -0400 Subject: [PATCH] Issue #24144:call postItemlocSeries which posts G/L --- foundation-database/public/functions/balanceitemsite.sql | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) diff --git a/foundation-database/public/functions/balanceitemsite.sql b/foundation-database/public/functions/balanceitemsite.sql index 853876054..3ae61d0d2 100644 --- a/foundation-database/public/functions/balanceitemsite.sql +++ b/foundation-database/public/functions/balanceitemsite.sql @@ -35,10 +35,8 @@ BEGIN FROM itemsite WHERE (itemsite_id=pItemsiteid); --- Post the invtrans records associated with the itemlocdist records - PERFORM postInvhist(itemlocdist_invhist_id) - FROM itemlocdist - WHERE(itemlocdist_series=_itemlocseries); +-- Post the itemloc series which will postIntoTrialBalance and postInvHist + PERFORM postItemlocSeries(_itemlocseries); -- Kill the resultant distribution records DELETE FROM itemlocdist -- 2.39.2