Urgent : Debtors transactions on FIFO basis based on closing balance.
hi
Actually I want pending invoices of debtors on the basis of closing balance of debtors on FIFO basis.
I have sales transactions of debtors and their closing balances ( amount receivable from them at the end of year). I need transactions of debtors which are receivable on FIFO basis with respect to their closing balance.
Would be grateful if anyone could provide the formula as per the data in the attached excel sheet.
Create a second sheet called Pending. Paste the following into a code module and run it.
Please Login or Register to view this content.
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
Hi natefarm
thanks for reply..... I am not able to run this code. Please attach excel sheet.
Last edited by mchawla; 04-15-2014 at 02:22 PM.
Here it is.
Last edited by natefarm; 04-15-2014 at 02:48 PM.
hey, thanks its awesome.....
hey , just one more thing how do I modify this code module to include some more details of debtors like their code and other details. My excel sheet is attached herewith.Originally Posted by natefarm
Replace the code with the following. It's flexible enough to handle additional columns you may add in the future, as long as the Amount is the final column and the Date immediately preceeds it.
Please Login or Register to view this content.
thx......its working
Re: Urgent : Debtors transactions on FIFO basis based on closing balance.
Hey natefarm,
I was working with the code given by you but there is an issue with the macro code. Its not giving the exact result for some transactions.
Can u please rectify or change the formula. Excel sheet is attached herewith for your reference.ageing formula.xlsmageing formula.xlsmageing formula.xlsm
Your data has closing balances that exceed the sum total of the invoices. ABCs closing balance is $190,000, but the invoices add up to $100,000. Since this doesn't make logical sense, the code hasn't been designed to handle it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks