Excel Forum

Allocation of transactions through Power Query

sumesh ek

New Member

Members

Forum Posts: 1

Member Since:
June 6, 2021

Offline

June 6, 2021 - 2:28 am

Hi,

I have customer statements where the details of invoices and the payments are available. I need to allocate the payments with the invoices in the FIFO method. I am enclosing herewith the query and the results I made manually for your reference. Please help me in preparing the result in power query.

Regards,

Sumesh

Catalin Bombea

Iasi, Romania

Admin

Forum Posts: 1807

Member Since:
November 8, 2013

Offline

June 10, 2021 - 2:51 am

Hi Sumesh,

Which is the order of the invoices? There is no invoice date field to detect FIFO order, which is supposed to be by date.
Your invoice numbers are not even consecutive:

689593
689594
689595
689589
676649
642360
689583
689599

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Jessica Stewart, Mark Carlson, Calvin Richardson

Guest(s) 10

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 870

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 219

A.Maurizio: 202

Jessica Stewart: 202

Aye Mu: 201

jaryszek: 183

Newest Members:

yashal minahil

Oluwadamilola Ogun

Yannik H

dectator mang

Francis Drouillard

Orlando Inocente

Jovitha Clemence

Maloxat Axmatovna

Ricardo Freitas

Marko Meglic

Forum Stats:

Groups: 3

Forums: 24

Topics: 6201

Posts: 27185

Member Stats:

Guest Posters: 49

Members: 31861

Moderators: 3

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Velouria, Riny van Eekelen