Expired and Unsettled Vendor Adjustments Report Card EBT Only) Description This report is used to view any vendor adjustments that are expired and unsettled that have not been manually closed. Expired is defined based on a system parameter that contains the number of days in which a vendor adjustment is processed to a zero balance. Unsettled is any non-zero balance adjustment that has not been manually closed. A user reviews and manually processes the non-zero balance and then closes the adjustment so that the adjustment is not included in future executions of this report. Parameters None Subtitle None Record Select all vendor adjustments occurrances that have expired and have a Selection / non-zero balance and have not been manually closed. Filtering / Expired is defined by comparing the current date against the date the Calculations vendor adjustment was sent to the EBT Host (VendorAdjustment.SentDt) + the number of days found in the system parameter, Vendor.AdjustmentExpiredDays. Non-zero balances are determined by comparing the vendor adjustment amount (VendorAdjustment.AdjustAmt and VendorAdjustment.AdjustCd which is a credit or debit) against the processed ARF D5 amounts. ARF D5 amounts are found by transversing the VendorAdjARF table (keys of VendAdj_ID and ARFD5_ID) to the ARFD5 record (ARFD5.AdjustAmt and ARFD5.AdjustCd which is a credit or debit). Not manually closed is defined as the adjustment record’s manual close date has not been set (VendorAdjustment.ManualCloseDt is null). Print Columns Vendor (width 30) Based on VendorAdjustment.Vend_ID. – Vendor.FFVendorID - Vendor.StoreName Description (width 30) VendorAdjustment.Description – Trace # - VendorAdjustment.TraceNr Sent Date VendorAdjustment.SentDt – Type - 6)– VendorAdjustment.AdjustCd Debit’ code – ‘Credit description Adj Amt - VendorAdjustment.AdjustAmt D5 Amts Amounts of ARFD5.AdjustAmt records associated with – vendor adjustment Remain Amt Calculated by subtracting the D5 Amts from the Adj Amts – Memo 20) VendorAdjustment.Memo – Sort Order Sent Date (oldest to most recent)
Expired and Unsettled Vendor Adjustments Report Card EBT Only) Description This report is used to view any vendor adjustments that are expired and unsettled that have not been manually closed. Expired is defined based on a system parameter that contains the number of days in which a vendor adjustment is processed to a zero balance. Unsettled is any non-zero balance adjustment that has not been manually closed. A user reviews and manually processes the non-zero balance and then closes the adjustment so that the adjustment is not included in future executions of this report. Parameters None Subtitle None Record Selection / Filtering / Calculations Select all vendor adjustments occurrances that have expired and have a non-zero balance and have not been manually closed. Expired is defined by comparing the current date against the date the vendor adjustment was sent to the EBT Host (VendorAdjustment.SentDt) + the number of days found in the system parameter, Vendor.AdjustmentExpiredDays. Non-zero balances are determined by comparing the vendor adjustment amount (VendorAdjustment.AdjustAmt and VendorAdjustment.AdjustCd which is a credit or debit) against the processed ARF D5 amounts. ARF D5 amounts are found by transversing the VendorAdjARF table (keys of VendAdj_ID and ARFD5_ID) to the ARFD5 record (ARFD5.AdjustAmt and ARFD5.AdjustCd which is a credit or debit). Not manually closed is defined as the adjustment record’s manual close date has not been set (VendorAdjustment.ManualCloseDt is null). Print Columns Vendor (width 30) – Based on VendorAdjustment.Vend_ID. Vendor.FFVendorID - Vendor.StoreName Description (width 30) – VendorAdjustment.Description Trace # - VendorAdjustment.TraceNr Sent Date – VendorAdjustment.SentDt Type - 6)– VendorAdjustment.AdjustCd – ‘Credit Debit’ code description Adj Amt - VendorAdjustment.AdjustAmt D5 Amts – Amounts of ARFD5.AdjustAmt records associated with vendor adjustment Remain Amt – Calculated by subtracting the D5 Amts from the Adj Amts Memo 20) – VendorAdjustment.Memo Sort Order Sent Date (oldest to most recent)