| Description |
The following changes should be made to contract balance report in order to make it more useful to do a MTM with.
# Get the excel format to be export friendly. Ultimately, the spreadsheet needs to be able to export without all of the header, footers, and odd columns. This makes it difficult to agument the data and put into a pivot.
## Add a grid to the bottom of the report criteria screen
## Add a button to allow people to fill and use the grid rather than run the report - export - and modify
# Add column for commodity, item, Month, Purchase/Sale - Commodity is in the section header. Needs to drop to line. Item is the specific item (not commodity) on the sequence. It is being used but not displayed. Month is the Month from the section header (position month) Purchase or Sale - This is also in the header.
# Get the UOM to be the COMMODITY UOM not Item UOM. Prices are all done by commodity, not item. Right now the qty and price are coverted into the UOM of the ITEM. Example -25KG bag. We need it to be in the UOM of the commodity that is attached to that item. Flour items have lots of UOMs, but are all tied to the commodity SoyMeal, which is Tons.
|Entity|Contract|Pricing
Type
|Date|Ship method|Ship period|Opt|Quantity|Qty UOM|Futures|Basis|Price|Price UOM|Stock UOM|Bal Open|Amount|Commodity|Position Month|Location|Contract tye|Commoty|
| | | | | | | | | | | | | | | | | | | |Purchase / Sale| |
!pastedImage_d109969_0.png!
|Field|Description|
|Entity|Entity on the contract|
|P/S|Purchase or sale contract|
|Item|Item fromt the contract detal|
|NGMO|Ignore|
|Contract|Contract number - Contract sequence|
|Type|Priced - basis|
|Date|Contract Date|
|Ship method|Ship method from contract|
|Ship period|Begin delivery and end delviery from contract sequence|
|Month|Delivery month for the contract|
|Opt|Sequence futures month|
|Quantity|Open balance as of contract date (in stock unit of commodity)|
|Futures|Futures price on Sequence (in stock unit of commodity)
|
|Basis|Basis from sequence|
|Price|Futures plus basis|
|Balance Open|Same as Quantity|
|Amount|Quantity multiplied by the price|
|Freight|Not generated in grid - added manually in excel|
|Adj Amount|Not generated in grid - added manually in excel|
|MKT Basis|Not generated in grid - added manually in excel|
|Mkt Price|Not generated in grid - added manually in excel|
|Mkt Price Conversion|Not generated in grid - added manually in excel|
|Market Value|Not generated in grid - added manually in excel|
|Gain / Loss|Not generated in grid - added manually in excel|
!pastedImage_d109969_1.png!
!pastedImage_d109969_2.png!
|