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.

Estimation for freight charges:

• Pull the estimated sell rate from a database to be entered under the client profile (to be handled on phase 2)
  • If nothing is in the database that matches the required information(TBA defined in Phase 2)the system should automatically calculate the estimated sell by:
    • Pull cost from a database (to also be handled in phase 2) and add 15% to it. The estimated sell should equal the total of the (cost x 15%)+ cost
  • Work around for Phase one - Operators should manually enter cost. The sell should calculate automatically be based on the above calculation.
• Operators will need to be able to edit the costs and sell and cost or sell estimations manually.
• They should also be able to add and remove lines from the estimation.

Exception:

• Customs Cost's
  • Charge Codes beginning with 12 should have no calculation. The sell should match the cost entered.
  • The operators should still be able to manually update the cost and sell and the cost or sell.

Point Of Revenue Recognition

For Ocean LCL and FCL Shipments #Port Of Loading 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

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

Please see attachments

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.

The difference between actual and estimation should be easily identified (by example attached maybe using a lighter color)

DETAILED DESIGN

HISTORY

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