Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
79
Views
Topic starter
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
Posted : 06/06/2021 12:28 pm
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 |
Posted : 10/06/2021 12:51 pm
