POST CUSTOMER PRODUCT BILLS
The Customer Product Journal contains product billings entered on the Manage Customer Product Bills screen. Use this screen to post invoices with a status of Selected. The journal debits the billed receivable account that is set up in the default subtask for this customer or the default billed receivable account on the Configure Accounts Receivable Settings screen. 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 "Application Locking/Dynamic Tables" for more information.
You can print and post the Customer Product Billing Journal to the ledger as many times as necessary during an accounting subperiod. Failure to post the Customer Product Billing Journal may result in an understatement of your revenue and billed receivables. You can print the Journal without posting to the General Ledger. However, you must print the journal before posting.
For more information, see "The Posting Process" topic.
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Accounting Period
Options
This field always displays One.
Start Fiscal Year
Enter, or click 
to select, the fiscal year to which you want to post invoices.
Start Period
Enter, or click to select, the period to which you want to post invoices.
Start Subpd
Enter, or click to select, the subperiod to which you want to post invoices. The ending date of this subperiod appears in the field to the right of the subperiod number.
Please note that open customer product bills are stored in the CUST_PROD_INVC_HDR and CUST_PROD_INVC_LN tables. These tables do not store open invoices by fiscal year, period, and subperiod. When you execute the posting program, it looks only for a status of Selected and posts these invoices to the fiscal year, period, and subperiod selected. Therefore, we recommend that you verify the status of invoices before posting them to the General Ledger.
Ending Date
This field displays the ending date of the Subpd.
Select
Select the manner in which you want to group invoices to be posted. Options include:
Options
Select the range option for the invoices you want to post. Valid options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
The default for this field is All.
Start
Enter, or click to select, the starting value for the range you want to include. If you select All or From Beginning in the Options field, this field is inactive.
End
Enter, or click to select, the ending value for the range you want to include. If you select All, One, or To End in the Options field, this field is inactive.
Post Bills
Select Post Customer Product Bills to post the bills. This selection is not available until you print the journal entry.
Print/Post Bills
Select Print/Post Customer Product Bills to print the journal entry and post the bills.
Posting Information
The following are posted as part of the Customer Product Bills posting:
-
Receivable — The program looks to the CUST_DFLT_ACCT tables for the account/org/ref1/ref2 with a transaction type of R. If no accounts are found, the program looks to the AR_DFLT_ACCT table for the default receivable account. The Invoice Amount net of discounts, sales tax, and shipping is posted as the billed receivable for invoices with a status of Selected.
-
Sales — The program looks to the CUST_DFLT_ACCT tables for the account/org/ref1/ref2 with a transaction type of S. If no accounts are found, the program looks to the AR_DFLT_ACCT table for the default sales account.
-
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, multiple account/orgs are 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 customer.
-
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 customer.
The final step in this screen is to calculate and store the available terms discount. This is different from the volume or good customer discount because the customer receives this discount if he pays the invoice promptly. However, since it is not known whether the customer will make this payment in time to take advantage of the discount, only an informational entry is made. Costpoint multiplies the invoice amount by the terms discount to arrive at the customer's discount amount. This amount is posted to the AR_HDR_HS table as a memo entry. If the discount is taken, it is reflected as part of the entry to Cash Receipts. The posting of Cash Receipts updates the AR_HDR_HS with the discount taken, thus providing you with a complete history by Customer of discounts offered and discounts taken.