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

Attachments

1

Activity

Show:

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

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

Michael Powacht June 23, 2017 at 8:55 AM

Thanks guys for identifying and fixing this quickly.

Heng Sin Low June 23, 2017 at 8:14 AM

Hiep Lq June 23, 2017 at 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 21, 2017 at 10:51 PM

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

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created April 24, 2017 at 5:49 AM
Updated September 1, 2017 at 7:54 AM
Resolved June 23, 2017 at 8:14 AM