Can't Post Combine Shipment with Line has Job No.
BHT
Member Posts: 56
Hi Guys,
I can't post Purch Invoice which line has job no. and item tracking code.
the scenario like this:
1. I made a purchase order for item with tracking line contain serial no & lot no.
2. This Item I purchase I allocate to a specific Job and Job Task line no.
3. I post receive only this purchase order.
4. then I use purchase invoice by executing get receipt line (combine shipment).
5. when trying to post then error comes.
it always telling the quantity in purchase receipt greater than expected.
6. from my investigation, after post receive this purch. line with job no. and tracking code,
NAV replace it's item tracking quantity to invoice with -1 instead of retaining qty. 1.
(NAV use negative adjmt. for consumption to job).
7. this problem never happen when post purch. line without job.
Anyone can help with some idea to overcome this???
...BHT
I can't post Purch Invoice which line has job no. and item tracking code.
the scenario like this:
1. I made a purchase order for item with tracking line contain serial no & lot no.
2. This Item I purchase I allocate to a specific Job and Job Task line no.
3. I post receive only this purchase order.
4. then I use purchase invoice by executing get receipt line (combine shipment).
5. when trying to post then error comes.
it always telling the quantity in purchase receipt greater than expected.
6. from my investigation, after post receive this purch. line with job no. and tracking code,
NAV replace it's item tracking quantity to invoice with -1 instead of retaining qty. 1.
(NAV use negative adjmt. for consumption to job).
7. this problem never happen when post purch. line without job.
Anyone can help with some idea to overcome this???
...BHT
Regards,
BHT
BHT
0
Comments
-
I found Article ID: 956434 regarding this issue from partner source.
The suggestion as below:
Existing code:
ItemLedgEntry.SETRANGE("Job No.",ItemJnlLine."Job No.");
ItemLedgEntry.SETRANGE("Job Task No.",ItemJnlLine."Job Task No.");
ItemLedgEntry.SETRANGE("Item No.",ItemJnlLine."Item No.");
IF ItemLedgEntry.FINDFIRST THEN BEGIN
REPEAT
IF ItemLedgEntry."Entry No." = ItemJnlLine."Item Shpt. Entry No." THEN BEGIN
ItemLedgEntry.NEXT;
ItemJnlLine."Item Shpt. Entry No." := ItemLedgEntry."Entry No.";
EXIT;
END;
UNTIL ItemLedgEntry.NEXT = 0;
END;
Replacement code
WITH ItemLedgEntry DO BEGIN
SETRANGE("Job No.",ItemJnlLine."Job No.");
SETRANGE("Job Task No.",ItemJnlLine."Job Task No.");
SETRANGE("Item No.",ItemJnlLine."Item No.");
SETFILTER("Item Tracking",'<>%1',"Item Tracking"::None);
IF FINDFIRST THEN BEGIN
SETRANGE("Entry Type",ItemJnlLine."Entry Type"::"Negative Adjmt.");
SETRANGE("Serial No.",ItemJnlLine."Serial No.");
SETRANGE("Lot No.",ItemJnlLine."Lot No.");
IF FINDFIRST THEN
ItemJnlLine."Item Shpt. Entry No." := "Entry No.";
EXIT;
END;
SETRANGE("Item Tracking");
IF FINDSET THEN
REPEAT
IF "Entry No." = ItemJnlLine."Item Shpt. Entry No." THEN BEGIN
NEXT;
ItemJnlLine."Item Shpt. Entry No." := "Entry No.";
EXIT;
END;
UNTIL NEXT = 0;
END;
But unfortunately doesn't change anything... ](*,)
BHTRegards,
BHT0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K 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
- 333 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