Payable Grid Detail
The payable grid may be sorted by any of the column headers. Select the header and drag to the section of the screen that reads, "Drag a column header and drop it here to group by that column"
Go to : Type the first few characters of the Unit ID, Service Type or Account No/Invoice to be taken to the first record that matches.
Default/Taxes : Populating the Taxes option will show the estimated taxes for this UDC line. Used for countries that are required to maintain payable tax detail.
Vendor Name/Code : Default is Vendor Name, populate Vendor Code to see the Vendor Code instead of the Vendor name.
Edit Direct Cost : Clicking this option will display the Direct Cost setup for the selected line. Edit as needed for posting. The Rate Type and Frequency cannot be edited once postings have occurred for this specific line. If the Description column contains an asterisk, this indicates that this is the initial posting for this UDC line. This is the only time the Rate Type and Frequency can be edited.
Unit ID : Unit IDs will be listed in this column. This is the initial retrieved order.
Service Type : The Service Type selected on the associated line will be listed.
Account No/Invoice : Invoice numbers are automatically generated based on the Unit ID and the month and year or the account number saved on the UDC line and the month and year. Auto-generated Invoice Numbers will appear if the feature is selected in the Service Type record page 123. If an invoice number is empty, the system will not allow selection of the record.
Inv Date : If the From date of the UDC line is prior to the system date, the Invoice Date will default to the system date. If the From date is greater than the system date, the From date will be used instead. Manually update this field if required. Right click to copy the date down to all lines below this line.
Due : Using the Vendor record Date Due, the Oscar application will calculate the Due Date from the Inv Date. Manually update this field if required. Right click to copy the date down to all lines below this line.
Vendor Name : The Vendor name associated with the UDC line will be displayed. Select Vendor Code to display the code instead.
Description : If the description is left empty, it will be automatically populated with the Service Type “Category”. Update as needed. Description lines that contain an asterisk are the initial postings for the UDC line.
From : The “from” service date of the UDC line.
To : The “to” service date of the UDC line.
Rate : The Rate saved in the UDC setup.
T : The UDC rate type; M-Monthly, W-Weekly, D-Daily, N-Nightly, P-Package.
Estimated : Based on service dates and rate, this is the estimated amount to be paid.
Posted : Amounts previously posted for this line will be displayed. Additional postings may occur for this line until the posted amount matches or exceeds the “Estimated” column.
To Post : When the “To Post” amount has been edited, the check mark for the record is automatically selected and it will be included in the batch. If the “To Post” amount is set to zero, the checkmark will be removed from the record and it will be removed from the batch. If the complete amount is not paid, additional postings may be made to this line using “Show all”
Select the payable : This will mark the payable to be posted and will set the “To Post” amount to the “Estimated” amount. Deselect the payable This will remove the mark, set the “To Post” amount to zero and the payable will not be included in the batch.
Deselect All : All marked records on the grid will be cleared and all “To Post” amounts will be reset to zero.
Select All : All unmarked records on the grid will be marked (except the ones with no invoice number) and all “To Post” amounts will be set to the “Estimated” amount.
Post : The selected records on the grid will be posted to the ledger. At this point, the filters will remain populated with the selections from the previous posting. Close the posting screen if finished, or select additional filters for another posting process.
Grid : Preview, Print or Export to Excel a copy of the current Batch Posting process. Changes to the sort will be maintained on this report.
Print : Will print a copy of the grid in the initial layout format. Changes to the sort will not be maintained on this report.