Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Periodic Sales invoice Update summary by Invoice Account, then by delivery note - BUT no grouping of qty for similar item Ids

Posted on by 2,650

Hi All,

Hopefully someone can assist in this.

My company requires an invoice modification made to the periodic sales invoice update process.

They typically require sales invoices to be firstly grouped by Invoice Account - so only 1 invoice per invoice account, per invoice run.

Secondly, they require each transaction to be based on the delivered qty of each sales order line - so the focus in on the delivery note lines.

Out of the box it will do one of two things; create one invoice per account and then group all delivery note lines where the item ID is the same and sum the qty to create one line instead of multiple.  I get this as it reduces the overall number of lines on an invoice and makes sense. However our customers need to see each and every delivery note line as a transaction itself - to be created as a distinct invoice transaction.

The other way, summary by journal (delivery note) - creates one invoice per delivery note - her the qtys are not summarised.

I need a combination of both - whereby the second option - each delivery note line appearing as an invoice line exists - but there is only one invoice created - per invoice account.

I had written a customisation myself, whereby the user would run their select to obtain all delivery note lines within a given timeframe.  Next I would then rearrange by journal (sales delivery note) - this creates one invoice line per delivery note line.

My final stage is a mod I have written which selects loops through the created SalesParmTable records (provisioinal invoice header recs) groups them by invoice account, takes the TableRefId from the first one it finds and then a second select is done to update all salesParmLine records where the invoice account matches that of the salesParmTable.  The TableRefId of each salesParmline is then updated with that of the selected salesParmTable - thereby ensuring that all salesParmLine records are linked to only one salesParmTable record or invoice per invoice account.

The result is exactly what I require, I have checked the records in SalesParmTable and SalesParmLine and all appear fine - however, when I go to post I get a message informing me under the first item code that "The Transaction is already posted."

Can someone please advise me on how I can resolve this or what is the best method?

Thanks

*This post is locked for comments

  • Kauto Profile Picture
    Kauto 2,650 on at
    RE: Periodic Sales invoice Update summary by Invoice Account, then by delivery note - BUT no grouping of qty for similar item Ids

    Hi Andre,

    Yes, when summary update invoice is run, if we take for example 1 sales order which has 1 line - this line is for 1000 of product x.

    We then have 5 deliveries done against this line on different delivery dates so we generate 5 delivery notes of 20 qty each.

    When I run invoicing, I want AX to create 5 invoice trans lines based on the fact I have 5 delivery notes related to the sales order line.  I do not want AX to group the 5 deliveries together in the invoice period give me 1 line for 1000.

    Hope this makes sense

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    RE: Periodic Sales invoice Update summary by Invoice Account, then by delivery note - BUT no grouping of qty for similar item Ids

    Hi,

    Standard AX only summarized packing slips from one single order line as it has a reference to an InventTrans record. So if you have the same item twice on one order or on several orders these will not be summarized to one line.

    In your scenario you want to split every packing slip.

    I'm not aware what exactly you have done. I think the best is to use the debugger to find the transaction that caused the error and try to understand why. Perhaps the same transactions will be updated.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans