ARUPDATE Not Finding Payments to Post

I have created a Regular Deposit and an Express Deposit for Pending Items.  I posted the Pending Item before creating the Payment.  I have set the Paymetns for Posting, but when I run ARUPDATE it does not find them.  They are in an open period for posting to GL.  This is in a test environment.  wondering what I might have missed in the setup.

Views: 67

Attachments:

▶ Reply to This

Replies to This Discussion

Permalink Reply by PSoftPros on February 10, 2010 at 3:43pm
Hey Scott, Look at your message log and post what it reads here. There might be a couple of things going on here.

Thanks
Derek
Permalink Reply by Scott Westberg on February 10, 2010 at 3:59pm
Derek,
Below is the message Log.
Messages Customize | Find | View All First 1-13 of 13 Last

Instance Process Severity Log Time Message Text
1110702 AR_UPDATE 11:04:06AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
11:03:47AM Parallel Preprocessor - 0 group(s) partitioned across 1 AR_PGG and 1 AR_POST process(es).
11:04:06AM Successfully posted generated files to the report repository
1110706 AR_PGG1 11:04:19AM Successfully posted generated files to the report repository
11:04:18AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
1110707 AR_POST1 11:04:35AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
11:04:35AM Successfully posted generated files to the report repository
1110703 AR_UPDATE2 11:04:51AM Successfully posted generated files to the report repository
11:04:51AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
10 11:04:41AM No more requests. Journal Generator calling Journal Edit.
10 11:04:41AM Request 1 complete 2010-02-03-11.04.40.000000. 0 Journals created.
10 11:04:39AM Journal Generator processing has begun 2010-02-03-11.04.38.000000.
10 11:04:49AM Journal Generator processing complete 2010-02-03-11.04.49.000000.
Permalink Reply by PSoftPros on February 10, 2010 at 4:05pm
I'm sorry but I don't see anything obvious here. Do you know how to turn on tracing? If not get your developer to turn tracing on for this specific application engine process. Then the process monitor will also have the trace file which will tell more.

Derek

Scott Westberg said:
Derek,
Below is the message Log.
Messages Customize | Find | View All First 1-13 of 13 Last

Instance Process Severity Log Time Message Text
1110702 AR_UPDATE 11:04:06AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
11:03:47AM Parallel Preprocessor - 0 group(s) partitioned across 1 AR_PGG and 1 AR_POST process(es).
11:04:06AM Successfully posted generated files to the report repository
1110706 AR_PGG1 11:04:19AM Successfully posted generated files to the report repository
11:04:18AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
1110707 AR_POST1 11:04:35AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
11:04:35AM Successfully posted generated files to the report repository
1110703 AR_UPDATE2 11:04:51AM Successfully posted generated files to the report repository
11:04:51AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
10 11:04:41AM No more requests. Journal Generator calling Journal Edit.
10 11:04:41AM Request 1 complete 2010-02-03-11.04.40.000000. 0 Journals created.
10 11:04:39AM Journal Generator processing has begun 2010-02-03-11.04.38.000000.
10 11:04:49AM Journal Generator processing complete 2010-02-03-11.04.49.000000.
Permalink Reply by Scott Westberg on February 10, 2010 at 6:03pm
Derek,

I have attached the trace and log files.

Derek Tomei said:
I'm sorry but I don't see anything obvious here. Do you know how to turn on tracing? If not get your developer to turn tracing on for this specific application engine process. Then the process monitor will also have the trace file which will tell more.

Derek

Scott Westberg said:
Derek,
Below is the message Log.
Messages Customize | Find | View All First 1-13 of 13 Last

Instance Process Severity Log Time Message Text
1110702 AR_UPDATE 11:04:06AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
11:03:47AM Parallel Preprocessor - 0 group(s) partitioned across 1 AR_PGG and 1 AR_POST process(es).
11:04:06AM Successfully posted generated files to the report repository
1110706 AR_PGG1 11:04:19AM Successfully posted generated files to the report repository
11:04:18AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
1110707 AR_POST1 11:04:35AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
11:04:35AM Successfully posted generated files to the report repository
1110703 AR_UPDATE2 11:04:51AM Successfully posted generated files to the report repository
11:04:51AM Published message with Pub ID of 0 to request to have report added in folder GENERAL
10 11:04:41AM No more requests. Journal Generator calling Journal Edit.
10 11:04:41AM Request 1 complete 2010-02-03-11.04.40.000000. 0 Journals created.
10 11:04:39AM Journal Generator processing has begun 2010-02-03-11.04.38.000000.
10 11:04:49AM Journal Generator processing complete 2010-02-03-11.04.49.000000.
Permalink Reply by Rajeev Ramachandran on February 16, 2010 at 4:00pm
Scott,
If you havent already figured out the issue could you post data from Deposit Control and Payment tables for the deposit which are not being processed by AR Update..?

Rajeev
Permalink Reply by Scott Westberg on February 16, 2010 at 4:36pm
How would I go about trying this. This is in a test system, so I'm willing to give anything a try.

Rajeev Ramachandran said:
Scott,
If you havent already figured out the issue could you post data from Deposit Control and Payment tables for the deposit which are not being processed by AR Update..?

Rajeev
Permalink Reply by Rajeev Ramachandran on February 16, 2010 at 4:48pm
Scott,
Please run the following query on your DB and post the results

SELECT * FROM PS_DEPOSIT_CONTROL WHERE DEPOSIT_BU = '' AND DEPOSIT_ID IN ('');
SELECT * FROM PS_PAYMENT WHERE DEPOSIT_BU = '' AND DEPOSIT_ID IN ('');

Rajeev
Permalink Reply by Marshall R Gunsel on March 4, 2010 at 11:02am
What are the run control parameters--a screenshot of that would help. The Process Frequency has to be something other than "Don't" which is the default.

RSS

© 2012   Created by PSoftPros.

Badges  |  Report an Issue  |  Terms of Service