SL 2011 FP1 Automatic Invoice Creation is using wrong task for sales tax?

(0) Share

Report

Posted on by jrcrickey

We have been using SL 2011 FP1 with Project Controller for years now without this problem happening. It just started for our billing in July. We have projects setup with the billing type "Bill By Task Group". There are multiple tasks in each project and each task is assigned to its own Bill Group. Most of the time only one of the tasks (per project) has a (sales) Tax ID assigned to it. Starting in July, we noticed that when we use Automatic Invoice Creation, it would create the regular lines with the correct task (and only one task) and then it would create the tax line with a different task (from the same project but does not have a tax ID associated with it and sometimes does not have a bill group assigned to it).

examples:

1. Project: RADIO. tasks: 00000 (no bill group) and 22222 (bill group = 01). Invoice is created with 22222 as the task in the regular lines and 00000 as the task in the Tax lines.

2. Project: EXALT. tasks: 11111 (no bill group), 22222 (bill group = 01), 33333 (bill group = 02), 44444 (bill group - 03), 55555 (bill group = 04). Invoice is created with 55555 as the task in the regular lines and 33333 in the tax lines.

*This post is locked for comments

All responses (3)

Answers (0)

CFROTON 4,710 on at

Like (0)

Report

RE: SL 2011 FP1 Automatic Invoice Creation is using wrong task for sales tax?

Hello Jrcrickey,

Wow that is great news, I could explain scenario #1, but #2 I could not get it to do that. Thank you for the update !
Suggested answer

jrcrickey 5 on at

Like (1)

Report

RE: SL 2011 FP1 Automatic Invoice Creation is using wrong task for sales tax?

We finally figured out what the problem/fix was after many hours. It turns out that during our implementation, our MS partner had created an automated SQL Agent job that updates the task in the Sales Tax line(s). This job was getting an error and shutting down before the line could be updated. We made a correction to a previous step in the job and now the job is completing successfully and the sales tax line(s) are correct.
Suggested answer

CFROTON 4,710 on at

Like (0)

Report

RE: SL 2011 FP1 Automatic Invoice Creation is using wrong task for sales tax?

Dear Jrcrickey,

From the help file in version 2015

If the transaction is a system-generated Tax or Retention line, the Task ID is the Default Task for System Postings in Project Controller Setup (PA.SET.00) if it is valid for the Project. If the Default Task for System Postings does not exist for the Project, the system uses the first task for the Project when it creates the line item. When manually entering the transaction, Task must be filled in.

I've never known the product to use anything but my default task for system posting. I found later that if you don't have that , it will use the first task in your list of tasks on the product- although ti should use the tax on the task that tax is calculated on.

Unfortunately we are no longer maintaining 2011 or below, so I would not have a hotfix for you, I looked for a bug and did not find anything assigning taxes to the wrong task.

Best Regards,

Jana MacDonald