CLOSURE - Cotton Inventory Closure
What is CLOSURE
Closure allows cotton companies to close complete sales, purchases and related inventory records ready for archiving (by S12 in dep.bat – S01 parameter).
Contracts need to meet the following criteria to be closed:
i) Sale fully invoiced (Including adjustment and weight adjustment invoices)
ii) Purchases fully invoiced and fulfilled.
iii) Inventory no longer appears in INVACCRUE
iv) Whole Group can be archived
v) MKTP records can be archived
Bales that do not meet the above criteria need to be moved to the following crop year.
There are functions to move the bales in CLOSURE.
1. Move open purchased bales:
Open purchases will be displayed on a grid with a tick column for move.
The following columns will be included on the grid:
Growth, Purchase, Sale, Counterparty, total quantity, shipment period, invoiced quantity, no. of open bales, tick column.
Filter by contract details.
Carry over purchase will be prompted.
On proceed all selected bales will be assigned to the carry over purchase. The invoicing will be moved to the carry over purchase. The invoicing will be combined on the carry over purchase as a single line with document reference “CARRYOVER” this cannot be reversed.
Equity bales cannot be moved to the carry over purchase.
Redeemed bales can be moved to the carry over purchase. But cannot be unredeemed once moved.
2. Process to change the crop year of open sales:
Open sales will be displayed on a grid
Sale, Purchase, Counterparty, total quantity, shipment period, invoiced quantity, tick to change crop year ( default ticked) .
On ok the crop year will be updated on the selected sales.
Closing
a) Submit Request to close the bales/trades; this process is activated by dep.bat sensing that a request (ctrl35_croptoclose <> ‘’) has been made during the day
b) Remove Closure Job from queue will simply undo the ctrl35_croptoclose
c) Submit Request to reopen Cropyear; this process will check what is closed and not archived and will enable the user to reopen the trades/inventory accordingly. The process is activated by dep.bat sensing that a request (ctrl35_croptoreopen <> ‘’) has been made during the day.
Archiving
After a set number of days (ctrl30_archivedays) the sale, purchases and inventory will be archived
Archiving inventory includes archiving class, plan, warehouse, cost, sample, reweighs records, mktp (and any other records held at inv01 level). These will be transferred to the ‘a’ table (inv01a, class01a…)
Archived data is accessible in INVENTORY/Enquiry