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,
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.