multiple currency output - :-(

Question

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!

dummy data.xlsx

Metadata21 · Answer

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.

dummy data.xlsx

Dummy data 2.xlsx

jarrod · Answer

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?

DataNath · Answer

@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.