2565 rfsa

From UG

(Difference between revisions)
Jump to: navigation, search
(REQUIREMENTS)
Line 7: Line 7:
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.
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)
*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:
+
**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 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.  
+
***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  
-
*Operators will need to be able to edit these estimates and add additional.
+
**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===
===Point Of Revenue Recognition===
Line 36: Line 45:
* Dollar amount
* Dollar amount
* Currency
* Currency
-
Automatic x% increase to cost details to be defined
+
 
===Reports===
===Reports===
Line 44: Line 53:
*should able to download to excel
*should able to download to excel
Requirements to be defined
Requirements to be defined
-
 
-
 
-
 
==DESIGN IDEAS==
==DESIGN IDEAS==

Revision as of 18:59, 1 December 2010


Contents

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

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.


File:Enter estimated charges on tab.JPG File:Estimation calculated.JPG File:Pl estimation screen.JPG


DETAILED DESIGN

HISTORY

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

Personal tools