Skip to main content
Solved

Intercompany

  • November 8, 2023
  • 1 reply
  • 277 views

Forum|alt.badge.img

What are the best pratices for intercompany process (Eliminate inter-company transactions )

Best answer by Benoit

Hi,

Sorry, this question was probably too open to get a quick and straight forward answer.

This is definitely possible in Pigment and depends on what process you’re trying to achieve.

Formula conditions can be implemented at the Transaction or Account level to identify, reallocate or exclude from specific blocks any relevant inter-company transactions.

 

One best practice I can share is trying to avoid as much as possible hardcoded text conditions.

Like: 

If (Transaction.Account = Account.”Name” ,… 

Because names can change and if you have multiple items to filter, your formula can quickly become a nightmare.

Instead, you’d prefer using a new boolean property in your Account dimension and call it it your formula:

If (Transaction.Account.BooleanProperty , …

This way you can identify multiple items at the same time in a more scalable way.

 

My last advice would be to go to your Solution Architect and discuss together your needs.

 

I hope this helps.

Best,

 

 

 

 

1 reply

Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • Answer
  • November 30, 2023

Hi,

Sorry, this question was probably too open to get a quick and straight forward answer.

This is definitely possible in Pigment and depends on what process you’re trying to achieve.

Formula conditions can be implemented at the Transaction or Account level to identify, reallocate or exclude from specific blocks any relevant inter-company transactions.

 

One best practice I can share is trying to avoid as much as possible hardcoded text conditions.

Like: 

If (Transaction.Account = Account.”Name” ,… 

Because names can change and if you have multiple items to filter, your formula can quickly become a nightmare.

Instead, you’d prefer using a new boolean property in your Account dimension and call it it your formula:

If (Transaction.Account.BooleanProperty , …

This way you can identify multiple items at the same time in a more scalable way.

 

My last advice would be to go to your Solution Architect and discuss together your needs.

 

I hope this helps.

Best,