I apologize. This is a complicated issue to try and describe.
Summary-level information.
1. We use OneWorld with multiple subsidiaries
2. We have projects that use employee's from multiple subsidiaries who all charge to one Project. (We call that one project the "Eggholder Job" because the subsidiary that owns that project is the same subsidiary that holds the contract with the end-Customer)
3. For Materials & Expenses, we have separate projects for them by subsidiary because of NetSuite's limitations. Please ignore that for now, my question focuses on labor.
We ran into what we think is an issue:
As an example, when we Post Time to Subsidiary-A employees, all of their labor is on GJE's to:
Debit Sub-A's Labor COGS account
Credit Sub-A's Project Cost Variance account.
The GJE's also charge the labor to Sub-A's projects.
However, if a subsidiary-A employee charges their time to a subsidiary-B project, the labor does not get posted to either the sub-A or sub-B project.
There appears to be a
TRANSACTIONS>FINANCIAL>CREATE INTERCOMPANY ADJUSTMENTS
module to allow the labor cost to be posted to the sub-B project. But that causes other issues.
In the process of running the module, the labor cost appears to be removed from the Sub-A project and charged to the Sub-B project. However, as I noted above, the labor cost was never posted to the Sub-A project in the first place. Therefore, running the module leaves a negative value in the project when you run an Income Statement by Job and choose Sub-A in the subsidiary filter. It would seem like the value should be zero.
On a related note, if we use the CREATE INTERCOMPANY ADJUSTMENTS module, it impacts both subsidiary's Income Statements with:
Therefore, both subsidiaries will have incorrect Financials because Sub-A actually paid for their employee's labor, but Sub-B has the cost.
The simplest answer is to get the Post Time module on Sub-A to attach the Sub-B project number to each record.
Is it possible that we did not enable a feature?
Is there another step that we are missing?
Are we doing something that we should not?
I've searched everywhere for some type of Overview video or article on best practices for the Post Time module for multi-subsidiary OneWorld instances. Can't find anything.
Suggestions?