Issue with GLPostings.inc

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Issue with GLPostings.inc

Pak Ricard
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

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with GLPostings.inc

ExsonQu
Administrator
Hi, Richard,

          Thank you for your test. You're right. It should be zero.  Let me fix it later.

          Thanks and best regards!

          Exson
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with GLPostings.inc

ExsonQu
Administrator
In reply to this post by Pak Ricard
Hi, Richard,

         I've revised the file as attached. Would you like to check if it fixes the problem?

         Thanks and best regards!

         ExsonGLPostings.inc
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with GLPostings.inc

ExsonQu
Administrator
In reply to this post by Pak Ricard
Hi, Richard,

              I've reworked the GLPostings.inc. But I have lost the test data. Would you like to test if it  fixed the problem?

              Thanks and best regards!

              Exson

GLPostings.inc
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with GLPostings.inc

Pak Ricard
Hi Exson:

I tested it and now it does not show the previous calculation error, so I suppose it's working fine now. Many thanks!

Regards,
Ricard

2016-02-23 20:59 GMT+08:00 ExsonQu <[hidden email]>:
*Hi, Richard,*

              I've reworked the GLPostings.inc. But I have lost the test
data. Would you like to test if it  fixed the problem?

              Thanks and best regards!

              Exson

GLPostings.inc
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658516/GLPostings.inc>




--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Issue-with-GLPostings-inc-tp4658512p4658516.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers


------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with GLPostings.inc

ExsonQu
Administrator
Hi, Richard,

              Thank you very much for your test!

              Best regards!
             
              Exson
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Issue with GLPostings.inc

Pak Ricard
Hi Exson:

It's just the opposite way. It's me (and for sure all of other developers) thanking you for all your dedication and cooperation :-)

Regards,
Ricard

2016-02-24 8:41 GMT+08:00 ExsonQu <[hidden email]>:
*Hi, Richard,*

              Thank you very much for your test!

              Best regards!

              Exson



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Issue-with-GLPostings-inc-tp4658512p4658518.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers


------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Web-erp-developers mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/web-erp-developers
Loading...