Sales Vs Cost Amount in ILE

gerrykistler · **Posted:** Sun Jun 10, 2012 9:22 pm

kmkaot wrote:

I think I have done the following actions/Steps (Mistakes)

1. I took opening stock as of 31/12/2011, using Item journal with Postive adjustement, created journal but not posted, because I want user to conirm the data.
The timing of entering and posting this would not have an impact on cost if you run Adjust Cost Item Entries and there was opening inventory in the location of the sale
2. User started entering sales from 01-01-2012.
3. I doubt accounting period was closed after posting Opening Financial Opening voucher.
(I doubt??).
You should confirm - your issue was the Average Costing Method was not changing - this could be why
4. Recently user has time to verify the opening stock in Item journal which was pending post till last month.

5. User has verified and posted Item journal.
6. When she takes the Inventory valuation report, Decreased quantity is shown but value is missing. Thus the closing stock value is very big and not flown to COGS.
7. I think later I have re-open the finaicial year and inventory period. but some where I missed.
If the Inventory Period is closed, I suggest re-opening and re-running Adjust Cost Item Entries. If the Accounting Periods are closed (prior year was closed) then you have to re-open through code

Warm Regards
KMK

kmkaot · **Posted:** Mon Jun 11, 2012 10:17 am

Dear Gerry Kistler,

No comment? :roll:

gerrykistler · **Posted:** Mon Jun 11, 2012 10:41 am

Did you read my comments in bold within the quote?

golfer · **Posted:** Mon Jun 11, 2012 8:02 pm

The remaining quantity is still negative in location DXB and therefore it will not update the cost. You need to transfer 2 pcs from location AUH to DXB, then it will update the cost.

kmkaot · **Posted:** Tue Jun 12, 2012 8:34 pm

Yes dear,

When I transfer 2 quantity from location AUH to DXB, then cost is getting updated. But why when I have opted for Item level costing and it is doing for Item, Location, Variant wise costing.?

Thank you for reply.

Warm Regards
KMK

gerrykistler · **Posted:** Tue Jun 12, 2012 8:59 pm

First of all I am not a dear. Second of all I am still waiting for replies to my earlier posts regarding the Accounting Periods etc...

kmkaot · **Posted:** Wed Jun 13, 2012 2:15 pm

Let us stop it here,

I think I dont need any more help from you..

We call 'dear' in GCC countries for friends also.

bye KMK

udayrmer · **Posted:** Sat Jun 16, 2012 9:23 am

Hi kmkaot,

I had tested your case, you had posted sales invoice without any inventory on-hand, as well as at the time of making sales order, on your item card Unit Cost was 0 so, in ILE Cost amount posted zero

kmkaot · **Posted:** Sat Jun 16, 2012 12:27 pm

Thanks Uday,

I also posted stock inbound entry with older date after making sales. Normally it should update the cost even though I have posted later with exact older date.

Warm Regards
KMK

udayrmer · **Posted:** Mon Jun 18, 2012 7:22 am

Hi KMK,

If you post inbound entry then you are selecting that item on sales order, the unit cost will updated, because Unit cost on item card has been updated with inbound entry cost.
This is the case so you are not updated with cost.

mibuso.com

Sales Vs Cost Amount in ILE

Who is online