How to Debug the error 'Please complete your tax accounting flexfield'

This post explains the process to debug the error 'Please complete your tax accounting flexfield' which appears in Auto Invoicing process.This approach helps you when the Receivables Auto Accounting rules derive the Tax account segments from E Business Tax setups and you have not much idea on EB Tax setups.

Step1: Get the Customer details from Auto Invoice Import program output or from Sales Order.

Step 2: Check the Auto Accounting setup for Tax Account
Responsibility: Any Receivables responsibility
Navigation: Setup > Transactions > Auto Accounting

Notice that the Account segment which is missing in the error has source as 'Taxes'. It means this segment gets derived from EB Tax.Generally Receivables uses Tax accounts which can be defined at any of the 3 levels shown below.
 1. Tax
2. Tax Jurisdiction
3. Tax Rate

Refer to Metalink Note ID 885225.1 for detailed explanation.


Step3: Create a manual AR invoice for same customer in test instances to know the Tax account details.

Responsibility: Any Receivables responsibility
Navigation: Transactions > Transactions

Enter a manual invoice and open Invoice Distributions Window.

 

 Note the distribution amount. Close this window and click on Tax button to open Tax window.

Based on the Distribution amount noted from Invoice Distributions window, find out the tax details in Tax window.

Step 4: Check whether the tax accounts are defined and/or active currently in EB Tax.

(i) Check at Tax Jurisdiction level:

Responsibility: Tax Manager or any Tax responsibility which has access to setups.

Navigation: Tax Configuration > Tax Jurisdictions

Query the form with Tax Jurisdiction code noted from step 3.

Click on update button to open Tax Jurisdiction window.

Click on Tax Accounts button which is on top right. Check whether Tax accounts are defined and/or active.

(ii) Check at Tax Rate level:
Navigation: Tax Configuration > Tax Rates

Query the form with required details noted from step 3.

Click on update button to open Tax Rates window.

Click on Tax Accounts button and check whether Tax accounts are defined and/or active.

(iii) Check at Tax level:

Navigation: Tax Configuration > Taxes

 Click on update button to open Tax window.

Click on Tax Accounts button which is on top right. Check whether Tax accounts are defined and/or active.

Make sure the tax accounts are defined and are active, then re run Auto Invoice program to process errored records.

Payment Due Calculation on AP invoice

Payables calculates payment Due Date using following values:

- Goods Received Date + Receipt Acceptance Days
- Invoice Date
- Terms Date

Payables populates the Payment Due Date with the most recent date among the above dates.

The logic is:
Most Recent( Goods Received Date + Receipt Acceptance Days, Invoice Date, Terms Date )

Goods Received Date:
            Goods Received Date gets populated on the invoice based on Terms Date Basis. We can find Terms Date Basis at following levels.
- Supplier Site Level
- Supplier level
- Payables Options

Payables first looks for Terms Date Basis at Supplier Site Level. If there is no value exist here, it will look at Supplier Level. If there is no value here as well, then Payables takes this value from Payables Options.

Receipt Acceptance Days:
         We can find Receipt Acceptance Days under Invoice Tab in Payables Options.

Invoice Date:
         We can find the Invoice Date in Invoice Date field on Payables Invoice.

Terms Date:
          Terms Date is the beginning date from which Payment Terms start when Payables calculates the scheduled payment(s) for an invoice. The invoice Terms Date defaults based on Terms Date Basis option you select:

• System: System date on day of invoice entry.
• Goods Received: The date you receive goods for invoices you match to purchase orders.
• Invoice: Invoice date.
• Invoice Received: Date you receive an invoice.


Payment Due Date calculation in case of a matched Invoice:

In case of a Matched invoice, Payables consider Receipt Transaction Date along with Goods Received Date + Receipt Acceptance Days, Invoice Date, and Terms Date.

The process includes two steps:

1. The system first checks for recent date of Goods Received Date+Receipt Acceptance Days and Receipt Transaction Date

The logic is:
Recent (GOODS RECEIVED DATE+RECEIPT ACCEPTANCE DAYS, RECEIPT TRANSACTION DATE)

2. After step1, the system uses the following logic again

Recent ( Recent Date from step1, Invoice Date, Terms Date)

Payables consider Receipt Date based on the “Recalculate Scheduled Payment” check box under Invoice Tab in Payables Options. If this check box is enabled, Payables consider the Receipt Date for the calculation of Payment Due Date. If you don't want the system to use Receipt Date in the calculation of Payment Due Date, then disable “Recalculate Scheduled Payment”.

If you want recalculation, then system considers Receipt date for a matched invoice.


Navigation to enable/disable “Recalculate Scheduled Payment”:
Responsibility:    Payables Responsibility which has the access to setups

Navigation:        Setup > Options > Payables Options
Tab:                   Invoice
                                                                       

 Enable/Disable Recalculate Scheduled Payment based on business requirements.