The closing process in Dynamics SL clears the PJALLSRT table each time it is run. Unfortunately it seems to be the only table that links the project cost record with the allocation that gets created. DCAA is asking us to directly link our GL records to project cost records and the subsequent billing record created by allocator. Without the historical data in this table it seems impossible to link them in some kind of report.
Any help in either recreating the PJALLSRT table or directly linking the GL cost record through to the Project billing record would be appreciated.
*This post is locked for comments