News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Sales and Prepayment I...

Microsoft Dynamics NAV (Archived)

Sales and Prepayment Invoice Report

(0) Share

Report

Report

Posted on by Community Member

I have setup separate GL accounts for Sales Prepayment invoices.

Sales Prepayment-

when prepayment invoice is done from SO :Debits AR a/c and Credit -Sales Prepayment a/c

when customer pays: Debit-Bank and Credit -AR

when invoicing-Debit-Sales Prepayment account and Credit-Sales a/c

My question is : I need a report on all OPEN prepayment Sales invoices which will tie up with the GL balance- How Do I get??

Note-cannot get the summary report of open SO with Status "Pending Prepayment" as this can be "Reopen" ed, thus upsetting the report

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Sales and Prepayment Invoice Report

Raga1,

Open, meaning unpaid, you can add the field Prepayment Invoice to the Posted Sales Invoice list and filter on Open = YES and Prepayment Invoice = YES.

Hope this helps.

Thanks,

Steve
qjwlq 219 on at

Like (0)

Report

RE: Sales and Prepayment Invoice Report

Yes, we have the same question.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,403 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans