6
Use Business Central 14.3 SaaS Version
Go to Payment Journal and create 4 transactions as below
POSTING DATE DOCUMENT TYPE DOCUMENT NO. EXTERNAL DOCUMENT NO. ACCOUNT TYPE ACCOUNT NO. EFT BANK ACCOUNT NO. RECIPIENT BANK ACCOUNT MESSAGE TO RECIPIENT DESCRIPTION CURRENCY CODE PAYMENT METHOD CODE PAYMENT REFERENCE CREDITOR NO. AMOUNT AMOUNT (LCY) VENDOR EXCHANGE RATE (ACY) BAL. ACCOUNT TYPE BAL. ACCOUNT NO. APPLIED (YES/NO) APPLIES-TO DOC. TYPE APPLIES-TO DOC. NO. APPLIES-TO DOC. DUE DATE BANK PAYMENT TYPE CORRECTION EXPORTED TO PAYMENT FILE TOTAL EXPORTED AMOUNT HAS PAYMENT EXPORT ERROR EFT REGISTER NO. DEPARTMENT CODE CUSTOMERGROUP CODE
4/1/2019 Payment G04001 ED01 Vendor 10000 Fabrikam, Inc. 10,000.00 10,000.00 0 G/L Account 2910 Yes Invoice 108218 1/1/2018 No No 0.00 No 0
4/1/2019 Payment G04002 ED02 Vendor 20000 First Up Consultants 20,000.00 20,000.00 0 G/L Account 2910 Yes Invoice 108219 1/1/2018 No No 0.00 No 0
4/1/2019 Payment G04003 ED03 Vendor 30000 Graphic Design Institute 30,000.00 30,000.00 0 G/L Account 2910 Yes Invoice 108213 1/1/2018 No No 0.00 No 0
4/1/2019 Payment G04004 ED04 Vendor 10000 Fabrikam, Inc. 40,000.00 40,000.00 0 G/L Account 2910 Yes Invoice 108218 1/1/2018 No No 0.00 No 0
Click on Actions --> Posting --> vendor Prepayment Journal
Click Preview
Expected Results
Document lines should be sorted based on Vendor --> Document No--> Applied Invoice
Actual Results
Document lines in the report are sorted by Document No, Line No.
Business Case
In the Above case, There are 4 lines created
Although, Line 2 and Line 3 are for Different vendors, Line 1 and Line 4 are for Vendor 10000
Expectation from the Partner is that, When two lines are from Same Vendor, They should be shown under the same Vendor Head.
Go to Payment Journal and create 4 transactions as below
POSTING DATE DOCUMENT TYPE DOCUMENT NO. EXTERNAL DOCUMENT NO. ACCOUNT TYPE ACCOUNT NO. EFT BANK ACCOUNT NO. RECIPIENT BANK ACCOUNT MESSAGE TO RECIPIENT DESCRIPTION CURRENCY CODE PAYMENT METHOD CODE PAYMENT REFERENCE CREDITOR NO. AMOUNT AMOUNT (LCY) VENDOR EXCHANGE RATE (ACY) BAL. ACCOUNT TYPE BAL. ACCOUNT NO. APPLIED (YES/NO) APPLIES-TO DOC. TYPE APPLIES-TO DOC. NO. APPLIES-TO DOC. DUE DATE BANK PAYMENT TYPE CORRECTION EXPORTED TO PAYMENT FILE TOTAL EXPORTED AMOUNT HAS PAYMENT EXPORT ERROR EFT REGISTER NO. DEPARTMENT CODE CUSTOMERGROUP CODE
4/1/2019 Payment G04001 ED01 Vendor 10000 Fabrikam, Inc. 10,000.00 10,000.00 0 G/L Account 2910 Yes Invoice 108218 1/1/2018 No No 0.00 No 0
4/1/2019 Payment G04002 ED02 Vendor 20000 First Up Consultants 20,000.00 20,000.00 0 G/L Account 2910 Yes Invoice 108219 1/1/2018 No No 0.00 No 0
4/1/2019 Payment G04003 ED03 Vendor 30000 Graphic Design Institute 30,000.00 30,000.00 0 G/L Account 2910 Yes Invoice 108213 1/1/2018 No No 0.00 No 0
4/1/2019 Payment G04004 ED04 Vendor 10000 Fabrikam, Inc. 40,000.00 40,000.00 0 G/L Account 2910 Yes Invoice 108218 1/1/2018 No No 0.00 No 0
Click on Actions --> Posting --> vendor Prepayment Journal
Click Preview
Expected Results
Document lines should be sorted based on Vendor --> Document No--> Applied Invoice
Actual Results
Document lines in the report are sorted by Document No, Line No.
Business Case
In the Above case, There are 4 lines created
Although, Line 2 and Line 3 are for Different vendors, Line 1 and Line 4 are for Vendor 10000
Expectation from the Partner is that, When two lines are from Same Vendor, They should be shown under the same Vendor Head.
STATUS DETAILS
Needs Votes
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team