Using Navision Item Charges and partially shipped orders

harm.poelen
Member Posts: 36
Hi there,
Got an other challendge... I've got 3 item lines with 3 charge item lines (seperatelly) linked to these item lines (one item on one charge item).
Now we can ship (using WMS) the first two lines. The last line cannot be shipped because we don't have sufficient stock. Now we will go and invoice the item lines that we have shipped...
In this case we don't want the charge item line linked to the last item line (the one not shipped) to be invoiced just yet.... this would look stupid on the invoice since the goods are not on that invoice...
So before invoicing I try to change the items to ship and invoice for the charge item to 0 (empty) and then try to invoice the first two lines with their charge items. No such luck.... the system is now telling me that I can not have 0 on the specific charge item line...
Anybody any suggestions on what to do... I'm going crazy thinking of solutions for this problem (other then just stop using the charge items and posting it directly to a G/L account)....
HELP !
Got an other challendge... I've got 3 item lines with 3 charge item lines (seperatelly) linked to these item lines (one item on one charge item).
Now we can ship (using WMS) the first two lines. The last line cannot be shipped because we don't have sufficient stock. Now we will go and invoice the item lines that we have shipped...
In this case we don't want the charge item line linked to the last item line (the one not shipped) to be invoiced just yet.... this would look stupid on the invoice since the goods are not on that invoice...
So before invoicing I try to change the items to ship and invoice for the charge item to 0 (empty) and then try to invoice the first two lines with their charge items. No such luck.... the system is now telling me that I can not have 0 on the specific charge item line...
Anybody any suggestions on what to do... I'm going crazy thinking of solutions for this problem (other then just stop using the charge items and posting it directly to a G/L account)....
HELP !
CANE Microsoft Solutions BV
Prins Hendrikplein 14
2518 JC DEN HAAG
The Netherlands
http://www.cane.nl
Prins Hendrikplein 14
2518 JC DEN HAAG
The Netherlands
http://www.cane.nl
0
Comments
-
To invoice this order, temporarily unassign quantity on charge line that relates to item that wasn't shipped. Then invoice first two lines.
Here is the logic that causes your problem:IF ABS(SalesLine2."Qty. to Assign" + SalesLine2."Qty. Assigned") > ABS(SalesLine2."Qty. to Invoice" + SalesLine2."Quantity Invoiced")
http://www.NaviTools.com
Documentation for Microsoft Navision
E/R diagrams, Workflow diagrams, UML diagrams, process diagrams0
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