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 Customer Product Journal contains product billings entered in the Edit Customer 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 is set up in the default subtask for this customer or the default billed receivable account in the A/R Settings screen (Accounting » Accounts Receivable » Controls). 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 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.
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 ending date of this subperiod will appear in the field to the right of the subperiod number.
Please note 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 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, you should 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. Options include:
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.
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.
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 you print the journal entry.
Click this button on the toolbar to post the bills. This button will not be available until you print the journal entry.
Click this button on the toolbar to print the journal entry and post the bills.
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 will be 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 the Post Customer Product Bills 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. The system 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.
Changes to this screen update the following tables:
AR_DETL_HS
AR_HDR_HS
CUST_PROD_HR_HS
CUST_PROD_LN_HS
FS_SUM
GL_DETL
GL_POST_SUM
REF_SUM (optional)