Use this screen to modify 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 modify in the Maintain Invoices screen. Selected information entered from the Manage Sales Orders, Manage Sales Order Inventory Issues, Manage Sales Order Non-Inventory Issues, and Manage Shipping Transactions screens will be the default values on the invoice and cannot be modified. Invoices and amortizations are posted to the general ledger via the Post Sales Order Journal screen. Once the invoice is posted, you will no longer be able to modify invoice data.
For sales order (SO) lines with component processing, if a prior invoice exists for a SO line, subsequent new invoices created may or may not include costs from component issues made after the prior invoice. This all depends on whether those costs were already posted via the Post Component COGS Corrections option on the Post Sales Order Journal screen.
For SO lines with component processing, for subsequent invoices created after initial invoicing, issues that were already posted (via Post Component COGS Corrections option) are 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 those issues, which were posted via a different invoice.
Since cost of issues can be posted to the cost of goods sold (COGS) accounts, even after an invoice was already created (when the Allow invoice for partially shipped component lines option is selected), Sales Group Abbrev Clearing Account/Org need not match 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 modify invoices for line items with Open status on approved SOs. You can invoice INO (Invoice Only), REC (Recurring), and MSC (Miscellaneous) line items after the SO 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 modify, SO invoices that are posted to the general ledger. You can print invoices any time after entering them.
This screen has eight tabs:
Details — Use this tab to establish information that pertains to the invoice as a whole, and to provide default values for recurring invoice lines.
A/R — Use this tab to view accounts receivable and billing period information for the invoice.
Posting Info — Use this tab to view posting information for the invoice. You can establish the fiscal year, period, and subperiod on this tab.
Addresses — Use this tab to enter address codes that have been established for the customer on the selected SO.
Liquidation — Use this tab to view data specific to delivery invoices, or invoices that have been set up with a revenue recognition method of liquidations, and to adjust the liquidation amount if necessary.
Notes — Use this tab to view and add notes for the invoice.
iRAPT — Use this tab to enter additional information about the SO invoice before including it in a Invoicing, Receipt, Acceptance and Property Transfer (iRAPT) file.
Print Info — Use this tab to view and edit the print settings for the invoice
Enter a valid invoice number or leave blank if the auto-numbering method is used. When using auto-numbering, the invoice number is assigned after all required information is entered. Costpoint increments the Last System SO Invoice Number on the Configure Sales Order Entry Settings screen by one.
If you use manual numbering, you must enter an invoice number before you can save the record. Costpoint does not store the last number used. You must use a log to track the invoice numbers.
Enter, or click to select, a valid SO number.
Click this button to load the SO head details.
This field displays the system date and can be modified as necessary. Auto-created invoices display the invoice date entered during the create invoices process.
This field displays the transaction currency. The transaction currency defaults from the Manage Sales Orders screen. You can use the Exchange Rates subtask to modify the exchange rate for the invoice. You can modify rate groups on this subtask; however, you cannot modify the specified transaction currency. You can also create invoice lines using transaction currencies on this screen. All amounts display in transaction currency.
Click this button to recalculate all amounts on the screen.
If you use Multicurrency, some amount fields labels contain the "Trans Currency" prefix to indicate the amount in transaction currency. This amount defaults from the SO and cannot be modified for the invoice once the SO has been approved. However, you can modify the exchange rate and rate group for the invoice on the Exchange Rates subtask. Click to add a new line.
This field displays the system identifier of a line on the invoice. It is a sequential number assigned by Costpoint to track the line items of the invoice. Costpoint supports an unlimited number of lines on an invoice.
Enter, or click to select, the SO line number against which you are invoicing. Once you have entered the SO line, existing SO, 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 SO.
This field displays the contract line item number (CLIN) entered on the Manage Sales Orders screen.
This field displays the item entered on the Manage Sales Orders screen.
This field displays the item revision entered on the Manage Sales Orders screen.
This field displays the description of the item entered on the Manage Sales Orders screen. If you selected the Allow Invoice Description Changes check box on the Manage Sales Order Project Defaults or Manage Sales Order Catalog Defaults screens, you can modify the default item description. You can enter up to 60 alphanumeric characters for the description. If you modify the description, it will not update the item description on the Manage Parts, Manage Services, or Manage Goods screens in Product Definition. If you do not enter an item and the Line Type field value is MSC, you can enter a free-form description of what is being ordered.
This field is visible only if the Use Part Data Security Controls check box is selected on the Configure Product Definition Settings screen, which indicates that the item is subject to data security restrictions, as defined in the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR).
If enabled, this field displays one of the following values to indicate whether the item you are accessing is subject to part data security restrictions and whether you have the necessary authorization to access information for that item:
Unrestricted— The item is not subject to data security restrictions.
Restricted— The item is subject to data security restrictions and that you are authorized to access detailed part information.
***UNAUTHORIZED***— The item is subject to data security restrictions and that you are not authorized to access or view part information. This value is displayed in red background color.
This field displays the item type entered in the SO. The system-defined types are as follows:
P — For items established as parts on the Manage Parts screen.
G — For items established as goods on the Manage Goods screen.
S — For items established as services on the Manage Services screen.
This field displays the line type entered on the SO. Costpoint updates this field for MSC (Miscellaneous) invoice lines that are not associated with existing SO 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 SO journal.
This field displays the miscellaneous line type entered on the SO and can be modified. You must establish the type on the Manage Sales Order screen. You can access this field only when a MSC (Miscellaneous) line type has been selected.
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 MSC (Miscellaneous) type. You cannot invoice an SO line for more than order quantity. 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. This depends also on the setting of the Allow Invoicing Short on Component SO Lines level option on Configure Sales Order Entry Settings screen. 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 to negative invoice quantity scenarios. The issue detail subtask is non-editable when issues are at the component level.
This field displays the unit of measure entered in the SO.
This field displays Y (Yes) or N (No) to indicate whether components are issued to the SO line.
This field displays the sales group abbreviation entered on the SO line and can be modified as necessary. This is a required field for all SO lines.
This default for this column is taken from the SO line to indicate whether the item is taxable. You can modify this field as necessary.
This field displays the gross unit price from the SO line and can be modified on this screen. Costpoint supports a maximum gross unit price of 99,999,999.9999. Negative unit costs are allowed. If you use Multicurrency, this field contains the prefix "Trans Currency".
This field displays the volume discount entered on the SO line and can be modified 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 Costpoint will derive the value from the Gross Unit Price and Net Unit Price fields.
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. Costpoint will derive the net unit price from the gross unit price and applicable volume discount percentage if they have been entered. You can modify this field as necessary. If you use Multicurrency, this field contains the prefix "Trans Currency".
This field displays the extended price amount. The calculation is: net unit price multiplied by invoice quantity. You must enter the extended price amount if you have not entered a quantity. You can modify this field as necessary. If you use Multicurrency, this field contains the prefix "Trans Currency".
Costpoint calculates the extended price amount differently for recurring line items, and you cannot modify the price on this screen. Use the following as an example: a SO 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.
The following shows the calculation of extended price amount:
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.
Extended Price Amount = (Order Quantity * Net Unit Price * Number of complete billing cycles) + (Prorated billing cycle amount)
Using the example above to calculate the Extended Price Amount results in the following:
Extended Price Amount = (1 * $1,000.00 * 5) + (322.58) = $5,322.58
This field displays the sales tax/VAT amount calculated by Costpoint when the Taxable column is set to Y (Yes). The calculation is: extended price amount multiplied by sales tax/VAT Rate. If you use Multicurrency, this field contains the prefix "Trans Currency".
This field displays the default sales tax code from the SO line and can be modified on this screen. A sales tax code is required for all taxable line items.
This field displays the sales tax/VAT rate associated with the selected sales tax code.
You can add other, miscellaneous charges for a line item on the Line Charges subtask. The cumulative price of the line charges entered on the subtask displays and can be modified only on that subtask. If you use Multicurrency, this field contains the prefix "Trans Currency".
Miscellaneous charges for a line item and their applicable sales tax amounts are added on the Line Charges subtask. This field displays the cumulative sales tax amount for the line charges entered on the subtask. You cannot modify this field; you must use the Line Charges subtask. If you use Multicurrency, this field contains the prefix "Trans Currency".
The unit cost for SO 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, Costpoint 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. Costpoint multiplies the unit cost by the SO 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 on the Issue Detail subtask.
This field displays the extended cost amount. The calculation is as follows: unit cost amount multiplied by invoice quantity.
This field displays the sum of Ext Price Amount, Line Charge Amount, Sales Tax/VAT Amount, and Line Charge Sales Tax/VAT Amount fields. If you use Multicurrency, this field contains the prefix "Trans Currency".
Select this check box to calculate the Sales Tax/VAT Amount when you save your changes.
Enter, or click to select, a valid cycle for the line item. This field is available only for "REC" (Recurring) SO line types. If the invoice was auto-created by Costpoint, the billing cycle displays as entered during the creation process and can be modified.
This field displays the starting date entered during the creation process, if the invoice was auto-created by Costpoint, and can be modified. This field is available only for REC (Recurring) SO line types.
This field displays the ending date entered during the creation process, if the invoice was auto-created by Costpoint, and can be modified. This field is available only for REC (Recurring) SO line types.
If the SO uses the deferred revenue recognition method, this field displays 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 (that is, not posted). If the SO does not use the deferred revenue recognition method, this field is hidden and the Amortization Schedule subtask is disabled. Establish amortization codes on the Manage Deferred Revenue Amortization Schedules screen.
This field displays any notes that were entered for the SO line. You can modify this description and add up to 254 characters of free-form text if the invoice has not yet been posted.
This field displays whether or not components have been fully issued to the SO line. If components have been fully issued, the field is set to Y (Yes) to indicate that the line can be invoiced.
For drop-shipment 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 in-transit components, this is determined upon shipping.
If this field is set to Y, the Allow Invoicing Short on Component SO Lines check box on the Configure Sales Order Entry 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 Costpoint indicates that the issue line has been invoiced.
Enter, or click to select, one of the following shipping advice codes for iRAPT reporting. The system-defined options are:
A — Components Missing
B — Missing Components Furnished
C — Quantity Increase
D — Quantity Decrease
E — Replacement Shipment
F — Shipped and Held in Bond at Contractor's Plant
G — Shipped and Held as GFP
H — Shipped/Performed as Indicated
Z — Under Run Quantity
Subtask |
Description |
Header Standard Text |
Click this link to open the Header Standard Text subtask. |
Exchange Rate |
Click this link to open the Exchange Rates subtask. |
SO Header Documents |
Click this link to open the SO Header Documents subtask. |
Totals |
Click this link to open the Totals subtask. |
Accounts |
Click this link to open the Accounts subtask. |
Issue Detail |
Click this link to open the Issue Detail subtask. |
Line Charges |
Click this link to open the Line Charges subtask. |
Line Standard Text |
Click this link to open the Line Standard Text subtask. |
Currency Line Information |
Click this link to open the Currency Line Information subtask. This button is disabled if the transaction and functional currencies are the same. |
Customs Info |
Click this link to open the Customs Info subtask. |
Amortization Schedule |
Click this link to open the Amortization Schedule subtask. This button is enabled if the SO's revenue recognition method is deferred revenue, and an amortization schedule code exists for the SO invoice line. |
Line Documents |
Click this link to open the Line Documents subtask. |