-
Issue in customer to ledger reconciliation report - values are not displaying in Difference column..
Create Posting profile.
Create 2nd posting profile for Default.
While doing customer payment journal we will select one posting profile and we will post it, later we will do the reimbursement for the same customer at this time it is considering the default customer posting profile. where there are two different accounts are mapped.
Accounts Receivable>> Payments>> Customer Payments.
Click on new and update Cust pay and go to lines.
Update the customer account and credit amount and select offset account type ledger and offset account cash payment.
Go to Payment tab and update posting profile is PR and save.
Post the customer payment.
Reimbursement
Accounts receivable >> Periodic tasks >> click on Reimbursement.
In reimbursement parameters page, select include customer with outstanding, filter with customer account.” customer” click on ok. Reimbursement process will complete.
• Accounts Receivable -- >Inquiries and reports-- >Customer-- > Customer to Ledger reconciliation.
• Generate report.
1.Example: Select any month data or small set of date (from date:10/9/2023 and to
date :10/10/2023) with include details option.
2.Select Include details option.
3.click on ok.
While generating the customer to ledger reconciliation report, when there is both customer balance and ledger balance in the report difference column is working fine, when there is no customer balance but there is a ledger balance in the report in this scenario also there is a value in difference column but when there is a customer balance but there is no ledger balance in the report in this scenario there is no value in the difference column.
Actual
Results:
While selecting include details option under customer to ledger reconciliation report unable to see accurate values and system shows zero difference on customer to ledger reconciliation report.
ACTUAL: Select any Example: Voucher number”00004”
Customer balance: 4,000
Ledger balance: 0.00
Difference: 0.00
Expected
Results:
While selecting include details option under customer to ledger reconciliation report, system should show correct difference values on customer to ledger reconciliation report.
Expected: Select any Example: Voucher number”00004”
Customer balance: 4,000
Ledger balance: 0.00
Difference: 4,000
Please fix the Report issue in the customer to ledger reconciliation report.
-
Reimbursement Functionality Not working as expected
Assume that we have two different customer posting profiles as below,
- Default (mapped in parameters also).
- Deposits.
- While doing customer payments we will select Deposits Customer posting profile, because it is a deposit made by customer.
- Due to some reasons i will reimburse the payment to the respective customer by using Reimbursement functionality.
- Here, system is considering the Default customer posting profile to reverse the payment instead of Deposits Customer posting profile.
Hence the reimbursement functionality is not working as expected and This results, other ledger accounts are affecting.
-
Project Budget should be committed including taxes at the time of PO confirmation based on the project line property.
When a Project PO is created, it includes the tax amount. However, upon confirming the PO, only the net amount is committed to the project budget, and the tax amount is not. The total amount, including tax, is updated in the consumed budget once the invoice is posted based on the project line property.
The expectation is that the tax amount should be included in the committed budget along with the net amount once the PO is confirmed project line property.
This is to prevent budget overlap if another user creates a different PO in the same project.