This article explains how the PA Periodic tables are updated for different types of transactions such as Timesheets, Purchasing transactions and Billing transactions.

For most transactions, the Periodic tables (eg. PA01304, PA01221, etc) are updated using the line date on the transaction. 

Consider this example for a Timesheet that crosses periods:
----------------------------------------------------------------------------------
Timesheet Entry Date: 5/15/2017
Posting Date: 6/1/2017
Document Date: 5/15/2017

Line items:
DATE       PROJECT  COST CAT ID  QUANTITY
4/30/2017 Project       Consulting       8.00
5/1/2017   Project       Consulting       8.00
5/2/2017   Project       Consulting       8.00

-------------------------------------------------------------------------------------

If we assume monthly periods for the Timesheet above, 8 hours would be posted to Period 4 (April)
and 16 hours to Period 5 (May) since it looks at the line date on the transaction.  However, since
the Posting Date is in Period 6 (June), the accounts in GL will be updated for the full amount
in June.  So you can see the issue with trying to reconcile a GL balance with the periodic records. 
It would be very difficult to reconcile especially when a timesheet or transaction crosses periods.
In this example, the Document Date (5/15/2017) is NOT used for updating the PA Periodics.


The exception to the line date usage is Purchasing and Billing transactions.  These types of transactions
do not have Line dates and so will look to the settings you selected below:

Periodic Billing Records:
1. Navigate to MDGP | Tools | Setup | Project | Billing
2. Review the “Update Periodic Using” field. The choices are Document Date and Posting Date
3. Select the option desired and click Ok.

Periodic Purchasing Records:
1. Navigate to MDGP | Tools | Setup | Purchasing | Purchase Order Processing
2. Click on Project
3. Review the “Update Periodic Using” field. The choices are Document Date and Posting Date
4. Select the option desired and click Ok.

The setting selected above would be used for that transaction type.  If you change the setting and then
run PA Reconcile Periodic, it will 'move' the values to another period bucket if necessary.

I hope this information is useful to you on how the PA Periodic tables are updated.


With regards,

Cheryl Waswick | Sr. Technical Support Engineer | Microsoft Dynamics GP Support