GL Batch skipped during Financial Transaction Transfer

(0) Share

Report

Posted on by Stuart Nottingham

1,170

Client has a GL Batch from May which did not get included in the Financial Transaction Transfer for some reason. I've tried setting the Period back to 05-2018 in Project, but the batch still does not transfer. Locally, I setup Profiler to see what happens during the FTT process. The only reference I found to GLTran using the Standard Template was to the GLTran_stran stored procedure. Running that procedure in their app database did return the GL Batch.

Anyone have any ideas for what to look for? I don't see any reason this batch shouldn't have transferred.

*This post is locked for comments

All responses (2)

Answers (0)

Stuart Nottingham 1,170 on at

Like (0)

Report

RE: GL Batch skipped during Financial Transaction Transfer

Thanks for your response, Erich. All of the transactions in question have gltran.pc_status = 1. The do appear in SQL when I run the GLTran_stran stored procedure manually.

Erich Strelow F

1,642 on at

Like (0)

Report

RE: GL Batch skipped during Financial Transaction Transfer

The FTT behavior is controlled by the GLTran.PC_Status field. The cues are as follows:

Value	Meaning
0 or blank	This row has no project relevance. It will never be transferred
1	This row should be transferred in the next FTT process
2	This row has already been transferred
9	We tried to transfer this row but something went wrong

This conditions are necessary but not enough. For instance, an AP transaction has GLTran rows but the APTran rows are the ones being FTTd.

If a GLTran got a 9 status, you must recall them using the "Transaction Transfer Re-queue PARQU00" before attempting a reprocess, even if you changed the current period.