payment journal computer check sort order

john_bellinger
Member Posts: 34
I'm working in 4.0 -
Out of the box computer checks print in account no. order. Has anyone ever changed order so that it is by vendor name? If so, how?
Out of the box computer checks print in account no. order. Has anyone ever changed order so that it is by vendor name? If so, how?
John Bellinger
ERP Manager
Activar, Inc.
ERP Manager
Activar, Inc.
0
Comments
-
You could add a key to the Gen Journal Line for "Description" (if it's not there already)
& then re-sort the line before you print the checks
- just a thought0 -
Please disregard - I found a solution.John Bellinger
ERP Manager
Activar, Inc.0 -
-
here is what i did:
Table: 372 Payment Buffer
- New field added called “Vendor Name”
- New Key “Vendor Name”
Report 393 “Suggest Vendor Payments”
- Add the following highlighted bold code in “MakeGenJnlLines” function
*****************************************************************************************************
IF PayableVendLedgEntry.FIND('-') THEN
REPEAT
PayableVendLedgEntry.SETRANGE("Vendor No.",PayableVendLedgEntry."Vendor No.");
PayableVendLedgEntry.FIND('-');
REPEAT
VendLedgEntry.GET(PayableVendLedgEntry."Vendor Ledg. Entry No.");
TempPaymentBuffer."Vendor No." := VendLedgEntry."Vendor No.";
TempPaymentBuffer."Currency Code" := VendLedgEntry."Currency Code";
//>>001
CLEAR(Vendor2);
IF Vendor2.GET(VendLedgEntry."Vendor No.") THEN
TempPaymentBuffer."Vendor Name" := Vendor2.Name;
//<<001
IF SummarizePerDim THEN BEGIN
TempDimBuf.RESET;
TempDimBuf.DELETEALL;
IF SelectedDim.FIND('-') THEN
REPEAT
*******************************************************************************************
//Also add this in the same function
CLEAR(OldTempPaymentBuffer);
//>>001
//TempPaymentBuffer.SETCURRENTKEY("Document No.");
TempPaymentBuffer.SETCURRENTKEY("Vendor Name”);
//<<001
IF TempPaymentBuffer.FIND('-') THEN
REPEAT
WITH GenJnlLine DO BEGIN
INIT;
Window.UPDATE(1,TempPaymentBuffer."Vendor No.");
LastLineNo := LastLineNo + 10000;
"Line No." := LastLineNo;
VALIDATE("Posting Date",PostingDate);
"Document Type" := "Document Type"::Payment;
"Posting No. Series" := GenJnlBatch."Posting No. Series";
IF SummarizePerVend THEN
"Document No." := TempPaymentBuffer."Document No."
ELSE
IF DocNoPerLine THEN BEGIN
IF TempPaymentBuffer.Amount < 0 THEN
"Document Type" := "Document Type"::Refund;John Bellinger
ERP Manager
Activar, Inc.0 -
Savatage wrote:You could add a key to the Gen Journal Line for "Description" (if it's not there already)
& then re-sort the line before you print the checks
- just a thought
This works too0
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