You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to override balancing segment value of Tax recoverable account for Tax spreadsheet Journals

edited Aug 30, 2024 7:55AM in Tax & Global 2 comments

Summary: Hi, I need to override BSV of Tax Recoverable account from Tax rate and should use spreadsheet tax Journal debit account BSV value


Content (please ensure you mask any confidential information):

Hi, we have GST-SALES tax rate defined and default Tax recoverable account at ledger level is 506700-000000-00000-6501-0000. We have 32 legal entities and 6501 is one bsv value of a legal entity. When I create Purchase Journals in spreadsheet using different legal entity and I use debit account as 100105-000000-00000-6401-0000 and credit account as 800390-000000-00000-6401-0000 on Spreadsheet. System generates below entries with Intercompany. We do not want Intercompany entries for Purchase and Sales Journals. We want to override BSV value of Tax recoverable account and system should pick the bsv value of spreadsheet journal. For this, I created account rule

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!