2565 rfsa
From UG
(→REQUIREMENTS) |
(→Glossary) |
||
Line 8: | Line 8: | ||
'''Gross Margin''' - same as "P/L". | '''Gross Margin''' - same as "P/L". | ||
- | '''Point Of Revenue Recognition''' | + | '''Point Of Revenue Recognition''' - This is the date that the "Sale" is considered complete. |
- | + | ||
- | This is the date that the "Sale" is considered complete. | + | |
For Ocean LCL and FCL Shipments [[#Port Of Loading Actual Date]] | For Ocean LCL and FCL Shipments [[#Port Of Loading Actual Date]] |
Revision as of 15:32, 2 December 2010
Contents |
PARENT MANTIS
0002515: [Estim P&L] .......<proj>
Glossary
Gross Margin - same as "P/L".
Point Of Revenue Recognition - This is the date that the "Sale" is considered complete.
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
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.
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
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)
SA Notes
HISTORY
0002565: [Estim P&L] Complete Requirements / Design Ideas wiki sections