Accounting Processor GL postings to "secondary" schema unreliable


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().




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

Need to commit/rollback posting to all schema in one transaction -

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

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:

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 - Posted not updated after posting completed with error ( it stay as N ).



Heng Sin Low


Michael Powacht



Tested By



Fix versions

Affects versions