2565 rfsa

From UG

Contents 1 PARENT MANTIS 2 REQUIREMENTS 2.1 Point Of Revenue Recognition 2.2 Estimated Cost 2.3 Estimated Sell 2.4 Reports 3 DESIGN IDEAS 4 DETAILED DESIGN 5 HISTORY

PARENT MANTIS

0002515: [Estim P&L] .......<proj>

REQUIREMENTS

Core: Enable accounting to “close out” the month end, at the actual end of each month, based on estimated charges. In order to achieve this we will follow the below.

• Pull the estimated sell rate from a database to be entered under the client profile (to be handled on phase 2)
• Pull cost form a database (to also be handled in phase 2)
• we will require operators to enter estimated sales and costs at the required point of revenue recognition.

Point Of Revenue Recognition

For Ocean LCL and FCL Shipments #Origin Terminal Actual Date

For Air shipments #Airport Of Departure Actual Date

For Truck shipments #Actual Export Pick Up Date

Estimated Cost

should reflect:

• Dollar Amount
• Vendor
• Currency
• Charge Code
• Charge Code Description

Estimated Sell

should reflect:

• Bill To Party
• Dollar amount
• Currency

Automatic x% increase to cost details to be defined

Reports

• Should be able to generate a report showing both estimated cost/sell and actual cost/sell
• The report should be per CT record
• should be within a selected time frame
• should able to download to excel

Requirements to be defined

DESIGN IDEAS

These charges will be entered in on a separate Tab Est., as per examples below

Once these charges are entered into this Estimation invoice – It should then pull through and show on the P/L tab.

DETAILED DESIGN

HISTORY

0002565: [Estim P&L] Complete Requirements / Design Ideas wiki sections