Recording external service details

Service Sale Billing - An overview

Unified Glossary

Basics of using a Ramco iEnterprise Series 5.0 Web Page

Using Online Help

Note: 1)) You can modify price details in this tab; if 1) The invoice basis is “Actuals” or The invoice basis is “Quote” and “Modification to Quote Values in Invoice Release” parameter for Service Sale Quote is set to 0 in the Set Sales Process Parameters activity of the Customer component and, 2) The invoice release is in “Fresh” status. Click the “Ext. Services” tab.

The “Current Ref. Details” group box displays the following:

CO #

The customer order that you have selected in the “Exe. Doc. Info.” section.

Exe. Doc. Type

The type of the execution document that you selected in the in the “Exe. Doc. Info.” section.

Exe. Doc #

The execution document that you selected in the in the “Exe. Doc. Info.” section.

The “Ext. Services Pricing Summary” displays the following:

SPL #/Rev. #

The service pricelist associated with the customer order.

Billable Ext. Ser.

The sum total of the final price for all the Service/Adhoc purchase orders in the “Ext. Services Pricing Details” multiline.

Billable Ext. Rep.

The sum total of the final price for all the repair orders in the “Ext. Services Pricing Details” multiline.

To retrieve external services from the invoice release

View Option

Use the drop-down list box to indicate the version of details of external services you wish to view. The drop-down list box displays the following: Billing Info and Actual Info. Select:

  • Billing Info. If you wish to view details of the external services as billed to the customer.

  • Actual Info. : If you wish to view details of the external services as per T & M pricing.

Note: You cannot modify any data in this tab page, if View Option is selected as “Actual Info.”

Note: You can search for a customer order by a number of parameters as explained below.

Search by

Use the first drop-down list box to select an attribute of the customer service order that you wish to retrieve. The drop-down list box displays the following: Billable?, COA? and Processed?.

Use the second drop-down list box to indicate whether the attribute that you select in the first drop-down list box is applicable for the customer service order that you wish to retrieve.

The “Ext. Services Pricing Details” multiline displays the following details for the customer service order or the shop work order /repair work order/customer purchase order/AME Ref. # that you have selected in the “Exe. Doc. Info.”  section.

The “Ext. Ser. Pricing Details” multiline displays the following.

I

Indicates whether the task is billed in the invoice release. The indicator 

  • ‘P ’denotes the task is pending execution and hence excluded from the invoice.

  • ‘E’ denotes the task has been completed and hence included in the invoice.

Rev. Ind.

Indicates whether the execution document was revised after authorization.

Cap. Ind.

Indicates whether cap is applicable on repair Price as stipulated in the sale contract for the customer order.

Price Disp.

Details of pricing of the external repair service hired for the maintenance of the Customer parts.

Exe. Doc. Type

The type of the execution document generated for the customer order. In case of Supplier Order based Invoice details, this field will show Purchase order or Repair Order.

Exe. Doc. #

The execution document on the basis of which the maintenance work was externally undertaken via repair order. In case of Supplier Order based Invoice details, this field will show the Purchase Order or Repair Order against which the Invoice was generated.

Parent WO #

The parent work order of the  execution document, if any.

Doc Type

The type of the document generated by the shop work order or customer order for external repairs, or service purchases  such as Repair Order or Purchase Order. In case of Supplier Order based Invoice details, this field will show the caption ‘Supplier Order based Invoice’.

Task OOS?

Indicates whether task is present in RO, which could be any of the following:

  •  Yes – Indicates that at least one task is present in the RO as out of scope

  •  No – Indicates that no out of scope task exists in the RO

WS Info.

Indicates whether workscope details are available for the repair order billed against a customer order, which could be 'Yes' or ' No'.

Click the hyperlinked “yes” displayed in this column to view the “Managing external services task pricing details’ popup.

Doc. #

The repair order or Service / Adhoc purchase order generated for external repairs or service purchases by the execution order/customer order. In case of Supplier Order based Invoice details, this field will show the Supplier Order based Invoice #.

Doc. Line #

The line item in the repair order or Service / Adhoc purchase order generated for the shop work order or the customer order. In case of Supplier Order based Invoice details, this field will show the line # reference from Supplier Order based Invoice which has been retrieved for billing.

Doc. Status

The status of the repair order or the service order.

Exch. Indicator

This field displays Direct, if the repair order part has been exchanged and as Parent if the root work order part has been exchanged.

Supplier #

The ID of the supplier who executed the repair order or purchase order.

Supplier Name

The name of the supplier who executed the repair order or purchase order.

Pricing Basis

The pricing policy for determining the price of external repairs, such as "Cost Plus Margin" or “Cost Incurred”.

Billing Element

The billing element for the resource, such as BER cost or Repair cost.

Part # (as in Doc. #)

The part # as specified in the repair order or Service / Adhoc purchase order generated for external repairs or service purchases by the execution order/customer order. In case of Supplier Order based Invoice details, this field will show the TCD Code & Variant code against which charges are being billed.

Part Description (as in Doc. #)

The description of the part as specified in the repair order or Service / Adhoc purchase order generated for external repairs or service purchases by the execution order/customer order. In case of Supplier Order based Invoice details, this field will show the description of TCD Code & Variant code against which charges are being billed.

Part Attributes

The attributes of the part as specified in the repair order or Service / Adhoc purchase order generated for external repairs or service purchases by the execution order/customer order.

Prime Part #

The prime part for the part as specified in the repair order or Service / Adhoc purchase order generated for external repairs or service purchases by the execution order/customer order.

Part Group

The part group to which the part as specified in the repair order or Service / Adhoc purchase order generated for external repairs or service purchases by the execution order/customer order.

To record details of external services in the invoice release

Qty.

The number of parts sent to the suppler for repair / maintenance. In case of Supplier Order based Invoice details, this will always be 1.

The “Ext. Ser. Pricing Details” multiline displays the following.

UOM

The unit of measurement for the part sent to the suppler for repair/maintenance.

Fact. Applied on

The value on which the price factor is applicable, such as Basic value or Total value.

Basic Rate (Doc. Curr.)

The rate of repair/maintenance for each part as per repair order / purchase order currency.

The basic rate is mandatory, if pricing basis is Fixed Price (FP).

Unit Tax

The tax liable on each part repaired/serviced by the supplier.

Unit Charge

The charge liable on each part repaired/serviced by the supplier.

Unit Discount

The discount granted on each part repaired/serviced by the supplier.

The multiline displays the following:

Ref. Rate (CO Curr.)

The  basic value or the total value of the repair order/ purchase order/ Supplier Order based Invoice/charges from Invoice , based on the field ‘Fact. Applied on’, in the currency of the customer order. The mark-up will be applied on the Ref. Rate (CO Curr.).

Basic Amt. (CO Curr.)

The value of the repair order or purchase order, in the currency of the customer order.

Covered Base Rate

The base rate cap that is not billable for the external service.

The multiline displays the following:

Adj. Base Rate

The base rate the system ascertains after taking into consideration the covered base rate.

  • Adj. Base Rate = Base Rate, if Base Rate >= Covered Base Rate.

  • Adj. Base Rate = 0, if Base Rate < Covered Base Rate.

Final Base Rate

The base rate that is billed for the repair order/ purchase order.

Price Factor

The mark-up on the basic rate of the part repaired/serviced by the supplier. This refers to the percentage of gain over cost to arrive at the price for the service.

Unit Mark-up

The value of mark-up/gain for each repaired/serviced par, which indicates the sum of all the Unit mark-ups against each task in workscope details if Workscope level details are available,

Basic Rate (CO Curr.) * Price Factor

Cap on Unit Mark-up

The upper limit on the mark-up for each part, as stipulated in the sale contract.

The multiline displays the following:

Adj. Unit Mark-up

The unit mark-up after application of the cap on unit mark-up, which will be,

  • Adj. Unit Mark up = Unit Mark-up, if Unit Mark-up<Cap on Unit Markup

  • Adj. Unit Mark up = Cap on Unit Mark-up if Unit Mark-up>Cap on Unit Markup

Note: You must not specify this field, if the quantity of the part consumed is greater than 0.

Final Unit Mark-up

The actual mark-up on each repaired/serviced part that is charged to the customer.

Unit Price

The repair/service price of each repaired/serviced part that is charged to the customer which is the sum of all Unit price against each task applicable to the RO,.if Workscope level details are available.

Covered Unit Price

The amount of the unit price covered cap value that is not billable for the resource as stipulated in the sale contract that is the sum of all Covered Unit prices against each Task in workscope details, if Workscope level details are available..

The multiline displays the following:

Adj. Unit Price

The unit price after application of the covered unit price that is all Adj. Unit prices against each Taskj in workscope details ,.if Workscope level details are available.

  • Adjusted Unit Price = Unit Price, if Unit Price>= Covered Unit Price 

  • Adjusted Unit Price =  0, if Unit Price< Covered Unit Price

Final Unit Price

The repair/service price of each part that is charged to the customer which is the sum of all Final Unit price against each task in workscope details,.if Workscope level details are available.

Extd. Basic Price

The sum total of repair/service price for all parts sent to the supplier.

Basic Rate (Doc. Curr.) * Qty

Extd. Mark-up

The sum total of markup price for all parts sent to the supplier.

Unit Mark-up * Price Factor

Cap on Extd. Mark-up

The upper limit cap for the Extd. Mark-up amount as stipulated in the sale contract of the customer order.

The total mark-up price for the part repaired/serviced by the supplier.

If cap as stipulated in the sale contract is applied on the final extended mark-up price, the extended mark-up will be:

  • Extd. Mark-up or Capped Extd. Mark-up whichever is lower

If cap as stipulated in the sale contract is not applied on the final extended mark-up price, the final extended mark-up price will be:

  • Extd. Mark-up

The multiline displays the following:

Adj. Extd. Mark-up

The mark-up after application of cap on extended mark-up.

  • Adj. Extd. Mark up = Extd. Mark-up, if Extd Mark-up<Cap on Extd Markup

  • Adj. Extd. Mark up = Cap on Extd. Mark-up, if Extd Mark-up > Cap on Extd Markup

Final Extd. Mark-up

The total mark-up price for the part repaired/serviced by the supplier.

If cap as stipulated in the sale contract is applied on the final extended mark-up price, the extended mark-up will be:

  • Extd. Mark-up or Capped Extd. Mark-up whichever is lower

If cap as stipulated in the sale contract is not applied on the final extended mark-up price, the final extended mark-up price will be:

  • Extd. Mark-up

Extd. Price

Extd. Base Price + Final Extd. Mark – up

Covered Extd. Price

The covered cap limit for the Extended price as stipulated in the sale contract for the customer order.

The multiline displays the following.

Adj. Extd. Price

The mark-up after application of cap on extended mark-up.

  • Adj. Extd. Mark up = Extd. Mark-up, if Extd Mark-up<Cap on Extd Markup

  • Adj. Extd. Mark up = Cap on Extd. Mark-up, if Extd Mark-up > Cap on Extd Markup

Final Extd. Price

The final extended mark-up for the part, which will be,

  • Final Extd. Mark-up = Extd. Mark-up, if Cap on Extd. Markup is not available

  • Final Extd. Mark-up = Adj . Extd. Markup, if Cap on Extd. Markup is available

Max. Extd. Price

The upper limit for the extended price as stipulated in the sale contract for the customer order.

The multiline displays the following.

Final Price

The total price of repair/servicing that is charged to the customer.

If cap as stipulated in the sale contract is applied on the final price, the will be:

  • Extd. Price or Capped Extd. Price whichever is lower

If cap as stipulated in the sale contract is not applied on the final price, the will be:

  • Extd. Price

Cap Notes

Additional information on cap on overhead prices charged for the task, as available in the sale contract.

Work Center #

The work center at which the task was executed on the part/aircraft.

Task Status

The execution status of the task, such as Fresh, Pending and Completed.

Quoted?

Indicates whether the task is quoted in the quotation for the customer order.

Qt. App. Status

The approval status of the task in the quotation for the customer order.

Processed?

Indicates that you have verified the resource pricing information.

Inv. Remarks

Additional information on the invoice release.

The multiline displays the following:

Sys. Billable?

Indicates whether the system recommends billing of the task to the customer.

Billable?

Use the drop-down list box to indicate whether you wish to bill the external service to the customer. The drop-down list box displays the following: No and Yes.

Note: You must select “Yes” in this field, if you are to select “No” in the “Warranty Res.” field. Similarly, it is mandatory that you select “No”, if you are to select “Yes” in the Warranty Res.” field.

COA?

Use the drop-down list box to indicate whether the task is out of scope of the customer order The drop-down list box displays the following: In Scope and Out of Scope. Select

  • In Scope to indicate that the task is stipulated in the customer order.

  • Out of Scope to indicate that the task is not stipulated in the customer order nonetheless was carried out due to an unforeseen event/requirement.

Note: 1) The COA for the external service is set automatically to the COA of the task, as specified in the “Reg. Billing Info.” tab. 2) Though you can change the COA of the external service; you cannot select In Scope here, if the COA of the task is Out of Scope. However, the opposite of this is possible.

The multiline displays the following.

Warranty Reco.

Indicates whether the maintenance/execution department recommends warranty for the part/aircraft repaired/maintained by the task.

Warranty Res.

Use the drop-down list box to indicate whether warranty is necessary for the part/aircraft repaired/maintained by the task.

Note: You must select “Yes” in this field, if you are to select “No” in the “Billable” field. Similarly, it is mandatory that you select “No”, if you are to select “Yes” in the “Billable” field.

Bill To Cust.

Use the drop-down list box to specify the customer to whom the service must be billed. The system lists all the values of bill to customer as defined in the Customer master for the customer against whom the Invoice Release is generated.

The multiline displays the following.

Warr Status ES

The warranty status of the customer order.

Price Narration

The price narration for the resource as available in the sale contract of the customer order.

Internal Notes

Additional information on the overhead prices charged for the task.

The multiline displays the following.

Task Type

The type of the task.

Repair Classification

The repair classification of the task as defined in the execution document.

Repair Process Code

The repair process associated with the task as defined in the execution document.

Pricing Task #

Indicates whether the task is a pricing task.

Pricing Task Desc.

The description of the pricing task.

Parent Task #

The parent of the task.

Parent Task Desc.

The description of the parent task.

WS Ref. Code

The work scope of the task as defined in the sale contract of the customer order.

WS Notes

Additional information on the work scope of the task defined in the sale contract.

Incl. /Excl. Ref. Code

The inclusion/exclusion reference code for the as defined in the sales contract. This indicates whether the task is stipulated in the customer order.

Incl. /Excl. Notes

Additional information on the inclusion/exclusion of the task from the customer order.

Part #

The part repaired/serviced by the repair agency.

Mfr. Part #

The manufacturer part # of the part repaired/serviced by the customer service order.

Mfr. #

The manufacturer of the part repaired/serviced by the repair order.

Part Serial #/Lot #

The serial # and/or lot # of the part repaired/serviced by the  repair order

Part Desc.

The short name/description of the part repaired/serviced by the customer service order.

ATA #

The ATA # relevant to the part.

ATA Desc.

The description of the ATA # relevant to the part.

A/C Reg. #

The aircraft repaired/serviced by the customer service order.

Last Updated Log

Displays values for the following as specified at the time of creation of the customer order: Qty., Unit Price, COA?, Billable? & Warranty Res.

Pricing Source

The input source of fixed prices (FP – Mat., FP – Lab. And FP – Oth. Res.), such as System or User.

This field displays “System”, if no user has modified the fixed prices since they were set in the sale contract. Conversely, “User” is displayed here, if users have modified the fixed prices. 

Modification Notes

The reasons for change in prices of the task. This field is mandatory, if the user has modified any of the prices.

The multiline displays the following.

Last Modified by

The employee code and name of the person who modified the price details.

Last Modified Date

The date on which the employee modified the price details.

Reapply Caps

Use the drop-down list box, select ‘Yes’ - to enable the system to apply capping on the mark up, price for the external services. Select ‘No’ to modify the caps in the multiline.