2565 rfsa

From UG

Revision as of 22:00, 30 November 2010

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)
  • If nothing in to database matches the required information(TBA defined in Phase 2)the system should automatically calculate the estimated sell by:
    • Pull cost form a database (to also be handled in phase 2) and add 15% to it. The total of the (cost x 15%)+ cost - Work around for Phase one - Operators should manually enter cost. The sell should be based on the above calculation.
• Operators will need to be able to edit these estimates and add additional.

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

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