3 <title>Reorder Exceptions by Planner Code</title>
4 <name>ReorderExceptionsByPlannerCode</name>
5 <description></description>
8 <topmargin>50</topmargin>
9 <bottommargin>50</bottommargin>
10 <rightmargin>50</rightmargin>
11 <leftmargin>50</leftmargin>
14 <sql>SELECT <? if exists("plancode_id") ?>
15 ( SELECT (plancode_code || '-' || plancode_name)
17 WHERE plancode_id=<? value("plancode_id") ?>)
18 <? elseif exists("plancode_pattern") ?>
19 text(<? value("plancode_pattern") ?>)
21 text('All Planner Codes')
24 <? if exists("includePlannedOrders") ?>
30 <? if exists("warehous_id") ?>
31 ( SELECT warehous_code
33 WHERE (warehous_id=<? value("warehous_id") ?>) )
41 <sql>SELECT warehous_code, item_number, item_descrip1, item_descrip2,
42 formatDate(reorderdate) AS f_reorderdate,
43 formatQty(reorderlevel) AS f_reorderlevel,
44 formatQty((itemsite_qtyonhand - qtyAllocated(itemsite_id, reorderdate) + qtyOrdered(itemsite_id, reorderdate))) AS f_projavail,
46 FROM ( SELECT itemsite_id,
47 CASE WHEN (item_type IN ('M', 'B', 'T')) THEN 1
48 WHEN (item_type IN ('P', 'O')) THEN 2
51 warehous_code, item_number, item_descrip1, item_descrip2,
52 reorderDate(itemsite_id, <? value("lookAheadDays") ?>, <? if exists("includePlannedOrder") ?>true<? else ?>false<? endif ?>) AS reorderdate, itemsite_qtyonhand,
54 FROM ( SELECT itemsite_id, itemsite_item_id, itemsite_warehous_id,
56 CASE WHEN(itemsite_useparams) THEN itemsite_reorderlevel ELSE 0.0 END AS reorderlevel
59 <? if exists("warehous_id") ?>
60 AND (itemsite_warehous_id=<? value("warehous_id") ?>)
62 <? if exists("plancode_id") ?>
63 AND (itemsite_plancode_id=<? value("plancode_id") ?>)
64 <? elseif exists("plancode_pattern") ?>
65 AND (itemsite_plancode_id IN (SELECT plancode_id
67 WHERE (plancode_code ~ <? value("plancode_pattern") ?>)))
70 ) AS itemsitedate, item, whsinfo
71 WHERE ((itemsite_item_id=item_id)
72 AND (itemsite_warehous_id=warehous_id))
74 WHERE (reorderdate IS NOT NULL)
75 ORDER BY reorderdate, item_number;</sql>
89 <weight>normal</weight>
93 <string>Exception Date</string>
105 <weight>normal</weight>
109 <string>Description</string>
121 <weight>normal</weight>
125 <string>Reorder Level</string>
137 <weight>normal</weight>
141 <string>Include Planned Orders:</string>
153 <weight>bold</weight>
157 <string>Reorder Exceptions by Planner Code</string>
169 <weight>normal</weight>
173 <string>Site:</string>
185 <weight>bold</weight>
190 <query>Parameter Query</query>
191 <column>lookAheadDays</column>
204 <weight>normal</weight>
208 <string>Proj. Avail.</string>
227 <weight>normal</weight>
231 <string>Item Number</string>
243 <weight>normal</weight>
247 <string>Site</string>
259 <weight>bold</weight>
265 <column>includeplnord</column>
278 <weight>bold</weight>
284 <column>warehouse</column>
297 <weight>bold</weight>
303 <column>plannercode</column>
316 <weight>normal</weight>
320 <string>Look Ahead Days:</string>
332 <weight>normal</weight>
336 <string>Planner Code(s):</string>
355 <weight>normal</weight>
359 <string>Item Number</string>
371 <weight>normal</weight>
375 <string>Proj. Avail.</string>
394 <weight>normal</weight>
398 <string>Reorder Level</string>
410 <weight>normal</weight>
414 <string>Exception Date</string>
426 <weight>normal</weight>
430 <string>Description</string>
442 <weight>normal</weight>
446 <string>Site</string>
453 <query>detail</query>
473 <weight>bold</weight>
478 <query>detail</query>
479 <column>warehous_code</column>
492 <weight>bold</weight>
497 <query>detail</query>
498 <column>item_descrip2</column>
511 <weight>bold</weight>
516 <query>detail</query>
517 <column>f_reorderdate</column>
530 <weight>bold</weight>
535 <query>detail</query>
536 <column>f_reorderlevel</column>
549 <weight>bold</weight>
554 <query>detail</query>
555 <column>f_projavail</column>
568 <weight>bold</weight>
573 <query>detail</query>
574 <column>item_number</column>
587 <weight>bold</weight>
592 <query>detail</query>
593 <column>item_descrip1</column>
610 <weight>normal</weight>
614 <string>Page:</string>
626 <weight>normal</weight>
630 <string>Report Date:</string>
642 <weight>bold</weight>
647 <query>Context Query</query>
648 <column>page_number</column>
661 <weight>bold</weight>
666 <query>Context Query</query>
667 <column>report_date</column>