check register

(0) Share

Report

Posted on by onetwo

3,285

Hello

i wanted to print some invoices payments on one check so i clicked on summarize per vendor . so it printed on one check. but to follow up what i paid when i go to vendor ledger entries or check ledger it shows the whole amount . my question is how do i know which invoices it paid for. there are no details to show me any of it.

iam also trying to create a report. a simple check register report.

check #, vendor, amount, posting date and vendor invoice number. i cant get the vendor invoice number from the check ledger entries. its not in there. what would i do

thanks

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Community Member on at

Like (0)

Report

Hi,

If you look at the applied entries (Entry -> applied entries) for the payment in the vendor ledger entry - does this give you the details you need?

If so you can follow the code on this form i.e. looking up the vendor ledger entry on the detailed ledger entry and then displaying the corresponding vendor ledger entries.

Hope this helps

Was this reply helpful? Yes No
onetwo 3,285 on at

Like (0)

Report

yes i saw it there . so everytime i need to go to entry applied entries?
what do you mean you can follow the code on this form? what code?
so if i want to print several invoices on one check . i need to click on summarize>?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi
yes i saw it there . so everytime i need to go to entry applied entries?

Yes from what I understand you will process payments for more that one invoice, so unless you create/code a link the only link will be with the vendor ledger entries

what do you mean you can follow the code on this form? what code?

Form 62 - Applied Ledger Entries function FindApplnEntriesDtldtLedgEntry.

so if i want to print several invoices on one check . i need to click on summarize>?

Not sure what you're tring to do - I'm assuming one check for one/many invoices. The normal procedure is to print a remittance advice document.

Was this reply helpful? Yes No
onetwo 3,285 on at

Like (0)

Report

thankyou soo much for putting your time in this. i apologize for not understanding.
all i want to do is print check for vendors with the following option.
on our current system when we print check. if a vendor has multiple invoices it prints on one check.
nav is printing on seperate checks for each invoice. this will cause of wasting 1000sss of checks.
all i want to do is print invoices per vendor on one check , how will i do this. thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Who are you generating the payment - using suggest vendor payments ? If so there is a summerize per Vendor in the options tab.

If not can you explain your process and I'll see if there is a solution.

Was this reply helpful? Yes No
onetwo 3,285 on at

Like (0)

Report

i tried that summarize thing and it worked. but here is the deal.
in my old system. when i go to check register. it shows all the check i printed. and paid with detail of invoices paid.
so for example it shows
vendor ABC check # 1234
invoice 1111    amount $10
invoice 2222    amount $20
invoice 2222    amount $30
check total $60
i cant figure out where to get that info from NAV

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

You can do this in standard Nav but it's a little longwinded.

Go to the check ledger entries and click on Navigate. The click show on the vendor ledger entry. From the ledger entry screen click Entry -> Applied Entries. It takes a few click but the info. you need is there - if the users find this a problem then it can be simplified by codeing on the check ledger entry form but you will find then they will get used to the steps quickly.

Was this reply helpful? Yes No
onetwo 3,285 on at

Like (0)

Report

too many steps. iam going to create a report for check register so i need to figure out how to put this togethor.
nav has soo many nice options but some things i just dont get why its like that. its frustrating

thanks alot for your time. really appreciate it

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

Yes it's not straightforward. You have two options

1. Add a button to the check ledger entry form and add code to find the corresponding Vendor Ledger Entry and then using this record call the Applied Vendot Entry (form 62). This will require access to a development licence

2. As you say develop a report. Use the document reference on the check ledger entry to find the vendor ledger entry. Then find the corresponding record on the detailed vendor ledger entry with type application to show what has been applied.

Gald to help

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

As stated - goto the vendor -> view the ledger entries -> click on which "payment" you want to view. Entires->"Applied Entries"

It's not that bad.

Was this reply helpful? Yes No

Community site session details

check register

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates

Community site session details

check register

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Featured topics

Product updates