• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Allocate remaining balance to multiple deduction.

denver_4114

New Member
hi there. Kindly help me to solve my problem please.

How to distribute invoices with remaining balance to the list of deduction available per CR No.

Screenshot below is the sample list and the result is on the right side:
81206

Hope some experts will look into it and solve the issue.

thank you

denver
 

Attachments

vletm

Excel Ninja
denver_4114
Tested the 1st row from 'Sheet 1' ...
How do You get those DEDUCTION DESCRIPTION's from 'Sheet 1' or 'Sheet 2'?
How do You get those 'dark orange values' from 'Sheet 2'?
Screenshot 2022-10-05 at 11.51.16.png
 

denver_4114

New Member
denver_4114
Tested the 1st row from 'Sheet 1' ...
How do You get those DEDUCTION DESCRIPTION's from 'Sheet 1' or 'Sheet 2'?
How do You get those 'dark orange values' from 'Sheet 2'?
View attachment 81209
awe, deduction description = that would be given from sheet2 actually. i forgot to put it in.

regarding shaded dark orange from sheet 2, that's actually one of my question. the result posted here was my daily task on my excel. to spread-out manually the remaining balance of invoices to the list of deduction given by the buyer per CR no.

like in my post: CR#102737, total purchase order was 104,384.28(sheet1;col.C), they have payment of 37,979.41(sheet1;col.D),and they have Outstanding balance of 66,404.87(sheet1;col.E). This remaining balance goes to the list of deduction given by the buyer(sheet2), for us to consider this us paid collection. And I'm doing it manually.

just wondering if you have something to recommend to make it automated.

thank you.
 

vletm

Excel Ninja
denver_4114
# If You ... just remember ... those R-column values are missing
... then those values are challenge.
# Could You explain other ways... more specific or so ...
... how (except manually) did You solve S7, S8 & S9 -values?
F5 seems to be same as S8 ... hmm?
>> I found those ... but ...
How to guess that rows 4...6 belongs to INVOICE 567096?
How to guess that row 7 belongs to INVOICE 567399?
How to guess that row 8… 22 belongs to INVOICE 567401?


# If something could recommend then given details should be valid and there should be clear logic.
 
Last edited:
Top