Find your answer in this short video - Watch this video: 

If you made a coding mistake after the invoice has been journalized, this set of steps will show you how to properly make an update.

In the Journalize menu, find the "Create Account Payable Journal" option and then use the "Reverse Invoice Posting" feature.

How do I write a check with an Arabic vendor name?

1. Enable the Alternate Language feature.
2. Store the Arabic name in the alternate name field in the vendor record.
3. Create a secondary check format that uses the alternate name for the payee.
4. Select the secondary check format when needing to print with an Arabic vendor name.

Why can I not reconcile AP to GL using the Aged Open Payables report and what I should do instead?

IDEAS is period-based system.  AP is date-based, but GL is period-based.  The Aged Open Payables report cannot be used for reconciliation because it is possible to enter a transaction in AP to the current period but with a transaction date for the next period.

Instead of using the Aged Open Payables report to reconcile, use the AP Reconciliation Reports (Reconciliation Report and Reconciliation Detail Report) found in the AP Reports menu option.

What is the best way to create 1099 forms?

An option popular with customers is to purchase a 1099 Express license, export the information from IDEAS and then import and generate the forms in 1099 Express.

1. Go to http://1099express.com
2. Purchase the appropriate license

3. Print a 1099 report from IDEAS that gives all of the pertinent information required

4. Send the IDEAS report to Excel

5. Import the Excel data into 1099 Express and print out the 1099s

In P2 IDEAS, you can designate in the vendor record that the vendor is a 1099 vendor.  By doing this, the 1099 flag for each invoice that is raised for the vendor is automatically marked as 1099.  If the vendor has services and goods on the same invoice, you have the option to mark the invoice as 1099 for the entire invoice or line by line.  At the end of the year or at any point in the year you can run the 1099 report and it will list all vendors that have had invoices entered with a 1099 designation and what the 1099 amount is.  You can export that to Excel and send that to 1099 Express for printing the 1099s.  There is also a utility to allow you to mark on or off an invoice to correct the 1099 designation for the invoice.

You can find the 1099 information under the "IVA" tab in the Vendor screen.

If you want to change the tab name to read "1099," you can do that by adding the below "AP Miscellaneous" VAR code to 1099 - see the below picture:

In the Vendor Maintenance screen you will see a 1099 tab.  If there is a tax ID in the field, then invoices for the vendor will default to 1099 in the Invoice Entry screen.

The Default tab of the Invoice Entry screen holds the 1099 options.  With a tax ID in the 1099 tab of the Vendor record, the 1099 option is checked by default for the invoice.  It also defaults to invoice level meaning the entire amount of the invoice will be recorded as a 1099 payment.

If you check the Line Level option, then on the Lines tab, there will be a cell to indicate if the line qualifies for 1099 or not.

How do I validate before posting checks?

At month end, ensure checks are journalized for posting to General Ledger.  Use this report to help determine:

1. Has the check been journalized?
2. What is the accounting period for the check?
3. What is the accounting year for the check?

How do I ensure invoices are journalized prior to close (Invoice Journalization Revision)?

Ensure invoices are journalized prior to close by reviewing this report.

How to remove incorrect AP Offset Accounts?

How do I use the AP Invoices Lines report to understand how invoices are coded?

Gain an understanding of how invoices are coded by viewing the details of how the cost is coded.

How to upload Invoices via AP Auto Invoices?

Process Overview

Watch this video introduction to the AP Auto invoices Process

How to prepare the Auto invoices import template?

The following video provides details about how to prepare the template. Refer to the next case scenarios as well for additional details.

Here is a sample of the upload template

How to import an invoice with one line item and no tax?

The following video details the process. Below are the templates used for this example.

How to import an invoice with one line item and VAT tax?

The following video details the process. Below are the templates used for this example.

How to import an invoice with one line item and Withholding Tax?

The following video details the process. Below are the templates used for this example.

How to import an invoice with two or more line items and no Tax?

The following video details the process. Below are the templates used for this example.

How to import an invoice with two or more line items and VAT at Invoice Level?

The following video details the process. Below are the templates used for this example.

How to import an invoice with two or more line items and VAT at line level?

The following video details the process. Below are the templates used for this example.

How to import an invoice with two or more line items and Withholding tax at Invoice Level?

The following video details the process. Below are the templates used for this example.

How to import and invoice with two or more line items and Withholding tax at line level?

The following video details the process. Below are the templates used for this example.