Good day,
Currently rebates are dealt with in this manner -
1. Rebate is received from the supplier.
2. Inventory adjusts out quantity at the actual cost.
3. Inventory adjusts in quantity at the discounted cost.
Finance would then match off the difference via AP. It's dealt with like this to facilitate the reduced price flows down to the items.
This is what the Item Ledger has
| Posting Date |
Entry Type |
Document Date |
Document No. |
Item No. |
Division Code |
Department Code |
Location Code |
Quantity |
Invoiced Quantity |
Remaining Quantity |
Sales Amount (Actual) |
Cost Amount (Actual) |
| 2/18/2026 |
Positive Adjmt. |
2/18/2026 |
ADJ153 |
SHL550072856 |
SALES |
SDU |
COUVA_WH |
453. |
453. |
0. |
0.00 |
215,641.68 |
| 2/18/2026 |
Negative Adjmt. |
2/18/2026 |
ADJ152 |
SHL550072856 |
SALES |
SDU |
COUVA_WH |
-453. |
-453. |
0. |
0.00 |
-224,558.29 |
This is the GL Entries
| Posting Date |
Document Date |
Document No. |
Description |
Source Code |
G/L Account No. |
Division Code |
Department Code |
Amount (LCY) |
Bal. Account Type |
Reason Code |
| 2/18/2026 |
2/18/2026 |
ADJ152 |
Direct Cost on 02/18/26 |
INVTPCOST |
505200 |
SALES |
SDU |
$ (8,916.61) |
G/L Account |
REBATE |
| 2/18/2026 |
2/18/2026 |
ADJ152 |
Direct Cost on 02/18/26 |
INVTPCOST |
505200 |
SALES |
SDU |
$ 233,474.90 |
G/L Account |
REBATE |
| 2/18/2026 |
2/18/2026 |
ADJ152 |
Direct Cost on 02/18/26 |
INVTPCOST |
140000 |
SALES |
SDU |
$ 8,916.61 |
G/L Account |
REBATE |
| 2/18/2026 |
2/18/2026 |
ADJ152 |
Direct Cost on 02/18/26 |
INVTPCOST |
140000 |
SALES |
SDU |
$ (233,474.90) |
G/L Account |
REBATE |
I've been tasked to figure out why the 8916.61 is there in the posting for the ADJ152, this was done first. You would notice the positive adjustment is on ADJ153 which was posted afterwards. I don't think BC will just come up with an entry there has to be some input.
Any insights is appreciated and my apologies if I'm reading this incorrectly.
Regards
Rosemary
