Accounting Processor GL postings to "secondary" schema unreliable

Description

the client is set up to post documents to 2 accounting schemes in parallel, primary schema USD and a local accounting schema.
Sys.Config CLIENT_ACCOUNTING is set to "Q" and the interval is 10 minutes. The accounting processor runs reliably every 10 minutes.
Accounting Processor=>Accounting Schema is blank so postings are made to all schemes.

Generally, the system behaves as expected and posts documents to both schemes. However, we often also find documents, which only get posted to primary schema USD and not to the local schema!
E.g. there are many MR documents posted correctly to both schemes but there are also some MR documents which only post to the USD schema.
The system does not issue any posting errors. The only way to resolve this problem is to display the "partially" posted document (eg MR document), push the "Posted" button, select the local schema and push the re-post-button. The fact that a cache reset is required prior to re-post could indicate a problem in cache array variable s_schema in MAcctSchema.getClientAcctSchema().

Environment

None

Activity

Show:
Heng Sin Low
June 21, 2017, 10:51 PM

Need to commit/rollback posting to all schema in one transaction - https://bitbucket.org/idempiere/idempiere/commits/b3efa26

Hiep Lq
June 23, 2017, 7:01 AM

commit b3efa26402f0 prevent document with wrong post complete.

account post and complete document share same transaction so when rollback on DocManager make transaction end, so outer process (complete document) can't commit.

redo step:
1. create material receipt with pchair product and a new attribute set instance
2. complete document

get error message

reason:
have wrong account post by this issue "WARNING: Resubmit - No Costs for Patio Chair (required order line)"
let docmanage rollback transaction, so MWFActivity can't save its status on ended transaction

full log here:
https://gist.github.com/hieplq/2d3645786c92a480a689ccd3314e87a3

Heng Sin Low
June 23, 2017, 8:14 AM
Michael Powacht
June 23, 2017, 8:55 AM

Thanks guys for identifying and fixing this quickly.

Heng Sin Low
July 4, 2017, 8:31 AM

https://bitbucket.org/idempiere/idempiere/commits/41d351d - Posted not updated after posting completed with error ( it stay as N ).

Fixed

Assignee

Heng Sin Low

Reporter

Michael Powacht

Labels

None

Tested By

None

Components

Fix versions

Affects versions

Priority

Major