Use this screen to print and post eligible inventory transactions to the General Ledger. You can print the inventory journal to review before posting, or print and post as one process. You can select the fiscal year, period, and subperiod(s) to be posted.
You can bill units from inventory issues by cost, units, or account, depending on the radio button that is selected in the Bill Inventory Issues As group box in the Other Info subtask of the Project Billing Info screen (in Costpoint Billing). The radio button that is selected determines how records will be inserted in the OPEN_BILLING_DETL table during the Post Inventory Journal process. If you selected the Account radio button, some issues can be billed as units and others as cost under the same project, depending on the account function code (Units, Non-Labor, or Labor) associated with the inventory transaction line's charge to project and account.
You can run this process at any time. However, you must post the Inventory Journal before closing an accounting period.
Enter the fiscal year in which inventory transactions are to be posted. The drop-down box displays fiscal years from the Fiscal Year table in Costpoint General Ledger.
Enter the period in which inventory transactions are to be posted. The drop-down box displays the periods from the Accounting Periods table in Costpoint General Ledger. The end date for the period selected also displays.
Select the range of subperiods in which inventory transactions are to be posted. The Starting and Ending drop-down boxes display the subperiods from the Subperiods table in Costpoint General Ledger. The end date for the subperiods selected is displayed.
Select the range of subperiods to be printed. The system-defined selections are: "All," "One," "Range," "From Beginning," or "To End."
Enter the starting subperiod in which inventory transactions are to be posted. The drop-down box displays the subperiods from the Subperiods table in Costpoint General Ledger. The end date for the subperiod selected is displayed.
Enter the ending subperiod in which inventory transactions are to be posted. The drop-down box displays the subperiods from the Subperiods table in Costpoint General Ledger. The end date for the subperiod selected is displayed.
The Journal Status field displays either "Journal Not Printed" or "Journal Printed" to indicate the Post Inventory Journal status. After you post the journal for a specified subperiod, the journal status displays "Journal Not Printed."
The information that is entered in this screen and saved as a parameter is stored in the FUNC_PARM_CATLG table. This screen also relies on the settings in the INVT_SETTINGS and ITEM_SETTINGS_CORP tables. Information for posting the inventory journal is also stored in and/or pulled from the following tables: ACCT, ACCT_GRP_SETUP, ACCTING_PD, BILL_SETTINGS, DELTEK, F, FS_SUM, FUNC_PARM_CATLG, FY, GL_DETL, GL_POST_SUM, INV_TRN, INVT_ABBRV_CD, INVT_PROJ, INVT_TRN, INVT_TRN_LN, INVT_TRN_STATUS, ITEM, ITEM_UM, MO_HDR, OPEN_BILLING_DETAIL, OPEN_BILLING_DETL, ORG, ORG_ACCT, POST_SEMAPHORE, POSTING, PROD_PRICE_CATLG, PROJ, PROJ_BILL_INFO, PROJ_CLIN_PROD, PROJ_EDIT, REF_STRUC, REF_SUM, S_INVT_TRN_TYPE, SEQ_GENERATOR, SUB_PD, UNITS_USAGE, UNITS_USAGE,UNITS_USAGE_HS, UNITS_USAGE_LN, UNITS_USAGE_LN_HS.
This application utilizes the following worktables when processing data: Z_INPEDJNL_DETL_P1, Z_INPEDJNL_DETL_P2, Z_INPEDJNL_GL_DETL, Z_INPEDJNL_LN_HS, Z_INPEDJNL_OB_DETL, Z_INPEDJNL_OB_ERR, Z_INPEDJNL_RP_REF1, Z_INPEDJNL_RP_REF2, Z_INPEDJNL_RP_SUM1, Z_INPEDJNL_RP_SUM2, Z_INPEDJNL_RP_SUM3, Z_INPEDJNL_SUM.