cost is not effecting in item transaction form

Dear all,

can any one give solution for the below issue

Cost amount is not effecting in transaction form, same can be find in cost amount column

Site Warehouse Location Physical date Financial date Reference Number Receipt Issue Quantity Cost amount
SH RW01 70FLOOR-01 17/05/2013 19/05/2013 Purchase order PO-1314-000026 Purchased 6 28.620 4.770
SH RW01 70FLOOR-01 17/05/2013 17/05/2013 Transfer order shipment TRFO-000127 Sold -2 -9.605 4.803
SH RW01 70FLOOR-01 17/05/2013 17/05/2013 Transfer order shipment TRFO-000128 Sold -2 -9.605 4.803
SH RS02 AVENUE 17/05/2013 17/05/2013 Transfer order receive TRFO-000128 Purchased 2 9.703 4.852
SH T009 T1 17/05/2013 17/05/2013 Transfer order shipment TRFO-000127 Purchased 2 9.703 4.852
SH T009 T1 17/05/2013 17/05/2013 Transfer order shipment TRFO-000128 Purchased 2 9.703 4.852
SH T009 T1 17/05/2013 17/05/2013 Transfer order receive TRFO-000128 Sold -2 -9.703 4.852
SH RS02 AVENUE 31/05/2013 31/05/2013 Sales order SO-1314-000620 Sold -1
SH RS02 AVENUE 22/06/2013 22/06/2013 Sales order SO-1314-001199 Sold -1
SH RS01 ALRAI 29/06/2013 29/06/2013 Transfer order receive TRFO-000127 Purchased 2 9.703 4.852
SH T009 T1 29/06/2013 29/06/2013 Transfer order receive TRFO-000127 Sold -2 -9.703 4.852
SH RS02 AVENUE 20/07/2013 20/07/2013 Sales order SO-1314-002077 Sold -1
SH 31/07/2013 31/07/2013 Weighted average inventory closing Purchased 10 48.026 4.803
SH 31/07/2013 31/07/2013 Weighted average inventory closing Sold -10 -48.026 4.803
SH RS01 ALRAI 17/08/2013 17/08/2013 Transfer order shipment TRFO-001637 Sold -2
SH T009 T1 17/08/2013 17/08/2013 Transfer order shipment TRFO-001637 Purchased 2
SH RW01 F04-02B 29/08/2013 29/08/2013 Transfer order receive TRFO-001637 Purchased 2
SH T009 T1 29/08/2013 29/08/2013 Transfer order receive TRFO-001637 Sold -2

Regards

Siddaiah

There is no Cost amount column shown here.

You need to provide minimum explanation of the problem. Please elaborate.

Run the inventory close.

Tell us your costing method and costing setup

Tell us your cost posting basis and the status of the transactions.

Tell us what is a) actually wrong and b) what you are expecting; for example you have made x and cost y and you cannot see cost y on sales z. So have you ended production and have you run the inventory close etc.

Hi All

Thanks for all for your replay

Kindly find the issue description in detail as below

1.costing method is Weighted average costing method

  1. costing calculation at site level

Scenario: Item ‘‘A’’ purchased 100 qty for 10/- each(10010=1000) in site ABC,warehouse: X, size XL . then 50 qty of same item sold for 12/- each(5015=500) in same site and warehouse, if see item transaction, cost amount is not effecting for this sales transaction in item transaction form, ideally cost amount has to be effect as in same site & warehouse already purchase transaction is there for the same item.

Can any body tell why cost amount is not effecting for sales transaction.

Regards

Siddu

Post a screen shot of Inventory transactions form.

are you seeing the cost amount updated for Purchase transaction? if yes, the sales order which you are talking about…is it invoiced?

is the size for the item is same in both the SO and PO?

And run the inventory close before posting the screen shot :slight_smile: