TRAFREP - Traffic Report
What is
TRAFREP is designed for reporting mainly stocks classified TRADE details. However there are several styles that are more general e.g. ‘Traffic managers’, ‘Insurance Declarations’, ‘Warehouse Accruals’.
Most of the report styles illustrate summaries per parcel with the 'with deliveries' being a full detailed sheet per warehouse/reference with every Sales call-off/delivery listed and specific warehouse transfers (e.g. Toll/Mixing/process out-turns) showing gross & nett weights.
Gross and Nett weights use the shipping weight terms and tare from the TRADE records, with any missing tare details located from the PHYSCODES/Packing codes table.
The Warehouse Storage/Rent Accruals (style 17). This applies CLI/Warehouse rates with the status of the Warehoused tonnages to produce a report of accrual charges for outstanding storage/rent. Storage rates are setup as either per day, Per full calendar month where if there is a number of days storage that is less than a full month charge, the rate will be based on 30 days and calculated accordingly OR per full or part calendar month where this basis for charging is irrespective of how many days are applicable for storage in any calendar month included in the time frame e.g. start rent on 10th June and exit on 20th August would generate 3 months charges.
The Traffic Managers Report (style 13) will provide a full list of trades that are marked with a shipping status e.g. nominated, afloat, landed, warehoused, arrivals. Tonnage and values are reported with some vessel, ETA, arrival dates and warehouse details. This ideal for a pre-arrival report.
The inclusion of which TRADE records is defined by the shipping status of the TRADE record. There is a selection grid of the different PHYSCODE/Shipping status with suggested defaults automatically applied from the PHYSCODES maintenance grid.
The Warehouse Movements reports lists movements, (incoming purchases and outgoing sales and warehouse transfers) starting with the brought forward date and finishing at the end of the carried forward date. The brought forward bags and quantity figures are totals of the movements up to the brought forward date, that remain as Open status TRADE records and their Shipping Status is included in the list. The carried forward bags and quantity figure are the balances at the end of this report, but do not necessarily correlate with the next report with that date's start point. This can be the situation where retrospective movements are applied in TRADE and therefore implicitly change the content of the previous report. The warehouse transfers are recognised in TRADE/traffic whereby the user is asked if this is a valid movement or an amendment to incorrect previous data.
Other report styles include Traffic Managers 'Afloats' which is sequenced by Vessel/Commodity and the ‘Purchases & Deliveries’ listing which is useful for an audit of how a tonnage has been processed/allocated/written-off.
The styles 3+4 provide an useful final page summary of Stocks per product group/product/pack code with units, weight, Stock value and Unallocated stock values.
Style 7 is used to review what has happened to all parts of a Purchase TRADE and it’s allocations. This is useful for the review of Stocks that are processed and Write-offs have occured, the delivery scheme is also reported.
Style 9 is used to show all unallocated Stocks and the detail of the last 2 deliveries into Stock. This report is designed for the listing of sundries stock items with goods status, shelf life etc to assist in production and call-off completion (Just In Time operation)
Style 10 is used to show all unallocated Stocks and the expected deliveries-out for the next 3 working days.
This report is designed for the listing of sundries stock items with goods status, shelf life etc to assist in production and reordering (Just In Time operation
Style 11 reports the tonnage and value of Goods Consumed within the selected cut off dates. Goods in transit are not included in the report. The report is organised by commodity group code and main commodity code. The consumption details are maintained in TRADE/Traffic/Miscellaneous.
Style 12 reports Insurance Declaration details within the selected cut off dates. The declared value and the premium paid are reported in various sequences and levels of detail. The Insurance Declaration details are maintained in TRADE at either Group level (prior contract selection) or on an individual tonnage in TRADE/right-click. The Formal process (tick box) will mark Declarations that are listed as now having been SUBMITTED to the Insurance Company and any subsequent cancellation will be similarly reported to the Insurance Company.
Style 14 reports a separate page per Warehouse/Rotation Ref showing all the Stock items (not marked as Status Closed) with sections of Allocated & Invoiced and Allocated & Not Invoiced tonnages. All the memorandum that are maintained in TRADE will be reported on the Stock card.
Style 15 reports 3 sets of summary Stock values and tonnage. The sections are stock by Department, stock by Warehouse, stock by warehouse country. The detail reports 1 + 2 will support the summary values.
Style 16 is a VERY specialised report for . See the legend on the selections page of the produced report. It operates with very explicit knowledge of what shipping status means what condition and is not easily adapted for other Operating companies.
Style 18 is a specialist Cocoa Out-turns report that is only enabled for companies setup for the process.
Style 19 is a specialist Stocks/qualities/samples report. Reports unallocated, Purchase tonnages that have their shipping status selected in the relevant prompt. Excludes Brokerage and 3rd Party tonnages.
Style 20,21 are specialist Insurance reports using INSCODES data.
Style 22 is a specialist Cocoa Product code/Warehouse/Shed/samples report. Reports unallocated, Purchase tonnages that have their shipping status selected in the relevant prompt. Excludes Brokerage and 3rd Party tonnages. It is similar to style 19 in design but different sectioning/totals
Style 23 shows completed and current voyages. The driver of this report is the B/L date and any contract split with a B/L date within the selected date range will be reported regardless of its current shipping status. The Report also includes reshipments i.e. contracts with a status of ‘V’ created in Traffic with the ‘New Voyage’ function.
Style 24 lists all detailed Sales deliveries (as per TRADE - phys07). The only filtering is the use of TRADE filter. The presentation is to show deliveries by Product/Dept/Sale Contract and the layout is very explicit to application of PHYSCODES/Commodity parts 3 and 4.
Style 25 (Aged Stocks) lists Open status Purchases where there is a BL date which is consistent with the Cut-off date selected. The difference to the style 13 report is to provide different sequencing and to show Agedness basis the PI (Purchase Invoice) date relative to today. Summaries by Warehouse and value/weight bands are produced. The application of TRADE BL date and TRADE Arrival date determines what section a TRADE is placed e.g. warehoused, afloat. This report does not use TRADE shipping status for its’ groupings. Exclusion of allocated trades can be enabled by entry of Sales invoice Cut-off date
Style 26 (Warehouse warrant and analysis) lists all selected Purchase trades and reports any warrant and analysis details. This is very specialist and is only available for companies setup for operating Warrant subsystem. The report is not suitable for printing, there are too many columns, but can be viewed on-line or exported to excel..
The filtering allowed on selected report styles includes:-
a) exclude allocated TRADE records which will produce a report showing all logical warehoused stock available for sale
b) exclude allocated TRADE records which have been marked as Sales Invoiced. If the date is applied, the report will list all stock that legally belongs to the Operating company.
c) exclude allocated TRADE records which have been marked as Sales Invoiced at a specific date, this produces a retrospective report of all stock that legally belonged to the Operating company at that date e.g. month-end
d) which database to use (if the company is maintaining frozen positions)
Extra sub-totalling can be requested by use of tick boxes, according to style/sequence of report selected.