I’m new to CETEC. However when we invoice an internal invoice labour and overhead is being expensed to the P+L, versus being capitalized on the balance sheet. However labour and overhead is being captured in the value of the manufactured part on the inventory valuation report.
This is causing a descrepancy between the inventory G/L accounts and the subledger (Inventory valuation report)
For example if I look at Internal Invoice 15485.2-1, the manufactured part (SUB1051B) is being a capitalized at $6.9286 per part. However in the G/L accounts only $6.50 is being recorded as inventory with $.40 being expensed to labour and $.0266 being expensed to overhead.
Any update on this? I have gone into GL Transaction mapping and changed the debit for labour and overhead to work in process. Yet on a internal invoice as late as yesterday (Jan 21) it is still posting labour and overhead to the P+L accounts. (Invoices are 15433.6-1).
I can see what’s causing your internal “build to stock” transactions to map debits of labor/overhead to COGS accounts, instead of debiting properly to inventory (or WIP, finished subassemblies, etc.)
There is a GL mapping override hierarchy, whereby you can override the system-wide GL mappings on specific bases like at the part-level or even that the machine/work-location level.
That appears to be what you have going on. If you take a look at your OrdlineStatus (work locations) data mainentenance table in Admin >> Maintenance >> Data Maintenance >> OrdlineStatus:
Notice the columns for GL debits… you have those set to debit account IDs 31 (for labor) and 26 (for overhead)
So that solves the mystery. To fix this, you could simply clear those 31 and 26 entries out of your OrdlineStatus table altogether, so that the system will use the proper system-wide default debit mappings on those internal build-to-stock transactions.
