Skip to Content
author's profile photo Former Member
Former Member

Initial Inventory Balance upload question

Hello Experts,

I am aware of how inventory balances are uploaded via MB1C from MM side. I understand this process until the Inventory Ac is debited and the initial inv balance upload account is credited. My question is:

1. What happens to the balance in the initial inv balance upload account?

2. While uploading trial balances, will we load inventory GL balance? If yes, what will be the accounting entry? We cannot debit the initial inv balance upload account here to zero this out since it can be only posted by the system.

3. In international loacations, where the local currency is say, YEN, and we have a USD balance bank account which can only be posed in USD currency, how do we deal with such conversion? I know that it should be a separate header with USD currency and exchange rate.

The entry will be Bank USD A/C Debit

to Data Migration A/C Credit???

I hope to get answers soon. I have read all the related posts but couldn't find any answers.

Thanks

AL

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Jan 25, 2016 at 03:18 AM

    Hi

    Please find the replies below:

    1. Since you are loading the trial balance, the sum total of debits & credits on all the initial upload account(s) should ideally be zero. You can choose to have one or more than one initial upload accounts. There is no reason that the balance will not be zero, unless there is a difference in your legacy balances or you have not tallied the balances before upload or there is some initial error during your upload process.

    2. When you upload using 561 movement type, the accounting entry should be

    Stock/Inventory A/c Dr

    To Initial Upload A/c

    The system would read the material master price for the plant and multiply the same with quantity of the material. This will be the value which will be updated as the stock value in the inventory account GL as well as stock balance in Materials Management.

    3.You would have decided on some exchange rate to use for conversion of balances. So for the conversion date, please maintain the required exchange rate in your system or your upload template and SAP would post the balances correctly with your trial balance tallied out. The accounting entry mentioned by you is correct.

    Thanks & regards

    Sanil Bhandari

    Add comment
    10|10000 characters needed characters exceeded