Expected Cost Posting Problems

selece28

Hi Nav masters
I'm a technical consultant and just learning bout Nav cost posting.
My application consultant want me to check some problems,
The problem is like this, we want the automatic cost posting to run on
Posting Ship from Sales Order.

We done some setting on
Warehouse menu - Setup - Inventory Setup, check the Automatic Cost Posting and Expected Cost Posting to G/L

Then how come when i post a Sales Order to Ship, then i click the Navigate on Posted Sales Shipment, it only have 3 line:
- Posted Sales Shipment
- Item Ledger Entry
- Value Entry

Did i forgot something? Where's the 4th line, the G/L Entry?
I debug the code on posting Ship but i'm lost. Could anyone tell me where to find the code that insert to G/L Entry?

Please help me.
Thanks in advance

David_Singleton

selece28 wrote:

Hi Nav masters
I'm a technical consultant and just learning bout Nav cost posting.
My application consultant want me to check some problems,
The problem is like this, we want the automatic cost posting to run on
Posting Ship from Sales Order.

We done some setting on
Warehouse menu - Setup - Inventory Setup, check the Automatic Cost Posting and Expected Cost Posting to G/L

Then how come when i post a Sales Order to Ship, then i click the Navigate on Posted Sales Shipment, it only have 3 line:
- Posted Sales Shipment
- Item Ledger Entry
- Value Entry

Did i forgot something? Where's the 4th line, the G/L Entry?
I debug the code on posting Ship but i'm lost. Could anyone tell me where to find the code that insert to G/L Entry?

Please help me.
Thanks in advance

You need also to set up the G/L posting accounts for Expected Cost posting. I think that by default some of these feilds are hidden in the forms. Though some how I think you would have gotten an error message if they were blank?

ecclectic

check the if the unit cost on the item card or sku is not zero.

try run adjust cost. ( not sure if adjust updates this)

selece28

Sorry David, could you be more specific.
Like maybe, if you don't mind, can you give me a list of what should i set and where to set. Because i'm afraid i miss something here.


And for ecclectic you said:
"check the if the unit cost on the item card or sku is not zero. "

what is SKU? my Unit cost is already 0.
Could you be more specific too.

I'm sorry but i really don't understand bout this.

Thanks in advance

ecclectic

selece28 wrote:

And for ecclectic you said:
"check the if the unit cost on the item card or sku is not zero. "

what is SKU? my Unit cost is already 0.
Could you be more specific too.

the sku is the stockkeeping unit of the item. it contains information about the item card that's related to a specific location.

If on the inventory setup card, you have set the costing method to be by location and variant, it means that navision will be keeping the cost of the item by location. Navision will then use the cost kept on the SKU to determine at what cost the item should be going out. Else if the costing method is not set by location and variant, the system will use the cost on the item card instead.

When you make a sales, the system will use the field unit cost on the sku or item card to update the value entry. if the unit cost is zero, no entry will be made in g/l.

on running the adjust cost, the system compares the cost at which the item went out and the value in the flowfield average cost (on item card or sku). should there be a discrepancy, adjustments will be made in value entry and g/l

selece28

Hi
I set the Average Cost Calc. Type = Item on Inventory Setup
and Stockkeeping Unit Exist. = NO on Item Card

But still no G/L Entry on Navigate on Posted Sales Shipment???

Thanks

ecclectic

selece28 wrote:

Hi
I set the Average Cost Calc. Type = Item on Inventory Setup
and Stockkeeping Unit Exist. = NO on Item Card

But still no G/L Entry on Navigate on Posted Sales Shipment???

Thanks

question: do you have a unit cost for the item?

selece28

Sorry forgot to mention. The Unit Cost in Item Card = 0

ecclectic

selece28 wrote:

Sorry forgot to mention. The Unit Cost in Item Card = 0

you got your answer. the unit cost being zero, no entry will be updated in the g/l unless the charges are applied to the item or pending receipts are invoiced

selece28

Sorry maybe this is a stupid question.
But how to add a unit cost?
When i add from item card, it shows
"You cannot change Unit Cost because there are one or more ledger entries for this item"

How can i solve this problems???

Thanks a lot

ara3n

You need to use standard cost worksheet, and change the cost of that item.

selece28

Hi all
I've done some testing using the default Cronus DB.
I test using item with Unit Cost and Item without Unit Cost.
And you are right, ecclectic.
My posted shipment now have G/L Entry.

Thanks all for the information. This is new things for me to learn.

Thank You once again, you guys are the best.
So happy now \:D/