NaushadAnwar
New Member
- Joined
- Oct 8, 2017
- Messages
- 11
Hello Sirs,
i have made this account receivable..i have following issues relating to formulas:
1) 1st bill was issued to company no previous balance was detected so Charged Arrears & LPS As Nil and issue the bill.
2) the company didnt paid previous balance amount and 2nd bill issued with previous amount outstanding as arrears, and charged 15% on Arrears amount.
3) the third bill was issued however in an assumption that the company didnt paid yet on due date, so we 15% on Arrears As LPS And added Previous LPS Amount.
3a) Let us know we assume that comoany has paid the amount as partial payment. we deduct the paid amount from LPS first which is 60, and remaining from we deducted from arrears and current bill which makes it (100+300)-240=160
3b) if the company paid after due date we charge LPS on Arrears then deduct paid amount first on LPS Then Arrears And then after Current Bill.
your intervention is requested please to solve this issue..
i have made this account receivable..i have following issues relating to formulas:
1) 1st bill was issued to company no previous balance was detected so Charged Arrears & LPS As Nil and issue the bill.
2) the company didnt paid previous balance amount and 2nd bill issued with previous amount outstanding as arrears, and charged 15% on Arrears amount.
3) the third bill was issued however in an assumption that the company didnt paid yet on due date, so we 15% on Arrears As LPS And added Previous LPS Amount.
3a) Let us know we assume that comoany has paid the amount as partial payment. we deduct the paid amount from LPS first which is 60, and remaining from we deducted from arrears and current bill which makes it (100+300)-240=160
3b) if the company paid after due date we charge LPS on Arrears then deduct paid amount first on LPS Then Arrears And then after Current Bill.
your intervention is requested please to solve this issue..
