• No replies
2 Posts

Pinned topic Using CC,FGETVAL to pull out intercompany sales by counterparty

‏2011-11-25T12:24:58Z |

I was hoping someone could help me please.

I am trying to pull out counterparty information from Controller 8 in relation to intercompany sales.

I can pull out each sale to each counterparty seperatly but ideally I would like to use the formula to pull the total amount split by x number of counterparties.

This is the formula I am using to pull out ths individual counterpartys:

=cc.fGetVal(*period*,,"ytd","AC",selling co,,,"LC",interco sales account code,,,,,,,,,,,*counter party*)

but I was hoping for something a bit more dynamic!

Thanks very much