TRADEREM - Reminder Lists
What is
TRADEREM is a series of simple (content) reports to alert where TRADE may need an action prior to the Expiry date of specific processes.
1. Freight to Fix, Contracts with a shipping status blank AND have not been invoiced AND have a shipment period starting before the expiry date AND contract terms of FOB.
2. Price Fixes, Price Fixing Contract families with a fix-by date prior to the expiry date or a fix period that will be off the board by the expiry date.
3. Margin Invoices, list Contracts which require Margin Invoice generation due to Market Movement exceeding/equalling Margin Movement set up on the contract in TRADE (G&O special)
4. Trust Receipts, Contracts which are marked as Trust/Loan in-complete and their due date is prior to the expiry date.
5. Unpriced Contracts, Contracts that are still marked as Unpriced (TRADE/Pricing/PriceType).
6. Tenders, Warehoused/tenderable Contracts which have not been allocated (sold) and their Certificate Expiry date (phys01_certexpires) is prior to the reports expiry date.
7. Bids/Offers, Quotes/Tickets that are due to expire before the entered date.
8. Marine Insurance (60 days), Contracts whose Marine Insurance is due to expire (TRADE arrival date + 60 days) prior to the selected Expiry Date.
9. TRADE/Stock Sell By, TRADE records that are recognised as being past their Sell-By date, as at Report expiry date. The definition of Sell-By date is D.O.M else Warehouse date with the products shelf life days applied
10. TRADE/Stock Best Before, TRADE records that have a Best Before Date (TRADE/Traffic/warehouse) that is prior to the report’s expiry date.
Technical. This report can be setup to run in the overnight batch with /emailaddr=……….. and /format=pdf
11. Charter Weight not fully assigned, Report CHARTERS and Group Numbers where there is data maintained indicating that a weight and/or number of containers have been agreed with a Shipping Company and the date to be fixed is prior to the selected Expiry Date. The report will show Charters /Group Numbers, where the weight to be fixed has not been fully assigned to TRADEs.
12. Registration Price (fully Priced), lists Fully Priced Fixing Contract families where payment has not been received (phys01_trustdate). The expiry date is applied against the Invoice Due Date (phys01_duedate). Restricted to contracts where Registration Price has been nominated. (div=Mitr P only)
13. Registration Price (Unfixed), list unpriced Fixing Contract families with a fix-by date prior to the expiry date or a fix period that will be off the board by the expiry date (when no fix-by date nominated). Restricted to contracts where Registration Price has been nominated.
14. Bond Enquiry, list the TRADE records that have a Bond Expiry (TRADE/Traffic/warehouse/ Best before date) that is within 45 days of today’s date. The report will section into 6 groups; overdue, 1-3 days, 4-7 days, 8-15 days, 16-30 days, 31-45 days and Overdue (Overdue = records that have Bond Expiry date prior to the date the report is run.
15. 3rd party Storage, list Storage (3rd party) invoicing that is required by the selected expiry date (div=UR only)
16. Missing Market Price date, lists TRADE where Market price maintained with NO market date i.e. could not find on new business a suitable CMYPRICES basis to populate M2M data.