What is GENENQ
This procedure is designed to view summarised information of any of the 3 accounting ledgers and the Trading databases.
After viewing summaries you can drill-down into a large amount of detail, constructing your own detail report layouts.
The facility to view summary Open Position TRADE tonnage by user selective grids is very powerful, e.g. select row by product and column by contract terms and you can see the company Freight exposure i.e. net Fob, net CIF tones. The Sales turnover/gross margin summary is similarly viewed here with your own grid content so it is possible to see by product, by counter-party, by period, by dept etc. The Shipping Position grid is a produce style front sheet that has several powerful drilldown features.
There are options for producing Consolidated enquiries (TRADENet, TradeBook and Shipping Position) to include any number of companies that are maintained on the same ITAS server. The Options icon on the tool bar enables this feature with it’s tight security on access rights by the user.
The different modes of enquiry are listed here and are all controlled by CMP/Privilege access rights.
View Trade Net [TRADENET]
Summary positions with physicals/futures/Inventory segregation, producing a single representation of selected Stocks, Physicals, Futures and Options positions. The content is any 'open' status tonnages i.e. TRADEs that have not been closed. F&O positions will be located for any House account that remain on the TERM database with settled deals being optionally included. The presentation is fixed with ROWS reporting Priced tonnage, Un-priced tonnage, Futures, F&O Options reported with Delta'd and In-Out-Money valuations and Pricing-to-come. The Futures are sectioned with hedge/price-fixings recognised with their TERM code (TERMCODES/Tradecode), and the other section reporting the remaining trades which may represent arbitrage /spec trading. The COLUMNS represent the trading periods as maintained in TRADE with the physicals using either the ‘Valuation period’ or ‘Position Month’ (user selection from Options icon) to position the tonnage. If any contracts are priced with an absolute market price and VALUATION period has been selected, then they will be positioned in the 'spot' column. The F&O rows use their prompt month for column positioning and the Price-to-come uses the contract Fixation month. The rows within each section are further divided by physical commodity code, F&O market or F&O broker. There are a series of 'Options' available for tailoring the report content with one being to include settled F&O or not. The ‘Options’ allow include/exclude Inventory. When Inventory is included and Sales are allocated to Inventory and the Sale is Invoiced, then the Sales tonnage is excluded because the inventory is automatically excluded and any F&O hedges would be nett to zero. F&O trade records to be included must be assigned to CLI accounts that are nominated as ‘House’ type, this enables exclusion of 3rd party trading. Physicals trades are excluded by the relevant tick boxes e.g. 3rd Party/Consignment, Brokerage; these are viewed from the Option icon .
View Commodity Trade Net [TRADENET]
Summary positions with physicals/futures/Inventory segregation organised by principal Physical Commodity code. This allows, for example, a combined report of different Coffee or Sugar types with net totals. The content is any 'open' status tonnages i.e. TRADEs that have not been closed. F&O positions will be located for any House account that remain on the TERM database with settled deals being optionally included. The presentation is fixed with rows reporting Priced tonnage, Un-priced tonnage, Futures, Options reported with Delta'd and In-Out-Money valuations and Pricing-to-come. The Futures are sectioned with hedge/price-fixings recognised with their TERM code (TERMCODES/Tradecode), and the other section reporting the remaining trades which may represent arbitrage /spec trading. The columns represent the trading periods as maintained in TRADE with the physicals using the contract valuation period to position the tonnage. If any contracts are priced with an absolute market price they will be positioned in the 'spot' column. The F&O rows use their prompt month for column positioning and the Price-to-come uses the contract Fixing month. The rows within each section are further divided by physical commodity code, F&O market or F&O broker. There are a series of 'Options' available for tailoring the report content with one being to include settled F&O or not. The ‘Options’ allow include/exclude Inventory. When Inventory is included and Sales are allocated to Inventory and the Sale is Invoiced, then the Sales tonnage is excluded because the inventory is automatically excluded and any F&O hedges would be nett to zero.
View Trade Book [TRADEBOOK]
Summary physical positions, you select the style of tradebook enquiry required, principally reporting unallocated tonnage with each contract tonnage rounded to whole MT equivalent, (except for Turnover style). The period analysis/presentation is described in local helps for row/columns. The turnover report again allows user selected rows/columns with each grid co-ordinate reporting Sales MT invoiced, the sale proceeds and Gross margin calculation. The Net Open style allows the user to select rows/column content and all buy + sell tonnage are netted showing the net as -ve for short positions. The Net not sales invoiced style, user selects rows/columns but allocated contracts that are NOT sales invoiced will be included in the report. Note tolled/processed tonnage are considered as Sales Invoiced. The Unallocated Sales report allows selection of rows/columns but only shows sales tonnage irrespective of filter selections. The Unallocated Purchases style, user selects rows/columns and only reports Buy tonnage.
View Contract History [CONTRACTHISTORY]
This enquiry is essentially the same as Trade Book where you pick your own style of report etc. The reason for it’s existence is that all TRADE tonnages including archived, write-offs and weigh-losses can be viewed and this provides a powerful tool for reviewing the history of any commodity, counter-party, vessel etc. The Option feature allows for different styles of X-Y headings and this is ideal for where wish to ascertain how many tons were shipped from which Origin or for which Counter-Party or for which commodity or for which Destination etc
View Shipping Position [SHIPPINGPOS]
The content is the filtered contracts with the 'Options' selection allowing any allocated contracts to be excluded. The presentation is fixed with columns of Stock, Afloat, Past shipment/delivery dates and a column for each shipment/delivery month (using the period analysis/presentation code as entered in TRADE).The rows are the individual commodity/product codes (parts 1,2,3 only). After viewing the summary there are options to view the net tonnage per row by Buy and tonnage. Other options are to view the warehoused stock position by individual warehouse locations and to view Afloat positions by Destination. There are feature to explode BOM products into their raw material requirements and view the position as a simple resource planning guide.
View Client Accounts [CLIENT]
Use filter to restrict list of accounts for picking. When you have selected an account, you will then have a choice of full (enquiry mode) CLI, a simple list of static description or view the associated TRADE contracts (for drill-down into individual items).
View WIP Accounts [WIP]
Use filter to restrict list of accounts for picking. When you have selected an account, you will then have a choice of full (enquiry mode) WIP, a simple list of static description or view the associated TRADE contracts (for drill-down into individual items).
View Vessels [VESSEL]
Use filter to restrict list of names for picking. When you have selected a name, you will have a choice of full (enquiry mode) TRADE for the associated contracts, a simple list of static description or view the associated WIP accounts in full (WIP enquiry mode).
View Contracts [CONTRACTS]
Use filter to restrict list of contracts for picking. When you have selected a contract, the choices are full (enquiry mode) TRADE, a simple list of contract details, or view the associated INVOICES.
View Nominal Accounts [NAQ]
Use filter to restrict list of accounts for picking. When you have selected an account, you can activate a full (read only) NAQ procedure to view and drill-down.
View Commodity Open Position [CMYOPENPOS]
Use filter to restrict list of contracts to view. This style will report a row per selected Commodity code with columns purpose defined by the user, using the Options button on the task bar. The criteria in the build is strictly applied so the report will be incomplete if any positions are not selected. There is a colour coding feature that enables a graphic presentation style, controlled by user using Options.
The grid drill-down information can be viewed/printed/dispatched in HTML, XML etc.