ANS-0374 · ACCOUNTING & FINANCIAL CONFIGURATION
How Does NetSuite Determine Department for GL Impact on Invoices and Vendor Bills?
Understand how NetSuite assigns department values to GL impact, especially for tax accounts and when department fields are hidden on transactions.
Short answer
NetSuite assigns department values to GL impact based on transaction body fields, particularly for tax accounts. If a GL-impacting segment like Department is hidden on the line, NetSuite automatically copies the body value to the line for GL impact. Tax line inheritance can be more nuanced, potentially sourcing from item lines or the transaction body.
Scenario
Users observed inconsistencies in how department values were reported on the GL Impact of invoices compared to vendor bills, particularly when the department body field was hidden. On some invoices, the department appeared to match the line item, while on vendor bills, it was empty, leading to confusion regarding NetSuite's department assignment logic.
Solution
When a department body field is hidden on an invoice or vendor bill, NetSuite follows specific rules for assigning department values to the GL Impact. For tax accounts, the department recorded on the GL Impact may inherit from the transaction body, item lines, or in some cases, from the last transaction line with tax if the header is empty, rather than exclusively from the transaction body. If a GL-impacting custom segment, such as Department, is configured for both the transaction body and line, and the line field is hidden, NetSuite automatically uses the body value for the line's GL impact. This explains why the department on an invoice might appear to match the line item even when the body field is hidden. Conversely, if the body field is hidden and no other inheritance rule applies, the department on the bill's GL impact might be empty.
Expert NetSuite Support
Need help with this NetSuite issue?
Accounting & Financial Configuration consulting and configuration support