Costing at Item Journal

RachelSoon
Member Posts: 202
Hi All,
I am using Nav 3.60 (SQL) cronus to check on the costing at the item journal. Found out that, if it's negative adjustment, the Unit Amount can not be changed as the system will post the Unit Amount which was suggested by the system.
Scenario:
1) Create a new item with Costing Method = Average
2) Create a new journal line, entry type = Negative Adjustment
3) When we select the Item, system will default the Unit Amount, say 10. The system accept if we manully overwrite the amount to 18.
4) the test report has not problem as well. We can post the entry sucessfully also.
5) But when we check at the Item Ledger Entry, the Cost Amount (Actual) is 10. And this happen for Negative Adjustment.
Anyone has encounter this problem before? how should we rectify this problem?
Thank you.
Regards
Rachel
I am using Nav 3.60 (SQL) cronus to check on the costing at the item journal. Found out that, if it's negative adjustment, the Unit Amount can not be changed as the system will post the Unit Amount which was suggested by the system.
Scenario:
1) Create a new item with Costing Method = Average
2) Create a new journal line, entry type = Negative Adjustment
3) When we select the Item, system will default the Unit Amount, say 10. The system accept if we manully overwrite the amount to 18.
4) the test report has not problem as well. We can post the entry sucessfully also.
5) But when we check at the Item Ledger Entry, the Cost Amount (Actual) is 10. And this happen for Negative Adjustment.
Anyone has encounter this problem before? how should we rectify this problem?
Thank you.
Regards
Rachel
0
Comments
-
Hi Rachel,
The COST at the time of -ve adj does not depend on the unit amout fld but the unit cost fld on the journal.
The unit amout fld and the unit cost on jrnl will be picked up from the unit cost from the item card.
In yr case, try changing the unit cost fld on jrnl to 18 instead of unit amount fld.
AmitApricot0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions