Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 326 Dynamics CRM
- 110 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 994 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Costing Issue in Adjust Cost - Item Entry
fjgillie
Member Posts: 17
Background:
We ran NAV 4.0 SP 1 for a trading company. There is no manufacturing, just purchase inbound and sales outbound, and some internal transfer order. The costing method is Average Costing. Normally we leave the initial unit cost equal to zero or 0.01 when the end user create new item card.
Inventory Setup
Automatic Cost Posting = YES, Expected Cost Posting to G/L = YES
Now I have an issue as following:
After running ACIE batch job, some acutal cost didn't show up in the field Cost Amount(Actual) in Item Ledger Entry with Entry Type = Sales. Acutally for this item, its related sales and purchase invoice are all posted. So I think ACIE must generate the cost adjustment entry to show the COGS. But it did not as expected.
During the batch running, there is an exception, i.e. we got the error message that is "*** entry have existed in table 5804 Avg. Cost Adjmt. Entry Point". I forget that its exact description.... I delete all the records in table 5804. I am not sure if there is any impact of the action. If any, how can I recover it?
As I know there are some tables and field related to ACIE batch job, but not quite sure of their relation and trigger point.
table 5804 Avg. Cost Adjmt. Entry Point
Item Application Entry
Item. "Cost is Adjusted" Item."Allow Online Adjustment"
"Item Ledger Entry"."Applied Entry to Adjust"
"Value Entry"."Valued By Average Cost"
"Value Entry".Adjustment
My question is:
If now I make sure of all sales/purchase invocie are posted and the ACIE didn't generate the adjustment entry. How can I judge when the adjustment entry will be trigger, or can I modify some specific above fields or insert/modify the above releated table to let ACIE re-running to generate the expected adjustment entries.
Thanks very much in advance.
We ran NAV 4.0 SP 1 for a trading company. There is no manufacturing, just purchase inbound and sales outbound, and some internal transfer order. The costing method is Average Costing. Normally we leave the initial unit cost equal to zero or 0.01 when the end user create new item card.
Inventory Setup
Automatic Cost Posting = YES, Expected Cost Posting to G/L = YES
Now I have an issue as following:
After running ACIE batch job, some acutal cost didn't show up in the field Cost Amount(Actual) in Item Ledger Entry with Entry Type = Sales. Acutally for this item, its related sales and purchase invoice are all posted. So I think ACIE must generate the cost adjustment entry to show the COGS. But it did not as expected.
During the batch running, there is an exception, i.e. we got the error message that is "*** entry have existed in table 5804 Avg. Cost Adjmt. Entry Point". I forget that its exact description.... I delete all the records in table 5804. I am not sure if there is any impact of the action. If any, how can I recover it?
As I know there are some tables and field related to ACIE batch job, but not quite sure of their relation and trigger point.
table 5804 Avg. Cost Adjmt. Entry Point
Item Application Entry
Item. "Cost is Adjusted" Item."Allow Online Adjustment"
"Item Ledger Entry"."Applied Entry to Adjust"
"Value Entry"."Valued By Average Cost"
"Value Entry".Adjustment
My question is:
If now I make sure of all sales/purchase invocie are posted and the ACIE didn't generate the adjustment entry. How can I judge when the adjustment entry will be trigger, or can I modify some specific above fields or insert/modify the above releated table to let ACIE re-running to generate the expected adjustment entries.
Thanks very much in advance.
0
Comments
2) Look for possible bugs resolved in SP2 and SP3. SP1 as any other version has some problems...
3) Are you working on MS SQL or Native DB?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
1) still not quite of the use of table 5804. I have deleted all record in table 5804. Do you mean it is no impact. The system will generate the temporary records for this table.
2) where can I download SP2/SP3 document to review the fixed bugs?
3) MS SQL
2) Documents about changes are on the install CD of the new version in root directory
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.