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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / RESOLVED: The inve...
Microsoft Dynamics AX (Archived)

RESOLVED: The inventory quantity to match for packing slip x item y cannot be reserved.

(0) ShareShare
ReportReport
Posted on by user5555 7,435

Hi,

This issue is resolved. This issues shows how to clean up the purchase update history which is created when a user is matching packingslips during posting invoices. If the connection breaks however or the AOS is shutdown during this process, it may caused a situation in which unmatched packingslip cannot be matched anymore. The do not show up as packingslips open for matching.

It looks like this is caused by the new AX2009 functionality allow you to match different packingslip on different purchase orders and also allows you to invoice on several packingslips or even post partial quantities of an invoice or packingslip. But this hypothesis is not supported by doing some tests.

The short cut to the solution is running 'Accounts Payable --> Periodic --> Clean up --> Purchase update history clean up'. Enter a date and the type of history you want to clean up.

J.

=== 

Hi,

I have a PO with 3 purchase lines. All lines are received and require invoicing. I received 2 separate invoices: 1 invoice matching 1 purchase line. The other invoice matches the other 2 purchase lines and a purchase line of another purchase order.

I try to select Posting -> Invoice . With parameter: Quantity: Packing list I do not see any packing list to select. If I select all I see all 3 purchase lines. I can select a packing slip then (1 left). I get error:

The inventory quantity to match for packing slip x item y cannot be reserved.

Any help appreciated.

J.

*This post is locked for comments

I have the same question (0)
  • spot Profile Picture
    spot 2,515 on at
    Re: The inventory quantity to match for packing slip x item y cannot be reserved.

    Hi while invoicing on the right u get one button packing slips first invoice matching one packing slip and again invoice matching the other two u wull achive your result.

    Regards

  • user5555 Profile Picture
    user5555 7,435 on at
    Re: Re: The inventory quantity to match for packing slip x item y cannot be reserved.

    Hi,

    Thank you for your reply.

    I need to check with the purchase department having this problem. But I think your solution will require 2 invoice numbers to be entered? I have setup that the invoice can only be used once. So using it twice will not be possible. Is this the scenario you describe?

    J.

  • spot Profile Picture
    spot 2,515 on at
    Re: Re: Re: The inventory quantity to match for packing slip x item y cannot be reserved.

    Hi ,

     Yes as the vendors sent invoices separetly the invoices numbers will be diferrent .Any how in my scenario the invoices numberrs cant be same , they shd be different.

    Regards

  • user5555 Profile Picture
    user5555 7,435 on at
    So problem I encounter is still there.

    Ok. That is what I believed. So problem I encounter is still there.

  • spot Profile Picture
    spot 2,515 on at
    Re: So problem I encounter is still there.

    Hi

    Got solution , In AP parameters updates tab there is an option called "check invoice numbers used" if u make it accept duplicates , you can specify single invoice number. Hope this solves u r problem .and Wish you a happy new year

    Regrads

  • user5555 Profile Picture
    user5555 7,435 on at
    MS BUG REPORT: 'Microsoft Dynamics AX Matching invoices to portions of a packing slip'.

    Hi,

    I believe I have found a considerable bug in the new 'Microsoft Dynamics AX Matching invoices to portions of a packing slip'. Does anybody know how to report this or where to look up more problems on it and (hopefully) a work around?

    I want to match an invoice on an packinglist no. 31299177, but if I select the packingslip for matching, it triggers next piece of code, not allowing me to invoice the packing slip.

    Attached the code snippets.

    I really dislike I have to pay for functionality not working except for the pain not being able to work properly. To whom do I have to turn to? Partner or MS?

    J.

    ===

    /// <summary>
    /// Determines whether current record is reserved by a different PurchParmLine exclusive of the provided PurchParmLine.
    /// </summary>
    /// <param name="_excludeRecId">
    /// records beloning to the given redId will be left out of the calculation;
    /// </param>
    /// <returns>
    /// true if current record is reserved by a different PurchParmLine; otherwise, false.
    /// </returns>
    public boolean isReservedbyOtherPurchParmLine(recId _excludeRecId)
    {
        PurchParmSubLine        purchParmSubLine;
        ;

        select firstonly RecId from purchParmSubLine
            where
                purchParmSubLine.JournalRefTableId == this.TableId &&
                purchParmSubLine.JournalRefRecId == this.RecId &&
                purchParmSubLine.LineRefRecId != _excludeRecId;

        if (purchParmSubLine.RecId != 0)
        {
            return true;
        }

        return false;
    }

     

    ==> Getting some data for this problem gives:

    /****** Script for SelectTopNRows command from SSMS ******/

    SELECT [PARMID]

    ,[LINEREFRECID]

    ,[JOURNALREFTABLEID]

    ,[JOURNALREFRECID]

    ,[RECEIVENOW]

    ,[INVENTNOW]

    ,[DOCUMENTID]

    ,[DATAAREAID]

    ,[RECVERSION]

    ,[RECID]

    FROM [V4A_DYNAMICSAX_2009_TEST].[dbo].[PURCHPARMSUBLINE]

    where JOURNALREFTABLEID = 501

    and

    (

    JOURNALREFRECID in (5637162149, 5637160906, 5637148582)

    or

    RECID in (5637162149, 5637160906, 5637148582)

    )

    or DOCUMENTID = '0031299177'

     

    -->

    PARMID LINEREFRECID JOURNALREFTABLEID JOURNALREFRECID RECEIVENOW INVENTNOW DOCUMENTID DATAAREAID RECVERSION RECID

    SID0015827 5637160906 501 5637147339 1.000000000000 1.000000000000 0031299177 bzo 1 5637148582

     

    --audit trail: 5637181587

    --> The packing slip is posted, but the invoice cannot?

    --DOCUMENTID = '0031299177' is the document no of the packing slip.

    --Can I remove this line in [PURCHPARMSUBLINE] to allow invoice posting?

  • user5555 Profile Picture
    user5555 7,435 on at
    Re: MS BUG REPORT: 'Microsoft Dynamics AX Matching invoices to portions of a packing slip'.

    Hi,

    This is the case/ bug report in functional point of view. My supplier uses SAP R/3.

    Concerns: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=e50fac2f-d69f-4659-9c18-f008183c2419

    PO  ItemNo PackingSlip InvoiceNo

    po1 itemno1 ps1 invoice1
    po2 itemno2 ps1 invoice2
    po2 itemno3 ps1 invoice2
    po2 itemno4 ps2 invoice2

    So dataflow:
    po1 --> ps1, invoice1
    po2 --> (ps1,ps2), (invoice1, invoice2)

    Any help is appreciated.

    J.

  • user5555 Profile Picture
    user5555 7,435 on at
    *** UNCONFIRMED WORK AROUND ***: MS BUG REPORT: 'Microsoft Dynamics AX Matching invoices to portions of a packing slip'.

    *** THIS SOLUTION IS UNCONFIRMED. DO NOT USE IN PRODUCTION *** 

    Hi,

    I have done next in my test database/ setup.

    1. Look up any related data based on parmid
    2. delete PURCHPARMSUBLINE where PARMID = 'sid0015827'
    3. Now the matching details on invoice posting show correctly 2 packing slips. I deselect the one of p21 of po2.
    4. Then I check matching details and invoice matches the amount of the po1.
    5. Now I can post my invoice without any problems.

    Can a developer of MS Dynamics AX 2009 confirm this bug and the solution I put forward here?

    Thank you.

    J.

     

     

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 299,327 Super User 2025 Season 2 on at
    Re: *** UNCONFIRMED WORK AROUND ***: MS BUG REPORT: 'Microsoft Dynamics AX Matching invoices to portions of a packing slip'.

    Hi

    With your information I dont know for sure if you encountered a bug. We did not have any problems with partial invoicing. In the past (v3.0) I had a similar problem when trying to post an invoice on a purchase order which was linked to a project. It turned out to be a bug in some tailor made software for the master planning.

    regards,

    André

  • user5555 Profile Picture
    user5555 7,435 on at
    Re: Re: *** UNCONFIRMED WORK AROUND ***: MS BUG REPORT: 'Microsoft Dynamics AX Matching invoices to portions of a packing slip'.

    Hi Andre,

    As far as I know there is no tailor made software:

    Do you know where *sub tables are used for? There are a lot of records in it. Can you have a look at your table?

    PO  ItemNo PackingSlip InvoiceNo

    po1 itemno1 ps1 invoice1
    po2 itemno2 ps1 invoice2
    po2 itemno3 ps1 invoice2
    po2 itemno4 ps2 invoice2

    So dataflow:
    po1 --> ps1, invoice1
    po2 --> (ps1,ps2), (invoice1, invoice2)

    I saw the product suggestion / bug report is not there, only for 299 euro to get assistance in 4 hrs.

    J.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans