How Position Report Works

The purpose of the DPR is to provide a view of risk and inventory to the user.

• Exposure to the market – what is the impact on the user if the futures market starts to move? Are we long or short and by how much?
• Basis risk – what is the impact on the user if basis starts to move? Are we long or short and by how much?
• Quantity available for sale – considering what is on hand, what contracts are open, and what is stored for third parties, how much product is available to sell?

1. Position Report.

   This first screen is a summary of company titled inventory, risk (cash) exposure, basis exposure, and quantity available for sale.  Each column is a different commodity.  This data is extracted and summarized from details so we will focus on those details and create the Live DPR summary last.  

Commodity: As each commodity is a row in the report, this selection will determine how many columns will appear. 

UOM: UOM of the commodity. This will be overwritten with the default UOM from the risk management company preference.

Company Titled: 

For each commodity, this is the quantity of inventory owned by the user.

on hand + company owned storage type + DP + difference between purchase and sales collateral+sales basis delivery

In-House

includes company titled and whatever is stored for customers like grain bank/open storage, Excludes in transits.

On Hand + On Storage + DP+ On hold

Price Risk

Company titled(inhouse)- purchase basis belivery + Collateral Sales+Futures + delta options+open purchases quantities* that are priced or HTA -open sales quantities* that are priced or HTA 

Basis Risk

Company titled +open purchase quantities* that are priced or basis - open sales quantities* that are priced or basis

Available for spot sales

Basis exposure - Priced and Basis open* purchases.

 When we select the commodity on the Live DPR grid. and it should be displayed the location wise details in the bottom location grid.

Position include Drop down :

THis will show Licensed and Non licensed type .  To configure the licensed and non licensed storages 

Open the company location from common info module and set "Licenced location " as checked. for any one location .

When we load the Position report with licensed strorage  it will load all the commodities which has got licensed location . and while select the same commodity it will load only the licensed location in the location grid. 

 Same was Non lincesed also will be performed. such as it will load commodities which has got  only non lincesed locations.

Vendor Customer Position check box 

After the check  vendor/customer position is  ticked then the next 2 drop down will be enabled.

Select the check box

enter the type as purchase

Enter the type as sales

When we select the type as purchase then the heading should change to Vendor position inquiry

 When we select the type as sales then the heading should change to Customer position inquiry.

In customer positoin inquiry the DPR grid should show the commodity name, UOM and the inhouse qty.

For Eg:

Create a scale in qty against Grain bank type which ins customer owned for eg: 50 Bu

Create a scale in against the DP which is company owned. for eg: 280 bu

Create a scale in against the on hold for eg: 120 bu

Open Customer position inquiry and check the in house qty

The DPR should show the inhouse qty as

Qty received against the customer owned storage type ( Grain bank) and on hold

 in the above eg: 120+50= 170