i purchase order with multiple items

suri
Member Posts: 123
q ) report which will create 1 purchase order for a vendor with multiple items
hi one and all
i have the question as shown above
i have two data items
purchase header
purchase line
processing only=yes
i have written the code in purchase header onafter the get record()
paysetup.GET;
IF "Purchase Header".FINDLAST THEN
"Purchase Header".INIT;
"Purchase Header"."No." :=nserie.GetNextNo(paysetup."Vendor Nos.",0D,TRUE);
"Purchase Header"."Document Type" :="Purchase Header"."Document Type"::Invoice;
"Purchase Header"."No." :=nserie.GetNextNo(paysetup."Order Nos.",0D,TRUE);
"Purchase Header"."Document Type" :="Purchase Header"."Document Type"::Order;
"Purchase Header"."Document Type" :="Purchase Header"."Document Type"::Quote;
"Purchase Header"."Buy-from Vendor No.":='189';
"Purchase Header".INSERT;
here it was throwing error,can any one suggest me the correct method.can any one can give better solution.
error: you cannot assign number greater then 106999 from the number series p-ord
thank you
hi one and all
i have the question as shown above
i have two data items
purchase header
purchase line
processing only=yes
i have written the code in purchase header onafter the get record()
paysetup.GET;
IF "Purchase Header".FINDLAST THEN
"Purchase Header".INIT;
"Purchase Header"."No." :=nserie.GetNextNo(paysetup."Vendor Nos.",0D,TRUE);
"Purchase Header"."Document Type" :="Purchase Header"."Document Type"::Invoice;
"Purchase Header"."No." :=nserie.GetNextNo(paysetup."Order Nos.",0D,TRUE);
"Purchase Header"."Document Type" :="Purchase Header"."Document Type"::Order;
"Purchase Header"."Document Type" :="Purchase Header"."Document Type"::Quote;
"Purchase Header"."Buy-from Vendor No.":='189';
"Purchase Header".INSERT;
here it was throwing error,can any one suggest me the correct method.can any one can give better solution.
error: you cannot assign number greater then 106999 from the number series p-ord
thank you
0
Comments
-
Its hard to find the the link between your requirement & your codes... You need a Purchase order with multiple lines and what should the line contain?0
-
thanks for giving reply
can any can give some suggestion,how can i solve this question
thank you0 -
Sorry but I am not able to understand your requirement at all :shock:0
-
thank you...
this is my actual requirement
1 . report which will create 1 purchase order for a vendor with multiple items0 -
You need to create 1 Purchase Header only but you are creating unlimited purchase headers in your report which you dont know.
No need to take any dataitems in report
You can write code ijn OnPrereport.
Create only 1 Purchase header.
Create Purchase Line with 1 Item first. If it is working then You can think of creating multiple lines..0
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