Price Adjustments Sales Update - Volumes are doubled - help!

Dana BY

Active Member
Guys, please help!
We had sales order for 1000 units, we used advanced pricing to set up price (we never used it before):
Quotation price = $245
Premium = $10

We printed invoice, it shows right price - $255*1000 units

We just run Sales Update report, then to Customer Ledger Inquiry->G/L distribution, and result show right amounts, right price, everything is right except for units - there are 2000 units!

I am afraid it has something to do with advanced pricing settings (I show only fields with data, all others are blank).

Here what sales order's Price History shows:
Seq No Adj.Name Factor Value Numeric Unit Price BC OP MC Based on Value Min/Max Adj Desc Mutually Exclusive
100 QUOTPRIC 245.0000 7 Y N None 0
150 PREMIUM 10.0000 10.0000 5 N N 1000 None 0


Please, help, what needs to be done to fix this issue?
 
Did you get your answer yet? .. this is a Bug ....

Advanced Pricing Adjustments cause G/L Units to be doubled or tripled at Sales Update (R42800)

>>> Some clients report that when they use the same G/L Account in AAI 4230 (Revenue) and in AAI 4270 (Price Adjustments) and the Sales Update (R42800) processing options is set to summarize G/L entries by Invoice, the units for that G/L account are accumulated for every price adjustment. For example if there are two price adjustments pointing to the same G/L account in AAI 4270 as the AAI 4230 G/L account, the units in the summarized Journal Entry (F0911) for the account would be 3 times the units on the Sales Order Detail (F4211) line.

This issue has been reported as a defect in the business function Get Sales AAIs And Call F0911 Edit Line (B4200520) and fixed in 9.1 and 9.2.

Please refer to the following documents and make sure you have applied the latest ESU for business function Get Sales AAIs And Call F0911 Edit Line (B4200520):

2105376.1 - F0911 Units Inconsistent with Advanced Pricing and Summarization
and
2294994.1 - G/L Units (F0911.U) Doubled By Sales Update (R42800) When Base Price is Zero.


Under these bugs code was changed in Get Sales AAIs And Call F0911 Edit Line (B4200520) so only one Unit entry is written for all G/L entries pointing to the same account. This is implemented only for DMAAI 4230, 4770 and 4280.
 
Back
Top