Post to alternate reconciliation account.

There might be cases where business might be willing to use same customer/ vendor or asset for different process but need to post to a different reconciliation account. To acheive this here are the steps to follow.

 

• Turn on “Recon. acct ready for input” indicator in the G/L master data for the reconciliation account maintained in customer master.
• Follow the menu path SPRO -> Sales and Distribution -> Basic functions -> Account Assignment/Costing -> Reconciliation Account Determination ->Define Alternative Reconciliation Accounts and maintain mapping of reconciliation account maintained in customer master to Alt recon. account with a given ID number.

Now if you try to post an invoice in FB70, then the G/L account field in the “details” tab will be open for entry with default account being the one maintained in the master data. This account can be changed to the altnative account at the time of posting. F4 should give you the list of alternative accounts maintained in the configuration step mentioned earlier.

I guess this can be automated using an FI substitution rule using “ID” in the mapping.

 

 

Transport standard texts

Forms, reports and various output communications use standard texts. These texts are maintained in SO10 and are used widely accross the system. How ever in SO10 there is no provision to generate transport for these standard texts and have to be manually created in the production system.

There are multiple ways to generate a change request such as program RSTXTRAN etc. This is one simple straight approach.

Go to transaction SE78

In “Standard texts section on the left, select the text ID and provide the text name on the right that you would like to transport.

Click tranport icon to generate the change request.

Change material valuation class

To change material valuation class, the materials shouldn’t have

1. Valuated stock in current or previous period.
2. Open purchase orders or delivery schedule lines.
3. Production order for which goods movement has already taken place.

If any of the above conditions fail, then follow the procedure mentioned.

1. If valuated stocks already exist, you can change the valuation class only as follows:

a) Post the stocks of the material to an interim account.
b) Change the valuation class in the material master record.
c) Post the stocks of the material back to their original account.

2. If open purchase orders already exist, you can only change the valuation class if you first flag the corresponding purchase order items for deletion.

3. If production orders exist for which a goods movement has already taken place, you can only change the valuation class if you first set the status of the production orders to Deleted.

 

However message for open purchase orders and production orders can be switched to warning messages. MM 326, MM 327

Once you have changed the valuation class, carry out a new material costing if necessary, or use transaction CKMM to change the price determination control from 3 to 2 and then from 2 to 3 again to avoid incorrect standard cost component split for price.

MRN9 – Balance sheet valuation at LC

Do we have an option if we want to revaluate inventory with different material prices? Yes SAP has provided an option to re-valuate inventory at different material prices /LIFO/FIFO etc. However I am not going to explain how system would calculate the LIFO and FIFO price (may be next time). You can calculate lowest cost / LIFO /FIFO price for material and revaluate your inventory with the calculated price. However there are few important things to know when using this process to post to inventory accounts.

I have tested this transaction to re valuate inventory at a price maintained manually ( not calculated) in the commercial price field of the material master. Since MRN9 is to revaluate your inventory at lowest cost price, you will not be able to revaluate inventory at a lesser price than standard cost in the material master. If the price in the commercial/ tax price fields is less than standard price, then inventory account is adjusted according.
Configuration has to be maintained in transaction OBYC – account determination. Maintain g/l accounts for transaction UMD and BSD.

Important facts to know…

Your FI and MM will not reconcile as this transaction is purely FI.
Material Ledger is not updated with the new price. Your standard price continues to be in the material master.
Though transaction BSD shows as “inventory posting” similar to BSX, both these do not act same. BSX posts to FI and MM so in material ledger, but BSD just posts to the FI inventory account. To have better reconciliation in FI, maintain similar inventory accounts for both BSX and BSD for each valuation class. This will help in reconciliation and makes sure the inventory adjustment is posted to the right account.
Be sure run it just “ONCE” as system does not recognize if the transaction was already run for the current period.
Posting keys assigned to these transactions doesn’t facilitate to reverse the postings. So if you are planning to reverse these transactions, change the posting keys in account determination to 40 & 50.