[WebERP-developers] Issue with GLPostings.inc

[Pak R. <pak...@gm...>]

Hi Exson:

Today I merged your Postings.inc into my system and I think it's not
working as intended, as one account should have a bfwd = 0 but it is not.

I include all gltrans and the chartdetails regarding this account, so you
can check it out. All tx against this account sum zero, but in period 38
the bfwd is set to -255.000 and should be 0 if I understood the thing
properly.

I also checked after running: Z_RePostGLFromPeriod.php and
Z_UpdateChartDEtailsBFwd.php from initial period, and the result was the
same.

INSERT INTO `gltrans` (`counterindex`, `type`, `typeno`, `chequeno`,
`trandate`, `periodno`, `account`, `narrative`, `amount`, `posted`,
`jobref`, `tag`) VALUES
(204257, 25, 860, 0, '2011-09-30', 30, '111499000', '', 897000, 1, '', 0),
(205417, 0, 389, 0, '2011-10-02', 31, '111499000', '', -897000, 1, '', 0),
(315079, 25, 1061, 0, '2012-06-18', 39, '111499000', '', 138000, 1, '', 0),
(315089, 25, 1061, 0, '2012-06-18', 39, '111499000', '', 117000, 1, '', 0),
(315885, 0, 1457, 0, '2012-05-18', 38, '111499000', '', -255000, 1, '', 0),
(400468, 25, 1208, 0, '2012-10-24', 43, '111499000', '', 729000, 1, '', 0),
(405557, 0, 1972, 0, '2012-10-24', 43, '111499000', '', -729000, 1, '', 0),
(433485, 25, 1322, 0, '2012-12-20', 45, '111499000', '', 2075000, 1, '', 0),
(436736, 0, 2554, 0, '2012-12-20', 45, '111499000', '', -2075000, 1, '', 0);

INSERT INTO `chartdetails` (`accountcode`, `period`, `budget`, `actual`,
`bfwd`, `bfwdbudget`) VALUES
('111499000', 0, 0, 0, 0, 0),
('111499000', 1, 0, 0, 0, 0),
('111499000', 2, 0, 0, 0, 0),
('111499000', 3, 0, 0, 0, 0),
('111499000', 4, 0, 0, 0, 0),
('111499000', 5, 0, 0, 0, 0),
('111499000', 6, 0, 0, 0, 0),
('111499000', 7, 0, 0, 0, 0),
('111499000', 8, 0, 0, 0, 0),
('111499000', 9, 0, 0, 0, 0),
('111499000', 10, 0, 0, 0, 0),
('111499000', 11, 0, 0, 0, 0),
('111499000', 12, 0, 0, 0, 0),
('111499000', 13, 0, 0, 0, 0),
('111499000', 14, 0, 0, 0, 0),
('111499000', 15, 0, 0, 0, 0),
('111499000', 16, 0, 0, 0, 0),
('111499000', 17, 0, 0, 0, 0),
('111499000', 18, 0, 0, 0, 0),
('111499000', 19, 0, 0, 0, 0),
('111499000', 20, 0, 0, 0, 0),
('111499000', 21, 0, 0, 0, 0),
('111499000', 22, 0, 0, 0, 0),
('111499000', 23, 0, 0, 0, 0),
('111499000', 24, 0, 0, 0, 0),
('111499000', 25, 0, 0, 0, 0),
('111499000', 26, 0, 0, 0, 0),
('111499000', 27, 0, 0, 0, 0),
('111499000', 28, 0, 0, 0, 0),
('111499000', 29, 0, 0, 0, 0),
('111499000', 30, 0, 897000, 0, 0),
('111499000', 31, 0, -897000, 897000, 0),
('111499000', 32, 0, 0, 0, 0),
('111499000', 33, 0, 0, 0, 0),
('111499000', 34, 0, 0, 0, 0),
('111499000', 35, 0, 0, 0, 0),
('111499000', 36, 0, 0, 0, 0),
('111499000', 37, 0, 0, 0, 0),
('111499000', 38, 0, -255000, 0, 0),
('111499000', 39, 0, 255000, -255000, 0),
('111499000', 40, 0, 0, -255000, 0),
('111499000', 41, 0, 0, -255000, 0),
('111499000', 42, 0, 0, -255000, 0);

Regards,
Ricard