Scott Young
Member
How to prevent Journal Entries for Advanced Pricing Adjustments from including G/L Units
When Sales Orders using advanced pricing are processed by Sales Update (R42800), seperate journal entries are created for each advanced pricing adjustment on the order. The problem is that each journal entry also includes the G/L units, so that total units sold are misrepresented. For example, an order for 10 units has $100 base price, and $10 advanced pricing adjustment. Both journal entries will inlcude the 10 units, so it appears that 20 units have been sold. Oracle states that this is functioning as designed, and that the advanced pricing AAIs (4270) should be directed to a different (non-revenue) G/L account, so the units do not appear in the same account twice. We wish to have the advanced pricing adjustments in the same revenue account. Any suggestions?
When Sales Orders using advanced pricing are processed by Sales Update (R42800), seperate journal entries are created for each advanced pricing adjustment on the order. The problem is that each journal entry also includes the G/L units, so that total units sold are misrepresented. For example, an order for 10 units has $100 base price, and $10 advanced pricing adjustment. Both journal entries will inlcude the 10 units, so it appears that 20 units have been sold. Oracle states that this is functioning as designed, and that the advanced pricing AAIs (4270) should be directed to a different (non-revenue) G/L account, so the units do not appear in the same account twice. We wish to have the advanced pricing adjustments in the same revenue account. Any suggestions?
