Dear Team,

The process to approve and convert requisition into a PO is not being completed.

I have run the data integrity but I am not able to REBUILD.
It checks but says it finds nothing but something is wrong.

Previous backups work but as of yesterday it has stopped working, can convert Requisitions to a PO

Need help urgent...

Thanks guys...(see below)

INTEGRITY CHECK...
User : SYS 1/11/2013 10:35:06 AM

PHASE 1 : FILE INTEGRITY TEST

Checking I/R Audit File AJC
I/R Audit File AJC... Ok
Checking I/R Audit GL
I/R Audit GL... Ok
Checking I/R Audit File
I/R Audit File... Ok
Checking I/R Auto Generation
I/R Auto Generation... Ok
Checking I/R Details Req Composite (1,2)
I/R Details Req Composite (1,2)... Ok
Checking I/R Comments
I/R Comments... Ok
Checking I/R Contract Pricing
I/R Contract Pricing... Ok
Checking I/R Competitive pricing
I/R Competitive pricing... Ok
Checking I/R Email Cover Detail
I/R Email Cover Detail... Ok
Checking I/R Email Cover Header
I/R Email Cover Header... Ok
Checking I/R Email Queue
I/R Email Queue... Ok
Checking I/R Event Budgets
I/R Event Budgets... Ok
Checking I/R User Group Access Levels
I/R User Group Access Levels... Ok
Checking I/R User Groups Form Rights
I/R User Groups Form Rights... Ok
Checking I/R Company Profile
I/R Company Profile... Ok
Checking I/R G/L Transaction Batch
I/R G/L Transaction Batch... Ok
Checking I/R Header
I/R Header... Ok
Checking I/R Header History
I/R Header History... Ok
Checking I/R Item History
I/R Item History... Ok
Checking I/R Header Req
I/R Header Req... Ok
Checking I/R Header Template
I/R Header Template... Ok
Checking I/R Import Export File Details
I/R Import Export File Details... Ok
Checking I/R Import Export File Header
I/R Import Export File Header... Ok
Checking I/R Import Defaults Field Values
I/R Import Defaults Field Values... Ok
Checking I/R Sundry Items
I/R Sundry Items... Ok
Checking I/R Company Profile Lock
I/R Company Profile Lock... Ok
Checking I/R Details History Additional
I/R Details History Additional... Ok
Checking I/R Details History
I/R Details History... Ok
Checking I/R Details Master
I/R Details Master... Ok
Checking I/R Details Additional
I/R Details Additional... Ok
Checking I/R Details Req Additional
I/R Details Req Additional... Ok
Checking I/R Details Req 1
I/R Details Req 1... Ok
Checking I/R Details Template Additional
I/R Details Template Additional... Ok
Checking I/R Details Template
I/R Details Template... Ok
Checking I/R Miscellaneous Charges
I/R Miscellaneous Charges... Ok
Checking I/R Parameters
I/R Parameters... Ok
Checking I/R Item Pictures
I/R Item Pictures... Ok
Checking I/R Print Order Options
I/R Print Order Options... Ok
Checking I/R Print Doc Options
I/R Print Doc Options... Ok
Checking I/R Pick-up Addresses
I/R Pick-up Addresses... Ok
Checking I/R Screen Defaults
I/R Screen Defaults... Ok
Checking I/R Shipto Addresses
I/R Shipto Addresses... Ok
Checking I/R Tax Tracking
I/R Tax Tracking... Ok
Checking I/R Totals History
I/R Totals History... Ok
Checking I/R Totals Req
I/R Totals Req... Ok
Checking I/R Totals Template
I/R Totals Template... Ok
Checking I/R Totals
I/R Totals... Ok
Checking I/R Tax Groups
I/R Tax Groups... Ok
Checking I/R Tax Group Jurisdictions
I/R Tax Group Jurisdictions... Ok
Checking I/R Audit
I/R Audit... Ok
Checking I/R User Groups
I/R User Groups... Ok
Checking I/R Ship Via Table
I/R Ship Via Table... Ok
Checking I/R Sundry Vendors
I/R Sundry Vendors... Ok

Deleting temporary files...

PHASE 2 : DATA INTEGRITY TESTS
Outstanding vendor/job costing balances will only be checked if a day end is performed before running the integrity check.

Verifying vendor and line counts...


Verifying Total records...


Verifying orphan line records...


Verifying qty on PO (IC item locations)...


Verifying qty on PO (IC items master)...

Item number : 140 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-90). -- Fixed.
Item number : 152 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-80). -- Fixed.
Item number : 219 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-200). -- Fixed.
Item number : 276 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-300). -- Fixed.
Item number : 295 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : 387 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-10). -- Fixed.
Item number : 425 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-100). -- Fixed.
Item number : 474 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-90). -- Fixed.
Item number : 529 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-100). -- Fixed.
Item number : 572 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-20). -- Fixed.
Item number : 596 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-30). -- Fixed.
Item number : 601 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-960). -- Fixed.
Item number : 602 - Quantity on Purchase Order (480) does not match quantity in IC Items Master (0). -- Fixed.
Item number : 622 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-500). -- Fixed.
Item number : 746 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-50). -- Fixed.
Item number : 856 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-600). -- Fixed.
Item number : 877 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-100). -- Fixed.
Item number : 888 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-14). -- Fixed.
Item number : 897 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1500). -- Fixed.
Item number : 900 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-2400). -- Fixed.
Item number : 950 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-180). -- Fixed.
Item number : 1040 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-140). -- Fixed.
Item number : 1049 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-55). -- Fixed.
Item number : 1159 - Quantity on Purchase Order (3100) does not match quantity in IC Items Master (2800). -- Fixed.
Item number : 1163 - Quantity on Purchase Order (560) does not match quantity in IC Items Master (0). -- Fixed.
Item number : 1225 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-10). -- Fixed.
Item number : 1234 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-6). -- Fixed.
Item number : 1249 - Quantity on Purchase Order (50) does not match quantity in IC Items Master (-50). -- Fixed.
Item number : 1250 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-15000). -- Fixed.
Item number : 1369 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-2160). -- Fixed.
Item number : 1377 - Quantity on Purchase Order (60) does not match quantity in IC Items Master (0). -- Fixed.
Item number : 1384 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-6). -- Fixed.
Item number : 1455 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-36). -- Fixed.
Item number : 1475 - Quantity on Purchase Order (2400) does not match quantity in IC Items Master (1800). -- Fixed.
Item number : 1516 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-150). -- Fixed.
Item number : 1529 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-2). -- Fixed.
Item number : 196A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-60). -- Fixed.
Item number : 318A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-120). -- Fixed.
Item number : 387A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-13). -- Fixed.
Item number : 521A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-4320). -- Fixed.
Item number : 572A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-42). -- Fixed.
Item number : 592B - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-100). -- Fixed.
Item number : 799A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-30). -- Fixed.
Item number : CSPT - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : 1037A - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : 1249C - Quantity on Purchase Order (150) does not match quantity in IC Items Master (-250). -- Fixed.
Item number : 1353A - Quantity on Purchase Order (6) does not match quantity in IC Items Master (-6). -- Fixed.
Item number : AND01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-4). -- Fixed.
Item number : AVC01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-5). -- Fixed.
Item number : AVT01 - Quantity on Purchase Order (7) does not match quantity in IC Items Master (6). -- Fixed.
Item number : CPT01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-4). -- Fixed.
Item number : CSR03 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-84). -- Fixed.
Item number : DHS01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : DSP03 - Quantity on Purchase Order (4) does not match quantity in IC Items Master (0). -- Fixed.
Item number : DSP09 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : DSP14 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : ELQ01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-50). -- Fixed.
Item number : ENT01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-6). -- Fixed.
Item number : FLU02 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-10). -- Fixed.
Item number : JNM01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-112). -- Fixed.
Item number : LTI01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-100). -- Fixed.
Item number : LYC01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-56). -- Fixed.
Item number : SMB01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-3). -- Fixed.
Item number : SNT03 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-30). -- Fixed.
Item number : TRA01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-400). -- Fixed.
Item number : ARCX01 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-21). -- Fixed.
Item number : CHEM03 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-8). -- Fixed.
Item number : EYDR02 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : EYDR03 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-5). -- Fixed.
Item number : EYDR10 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-2). -- Fixed.
Item number : LEG001 - Quantity on Purchase Order (2) does not match quantity in IC Items Master (-4). -- Fixed.
Item number : MARA02 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-1). -- Fixed.
Item number : ACCU001 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-600). -- Fixed.
Item number : BANDGE3 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-50). -- Fixed.
Item number : LTMED10 - Quantity on Purchase Order (60) does not match quantity in IC Items Master (0). -- Fixed.
Item number : NONLTXL - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-5000). -- Fixed.
Item number : OT9000A - Quantity on Purchase Order (14) does not match quantity in IC Items Master (0). -- Fixed.
Item number : PRO40RB - Quantity on Purchase Order (48) does not match quantity in IC Items Master (0). -- Fixed.
Item number : QDRW11S - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-3). -- Fixed.
Item number : SFC14FR - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-50). -- Fixed.
Item number : STOCKI4 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-10). -- Fixed.
Item number : TOPAX25 - Quantity on Purchase Order (0) does not match quantity in IC Items Master (-14). -- Fixed.

Verifying qty on PO (Sundry items)...


Checking for orphaned Sub Events...


Verifying Sub Event Budget counts...


Verifying Event Budget balances...


Verifying Main Event Budget balances...


****** Done ******