Finance | Project Operations, Human Resources, ...

Purchasing Batch Entry Posting very slow, took more then a month

(0) Share

Report

Posted on by c4c4571f00c7433e841...

1,110

hi all,

we have posted a Purchasing Batch, and it took more than a month, from the day start 10th July when I click on the post, it shows 25% and now after a month, still it is showing 25%. I checked from the profiler, and there seems batch is still posting. what to do with it, we have to close the fiscal year, but due to this closing already delayed.

that is an LC batch, whose some transactions are of last fiscal year, and most are of the currently opened fiscal year, there are more than 300 GRINS and about 27000 TON of raw material.

Now what to do, why it is taking too much time.

we are using Dynamics GP 2013. and batch is being posted on direct DB server (not on terminal)

plz suggest me how to trace the progress, how much it remaining??

Categories:

Microsoft Dynamics GP

All responses (8)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

Do you have an integration running? At this point in time I would suggest using task manager to stop this GP session. Then change marked to post and batch status to 0. Go into GP and look at the transactions in this batch. Hopefully this will give you a clue as to what they are. Chances are good that they are empty transactions. There is nothing in native GP that would cause this.
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

hi Richard....

We have not any customization in GP, and now status is,

MKDTOPST=1

NUMOFTRX=15996

BCHTOTAL=7285308

POSTTOGL=0

BCHSTTUS=3

number of trx are increasing . and percentage at front end is still 25. what is recommendation now?? as far my knowledge, profiler showing something working on batch, these upper values shows, some backend working is going on, but what is going looks abnormal, what to do next??? wait or should i interrupt the batch posting, logoff user forcefully and then...????
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

Something is wrong here. The batch status is 3 which means it is marked to post. Entries cannot be added to batches that are marked to post. Do you have a customization that could be causing this? Any triggers perhaps?
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

hi Richard...

SY00500 has multiple rows, and there are about 4 rows of different GLTRX out of which one is GLTRX533026 which is in profiler...

in that row, NUMOFTRX and BCHTOTAL are increasing...

NUMOFTRX=15796

BCHTOTAL=7202768

Series = 2

MKDTOPST=1

BRKDNALL=1 (i don't know whats this field)

POIVC batch in financial is also on receiving status...
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

This looks like an inventory transfer batch. If you look in your SY00500 table what is the status of this batch? I have never heard of a batch that perpetually keeps adding records to itself.
c4c4571f00c7433e841... 1,110 on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

hi...

there are about 800 GRIN in that batch, some are of last closed fiscal year, and some are currently opened year (about 50-50).

while i drill down the transactions from table, and profiler, i came to know, GP is working on a GLTRX batch, from many days, and in profiler, same batch is being shown in different queries having different GRIN and Transfer numbers, and date also varies in queries (as shown in image), so i think something is processing, batch is not stuck??

i looked in table GL10000 and GL10001, there are about 15752 and 31504 JRNentries respectively against that GLTRX batch, and they are increasing 2 to 4 lines after every 15 minutes.

Now, in profiler, i selected only that user by whom batch is being posted (his password never expired , not implemented to expire the password police), and in profiler about 700 to 1000 rows has being showing processed in a minute.'
Suggested answer

Dean Marty on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

I would suggest that you most likely have data damage on one or more of your transactions due to this long run time.

Ideally I would suggest to restore to a backup from before you posted, but, since it has been so long, that's not realistic.

You are going to want to make a copy of your live database and restore it into a test company and verify all the transactions.

I would suggest to break that batch into multiple smaller batches and test posting each one of those smaller batches in your test company before doing anything else with it in your live database.

Thanks
Carlos Henao @ GP365 15 on at

Like (0)

Report

RE: Purchasing Batch Entry Posting very slow, took more then a month

Hi Khurram

A month for your batch? Clearly there's something wrong. How many transactions are in that batch anyway? Regardless of the answer, the most I have ever seen a batch take to post is a few minutes, even if there's thousands of transactions in there.

Were you suggesting theres something actually processing, when you look at profiler?

If this has been posting for a month, I speculate that GP has been closed and reopened, probably several times. Random issues that could have happened are that the user password expired during the post.

I would be tempted to treat this as a "stuck batch". If you're not sure how to handle that situation, here's something we wrote up that will help. Especially useful if this is a payments batch.

gp365.ca/.../15533

Thanks!