Account for Miscellaneous Charges at the Distribution Level
I have setup Miscellaneous Charges in PS 9.1 to prorate. I am trying to develop a PS Query to account for these Miscellaneous Charges at the Voucher Distribution Line level. I am using the MISC_AMT field on the table VCHRLN_MISC_CHG, but this only works if there is NOT multiple lines at the distribution level. I can use the MISC_AMT field on the DISTRIB_LINE table for those with multiple distribution lines, but it is incorrect for the Voucher lines that only have one distribution. Does anyone know of a table similar to the VCHRLN_MISC_CHG that is for Distribution Lines? Or any