Wednesday, March 14, 2018

Journal Posting Issue and resolution


Issue:-
GL period was closed before closing the payable period because of that many of the journal entries remain un-posted in GFP as entries stuck into GL interface table.
As P3 is now closed we can’t post these entries into P3 and if we delete data from interface we can’t get it back from sub-ledger as the sub-ledger period is already closed so all transection would be accounted and Posted.
We can delete the data from sub-ledger and again import the data from spreadsheet or any other feeder system but not possible from sub-ledger.
So the only solution remain is to post the data in very next period of GL, defiantly you won’t be able to reconcile GL and sub-ledger for that specific period but during next period posting it can be taken care by business and it won’t result into unbalancing at fiscal end.

Fix Summary:-
As per agreed action plan if you want to go for posting the P03 batch into P04 (no other posting activities are allowed from Payables during this is being performed):
1.    GL posts every AX Payables batches (P04 ones) which can be there may be waiting for posting. To have a clean starting point.
2.    Unfreeze the Journal batch source, once the Journal source is unfreeze GL dates can be changed from Journal import correct window or even threw Journal Batch



3.    GL changes the period of those batches to P04 



4.    GL posts the batches into P04
5.    Freeze the Journal source again.

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...