Freight Update - Randomly ignores Freight charges F4945 and re-rates teh shipment?

Hi!
We have a problem with freight update randomly ignoring the spot quotes (and consequently the Freight Charges in F4945). In stead, R4981 pulls in the default rate from the rate schedule.
This happens with no apparent pattern. Roughly 25% of all the shipments are affected.

- The rate definition is set up to have only PAYABLE rates
- We do have both payable and billable checked in the R4981 processing options (as the order status would not otherwise be advanced)
- Loads are not used
- The shipment charges/Spot Quotes are correctly entered.
- The route/Rate setup has been verified and is correct
- The spot quotes have been entered with correct currency.
- Multi-currency environment. GBP/USD/EUR/SEK/NOK
- 30-50 shipments per day
- No Shipment Consolidation


We back up F4945 every night and compare the backup against F4981 after Freight Update. It can be clearly seen that the F4945 are plain ignored and the shipment is re-rated by Freight Update.

We tried to replicate the error by refreshing the PY environment from PD prior to Freight Update. We then ran R4981 in PD and noted the shipment numbers that were incorrectly re-rated. in PY we selected these shipments + a few others that were correctly processed for freight update in PY and the result was truly weird.
- Some of the errors from PD also happened in PY.
- Some shipments that were correctly updated in PD were re-rated in PY
- Some of the shipments that were re-rated in PD were processed correctly in PY

No errors appear in the logs (when running with tracing) from R4981

I would appreciate any input as how this could be solved. I have reported this to JDE but i fear the response will be "Closed - Could not replicate" :-(


ERP8 SP20
NT server / WTS
MS SQL

Re: Freight Update - Randomly ignores Freight charges F4945 and re-rates teh shipment?

Hi,

seem to be hard to reproduce,
nevertheless, have a look at ODS-03-0003 and SAR 6429676 (ESU JD18112),
can you also trace if the rerated records has the field RSRATR in the F4941 populated differently than the "non rerated" ones ? Could be a clue.

Good luck and keep us informed please

Fred

Re: Error found! - Randomly ignores Freight charges F4945 and re-rates teh shipment?

Hi all!
Found the error when debugging the UBE!

In Short!

- Two shipments from same Branch/Plant with different carriers and different "Actual Ship Date"
The Spot Quote for the first shipment processed is correct but the second shipment pulls in the default charge

I have been able to reproduce this error constantly in our environment (no modifications)

R4981 Processing options
Defaults 1
Invoice Date- 2
G/L Date - 2

Defaults 2
All fields are blank

Process
Flex Accounting - 1
Summarize GL- 1
Summarize AP - blank
Update Item Cost blank

Outbound SO:s
Freight line F
status of freight line 580
Override SO status 580

Loads
All fields are blank

Versions
G/L version blank

Performance
Suppress Payable blank


- Set up a rate scheduler/rate definition for per-ton rate for two carrires. Only PAYABLE freight, no billable freight.(Maybe same error occurs with Billable, we do not use it though) Charge code 010
- Set up a route for two customers with the above rate schedule and separate carriers.

- Enter two orders, one for each customer, against same depot .
- In routing options, select different carrier for each order/shipment.
- In Shipment charges, create a spot quote for both shipments and rate the shipments
- Ship confirm the orders using DIFFERENT actual ship date for both orders/shipments
- Run Freight Update. Only shipment the that is processed first still retains the spot quote. The second shipment is overridden with the default rate

If i do the above but select the same Acual Ship Date, the error does NOT occur.

Apparently the error is in the logical level break in R4981. The sequencing in R4981 is unchanged from standard version
1. Carrier
2. Business Unit (MCU)
3. Actual Ship
4. Load No
5. Delivery No
6. Shipment no.
7. Routing Step number

When the carrier changes, the UBE closes the FT document. The carrier change is detected by comapring the new record with previously processed one. In the EndDoc, also the curent record(shipment) is included in some updates, including reset of F4945.
When the current record is then processed, F4945 has no charges and the default rate is pulled in

JDE is going to test this scenario and raise a SAR if they get the same results.

Regards...

Re: Freight Update - Randomly ignores Freight charges F4945 and re-rates teh shipment?

Hi,
something similar happens to us.
When we run R4981 we get assorted results:

-sometimes freight charges go to F4211, sometimes not. In any case they get deleted from F4945
-when we do it for a single load number it goes well. When several loads (no need to be many) are involved the thing goes mad and acts randomly.
- we have either payable and billable charges

We use standard data selection and sequencing.
We raised an issue with JDE and they found no errors.
We are testing Update 5, in the Update 2 it did not work either.
We are going to debug today.

Please keep us posted!

Thanks

Re: Freight Update - Randomly ignores Freight charges F4945 and re-rates teh shipment?

Hi there!

JDE have duplicated the problem. The error only appears when running freight update over multiple shipments with spot quotes (payable/billable or both). There is a bug in a "logical level break" when carrier and actual ship date changes.

SAR 6498663 has been entered, the planned date is April 30.

Regards...