Hierachy transform aggregate transactions (1 reply)
Cancel that =, I saw the problem was that the other invoice was being dropped because the vendor ID had an invalid character so the hierarchy keys did their job.
Cancel that =, I saw the problem was that the other invoice was being dropped because the vendor ID had an invalid character so the hierarchy keys did their job.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Hiya
A bit of a silly question.
I have some transactions coming in as separate rows of data but would like to transform them into a hierarchy as header (total invoices) and details (seperate invoices).
Is there a quick and easy way to do this? Ideally I would count any duplicates and have a flag of sorts to identify the transactions then key them in the hierarchy but seems COUNT only gets the number of transactions.
Thx.