Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Adjust cost - item entries
Steini
Member Posts: 5
Hope someone will be able to tell me how to get through this error message.
Here is the situation:
I am running the Adjust Cost - Item entries batch job and
Costing method is Average for all Items and
Location mandatory = yes
When trying to run the batch job I get an error message stating that I must specify New location code in Item journal line Journal Template name = '', journal batch name='', Line no.=0.
The thing is that the Item Ledger Entry that the batch job stops on is a Transfer entry from one Location code to another.
In the Item Ledger Entry table there is no field for this, but there is one in the Item journal line.
The system uses this to split the transfer into two Item ledger entries but does not keep this field in the item entry.
I can get through this by taking the location mandatory option off but that to me is a short term solution.
any help is appreciated.
Regards
Steini
Here is the situation:
I am running the Adjust Cost - Item entries batch job and
Costing method is Average for all Items and
Location mandatory = yes
When trying to run the batch job I get an error message stating that I must specify New location code in Item journal line Journal Template name = '', journal batch name='', Line no.=0.
The thing is that the Item Ledger Entry that the batch job stops on is a Transfer entry from one Location code to another.
In the Item Ledger Entry table there is no field for this, but there is one in the Item journal line.
The system uses this to split the transfer into two Item ledger entries but does not keep this field in the item entry.
I can get through this by taking the location mandatory option off but that to me is a short term solution.
any help is appreciated.
Regards
Steini
0
Comments
To solve this question perform the following correction on Codeunit
21"Item Jnl.-Check Line":
Function RunCheck: Only check for new location if Quantity <> 0:
Before:
IF (InvtSetup."Location Mandatory") AND
("Value Entry Type" = "Value Entry Type"::"Direct Cost")
THEN BEGIN
IF Quantity <> 0 THEN
TESTFIELD("Location Code");
IF "Entry Type" = "Entry Type"::Transfer THEN
TESTFIELD("New Location Code");
END;
After:
IF (InvtSetup."Location Mandatory") AND
("Value Entry Type" = "Value Entry Type"::"Direct Cost") AND
(Quantity <> 0)
THEN BEGIN
TESTFIELD("Location Code");
IF "Entry Type" = "Entry Type"::Transfer THEN
TESTFIELD("New Location Code");
END;
Regards,
Luís Nunes