Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035743
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2017-04-10 13:262017-05-29 17:43
ReporterngarciaView Statuspublic 
Assigned ToAtulOpenbravo 
PriorityurgentResolutionfixedFixed in Version3.0PR17Q3
StatusclosedFix in branchFixed in SCM revision21e5d56eca66
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toaferraz
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035743: Accounting Templates for payments are not taken into account if the Acct Server Process is scheduled at System level

DescriptionAccounting Templates for payments are not taken into account if the Acct Server Process is scheduled at System level.

Both acctSchemaTableDocTypes and acctSchemaTables lists are empty as the OBQuery.list is filtering by ad_org_id in ('0') and ad_client_id in ('0')
Steps To ReproduceAs system admin role:
   Install the 'Timing of VAT booking for Sales Storno Invoices' module in order to have an accounting template for payments
   Set as Displayed the Accounting Template field in the following tabs:
      General Ledger Configuration - Active tables
      General Ledger Configuration - Active tables - Documents

As group admin role:
   Unschedule the Acct Server Process

1
   Go to General Ledger Configuration and select FIN_Payment table in Active tables window
   Add a record in its Document tab:
      Document Category: AR Receipt
      Accounting Template: Accounting Engine - Financial Payment
   Create a Payment In that should be posted in the configured general ledger
   Configure the financial account to post that payment (In Transit Account)
   Schedule the Acct Server Process and check the Payment In is posted using the template
   (You could put a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable has a value)

   Unpost the payment

As system admin role:
   Schedule the Acct Server Process and check the Payment In is not posted using the template but the common process
   (You could put a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable is empty)

As group admin role:
2
   Unpost the Payment In
   Go to General Ledger Configuration and select FIN_Payment table in Active tables window
   Add the 'Accounting Engine - Financial Payment' as Accounting Template in Active tables tab
   Remove the record in its Document tab:

   Schedule the Acct Server Process and check the Payment In is posted using the template
   (You could put a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable has a value)

   Unpost the payment

As system admin role:
   Schedule the Acct Server Process and check the Payment In is not posted using the template but the common process
   (You could put a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable is empty)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0096057)
AtulOpenbravo (developer)
2017-04-18 19:18
edited on: 2017-04-18 19:19

- Login as system admin role:
- Install the 'Timing of VAT booking for Sales Storno Invoices' module in order to have an accounting template for payments
- Set as Displayed the Accounting Template field in the following tabs:
  - General Ledger Configuration - Active tables
  - General Ledger Configuration - Active tables - Documents

- Login as Group Admin role:
- Unschedule the Acct Server Process

Check 1:

- Go to General Ledger Configuration and select FIN_Payment table in Active tables window
- Add a record in its Document tab:
      Document Category: AR Receipt
      Accounting Template: Accounting Engine - Financial Payment
- Create a Payment In that should be posted in the configured general ledger
- Configure the financial account to post that payment (In Transit Account)
- Schedule the Acct Server Process and check the Payment In is posted using the template by adding a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable has a value.
- Unpost the payment
- Login as System Admin role:
-Schedule the Acct Server Process and check the Payment In is posted using the template by adding breakpoint in createFact function of DocFinPayment class in order to check strClassname variable has a value.

Check 2:

- Unpost the Payment In
- Go to General Ledger Configuration and select FIN_Payment table in Active tables window.
- Add the 'Accounting Engine - Financial Payment' as Accounting Template in Active tables tab
- Remove the record in its Document tab:
- Schedule the Acct Server Process and check the Payment In is posted using the template by adding a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable has a value.
- Unpost the payment.
- Login as system admin role:
- Schedule the Acct Server Process and check the Payment In is posted using the template by adding a breakpoint in createFact function of DocFinPayment class in order to check strClassname variable has a value.

(0096270)
hgbot (developer)
2017-04-28 16:30

Repository: erp/devel/pi
Changeset: 21e5d56eca66756563f47550f78fe9c004c97fb4
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Apr 18 22:35:56 2017 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/21e5d56eca66756563f47550f78fe9c004c97fb4 [^]

Fixes issue 35743: Accounting Templates for payments are not taken into
account if the Acct Server Process is scheduled at System level

By default client and organization filters where added while fetching
Accounting Schema Table and Accounting Schema Table Document Type.
In case of scheduling accounting server process at system level above
information was fetched for system client 0 and organization 0 which
gives no results for the accounting schema of business client.
For fetching required data schema id and table id is enough no need
to filter it by client or organization as in the other classes
for eg: DocInvoice.java

---
M src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
---
(0096271)
hgbot (developer)
2017-04-28 16:30

Repository: erp/devel/pi
Changeset: 48dc3283427f311b5c0bf188f0a482e33c942f2d
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Fri Apr 28 15:39:00 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/48dc3283427f311b5c0bf188f0a482e33c942f2d [^]

Related to issue 35743: Update copyright

---
M src/org/openbravo/erpCommon/ad_forms/DocFINPayment.java
---
(0096272)
aferraz (manager)
2017-04-28 16:32

Code review + Testing OK
(0096918)
hudsonbot (developer)
2017-05-29 17:43

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/1ee70113bdc4 [^]
Maturity status: Test
(0096919)
hudsonbot (developer)
2017-05-29 17:43

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/1ee70113bdc4 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-04-10 13:26 ngarcia New Issue
2017-04-10 13:26 ngarcia Assigned To => Triage Finance
2017-04-10 13:26 ngarcia Modules => Core
2017-04-10 13:26 ngarcia Resolution time => 1493676000
2017-04-10 13:26 ngarcia Triggers an Emergency Pack => No
2017-04-10 13:26 ngarcia Issue Monitored: networkb
2017-04-12 14:36 aferraz Assigned To Triage Finance => AtulOpenbravo
2017-04-17 21:28 AtulOpenbravo Status new => scheduled
2017-04-18 19:18 AtulOpenbravo Note Added: 0096057
2017-04-18 19:19 AtulOpenbravo Note Edited: 0096057 View Revisions
2017-04-28 16:30 hgbot Checkin
2017-04-28 16:30 hgbot Note Added: 0096270
2017-04-28 16:30 hgbot Status scheduled => resolved
2017-04-28 16:30 hgbot Resolution open => fixed
2017-04-28 16:30 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/21e5d56eca66756563f47550f78fe9c004c97fb4 [^]
2017-04-28 16:30 hgbot Checkin
2017-04-28 16:30 hgbot Note Added: 0096271
2017-04-28 16:32 aferraz Review Assigned To => aferraz
2017-04-28 16:32 aferraz Note Added: 0096272
2017-04-28 16:32 aferraz Status resolved => closed
2017-04-28 16:32 aferraz Fixed in Version => 3.0PR17Q3
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096918
2017-05-29 17:43 hudsonbot Checkin
2017-05-29 17:43 hudsonbot Note Added: 0096919


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker