Question:
Currently, when I add the freight condition for moving average price and post a GR, freight is then included in the moving average price.
I post an invoice via MIRO and changed the display option to planned delivery costs, thinking that it would then update the moving average price, but it doesn't.
Is there anyway to configure such that pricing condition does not update moving average price when a freight pricing condition is used when posting a goods receipt?
Answer:
What is the condition category of the condition you are using?
Cheers,
JP
Answer:
Currently, when I add the freight condition for moving average price and post a GR, freight is then included in the moving average price.
I post an invoice via MIRO and changed the display option to planned delivery costs, thinking that it would then update the moving average price, but it doesn't.
Is there anyway to configure such that pricing condition does not update moving average price when a freight pricing condition is used when posting a goods receipt?
What exactly would you like to achieve when posting GR?.
Cheers,
HT
_________________
Moderator:
Answer:
To answer both questions:
1) The condition category is B- Delivery Costs
2) Here is what we're expecting. The before and after picture:
Current Scenario: Upon GR
Inventory +$90.00 (Inventory was $10.00 + $80.00 freight)
Freight Clearing - $80.00 (Assuming Freight is $80.00)
GR/IR - $10.00
What we would like it do is:
Desired Scenario: Upon GR
Inventory +$10.00 (Inventory $10.00)
Freight Account + 80.00 (Freight is $80.00)
Freight Clearing - $80.00 (Assuming Freight is $80.00)
GR/IR - $10.00
Desired for Invoice Receipt
Freight Clearing +80.00
GR/IR -10.00
Vendor - 90.00
Answer:
Hi,
Unfortunately, it is not feasible to achieve it as when you are posting GR for both material costs and freight costs, they are all debited to the same stock account.
Cheers,
HT
_________________
Moderator:
Answer:
Hi,
Here is a workaround solution to your problem......so that you get the accounting entries at GR and IR as desired....
Basically, you can achieve this by a modification to your pricing calculation schema......
1. First, create a new/dummy condition type ZXXX(copied from your freight condition, say FRA1). Maintain this as a negative condition amount (Plus/Minus - Negative, the value should be 100% of your FRA1 cond. type). Change the Cond. Category from delivery costs to blank. Make sure you check the "Accruals" indicator. The other settings within the condition type can be the same as the freight condition type.
2. Create a new Trans./Event key Z00(like FR1, FR2 etc) and link this to your "Freight Account" in OBYC.
3. Now, add this new condition type (ZXXX) to your calculation schema and place it just after your FRA1 condition type (In the "From" field, give the step no. of your FRA1 cond. type). In the "Accrls" field, give your Trans./Event key Z00 that you created.
With this new schema, you should be able to achieve the desired posting lines at GR and IR. Now, the inventory/stock account will not be loaded with the freight value and the thus the MAP will be not affected with your pricing condition for freight.
If this doesn't work for you. then you can purchase the freight as a seperate line item in the PO with an account assignment category (say 'K') so that you can post directly to the desired P & L account.
blues