【文章內(nèi)容簡介】 Purchase Order Line. Ensuring that the percentages for all Purchase Order Lines, on one Purchase Order, exactly sum to 100%. The ability to record the Freight, Duty and Insurance costs associated with each inventory receipt and add these extra costs to the receipt cost of the particular item. Order EntryAt Order Entry Screen, it is required to give the user a sorting option in viewing the existing lots 9drums) in descending order of variance percentage (requested length vs available length). PurchasingUpon rejection of goods after receipt, give user a option to auto generate a debit memo. Oracle Alert should hold the payment for all the invoices with the matching PO item shipment line. Cable Stock Management SystemBest Fit Pick Process (Batch) Start searching for all the shortest length cables to meet the best fit (may be with acceptable tolerance %) Accounts PayablesRequirementsModification DescriptionAccounts Payables Due DateThe system must be capable of selecting invoices for payment on the basis of a range of dates and the user may then pay all invoices selected or edit the selected invoices prior to initiating the payment process.You can only enter a due date in the payment selection, not a due date range.Provide another payment selection program, or change the existing program to allow enter due date range. Alternate PayeeIn a number of instances suppliers have directed payment to be made to a third party at an address different from that of the supplier. The system must be capable of maintaining the necessary records to support an alternate payee. The system shall be able to settle all invoices of a vendor, including all redirected invoices from other vendors using the alternate payee function, in one single cheque in a payment cycle.You can store alternative payee name or use one of the contact person as alternative payee.Create a flag to indicate whether alternative payee will be used or not by descriptive flexfieldChange of the payment program to select alternative payee based on the flag.Another way is to create the alternative payee as a normal vendor in the systemUse descriptive flexfields to store the vendor code of the alternative payee.Change the payment program to use the alternative payee vendor details. Invoice TrackingWith the functionality outlined in , the system must be capable of tracking the progress of the invoice by location and processing stage. This information should be accessible to users enquiring of the progress of the invoice.System should be able to record the name and location of the action officer who approve the invoice or perform invoice matching to PO.Descriptive Flexfields can be created to store the required informationCreate a new invoice inquiry function which allow user to enter criteria in the descriptive flexfields Bank AccountsThe system shall be able to automatically assign the appropriate bank account for paying the invoices based on account code, amount and currency.The system should be able to perform the following :1. based on the account code to determine the type of expenses : CAPEX or OPEX2. There are specific bank accounts assigned for CAPEX and OPEX expenses respectively.3. For OPEX expenses, if the amount is less than a predefined amount (. 1M), a particular bank account will be used. Otherwise, another bank account will be used.Program modifications :1. In bank account maintenance, add fields to specify whether the bank account will be used for OPEX and CAPEX and for what amount range.2. In invoice, store the information which can be used to determine the type of expenses (note that the account code structure may be changed so that it may be not able to use the account code to determine the type of expenses in future)3. In payment batch creation, user still need to specify they want to pay OPEX or CAPEX expenses and amount range by specifying the bank account4. Change the invoice selection program to provide the intelligent to base on the flag stored in the invoice to determine the type of expenses and amount range. It then select only those invoices for payment. Internal Satellite Systems FunctionalityBased upon the information Oracle has on the Internal Satellite systems functionality Oracle has identified minor extensions and or workarounds to be applied for replacing the following two Satellite Systems by using Oracle Standard Products, the Mobile Sales and Administration SystemMSAS and the Deliver Order Transmission System. During the Definition phase of the implementation Project the detailed requirements will be defined and agreed upon. InterfacesThe plex mix of existing legacy Satellite Systems ,25 systems recognized as internal and another 12 systems recognized as external to the logistics system , new custom systems, and nonOracle systems make interface development a critical part of the project.However through the replacement of 20 internal satellite systems by Oracle Applications standard function and features, the effort of developing interfaces has bee less critical for the project implementation and gives HKT an important benefit in embedding some of the standalone systems as integrated parts of the Logistics system. Thus avoiding redundant data capture and maintenance effort of the Satellite SystemThe Oracle project manager together with the Hongkong Tele project manager will manage the remaining interface development process using Oracle’s interface development procedures. System InterfacesOracle will develop twentysix (26) interfaces between 2 internal and 12 external Satellite Systems and the Oracle Applications. All interfaces will be filetofile interfaces, not programtoprogram interfaces. Data wi