Accounts Receivable Aging help Fifo Credit Basis

[iamfarhanmahmood]

Hellow,

I am preparing accounts receivable aging.

Its working to extract. Records according to due days but i need formula which less the amounts according to fifo basis.

I means if some amount amount i post in credit enerty it nuteralize oldest category rest other remaining same.

Need help.

Regards
Farhan

 

[iamfarhanmahmood]

Need Help Accounts Receivable Aging

Hellow,

Need help in Regards of Preparing Accounts Receivable Aging need help for credit entery nuteralized oldest category means Fifo bais.

Eg i have array.

A Column Have Party name
B Column Have Invoice Date
C Column Have Invoice Number
D Column Have Debit Amount
E Column have Credit Amount
F Column have Due Days Calculated (Today Date-invoice Date)

I have Sum amounts using sumifs criteria 01-15 Days Due 16-30Days Due 31-60 Days Due i need help when That when i post any amount in column E which have credit enteries it nuteralize 31-60 Days category then 16-30 Days Category then 01- 15 Days Category and so on...

Waiting urgent positive help.

Regards Farhan

 

[iamfarhanmahmood]

Re: Need Help Accounts Receivable Aging

Anybody please help help help...

 

[mtariqraheem]

Re: Need Help Accounts Receivable Aging

I advise you to use IF function for making against each transaction.