Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Receipt to Invoice Report

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

I'm trying to write a report which will show the receipt date and invoice date for all invoices in the system. The end goal is to view receipt compliance as we have an issue where accounts payable are chasing the business to receipt open purchase orders in order for them to process an invoice. Ideally we'd want to have receipts in place before the invoice is received. 

I've tried numerous links and joins in the report but can find anything which works. Can anyone suggest a join or some table information which would help this report. 

Ideally want to see receipt number, receipt date, invoice number, invoice date and be able to analyse this information. 

Thanks in advance,

Bruce

*This post is locked for comments

  • Suggested answer
    guk1964 Profile Picture
    guk1964 10,877 on at
    RE: Receipt to Invoice Report

    Use the invoice register to pre-register invoices when those arrive in the company and record the information (vendor account, invoice number, amount and approval person). For the  receipt date add an extra field to hold it. - (you need to consider whether to add any validation to the date e.g. can it be forward or backward dated e.g. is the vendor allowed to invoice before receipt? .Will there be invoices that arrive on a weekend etc.)

    For report writing that field can also be updated to the invoice screen.

    Maybe to avoid the need for reporting, speed up the invoice approval process- Consider a workflow process for approval, the requestor for approval can be the post room for first step, then you have dates for each step,  you can also consider  an alert, or a cue on registered invoices,  or exception report, or just get AP in the habit of reviewing the register every day.

    You can also attach a notepad file, and update it with date-time stamped remarks e.g received, sent to marketing, approved etc. (just press f5 in Notepad and it does this automatically.

    Maybe start with an old fashioned post room and rubber stamped date. It may be necessary to also note the date on the envelope - I have had more than my share of back dated/late posted  invoices.

    If need  be, then attach scan of that hard copy document in the invoice register.

    Accounts payable > Common > Purchase orders > All purchase orders. On the Action Pane, on the Invoice tab, click Pending invoices. Use this form to view vendor invoices that have been saved and matched to product receipts, but not posted. The invoices have a status of New or Pending. You can open the form from Inventory and warehouse management, Accounts payable, or Fixed assets. Depending on how you open the form, the form name might be Unposted matched invoices - invoice: %1, %2.  When you open the form from the Purchase order form, it displays pending invoices for the selected purchase order. When you open the form from the Vendors form, it displays pending invoices for the selected vendor. If you open the form from the inventory Postings form, then it displays unposted invoices for the selected released product.

    You might also look at the accrued purchases report - that will highlight goods received with no invoice in the system see: https://community.dynamics.com/ax/f/33/t/160979

    In DMO365 the workspace “Vendor invoice entry” gives a Summary section of cues for various unposted invoices. There’s also cues for Documents not invoiced. Product receipts gives a list of all the Product receipts posted. you   filter by: date, invoice account, and Purchase order number.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans