inv. statistic is showing greater cost than realistic

ernest

Hi all

I am using Nav 5.0 and i have created a purchase invoice where i have bought some goods and after that directly registered a sales invoice with the same goods.
when i navigate to the invoice statistic window it is telling that the cost of the items is much bigger than it is for real.
i checked the prices many times and i checked these two documents several times and it is nothing wrong.

maybe this is coming because the sales invoice date is earlier than purchase date, but i do not know what is happening.

Please help. if you need i can even upload print screen from these two documents.

Regards
Ernest

FDickschat

Did you enter the sales invoice AFTER posting the purchase invoice?
Do you have cost adjustment on automatic? If not, did you run inbetween cost adjustment?

NAV reads the unit cost either from the SKU or item card at the time of entering the sales invoice. If cost has not been adjusted or if you enter the sales invoice before posting the purch. invoice it is of course showing the old cost.

ernest

1) the sales invoice was registered after posting the purchase invoice. Inbetween i have executed the report Ajust Cost Item Entries and still was not showing correct cost. i posted the sales invoice and than ran the report again and still the cost is wrong.

I do not know what i happening. These goods can not have different cost, because this was a specific order, i bought these items for the first time and then sold them directly to the customer who made the order.

When i go to each item card which i have used on these two invoices i can see clearly that cost is smaller then the amount of sales but still it is showing that profit is -72.4.

I can not understand why this is happening. Please help.

Best Regards

Fordewind

ernest wrote:

if you need i can even upload print screen from these two documents.

Can you upload print screens of Item Ledger Entry and Value Entry filtered by these items

FDickschat

Which Costing Method?
Do you use average, have Average Cost Calc Type in Inventory Setup set to per location but don't have SKUs setup?

Usually the doc statistic is a best guess. But yes, it should reflect the cost of the item at the time of registering the doc. All the rest will be done by ACIE.

ACIE will NOT update docs!! ACIE will only update VLE and the cost amount of item card and/or SKU. So running ACIE does not change your open or posted document!

A wild guess: You document is in currency and you have looked at the wrong field (cost instead of cost (LCY))?

ernest

Hi

I am using Average cost method for my items. I found that in the item card, last direct cost was a strange value, which i have not any idea where the system did get it.

the unit cost has the right value, but the last direct cost not. i changed this, but i have registered the two documents now and i do not know if there is any solution for this.

I noticed that when i was trying to export value entry values.

I am new at Navision so please don't write with acronyms to help me understand better.

Thank you and best regards

FDickschat

OK, Average Costing. But you did not answer all my questions:
- Does your doc have a different currency then local currency (LCY = local Currency)?
- What is the setting of the field Average Cost Calc Type in Inventory Setup?
If the field is set to "Per Item, Location, Variant":
- Do you use SKUs (Stock Keeping Units)
- For the item in question: Do you have a SKU record set up for the location in question?
- If yes: What is the Unit Cost on the SKU?
- If it does not exist: Create it and test new.

ACIE = Adjust Cost Item Entries

ACIE will NOT update docs!! ACIE will only update Value Entries (generate new ones) and will update the Unit Cost of item card and/or SKU. So running ACIE does not change your open or posted document and the doc statistic will still show the old unit cost!

In the document lines 2 fields exist for Unit Cost: One for the doc currency and one for LCY. Make sure you look at the correct one.

There is a white paper existing from MS for Item Costing. You should get it from Partner Source to understand better how all this works together. Actually, if you are new with NAV I suggest to download all available whitepapers for NAV and to read as much as possible to gain a better understanding how NAV works.

ernest

Hi Frank

Yes my docs are in foreign currency, but both have the same exchange rate and i checked this many times.

The Average Cost Calc Type in Inventory Setup is set to item.

I do not use SKU, i do not use locations for this enterprise.

Please help me how to solve this problem.

Regards
Ernest

FDickschat

Without seeing the full history of transactions it will not be possible to solve this from here.

One thing you can check: After posting the Purch. Inv. look at the item card and not the unit cost. Create your sales invoice and check that the unit cost in the line is identical to the unit cost of the item card. If no, there is a modification in your system. Find it. If yes, everything's fine.

Be sure to check both Unit Cost fields.

ernest

But the full history of transactions is composed only with 2 transactions, because i have registered the purchase invoice and than the sales invoice.

I had this problem that in the last direct cost in the item card, had taken some strange value.

Now the sales invoice is telling that my profit is with minus and this is not true.

how can i solve this. should i register some credit memo for sales invoice and then create another one.

Do you need any other information to help me.


Best Regards

FDickschat

As Fordewind and I already suggested: Please upload screenshots of the Item Ledger Entries and Value Entries in question, the Unit Cost on the Item card, the sales invoice line in question.

ernest

Value entry:
Posting Date Item Ledger Entry Type Entry Type Document No. Item Charge No. Description Sales Amount (Actual) Cost Amount (Expected) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Cost Posted to G/L Item Ledger Entry Quantity Valued Quantity Invoiced Quantity Cost per Unit Cost per Unit (ACY) Item No. Gen. Bus. Posting Group Gen. Prod. Posting Group Source Type Source No. External Document No. Valued By Average Cost Item Ledger Entry No. Capacity Ledger Entry No. Entry No.
06/11/10 Sale Direct Cost SH-B-00251 204,686.15 0.00 -360,997.50 0.00 -360,997.50 -1 -1 -1 360,997.50 0.00 109022197 VENDAS PROG Customer CU-001000 Yes 409 0 614
06/11/10 Sale Direct Cost SH-B-00251 818,744.61 0.00 -1,443,990.00 0.00 -1,443,990.00 -4 -4 -4 360,997.50 0.00 109030897 VENDAS PROG Customer CU-001000 Yes 410 0 615
06/11/10 Sale Direct Cost SH-B-00251 33,523.30 0.00 -59,124.00 0.00 -59,124.00 -1 -1 -1 59,124.00 0.00 109045099 VENDAS PROG Customer CU-001000 Yes 411 0 616
06/11/10 Sale Direct Cost SH-B-00251 33,523.31 0.00 -59,124.00 0.00 -59,124.00 -1 -1 -1 59,124.00 0.00 109045105 VENDAS PROG Customer CU-001000 Yes 412 0 617
06/11/10 Sale Direct Cost SH-B-00251 100,569.93 0.00 -177,372.00 0.00 -177,372.00 -1 -1 -1 177,372.00 0.00 109033397 VENDAS PROG Customer CU-001000 Yes 413 0 618
06/11/10 Sale Direct Cost SH-B-00251 50,284.96 0.00 -88,686.00 0.00 -88,686.00 -1 -1 -1 88,686.00 0.00 109030961 VENDAS PROG Customer CU-001000 Yes 414 0 619
06/11/10 Sale Direct Cost SH-B-00251 50,284.96 0.00 -88,686.00 0.00 -88,686.00 -1 -1 -1 88,686.00 0.00 109030962 VENDAS PROG Customer CU-001000 Yes 415 0 620
06/11/10 Sale Direct Cost SH-B-00251 241,058.78 0.00 -364,476.72 0.00 -364,476.72 -1 -1 -1 364,476.72 0.00 108075582 VENDAS PROG Customer CU-001000 Yes 416 0 621
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 91,119.18 0.00 91,119.18 0 -1 0 -91,119.18 0.00 108075582 VENDAS PROG Customer CU-001000 Yes 416 0 622
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 166,058.85 0.00 166,058.85 0 -1 0 -166,058.85 0.00 109022197 VENDAS PROG Customer CU-001000 Yes 409 0 623
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 664,235.40 0.00 664,235.40 0 -4 0 -166,058.85 0.00 109030897 VENDAS PROG Customer CU-001000 Yes 410 0 624
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 40,795.56 0.00 40,795.56 0 -1 0 -40,795.56 0.00 109030961 VENDAS PROG Customer CU-001000 Yes 414 0 625
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 40,795.56 0.00 40,795.56 0 -1 0 -40,795.56 0.00 109030962 VENDAS PROG Customer CU-001000 Yes 415 0 626
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 81,591.12 0.00 81,591.12 0 -1 0 -81,591.12 0.00 109033397 VENDAS PROG Customer CU-001000 Yes 413 0 627
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 27,174.30 0.00 27,174.30 0 -1 0 -27,174.30 0.00 109045099 VENDAS PROG Customer CU-001000 Yes 411 0 628
06/11/10 Sale Direct Cost SH-B-00251 0.00 0.00 27,174.30 0.00 27,174.30 0 -1 0 -27,174.30 0.00 109045105 VENDAS PROG Customer CU-001000 Yes 412 0 629


Item Ledger Entries:
item 1)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109022197 -1 -1 0 204,686.15 -194,938.65 0.00 No 409
06/14/10 Purchase P-SH-01563 109022197 1 1 0 0.00 194,938.65 0.00 No 397

item 2)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109030897 -4 -4 0 818,744.61 -779,754.60 0.00 No 410
06/14/10 Purchase P-SH-01563 109030897 4 4 0 0.00 779,754.60 0.00 No 398

Item 3)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109045099 -1 -1 0 33,523.30 -31,949.70 0.00 No 411
06/14/10 Purchase P-SH-01563 109045099 1 1 0 0.00 31,949.70 0.00 No 402

item 4)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109045105 -1 -1 0 33,523.31 -31,949.70 0.00 No 412
06/14/10 Purchase P-SH-01563 109045105 1 1 0 0.00 31,949.70 0.00 No 403

item 5)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109033397 -1 -1 0 100,569.93 -95,780.88 0.00 No 413
06/14/10 Purchase P-SH-01563 109033397 1 1 0 0.00 95,780.88 0.00 No 401

item 6)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109030961 -1 -1 0 50,284.96 -47,890.44 0.00 No 414
06/14/10 Purchase P-SH-01563 109030961 1 1 0 0.00 47,890.44 0.00 No 399

item 7)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 109030962 -1 -1 0 50,284.96 -47,890.44 0.00 No 415
06/14/10 Purchase P-SH-01563 109030962 1 1 0 0.00 47,890.44 0.00 No 400

item 8)
Posting Date Entry Type Document No. Item No. Description Location Code Quantity Invoiced Quantity Remaining Quantity Sales Amount (Actual) Cost Amount (Actual) Cost Amount (Non-Invtbl.) Open Entry No.
06/11/10 Sale S-SH-00300 108075582 -1 -1 0 241,058.78 -273,357.54 0.00 No 416
06/14/10 Purchase P-SH-01563 108075582 1 1 0 0.00 273,357.54 0.00 No 404

FDickschat

Not really a screenshot :shock:

I did not check on the values in this mess but one thing is obvious: Your purchase is dated after the sale (purch=06/14, sale=06/11).
Try the whole thing again with new items without any transactions:
- Day 1: Enter Purch. ODer and post Purchase Receipt
- Day 2: Post Purchase Invoice
- Day 3: Run Cost Adjustment
Check that ILE + VE were posted correct
- Day 4: Enter Sales Order
Check that the fields "Unit Cost" and "Unit Cost (LCY)" are correct
Post Shipment
- Day 5: Post Sales Invoice
- Day 6: Run Cost Adjustment
Check that ILE + VE of the Sale are correct and whether Cost Adjustment has created an additional VE

If it is now incorrect there is a modification in your system changing something. In this case try it in an unmodified NAV DB and find out where the mod is doing something wrong.

For the Attachment: Next time please use a jpg and better hide the company name.

And please: Get the NAV whitepaper about Item Costing.

ernest

But what should i do with the transactions that are already in the system. should i create reversals or what?

Regards
Ernest

FDickschat

You are not saying that you have posted this in a live environment? ](*,) ](*,)

Forget about the document statistics in posted docs. ACIE does not update them.
Check the value entries, whether ACIE has made adjustments. To correct it there are several ways. Copy the database into a testsystem and try it there.

](*,) Sorry, I have no time to guide you step by step, but maybe someone else has. This is basic item costing knowledge... the simplest way is to ask an experienced developer/consultant to explain personally.

ernest

Hi FDickschat

Thanks for all your posts, but please just tell me what to do to fix this.

Should i create reversals in the system.

I have posted these documents in live environment.


Thanks you and best regards
Ernest

FDickschat

What did you try in your test database? Am I correct that you have not followed my advice to create one and test? :roll: [-X

You can try reversing documents. Do it in the original order backwards until you reach the purchase invoice. Before you start posting forward again run ACIE and check whether now the cost price of the item is "correct" on item card level
You might want to go with item revaluation without posting any reversals.
Check that you have no received, not invoiced goods of that item in stock.

You need to discuss this also with accounting. To be able to discuss with them YOU need to create a test DB (probably several) and start test posting this yourself. If you can't figure it out yourself you will need LOCAL help (at least someone with access to your DB).