Change Location before Qty Invoiced in Purchase
casanova
Member Posts: 194
Hi All,
i have a question regarding purchase receipt
so lets say i create purchase order for 1 item
Item A Qty Order = 10
I receive this item partially
1st Receipt --> Location BLUE
2nd Receipt --> Location GREEN
3rd Receipt --> Location SILVER
note : we cant invoiced this receipt regarding company policy, so is there a way to this?
maybe we can create as 3 different lines, but the problem here is... we dont know this item will be distributed to which location until we receipt
I just imagine, i change the code in Table 39 (Purchase Line)
on user validate "Location Code", i block this code
i tried it, and it works... but is there any implication for the future if i do this?
thanks for the advice
i have a question regarding purchase receipt
so lets say i create purchase order for 1 item
Item A Qty Order = 10
I receive this item partially
1st Receipt --> Location BLUE
2nd Receipt --> Location GREEN
3rd Receipt --> Location SILVER
note : we cant invoiced this receipt regarding company policy, so is there a way to this?
maybe we can create as 3 different lines, but the problem here is... we dont know this item will be distributed to which location until we receipt
I just imagine, i change the code in Table 39 (Purchase Line)
on user validate "Location Code", i block this code
Location Code - OnValidate()
//TestStatusOpen;
IF xRec."Location Code" <> "Location Code" THEN BEGIN
IF "Prepmt. Amt. Inv." <> 0 THEN
IF NOT CONFIRM(Text046,FALSE,FIELDCAPTION("Direct Unit Cost"),FIELDCAPTION("Location Code")) THEN BEGIN
"Location Code" := xRec."Location Code";
EXIT;
END;
//TESTFIELD("Qty. Rcd. Not Invoiced",0);
//TESTFIELD("Receipt No.",'');
//TESTFIELD("Return Qty. Shipped Not Invd.",0);
//TESTFIELD("Return Shipment No.",'');
END;
i tried it, and it works... but is there any implication for the future if i do this?
thanks for the advice
0
Comments
-
The "correct" way of doing this is to receive all items in a single location and then use Transfer Order to distribute the items from that location to the others.________________________________
Gunnar Gestsson
Microsoft Certified IT Professional
Dynamics NAV MVP
http://www.dynamics.is
http://Objects4NAV.com0 -
yes that what i'm thinking
but it's make users double job
they must input all the items 1 more time
and then select the lot no.0 -
You can create an interface for the user to input all needed information in the purchase order and then in the posting process you can create and post the transfer order automatically.
Everything is possible with NAV
________________________________
Gunnar Gestsson
Microsoft Certified IT Professional
Dynamics NAV MVP
http://www.dynamics.is
http://Objects4NAV.com0
Categories
- All Categories
- 75 General
- 75 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
- 611 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 253 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions