Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Wiser]

We are looking to use the prepayment functionality for customer prepayments, but would like to exclude the prepayment from the Aged A/R report.  What is the best way to do this?  We don’t want the prepayments to dilute the real receivables.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————

[Jacqui Velocci]

When we use the Prepay function, the Prepayment does not show up on the AR aged report, as it is linked to a Prepay Invoice, created from the Sales Order, so there are no open transactions on the customer account. 

If you are not using the Prepay Invoice function, I am not sure how to avoid the Prepays showing up.  Maybe through a filter for the report?  You can choose Payment Terms as a filter, so maybe that would work?

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

[Kathy Jones]

Can you give detailed instructions on how to use the Prepay Invoice Function, I have been trying to figure this out also because ours also shows up on the aging.

——————————
Kathy Jones
McClancy
Fort Mill SC
——————————
——————————————-

[Eduardo Diaz]

HI Dave,

 

We added an option on the Customer Statement report to show or hide all Prepayment invoices. I think it uses the “Prepayment” field to filter the table. You can try something similar.

 

 

Cheers,

 

EDUARDO M. DIAZ | IT DIRECTOR

Direct:  +1 305.925.4007 Office:  +1 305.925.4000 E-Mail:  ediaz@minequip.com http://www.minequip.com

 

 

——Original Message——

We are looking to use the prepayment functionality for customer prepayments, but would like to exclude the prepayment from the Aged A/R report.  What is the best way to do this?  We don’t want the prepayments to dilute the real receivables.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————

[Sophia Gjorgievska]

Hi Dave,

A workaround could be to check the “Print to Excel” field on the report and send it to Excel.  Then in Excel filter out the prepayment invoices in the  “Document No.” column. This assumes that you would use a different “No. Series” to post the prepayment invoices.

——————————
Sophia Gjorgievska
Senior Consultant
Socius
Brecksville OH
——————————
——————————————-