2565 rfsa
From UG
(Difference between revisions)
(→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 | + | **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 | + | ***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 | + | **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 | ||
- | + | ||
===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.
- 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:
- 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.
DETAILED DESIGN
HISTORY
0002565: [Estim P&L] Complete Requirements / Design Ideas wiki sections