Use this screen to edit and delete invoices auto-created by Costpoint and enter and maintain additional invoices. You can also use this screen to maintain price data and sales tax information that you cannot edit in the Maintain Invoices screen. Selected information entered in the Enter Sales Orders screen, the Enter Sales Order Inventory and Enter Sales Order Non-Inventory Issues screens, and the Enter Shipping Transactions screen will be the default values on the invoice and cannot be changed. Invoices and amortizations are posted to the general ledger via the Post Sales Order Journal application. Once the invoice is posted, you will no longer be able to edit invoice data.
For SO lines with component processing, if a prior invoice exists for a particular SO/line, subsequent new invoices created may or may not include costs from component issues that were made after the prior invoice, depending on whether those costs were already posted via Post Component COGS Corrections option in the Post Sales Order Journal application.
For SO lines with component processing, for subsequent invoices created after initial invoicing, issues that were already posted (via Post Component COGS Corrections) will be associated with the invoice number referenced at the time of posting of the issue cost, even though subsequent invoice quantity adjustments are made referencing this new invoice number. Deletion of the new invoice/line reverses the invoiced quantities, but does not affect the posted costs of such issues, which were posted via a different invoice.
Since cost of issues can be posted to the COGS accounts, even after an invoice was already created (when the Allow invoice for partially shipped component lines is selected), Sales Group Abbrev Clearing Account/Org need not equal the CGS Account Org.
An invoice or invoice line cannot be deleted if any of the associated issue transactions contain component correction lines that have been posted, via Post Invoices or via Post Component COGS Corrections.
Enter and edit invoices for line items with "Open" status on approved sales orders. You can invoice "INO" (Invoice-Only), "REC" (Recurring), and "MSC" (Miscellaneous) line items after the sales order is approved. You must issue and ship "INV" (Inventory) and "INT" (In-Transit) line items before you can enter an invoice. You must issue "DRP" (Dropshipment) line items before you can invoice them. You can view, but not change, sales order invoices that have been posted to the general ledger. You can print invoices any time after entering them.
You can number invoices manually or have the system assign them automatically. Select the invoice numbering method in the Invoice group box in the Sales Order Settings screen.
Enter an invoice number up to a maximum of 15 characters or leave this field blank if you are using the auto-numbering method. When manually entering the invoice number, you cannot enter spaces. If you choose auto-numbering, the invoice number is assigned after all required information is entered. The system increments the Last System SO Invoice Number in Sales Order Settings by one.
If you choose manual numbering, you must enter an invoice number before you can save the record. The system does not store the last number; you must track the invoice numbers in a log.
This field displays the system date and can be changed as necessary. Invoices that were auto-created by the system display the invoice date entered during the Create Invoices process.
Select this checkbox to print invoices designated as DD250 type with a capital "E" in Box 6. Invoice Number and Date of the form. This checkbox is used to mark DD250 invoices as "Estimated."
Select this checkbox to indicate the invoice is on hold and is not eligible for sales order journal posting. Leave this checkbox empty to include the invoice in the sales order journal posting process.
The system calculates and displays the invoice due date based on the entered invoice date and the customer's established payment terms. You can change the calculated due date.
Enter, or use Lookup to select, a valid sales order number.
This field is currently unavailable.
Enter, or use Lookup to select, the applicable customer payment terms. The system provides the terms established for the customer in the Customer table as a default, which can be changed as necessary.
This field displays the delivery terms, if applicable, that were entered in the Header Information subtask of the Enter Sales Orders screen.
These non-editable fields display the customer established in the sales order.
This non-editable field displays the transaction currency. The transaction currency defaults from the Enter Sales Order screen. You can use the Exchange Rates subtask to modify the exchange rate for the invoice. You can change rate groups in this subtask; however, you cannot modify the specified transaction currency. You can also create invoice lines using transaction currencies in this screen. All amounts will be displayed in transaction currency.
This non-editable field displays the pricing project for the order established in the Enter Sales Orders screen.
This non-editable field displays the pricing catalog for the order established in the Enter Sales Orders screen.
Enter free-form text that pertains to this sales order invoice containing up to 254 alphanumeric characters. As you enter the text, it automatically word-wraps. You can insert paragraph breaks and blank lines by pressing [CTRL-ENTER] to force hard-carriage returns where needed. Text is printed in its entirety on the invoice forms.
If you are using Costpoint Multicurrency, some amount fields in the table window will be denoted by "Trans Currency" to indicate the amount in transaction currency, which defaults from the sales order and cannot be changed for the invoice once the sales order has been approved. However, you can modify the exchange rate and rate group for the invoice in the Exchange Rates subtask.
This non-editable field displays the system identifier of a line on the invoice. It is a sequential number assigned by the system to track the line items of the invoice. Costpoint supports an unlimited number of lines on an invoice.
Enter, or use Lookup to select, the sales order line number against which you are invoicing. Once you have entered the SO line, existing sales order, issue, and shipping information will default into the invoice line. Leave this field blank if you are invoicing for miscellaneous items not identified on the sales order.
This non-editable field displays the CLIN entered in the Enter Sales Orders screen.
This non-editable field displays the item entered in the Enter Sales Orders screen.
This non-editable field displays the item revision entered in the Enter Sales Orders screen.
This field displays the description of the item entered in the Enter Sales Orders screen. If you have selected the Allow Invoice Description Changes checkbox in the Sales Order Project Settings or the Sales Order Catalog Settings screens, you can change the default item description. You can enter up to 60 alphanumeric characters for the description. If you change the description, it does not update the item description in the Basic Part Data, Services, or Goods tables in Costpoint Product Definition. If you did not enter an item and the order line type is "MSC," you can enter a free-form description of what is being invoiced. This is a required field.
This field displays any notes that were entered for the sales order line. You can change this description and add up to 254 characters of free-form text if the invoice has not yet been posted.
This non-editable field displays the line type entered on the sales order. The system updates this field for "MSC" (Miscellaneous) invoice lines that are not associated with existing sales order lines.
Miscellaneous line type items do not permit entry in the Item column. Enter the item ordered and its associated description in the Item Selling Description column. Miscellaneous types generally represent invoice items entered one-time-only for sales or various freight, handling, and expediting charges. This line type functions like the "INO" (Invoice Only) line type in that there is no interface with material movement, nor is issue transaction permitted. The cost of sales journal entry will be posted to the general ledger through the Sales Order journal.
This field displays the miscellaneous line type entered on the sales order and can be changed as necessary. You must establish the type in the Sales Order Line Charge Types screen. You can access this field only when a "MSC" (Miscellaneous) Line Type has been selected.
This field displays the item type entered in the sales order. The system-defined types are as follows:
P - Items established as parts in the Basic Part Data screen in Costpoint Product Definition.
G - Items established as goods in the Goods screen in Costpoint Product Definition.
S - Items established as services in the Services screen in Costpoint Product Definition.
Enter the invoice quantity for line types that are "INO" (Invoice-Only), "MSC" (Miscellaneous), and "REC" (Recurring) items. Use the Issue Detail subtask to assign the invoice quantity for line types that require material movement, which are "INV" (Inventory), "INT" (In-Transit), and "DRP" (Dropshipment) line items. This field is required for all line types except the miscellaneous type. Fractional quantities are supported and the maximum quantity is 99,999,999.9999. Negative invoice quantities are allowed.
For SO lines with component issues, partial invoicing is not allowed. The invoiced quantity must equal the order quantity (positive or negative) and the associated issues must support this invoiced quantity (depends also on SO Settings ‘Allow Invoicing Short on Component SO Lines level). If the invoice quantity on the main screen is positive, then the issue details subtask still loads both positive and negative issue rows, and updates invoice quantity (equal to issue quantity) against all the issue rows (positive and negative). Similar logic applies for negative invoice quantity. Issue detail subtask is not editable when issues are at the component level.
This non-editable field displays the unit of measure entered in the sales order.
This field displays the gross unit price from the sales order line and can be edited in this screen. The system supports a maximum gross unit price of 99,999,999.9999. Negative unit costs are allowed. If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency."
This field displays the volume discount entered on the sales order line and can be changed as required. The Volume Discount percentage is applied to the Gross Unit Price of the item. Enter a 5.25% discount as "5.25." The discount percentage is intended as a volume discount, rather than a cash or payment discount. If you do not know the discount percentage, leave this field blank and the system will automatically derive the value from the Gross Unit Price and Net Unit Price.
Enter the net unit price of the item. This is the price of one unit of the item after any volume discounts have been applied. The system will automatically derive the net unit price from the Gross Unit Price and applicable Volume Discount percentage if they have been entered. You can edit this field as necessary. If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency."
If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency." The system automatically calculates the extended price amount as follows: Net Unit Price times Invoice Quantity. You must enter the extended price amount if you have not entered a quantity. You can change this field as necessary.
The system calculates the extended price amount differently for recurring line items, and you cannot edit the price in this screen or in the Invoice Supervisor Screen. Use the following as an example: a sales order line item is entered for a service agreement, hardware maintenance. You enter the line item as a "REC" (Recurring) line type. The maintenance agreement is effective for the period 7/22/02 through 12/31/02 and the price is $1,000 per month. The customer is billed monthly and the Actual Day prorate method is used.
Costpoint calculates the Ext Price Amount, which cannot be changed for recurring line items. The calculation is as follows:
Extended Price Amount =
(Order Quantity × Net Unit Price × Number of complete billing cycles)
+ (Prorated billing cycle amount)
The system calculates the prorated billing cycle amount follows:
Prorated Billing Cycle Amount =
(Unit Price per month ÷ *31 or 30 days) × Number of days in prorated cycle
*Actual Day Prorate Method uses the actual number of days in a month, and
the 30-Day Prorate Method uses 30 for each month.
Using our example, the prorated invoice amount is calculated as follows:
Prorated Invoice Amount =
($1,000.00 per month ÷ 31 days) × 10 days = $322.58
Costpoint prorated the month of July using the starting date of 7/22 and the ending date of 7/31. The starting date is included as the first date of the prorated cycle, which results in 10 days.
Using the example above to calculate the Ext Price Amount results in the following:
Extended Price Amount =
(1 × $1,000.00 × 5) + (322.58) = $5,322.58
You can add other, miscellaneous charges for a line item in the Line Charges subtask. The cumulative price of the line charges entered in the subtask is displayed and can be edited only in that subtask. If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency."
This default for this column is taken from the sales order line to indicate whether the item is taxable. You can edit this field as necessary.
This field displays the default sales tax code from the sales order line and can be edited in this screen. A sales tax code is required for all taxable line items.
This non-editable field displays the tax rate associated with the selected sales tax code.
This non-editable field displays the sales tax amount automatically calculated by the system when the Taxable column is set to "Y" (Yes). The calculation is as follows: Ext Price Amount times Sales Tax/VAT Rate. If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency."
Miscellaneous charges for a line item and their applicable sales tax amounts are added in the Line Charges subtask. This field displays the cumulative sales tax amount for the line charges entered in the subtask. You cannot edit this field; you must use the Line Charges subtask. If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency."
This non-editable field displays the total line amount automatically calculated and displayed by the system. The calculation is as follows: Ext Price Amount plus Line Charge Amount plus tax and Line Charge Sales Tax/VAT Amount. If you are using Costpoint Multicurrency, this field will contain the prefix "Trans Currency."
This field displays the sales group abbreviation entered on the sales order line and can be edited as necessary. This is a required field for all sales order lines.
This field displays the starting date entered during the creation process, if the invoice was auto-created by the system, and can be edited. This field is available only for "REC" (Recurring) sales order line types.
This field displays the ending date entered during the creation process, if the invoice was auto-created by the system, and can be edited. This field is available only for "REC" (Recurring) sales order line types.
This field displays the billing cycle entered during the creation process, if the invoice was auto-created by the system, and can be changed as necessary. This field is available only for "REC" (Recurring) sales order line types. Enter, or use Lookup to select, a valid cycle for the line item. The billing cycle is required for all recurring line items.
The unit cost for sales order items that do not require material issue transactions, but do require only an invoice (line types "INO" (Invoice-Only), "MSC" (Miscellaneous), and "REC" (Recurring)), are determined during the invoice generation process and when invoices are added manually. For these items, the system checks the Sales Order Cost Types table to determine the user-defined costing sequence. If a sequence number of zero has been assigned, the cost type will be ignored. If the cost is not zero, it defaults into the estimated unit cost field. If a cost type does produce a unit cost equal to zero, the cost type with the next available sequence number is used. The system multiplies the unit cost by the sales order invoice quantity to determine an extended cost amount.
The unit cost for line items that require material issue transactions ("INV" (Inventory), "INT" (In-Transit), and "DRP (Dropshipment) items) is determined when the issue is recorded. This field displays the average unit cost for the issues linked to this invoice line. The individual costs assigned to the issue transactions are displayed in detail in the Issue Detail subtask.
This non-editable field displays the extended cost amount automatically calculated by the system. The calculation is as follows: Unit Cost Amount times Invoice Quantity.
This non-editable field displays "Y" (Yes) or "N" (No) to indicate whether or not components are issued to the sales order line.
This non-editable field indicates whether components have been fully issued to the sales order line. If components have been fully issued, the field is set to "Y" (Yes) to indicate that the line can be invoiced.
For dropshipment component issues, if the absolute value of the sum of issued quantities (not yet invoiced, for all components) is greater than or equal to the component line order quantity, the SO line is ready for invoicing. For inventory and intransit components, this is determined upon shipping
If this field is set to "Y," the Allow Invoicing Short on Component SO Lines checkbox in the Sales Order Settings Screen is selected, and the SO Line Type is "INO" (Invoice Only), the invoice quantity for the issued SO line may not be the same as the order/issued/shipped quantities on the component line due to the fact that all components may not yet have been issued, but the system indicates that the issue line has been invoiced.
If the sales order's Revenue Recognition drop-down box is "Deferred Revenue" in the Header Accounts subtask in the Enter Sales Orders screen, this field will display the amortization schedule code assigned to the SO line. You must populate the Amortization Schedule subtask if an Amortization Schedule Code exists and the invoice is open (i.e., not posted). If the Revenue Recognition drop-down box is not "Deferred Revenue," this field will be hidden, and the Amortization Schedule subtask will be disabled. Establish amortization codes in the Deferred Revenue Amortization Schedules screen in the Sales Order Entry Controls menu.
Select this pushbutton to open the Invoice Header subtask.
Use this pushbutton to open the Addresses subtask.
Select this pushbutton to open the Header Standard Text subtask.
Select this pushbutton to open the Liquidation subtask.
Select this pushbutton to open the Exchange Rates subtask.
Select this pushbutton to open the Invoice Totals subtask.
Use this pushbutton to open the Accounts subtask.
Select this pushbutton to open the Issue Detail subtask.
Use this pushbutton to open the Line Charges subtask.
Use this pushbutton to open the Line Standard Text subtask.
Select this pushbutton to open the Currency Line Info subtask. This pushbutton is disabled if the transaction and functional currencies are the same.
Select this pushbutton to open the Customs Info subtask.
Select this pushbutton to open the Amortization Schedule subtask. This pushbutton is enabled if the sales order's Revenue Recognition method is "Deferred Revenue" in the Header Accounts subtask in the Enter Sales Orders screen, and an Amortization Schedule Code exists for the sales order invoice line.