[Jacqui Velocci]

Good afternoon.

We are using the prepay function in NAV (2013).  We need a list of all PrePay invoices that do not have an Invoice applied as of our year-end date.  Also, is there a report that shows all open Sales Orders at a previous date, such as year end?  Any report we run now shows only what is currently open

Thank you.

——————————
Jacqui Velocci
Busch Systems International Inc
Barrie ON
——————————

[Amanda Mayer]

Jacqui,

For the customer prepayments, you can do one of two things:

1. Create a filtered list on the Customer Ledger Entries where Description is Prepayment*. This will also let you drill into the transaction if necessary.
2. Run the Customer Register report where Description is Prepayment*.

For the SO report, I’m not sure, but maybe you can provide details why you’d need a point in time report for open SO’s after the fact?

——————————
Amanda Mayer
New View Strategies
Milwaukee WI
——————————
——————————————-

[Jacqui Velocci]

Thank you, Amanda.

We are trying to see what was still open as of year end in prepay status.  Our GL account for Customer Deposits shows the Prepayment invoice in and then it is taken out when the actual invoice is created.  We can’t go through the customers, as the payment closes against the Prepay invoice, so nothing is open. 

We were trying to find an easy way to see what was still in Prepayment status as of our year end date.  We can send the entries to Excel and delete all of the “matching” entries and be left with the remaining.  However, we had over 3000 prepay invoices last year, very time consuming.  our accountants want just the orders still open.

We ended up doing the matching this year, as they needed the data.. just trying to make it easier for next year.   🙂 

Thank you!

——————————
Jacqui Velocci
Busch Systems International Inc
Barrie ON
——————————
——————————————-

[Amanda Mayer]

Jacqui,

While the Customer Register report will show the PrePayment if it hasn’t been applied yet, if you also want to know if it’s been received or not at a point in time, the date filter will not provide that. Once a PrePayment invoice is paid, it will always show a Remaining Amount of $0.

This should get you closer, but I’d suggest running it on the last day of the month or when you are “closed”. You may even run it a couple of times for the auditors. It would reduce the amount of work that you need to do.

——————————
Amanda Mayer
New View Strategies
Milwaukee WI
——————————
——————————————-