Considerations before moving new file transactions or renaming a new file.

Accounts Payable (new.api)

Only use this process if you aren’t using Pending Invoices in Accounts Payable. If you use Pending Invoices, or if you only want to remove some of the invoices in the new file, delete each invoice individually.

How do I get rid of all the Accounts Payable invoices in the New file?

Accounts Receivables (new.art)

You can’t rename or move items out of the new.art. Post and void items to remove them. If you rename or delete the new.art file, it requires a file fix to correct the data. There’s a fee for the file fix.

Can I rename the new.art?

Billing (new.blt)

You can remove all items in the new.blt or create a dummy contract and generate WIP to it.

How do I remove unwanted entries from the New.blt file?

Cash Management (register.cmt – unposted status)

Cash Management doesn’t have a new file. The items exist in the register.cmt with a status of unposted. If the items originated in Cash Management, you can post and then delete them in Edit Register. A locked file at the server or an empty batch can stop entries from posting. An empty batch will require that you run File Doctor to fix.

Note: If the items originated in another application, review them to determine if posting in the application of origin will resolve. When posting doesn't resolve, fix them per the application-specific instructions.

Posted payroll check is unposted in Cash Management

What do I do with unposted Payroll direct deposits in the Cash Management register when they do not exist in Payroll?

Contracts (active.cnt)

The contract module doesn’t have a new file. Items in the transaction file can have both posted and unposted statuses.

Resolutions vary depending on the issue. Possible solutions are moving the missing contract back from history, recreating a deleted contract item, or closing the month so future entries post. In rare occasions, if the items net to zero by date to a far future date, there’s a work-around for posting those items. They must net to zero by the date and contract item (voided in AR with the same future date).

Solutions to clear unposted CN entries:

• How can I post future transactions in Contracts?
• Error: "Rejected - [date] is beyond next month."
• Error: "Rejected: unable to lock contract derived"
• Error: "Rejected: Contract derived not found" (Contract moved to History)
• Error: "Rejected: Item derived not found" (Contract item was deleted)

Equipment Cost (new.eqt)

You can move washing entries import batches that are incorrect or incomplete from the new file. If the entries originated from an interfacing application, fix them in the interfacing application.

How do I remove unwanted transactions from the Equipment Cost new file? (Move transactions New to New)

General Ledger (new.glt)

You can move transactions with an application of origin of GL, as long as they aren't from a partially posted batch. Check the current file before moving one sided batches.

Transactions from an application other than GL must net to zero by account and date OR you must make a journal entry before moving. If the items don’t net to zero and you don't make a journal entry, the applications will be out of balance. This will require a journal entry or that you reverse the original entry with the original date in the application of origin.

How do I remove unposted and unwanted transactions from the General Ledger new file using File Tools?

Job Cost (new.jct)

Only use this option for batches or transactions that you entered in Job Cost or Estimating (JC/PE). Only use for Estimating entries if they're estimates that are incorrect or duplicated and you don't want to post them. Entries from interfacing applications require that you meet specific criteria.

To remove entries that originated in another application, make the correcting entries in the other application first and then use a linked option below. This doesn't apply to entries imported from a third-party program.

Interfacing entries must net to zero by Job, Extra, Cost Code, Category, Transaction Type, and Accounting Date before moving new to new. If you move the entries out of Job Cost without fixing the entry in the original application, it will cause an out of balance situation.

If you fixed the item in an interfacing application, but the transactions don’t net to zero, review the fixed entries in the other application. Confirm that you used the correct reversing dates before continuing.

Options to move JC entries:

• Moving unwanted transactions in the Job Cost New file using the Move option
• How to remove unwanted transactions from Job Cost new file
• How do I remove unwanted, unposted entries in Job Cost?

Payroll (new.prt)

You can use File Tools to rename the new.prt file if:

• All the time records in the new file have a status of New check or Processed
• You need to start over and clear all unposted time records (Example: you imported time twice)

Don't rename the new file if you did any of the following processes:

• Printed checks
• Recorded manual checks
• Generated direct deposits
• Generated Accruals
• Entered time via Service Management

Note: If you rename a file that contains accrued time, generated direct deposits, or printed checks, you must restore the file. Post and void the checks before renaming the file. If you cannot locate the renamed file or if you deleted the file, the resolution can include a chargeable file fix. Contact Sage Support for assistance.

Can I rename a new payroll file?

Property Management (new.pmt)

Review all transactions before deleting entries or renaming a file. You may have posted transactions that are connected to the unposted transactions. For example, an unposted charge with a payment, credit, or deposit applied to it. Unposted transactions are available to be paid, applied, refunded, etc in the various PM tasks.

What are the criteria for moving Property Management transactions with Move Entries?

How do I remove transactions in the Property Management new file?