web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Batch processing invoices without custom coding?

(0) ShareShare
ReportReport
Posted on by

Hello!

I'll preface this question by stating I'm an AX admin, not a developer.  This may be a very 'simple' question, and if so, I apologize.

We are on AX 2012 R2, and I've been asked by my boss to explore whether we can use a batch process to convert our sales orders to invoices and send them out... with a caveat or two.  It's the caveat that is tripping me up.

We require manual review of each sales order to ensure that it is actually ready for invoicing--we cannot simply assume that because an order has shipped, it can be invoiced.  The process, as it is envisioned, would look something like this:

Day 1 - an completed order is shipped out.  The associated paperwork is given to the AP clerk at the end of day 1.

Day 2 - AP reviews the order and decides if it is ok to invoice.  If it is ok to invoice, the order is manually added to the batch.

Evening of Day 2 - all invoices from Day 1 that were ok'd for invoicing are processed via batch.  Invoices are emailed or printed according to each individual customer's setup parameters.  The invoices should go out with Day 1's date (the net terms start from the date of the shipment, not the date of the invoicing).

Is this possible with out of the box configurations, or will this require a developer?  My initial readings show that you can use filters to select specific orders for processing, or that you can select a range of order numbers, but I haven't yet found documentation on manually selecting orders for invoicing and adding them to a batch process.

Thank you for your time.

sm

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Guy Terry Profile Picture
    28,924 Moderator on at

    Hi smilner1971,

    The review part is not too hard. Simply pick a field on the Sales order header that you're not using, and get the reviewer to set this field after they have OK'd the order. Then, on the Batch job, use the 'Select' to select only those sales orders where this field has been set that it is OK to invoice.

    The date part I am struggling with. I think the invoice date for invoices created in batch will always be the date that they were created. If you were creating the invoices manually, you'd have the chance to enter the date, or change your session date. I don't think either of these things will be possible if a batch job is posting the invoices.

  • Community Member Profile Picture
    on at

    Thanks for the thoughts, Guy!

    I'll work though this in our TEST environment and see if it will work for the accounting group. 

    I really appreciate the help!

    Scott

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans