Bagaimana ketahui bhw sebuah sales return dibuat dg exact-cost-reversing (aka. fixed-application) ?
Lihat apakah di table Item Application Entry utk retur tsb, field Outbound Entry No. terisi
Tg 7 JULI sudah jalankan ACIE dg Allow From 1 JUNI
Hr ini tg 12 JULI leo minta ACIE lagi. Perlukah ?
JAWAB :
VE: Filter entry SETELAH ACIE terakhir, cari apakah ada VALUATION DATE dg bln JUNI
Jika ada dan ACIE tidak dijalankan, maka akan ada hasil ACIE utk entry2 tsb yg nantinya akan jatuh di 1 JULI (Allow From saat ACIE berikutnya )
The program uses the posting date of the original value entry in the adjustment entry, unless that date is in a closed inventory period. In that case, the program uses the starting date of the next open inventory period. If inventory periods are not used, the date in the Allow Posting From field of the General Ledger Setup window will define when the adjustment entry is posted.
Posting Date on Adjustment Value Entry
Version 3.70.B..4.0
In the request form of the Adjust Cost - Item Entries batch job there is a Closed Period Entry Posting Date to be entered by the user. The batch job runs through all necessary changes and creates value entries with the posting date of the parent item ledger entry (shipment date of the sale that the adjustment address). If the posting date of the parent item ledger entry is not within allowed posting date range the posting date stated as Closed Period Entry Posting Date will be assigned the Adjustment Value Entry. A date is considered to be in a closed period when it is earlier than the date in the Allow Posting From field in the General Ledger Setup.
From version 5.0:
There is no longer a posting date to be stated in the request form of the Adjust Cost - Item entries batch job. The batch job runs through all necessary changes and creates value entries with the posting date of the value entry it adjusts. If the posting date is not within allowed posting date range the posting date in the Allow Posting From field in the General Ledger Setup, OR if the Inventory periods are used, the later date of the two will be used. See described concept above.
Why you have Negative Inventory Value with 0 Quantity – Navision 3.7b to Navision 5.0
If the adjust cost is processed on 7/31/07, and the Allow Posting From was 7/1/07 on General Ledger Setup, the following would occur:
6/28/07 – Ship and Invoice – $10
7/31/07 – Additional Cost for the sale made on 6/28/07 – $2
Articles
Specific Costing for Lot No Tracking
...If you use FIFO costing with the setting "Lot Specific Tracking" then the outbound entries will be applied
...to inbound entries by lot - which will be lot specific costing. this is just as it works
Design Details: Average Cost Calculation
Costing for Navision 4.0 Technical White Paper (May 2004)
Simulation of Average Cost Calculation (Jan 2012)
microsoft-dynamics-nav-inventory-costing-correction-whitepaper.pdf (Oct 2011)
Google: adjust cost item entries valuation date exact|applied
Determine why an ILE of Production Output received INVTADJMT
One or more Consumption entry of the same Production must have had its cost adjusted
How does NAV know which items to processed during Adjust Cost Item Entries (ACIE)?
When we a post purchase(?) transaction, a record is inserted to (or updated on) Avg. Cost Adjmt. Entry Point (ACAEP) table
At the end of ACIE process, ACAEP table will be emptied
For FIFO: In Item ledger entry table there is a field called "Applied Entry to Adjust". This is how adjust routine doesn't look at entries it has adjusted.
For Average: it populates the Avg. Cost Adjmt. Entry Point or Average Cost Adjustment table (based on which version you use) upon inventory movements and adjust those items mentioned there with Valuation Date later than the date shown there.
source: adjust cost - never adjust more than once
Related:
Very important Adjust cost summary
when "Applied Entry to Adjust" is yes?
ACIE: Posting Date in Adjust Cost-Item Entries
If the adjustment entry is not within the allowable posting date range specified on the General Ledger Setup, then it's going to use the date you specify on the Adjust Cost Item Entries process [even if the date is allowed in User Setup table]
ACIE: Error "Posting date is not within your range"
If G/L Setup or User Setup is restricting date from X to Y, check Value Entries for Posting Date outside that range
What's the difference between Appl.-TO and Appl.-FROM ILE column?
Appl.-TO is related with purchase returns where you can select a positive open ILE.
Appl.-FROM is related with sales returns where you can select a negative ILE.
Source:
Exact Cost Reversing Link has not been created...
www.mibuso.com/forum/viewtopic.php?f=23&t=33683
Online Help for Exact Cost Reversing... field both on "P and P" and "S and R" Setup
Related
--------
Is there any way to have Navision auto-fill Apply-from column?
sorry but there is no option to aufill that appl. from item entry
(source: Credit Memo error "Appl. from Item Entry...")
Exact Cost Reversal function becomes more humane in Microsoft Dynamics NAV 5.0
1.can access regular documents (rather than item ledger records) and copy one or multiple lines, be they from the same or different documents
2.among the documents to copy from, will find invoices (as well as credit memos, if that's relevant) - the most logical reference document in returns situation (see screenshot below; click to expand)
3.will not have to manually enter serial/lot numbers for the returned items - the program automatically copies item tracking lines to the return document from the original document
4.can rely on the program to keep track of the already returned and cost reversed quantity on the sales documents - so you don't have to worry about cost reversing return of the same sold quantity more than once.
How to change Cost Amount of an inbound ILE?
Use Revaluation Journal:
..Calculate Inventory Value (KALO INI, HANYA UTK REMAINING QTY)
OR,
..Fill Item No. (ignore Posting Date, it will be autofilled by next step)
..Fill Apply-to Entry
THEN,
..Change Unit Cost (Revalued) for ILE in question
..Post
Sample scenario that requires above procedure:
..User posted purchase order with right qty but wrong price, realized it then has post return and
..new correct order BUT
..stock from initial order has been consumed/sold
With Average costing method, will Unit Price of Sales Return affects Unit Cost?
No; See screenshot below (post Adjust-cost condition):
Simulate how NAV calculate Average Cost
www.navision-girl.com/2009/03/steps-to-calculate-average-cost-in.html
Note:
Quantity mentioned on the article might refer to "Invoiced Quantity"
It's probably better to sort on "Item Ledger Entry No." as well (after "Valuation Date")
Koreksi atas Purchase yang salah harga dan sudah dibuatkan Purchase Return
- jika pro sdh betul diisi apply-to nya, maka tinggal buat po baru yg benar
- jika pro lupa diisi apply-to nya, maka selain buat po baru yg benar, harus revaluate pr dari po yg pertama (agar cost tidak kacau)
Buat SRO yang benar dulu (agar stok tersedia utk SO yg nantinya akan dibuat):
- Gunakan Copy Document: Posting Date sesuai SRO yg keliru
- pastikan exchange rate sesuai SO awal
- isi Apply-from
- Pastikan Warehouse Receipt diposting dg lot sesuai SO awal dan dg Posting Date sesuai SRO yg keliru
Buat SO utk batalkan SRO yg keliru:
- Pastikan isi Apply-to (*)
- pastikan exchange rate sesuai SRO
- isi Unit Cost (LCY) sama dengan Unit Cost pada SRO yg keliru (!!!)
- Pastikan Warehouse Shipment diposting dg lot dan Posting Date sesuai SRO
Validasi lunas kedua dokumen tsb
(*) Utk kondisi dimana pengisian Apply-to tidak bisa dilakukan (krn baris ILE sudah tidak Open) _DAN_ tidak ada perubahan avg cost sejak SO awal hingga SRO yg keliru, maka cukup lakukan Revaluation Journal atas ILE milik SRO yg keliru agar sesuai dengan avg cost dari transaksi di "sekitarnya"
Omzet minus tapi profit plus
Retur jual lebih besar dari jual, tapi secara rasio thd nilai transaksinya, retur memiliki hpp lebih besar drpd jual (Retur adalah untuk jual yg lain/terdahulu)
Contoh:
Omzet HPP Profit
2000 -1000 1000 HPP=50% dari Omzet
-4000 3500 -500 HPP melebihi 50% dari Omzet
------- ------ -----
-2000 500
NAV 4.0: Agar ACIE hanya proses item tertentu
CU 5895 MakeSingleLevelAdjmt:
...
WITH ItemLedgEntry DO BEGIN
SETCURRENTKEY("Item No.");
SETFILTER(ItemLedgEntry."Item No.",'ITEM_CODE_HERE');
IF FIND('-') THEN
REPEAT
...
SETRANGE("Item No.",'ITEM_CODE_HERE');
UNTIL (NEXT = 0) OR LevelExceeded;
Kenapa ada baris Sale yang Cost Amount nya tinggi sekali padahal secara kasat mata terlihat bahwa Purchase terkait memiliki Cost Amount rendah (Catatan: Belum jalankan ACIE)
Jalankan dulu ACIE
Sebelum jalankan ACIE, Cost yang didapat sebuah Sale berasal dari Cost saat Sales Order dibuat
(Bisa dilihat dengan membandingkan Unit Cost yang ada di Sales Shipment Line dengan Average Cost di tanggal-tanggal sekitar saat SO dibuat)
