Unposted Transactions in Spectrum
Each transaction has a source file which shows where it originated from. The table below shows the transactions and why they are unposted.
Transaction source |
What is counted? |
Which date is used to determine unposted items? |
Tip to resolve |
---|---|---|---|
Accounts Payable invoices / credit memos |
Count unposted records from Vendor Invoice Entry |
G/L date of invoice |
Highlight the source and click Update. With the cursor on the Batch field, click the drop-down arrow. Select a batch code and click Details to view the unposted transactions. |
Accounts Payable manual checks |
Count unposted checks from Manual Check Entry |
Check date |
There are two possible solutions here:
|
Accounts Payable void checks |
Count unposted, non-zero checks from Void Check Entry |
Void transaction date |
Highlight the source and click Update. |
Accounts Payable regular checks |
Count checks that have been printed in Payment Processing / Print Checks |
Check date |
Highlight the source and click Update. Preview the A/P Payment Register and update. |
Accounts Payable payment G/L transactions |
Count unposted transactions on the Payments G/L Report |
G/L date |
Highlight the source and click Update. Preview the Payments G/L Register and update. |
Accounts Receivable invoices / credit memos |
Count unposted records from Customer Invoice Entry |
G/L date of invoice |
Highlight the source and click Update. With the cursor on the Batch field, click the drop-down arrow to view the unposted transaction count by batch. |
Accounts Receivable draw requests |
Count draws with non-zero 'this period' billing from Draw Request Entry. |
Period-to date (but ignore draws with blank date) |
Highlight the source and click Update. Press Enter to accept the batch code. Click the Select button to open the Select Applications to Update window. Unposted draws are those with an amount in the 'This period billing' column. In other words, only those with current billing (not zero) are counted. |
Accounts Receivable cash receipts / adjustments |
Count unposted checks from Cash Receipts Entry and Misc. Cash Receipts screens. |
Transaction date |
Highlight the source and click Update. With the cursor on the Batch field, click the drop-down arrow to view the unposted transaction count and amounts by batch. |
Accounts Receivable finance charges |
Count unposted transactions in Finance Charge Entry / Change |
Transaction date |
Highlight the source and click Update. View the unposted finance charges in detail on Finance Charge Entry. |
Cash Management reconciliation transactions |
Count addition and deduction transactions from Reconciliation Adjustments Entry |
Transaction date |
Highlight the source and click Update. By account, preview the Other Reconciliation Adjustment Register. Cancel the update. |
Cash Management direct checks |
Count unposted direct checks |
Check date |
Highlight the source and click Update. By account, preview the Direct Checks Register. Cancel the update. |
Cash Management void direct checks |
Count unposted void direct checks |
Void transaction date |
Highlight the source and click Update. By account, preview the Void Direct Checks Register. Cancel the update. |
Cash Management wire transfers |
Count unposted records from the Wire Entry screen |
Transaction date |
Highlight the source and click Update. By account, preview the Wire Transfers Register. Cancel the update. |
Cash Management void wire transfers |
Count unposted void records from Void Wire Transfer Entry |
Void transaction date |
Highlight the source and click Update. By account, preview the Void Wire Transfers Register. Cancel the update. |
Equipment Control transactions |
Count unposted transactions from the detail portion of Equipment Transaction Entry |
Transaction date |
Highlight the source and click Update. Preview the Ownership Cost G/L Register. Cancel the update. |
Equipment Control G/L transactions |
Count unposted transactions on the Equipment Control G/L Report |
Transaction date |
Highlight the source and click Update. With the cursor on the Batch field, click the drop-down arrow to view the unposted transaction counts. |
Equipment Control depreciation / license / insurance |
Count unposted transactions from the detail portion of Depreciation/License/Insurance Entry |
Last day of period assigned to transaction |
Highlight the source and click Update. Preview the Ownership Cost Journal. Cancel the update. |
Equipment Control DLI G/L transactions |
Count unposted transactions on the Depreciation/License/Insurance G/L Report |
Transaction date |
Highlight the source and click Update. Preview the Ownership Cost G/L Register. Cancel the update. |
Fixed Assets depreciation |
If the cycle is fully updated, set record count to zero. Otherwise, count assets with non-zero current depreciation from Depreciation Entry / Edit |
Depreciation date |
Highlight the source and click Update. Preview the Fixed Assets G/L Summary Report. Cancel the update. |
General Ledger journal entries |
Count unposted journal entries with detail records |
Journal entry date |
Navigate to to view unposted entries. |
Inventory Control shipped job requisitions |
Count requisitions with status of Shipped from Job Requisition Entry |
Ship date (but ignore requisitions with blank date) |
Highlight the source and click Update. Preview the Inventory Transaction Report. Cancel the update. |
Inventory Control physical inventory transactions |
If a physical inventory is not in progress, set record count to zero. Otherwise, count transactions from Physical Count Data Entry |
Current Inventory Control processing date |
Highlight the source and click Update. Preview the Count Transaction Listing to view the unposted records. |
Inventory Control other transactions |
Count unposted transactions on the Inventory Transaction Report |
Transaction date |
Highlight the source and click Update. Preview the Inventory Transaction Report. Cancel the update. |
Inventory Control G/L transactions |
Count unposted transactions on the Inventory G/L Report |
G/L date |
Highlight the source and click Update. Preview the Inventory Transaction Report. Cancel the update. |
Job Cost Transactions |
Count unposted transactions from detail records in Job Cost Transaction Entry |
Transaction date |
Highlight the source and click Update. With the cursor on the Batch field, click the drop-down arrow to view the unposted transactions. |
Job Cost G/L transactions |
Count unposted transactions on the Job Cost G/L Report |
Transaction date |
Highlight the source and click Update. Preview the Job Cost G/L Detail Report. Cancel the update. |
Materials Management |
Count tickets from Scale Ticket Entry |
Scale ticket date |
Highlight the source and click Update. With the cursor on the Ticket # field, click the drop-down arrow to view the unposted transactions. |
Order Processing invoices |
Count unposted invoices from Invoice Entry |
Invoice date |
Highlight the source and click Update. Preview the Invoice Register Report. Cancel the update. |
Order Processing G/L transactions |
Count unposted transactions on the Invoice G/L Report |
G/L date |
Highlight the source and click Update. Preview the Invoice G/L Detail Report. Cancel the update. |
Order Processing unprinted invoices |
Count invoices that have not been printed. |
Invoice date |
Highlight the source and click Update. Preview the OP Invoice Print, set for first print only. |
Payroll time cards |
If the cycle is fully updated, set record count to zero. Otherwise, count time cards from Time Card Entry |
Check date assigned to pay cycle |
Highlight the source and click Update. Select Time Card Listings. Preview the report to view unposted time cards. |
Purchase order 2-step receiving with packing list update |
Count purchase orders from Packing List Quantity Entry that have not yet been updated to Inventory |
Receipt date |
Highlight the source and click Update. Preview Summary Packing List Quantity Edit List. Cancel the update. |
Service Contract Earned Revenue Transactions |
Count number of scheduled records from Service Contract Billings |
Scheduled date |
Highlight the source and click Update. Preview Earned Revenue Register. Cancel the update. |