How to reconcile “Issue Pending Quantity” …

 

Background Knowledge:

 

“Issue Pending Quantity Reconciliation” is another R-Supply database alignment program that reconciles quantity differences between the stock_item table iss_pndg_qty column and the actual total quantity of the outstanding issue transactions.

 

Procedures:

 

To reconcile the issue pending quantity, follow the steps listed below:

 

Step #1: LOGON to R-Supply and GoTo: File>Utilities>Issue Pending Qty Reconciliation.

 

Step #2: Select the appropriate checkbox.

 

Issue Pending Qty Recon (Pre-selected) - Generates a report that lists the transactions and quantities requested that are tied to a specific NIIN that will have the stock_item table iss_pndg_qty modified and updated.

 

Report Only - If not selected, a report is still created, and the stock_item table iss_pndg_qty is modified and updated.

 

Step #3: Click “Apply” icon to initiate the Batch Job.

 

Step #4: Click “Submit” button to submit the Batch Job for approval or release the Batch Job to

NTCSS for processing.

 

Step #5: Approve the Batch Job. GoTo: Site>Management>Site Internal>Batch Job

Scheduling>Approval. Type-in “R” to release the Batch Job to NTCSS for processing. This Step applies only if the “Approval Required” checkbox is selected at the Control Parameter Update screen.

 

Step #6: Verify output. No actions required.

 

 

 Any questions, feedback or comments, email Lonnie Auza.