multiple currency output - :-(

[Metadata21]

Hello there fellow brainiacs 

I am in a bit of a dilemma, still quite newish to Alteryx and I am in a bit of a pickle. Attached is some dummy data that goes through the following process 

Invoice starts out coded to 133215

When coded it gets split – intercompany 29999 then entity

That then generates an interco document in 89999 which then flags to GL

GL will then code it based on coding files

Cost in correct place

I am required to output the stages this particular invoice goes through in Alteryx like the Pivot table (attached) including the currency workings - making sure the balance at the start is also the balance at the end.

I have been banging my head at this so pls people of Alteryx shine upon me some grace!

[Metadata21]

@DataNath could you help with this?

[Metadata21]

@jarrod could you help with this one?

[DataNath]

@Metadata21 if you could provide an initial input and a detailed list of steps and what happens at each one then we could definitely have a go at finding a solution for you. At the moment, it's a little overwhelming to figure out what's going on when I'm not familiar with the process and what each section represents.

[jarrod]

Hi @Metadata21, 

I'm not exactly clear on the business logic mentioned above. What steps have you taken so far and do you have a workflow where you've attempted something?

[Metadata21]

Hi @DataNath @jarrod  it is kind of hard to explain..

I'll use one particular prepayment invoice example - the excel file I am trying to recreate is attached below with the formulas. This invoice gets coded by a team in India is USD this invoice then gets split within the balance sheet within multiple currencies.