Aarto
Reputable Poster
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
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