PDF Files:

Page Format:

  • Orientation: Landscape
  • Fixed to 2 Pages


Daily Position Record By Range Filter

Menu ButtonsFunction
Print
  • This will trigger generation of report
Undo
  • This will clear all inputted detail/s
Close
  • This will close the Daily Position Record By Range filter screen
FieldsConditions
Month / Year:
  • Mandatory Field
  • Drop Down List of Months
  • Month Text format: Full Month Name (ex. December)
  • Drop Down List of Year
  • Earliest: 1900 and Latest: Current Yr + 1
  • Year Text Format: YYYY
Commodity:
  • Mandatory Field
  • User is required to select specific Commodity
  • List will be coming from Inventory> Commodities
Location
  • Mandatory Field
  • Will only include all active Company Locations
  • List will be coming from Common Info> Company Locations
  • Includes "All Location" selection
Licensed:
  • Licensed/ Non-Licensed/All selection
  • Blank or No Selection will be considered as All



Daily Position Record Report

Other Components:

Field/ ComponentFormula/Condition
Title
  • Daily Position Record - Form No. 2539 - A For: < Selected Month / Year Format: Mon YYYY>
Location:
  • Selected Location
Commodity: 
  • Selected Commodity
Month:
  • Selected Month  <Format: Mon>
  • Basis of Report Date Range and Rows = Number of Days
Balance Forward:
  • Ending Balance of Previous Month


Page 1

#FieldsFormula/Condition

Physical MovementAny grain in/out movement regardless of ownership
1
  • Unloads
All Inbound Tickets
2
  • Loadouts
All Outbound Tickets
3AdjustmentsInventory Adjustments
4Total Stock

Total stock regardless of ownership

Company owned + Customer Owned


Total Warehouse Receipts (Customer + Collateral WHR Receipts)All Warehouse Tickets
5
  • Issued
Any inbound Transfer to Warehouse Storage or Warehouse Ticket 
6
  • Cancelled
Any outbound Transfer from Warehouse Storage to any non - Warehouse Storage or Contract
7
  • Outstanding
Ending Balance (Open Balance of WH) =  Previous Ending Balance plus Issued minus Cancelled

Terminal Offsite Storage + Offsite Intransit In/OutAny Terminal Storage stored at another Elevator
8
  • In
Any inbound tickets that are Terminal Storage/Offsite Intransit
9
  • Out 
Any outbound tickets that are Terminal Storage/Offsite Intransit
10
  • Total
Ending Balance (Open Balance of All Terminal Storage) =  Previous Ending Balance plus In minus Out

All Customer Storage Types (Except Warehouse Receipts)Open Storage, To Be Distributed, Customer Hold, Grain Bank 
11
  • In

Inbound Storage Tickets, Transfer In Storage

Reversal/ Unposting of Storage Settlement

Inventory Adjustment (+)

12
  • Out 

Outbound Storage Tickets

Grain Bank via Invoice Customer Storage

Transfer Out Storage

Posting of Storage Settlement

Inventory Adjustment (-)

13
  • Total
Ending Balance (Open Balance of All Customer Storage ex. WH) =  Previous Ending Balance plus In minus Out


Page 2

#FieldsFormula/Condition

Price Later ContractAll Delayed Pricing Tickets
14
  • In

Inbound DP Tickets

Transfer to DP

15
  • Out

Transfer from DP to another Storage Type

Settlement of DP

16
  • Balance
Ending Balance (Balance of Price Later Contract) =  Previous Price Later Contract Balance plus In minus Out

Unsettled I/V - Company OwnedAny Unpaid/Paid voucher but not yet processed Pay Voucher (Including DP)
17
  • Increase

Any Unpaid/Paid voucher but not yet processed Pay Voucher (Including DP)

Settlement against Spot/Contract

Spot Sale/Contract/DP Tickets

18
  • Decrease

Processed Pay Voucher (Check/ACH)

Void Voucher

19
  • Balance
Ending Balance (Balance of Unsettled) =  Previous Unsettled Balance plus Increase minus Decrease

Settled I/V - Company Owned (Except Collateral WHR and Intransits)

Any Processed Pay Voucher (Including DP)

20
  • Increase

Any Processed Pay Voucher (Including DP)

Inventory Adjustment (Company  Owned)

21
  • Decrease
Reversal of Pay Voucher (Company  Owned)
22
  • Balance
Ending Balance (Balance of Settled) =  Previous Settled Balance plus Increase minus Decrease
23Company Owned BalanceTotal of Unsettled Balance and Settled Balance
24Total Storage Liability/WHR OwnedTotal of Customer Owned Stocks including all Storage Types (Open Storage, To Be Distributed, Customer Hold, Grain Bank, Warehouse)

Supporting Detail For Settled - Company Owned

  • Collateral WHR Receipts
All Customer Owned Collateral Warehouse Receipts (Negotiable Only)

    • Issued
Any inbound transaction Customer Owned Collateral Warehouse Receipts

    • Cancelled
Any outbound transaction Customer Owned Collateral Warehouse Receipts

    • Outstanding
Ending Balance (Open Balance of Collateral WH) =  Previous Ending Balance plus Issued minus Cancelled

  • Intransit Outbound Balance
Any outbound tickets that are Intransit

  • Intransit Inbound Balance
Any inbound tickets that are Intransit




  • No labels