No Item Cost when performing a stock transfer

[Former Member]

Hi there,

I've had a look through the existing posts but can't find anything about this.

I have a customer who has a new warehouse in a different location. They've setup a new warehouse in SAP B1 and created new G/L accounts specific to that warehouse.

However, when they do a stock transfer to the new warehouse from the general warehouse, the item cost does not carry over and instead of posting to the new stock G/L account, the system posts to a variance account instead.

Other stock transfers they have done in the past all carry the item cost over. The only difference I can see is that previous stock transfers were all done against a customer, whereas the new stock transfer wasn't and used last purchase price instead of whatever the customers price list was.

Can you help?

If other information is required please let me know.

[Former Member · Accepted solution]

For Standard Cost, you have to setup Item Cost first in the target warehouse. It can not be set by stock transfer transaction.

[Former Member · Accepted solution]

Thanks for the reply,

Just got a a few more questions.

1. Where do you setup the item cost for the target warehouse?

2. If the valuation method was moving average, would the item cost get set by stock transfer?

3. The customer currently use stock transfers for items specific to certain customers and the item cost is set in the target warehouse when they perform these transactions. Is the item cost carried over in these circumstances as it is against a customer?

Thanks

Steve Lowery

[Former Member · Accepted solution]

1. Use Stock Revaluation to setup the item cost for the target warehouse.

2. The item cost will not be carried over in these circumstances as it is against a customer, you have to use the cost for the customer to set up the item cost for the target warehouse.

[Former Member]

Hi Lowery........

Please check Inventory Audit report for the Item for From Warehouse you are trying to transfer and if its valuation method is FIFO then please check I'm sure at some stage you have not recorded the Item Cost because of which you are getting this Error.......

Regards,

Rahul

[Former Member]

Many thanks for the quick reply.

Before I run the stock audit report can I just check something.

The From and To dates. Should I enter a start date from when the product was first received into the general warehouse in order to calculate the report on every instance of when stock was received?

[Former Member]

Hi,

You have a right assumption: The From and To dates should be a start date from when the product was first received into the general warehouse in order to calculate the report on every instance of when stock was received.

What is your B1 version/PL and inventory valuation method?

Thanks,

Gordon

[Former Member]

Hi Lowery......

Yes you have to run this Inventory Audit Report as you mentioned on the dates.

This will let you know about the status and its Value.......

Regards,

Rahul

[Former Member]

I have just had the customer run the stock audit report for the particular item and the valuation method is standard not FIFO. Could there be another reason why the item cost is not showing after the transfer?

[Former Member]

Hi Lowery......

If you have Standard Valuation Method then that would not be a problem......

Please raise this concern to SAP by raising Support Ticket.......

Regards,

Rahul