Hi All,
We have upgraded our system from R2 to R3, after upgrading we have faced issue regarding posting of wrong ledger entries on PO invoicing (PO that received on R2 and now we are posting them on R3) but in Sub ledger entries it showing correct entries.
Below is example of one invoice.
If I click on Subledger journal entries then show below entries:
Subledger journal |
Entry type |
Posting type |
Ledger account |
Debit |
Credit |
DMC-010659 |
None |
Sales tax |
050111000(Purchase expense) |
700 |
0 |
DMC-010659 |
None |
Vendor balance |
020010101 (Accounts Payable) |
0 |
70,700.00 |
DMC-010659 |
None |
Purchase expenditure for product |
050111000 (Purchase expense) |
70,000.00 |
0 |
DMC-010659 |
None |
Purchase expenditure for product |
050111000 (Purchase expense) |
0 |
70,700.00 |
DMC-010659 |
None |
Product receipt |
010022102 (Other inventory) |
0 |
70,700.00 |
DMC-010659 |
None |
Purchase expenditure, un-invoiced |
050111000 (Purchase expense) |
70,700.00 |
0 |
DMC-010659 |
None |
Purchase, inventory receipt |
010022102 (Other inventory) |
70,700.00 |
0 |
DMC-010660 |
Liability accrual |
Purchase expenditure, un-invoiced |
050111000 (Purchase expense) |
0 |
28,280.00 |
DMC-010660 |
Liability accrual |
Purchase expenditure, un-invoiced |
050111000 (Purchase expense) |
0 |
42,420.00 |
DMC-010660 |
Liability accrual |
Purchase, accrual |
020010102 (Accounts payable – Uninvoiced) |
28,280.00 |
0 |
DMC-010660 |
Liability accrual |
Purchase, accrual |
020010102 (Accounts payable – Uninvoiced) |
42,420.00 |
0 |
But when click on Voucher of Invoice journal or view the voucher through Audit trial then show following entries:
Journal number |
Voucher |
Date |
Ledger account |
Amount in transaction currency |
Amount |
Amount in reporting currency |
DMC-088899 |
DMC-110003201 |
30-06-17 |
020010101 (Accounts Payable) |
-70,700.00 |
-70,700.00 |
-70,700.00 |
DMC-088899 |
DMC-110003201 |
30-06-17 |
010022102 (Other inventory) |
70,700.00 |
70,700.00 |
70,700.00 |
DMC-088899 |
DMC-110003201 |
30-06-17 |
010022102 (Other inventory) |
-70,700.00 |
-70,700.00 |
-70,700.00 |
DMC-088899 |
DMC-110003201 |
30-06-17 |
050111000 (Purchase expense) |
70,700.00 |
70,700.00 |
70,700.00 |
DMC-088899 |
DMC-110003201 |
30-06-17 |
050111000 (Purchase expense) |
-700.00 |
-700.00 |
-700.00 |
DMC-088899 |
DMC-110003201 |
30-06-17 |
050111000 (Purchase expense) |
700.00 |
700.00 |
700.00 |
Actually these two accounts aren’t hit in actual voucher that mentioned in Subledger entries with some wrong entries on voucher:
DMC-010660 |
Liability accrual |
Purchase expenditure, un-invoiced |
050111000 (Purchase expense) |
0 |
28,280.00 |
DMC-010660 |
Liability accrual |
Purchase expenditure, un-invoiced |
050111000 (Purchase expense) |
0 |
42,420.00 |
DMC-010660 |
Liability accrual |
Purchase, accrual |
020010102 (Accounts payable – Uninvoiced) |
28,280.00 |
0 |
DMC-010660 |
Liability accrual |
Purchase, accrual |
020010102 (Accounts payable – Uninvoiced) |
42,420.00 |
0 |
Anyone have any idea about it?