Summary
When importing invoices into Accounts Payable, they reject with the message that the cost code or category doesn't exist in Sage 300 CRE.
Description
Cause
Item not created
- Cost Code didn't get set up for the job used on the rejected invoice
- Category didn't get set up for the job, extra, cost code combination used on the rejected distribution line
Import Invoices doesn't create Cost Codes or Categories on the fly.
Wrong status on the item
Sometimes, this is a false message. The item exists, but the status isn't set to In progress. As of version 25.1, the message now reads "Cost Code [cost code ID] is completed".
Resolution
Confirm that you created the cost code or category, and they have the correct status.
Cost Codes
- Verify that you entered the correct Job on the rejecting APD line (or APDF line for the fixed format).
- Add the Cost Code to the Job.
- If the Cost Code exists for that job, make sure the status is In progress:
- In Job Cost, select Setup, Cost Codes.
- Select the cost code.
- On the General tab, change the status to In progress, if needed.
- Click Save.
- Click Close.
- Import the rejected invoices from the reject file.
Categories
- Verify that you entered the correct Job and Cost Code on the rejecting APD line (or APDF line for the fixed format).
- In Job Cost, go to Setup, Categories.
- Enter the Job, Extra (if used), and Cost Code.
- Enter the correct Category in the field.
- Tab or Enter past the Description.
- Click Save.
- If you want the category automatically added to new jobs when making entries, add the category to the cost codes under Setup, Standard Cost code.