to select, the starting value for the
range you want to include. If you select All
or From Beginning in the Range Option field,
this field will be inactive. The Project Product Journal contains product billings entered in the Edit Project Product Bills screen (Projects » Billing » Edit Billings). Use this screen to post invoices with a status of Selected. The journal debits the billed receivable account that has been set up in the project’s project account group. Unbilled amounts are posted to the unbilled receivable account that has been set up in the project’s project account group. If discounts have been taken, these amounts are posted, and shipping charges and sales tax accrued.
This application uses "dynamic temporary tables." Application locking for this program is set to Single; only one user can access this application at a time. Refer to System Administration Special Topic SA-4, "Application Locking/Dynamic Tables," for more information.
You can print and post the Project Product Billing Journal to the ledger as many times as necessary during an accounting subperiod. Failure to post the Project Product Billing Journal may result in an overstatement of your unbilled receivables and an understatement of billed receivables. You can print the Journal without posting to the General Ledger. However, you must print the journal before posting.
Use this group box to select the period in which you would like to post your bills.
Enter, or use the drop-down list to select, the fiscal year to which you want to post invoices.
Enter, or use the drop-down list to select, the period to which you want to post invoices.
Enter, or use the drop-down list to select, the subperiod to which you want to post invoices. The subperiod ending date will appear in the field to the right of the subperiod number.
Open project product bills are stored in the PROJ_PROD_INVC_HDR and PROJ_PROD_INVC_LN tables. These tables do not store open invoices by fiscal year, period and subperiod. When the posting program is executed, it looks only for a status of Selected and posts these invoices to the fiscal year, period and subperiod selected. Therefore, verify the status of invoices before posting them to the General Ledger.
Use this group box to limit the bills that will be posted.
Select the manner in which you want to group invoices to be posted. Valid options are:
Project - Select this group to post a range of invoices based on project number.
Customer - Select this group to post a range of invoices based on the customer being invoiced.
Invoice Number - Select this option to post a range of invoices based on invoice number.
Bill User Group - Select this option to print invoices belonging to particular user groups.
Select the appropriate range of invoices you want to post. Valid options are:
All
One
Range
From Beginning
To End
The default for this field is All.
Enter, or use to select, the starting value for the
range you want to include. If you select All
or From Beginning in the Range Option field,
this field will be inactive.
Enter, or use to select, the ending value for the range
you want to include. If you select All,
One, or To
End in the Range
Option field, this field will be inactive.
This field displays the current journal status. When you enter the screen, the status is Journal Not Printed. After you print the journal, the status changes to Printed. The journal status must be Printed before you can post.
The Post Bills icon on the toolbar will not be available until the journal entry has been printed.
Click this icon on the toolbar to post the bills. This button will not be available until you have printed the journal entry.
Click this icon on the toolbar to print the journal entry and post the bills.
The following are posted as part of the Project Product Bills posting:
Receivable - The program looks to the PROJ_ORG_ACCT and ACCT_GRP_SETUP tables for the account/ref1/ref2 with a function code of Billed A/R. If an account with the function code of Billed A/R cannot be found then the program will display a message saying that the posting cannot be completed. The program then looks to the PROJ_BILL_INFO table for the level at which this invoice should be posted. The Owning Organization assigned to the project is used as the Org for posting. The Invoice Amount net of discounts, sales tax and shipping is posted as the billed receivable for invoices with a status of Selected.
Unbilled - The program looks to the PROJ_ORG_ACCT and ACCT_GRP_SETUP tables for the account/ref1/ref2 with a function code of Unbilled-Genrl. If an account with the function code of Unbilled-Genrl cannot be found, the program displays a message saying that the posting cannot be completed. The program then looks to the PROJ_BILL_INFO table for the level at which the receivable is posted. It looks to the PROJ_REV_SETUP table to find the project level at which revenue is posted. It compares the two. If different, the unbilled amount is posted at the higher of the two levels.
Sales tax - The program looks to the SALES_TX_ACCT table for the account/org/ref1/ref2 for each sales tax code. Account/Orgs used in the posting of sales tax are determined for each sales tax code. So if sales tax is accrued to multiple sales tax codes, there will be multiple account/orgs updated with sales tax amounts.
Shipping - The program looks to the AR_DFLT_ACCT table for the default accounts identified for shipping and handling charges. The account/org/ref1/ref2 stored in this table is always used for these charges. Therefore, shipping charges are not stored by project.
Discounts - The program looks to the AR_DFLT_ACCT table for the default accounts identified for discounts offered. The account/org/ref1/ref2 stored in this table is always used for these charges. Therefore, discount amounts are not stored by project.
Changes to this screen update the following tables:
AR_DETL_HS
AR_HDR_HS
FS_SUM
GL_DETL
GL_POST_SUM
PROJ_BILL_HS
PROJ_PROD_HDR_HS
PROJ_PROD_LN_HS
REF_SUM (optional)