Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

Posted on by 5,195

hi 

i am using lot number with expairy date in my inventory module. we are using 'Inventory Transfer' entry to transfer materials to different site from main warehouse. it was working fine but recently some of the transfer entries we cannot post because its showing error "Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot". i checked all line items all are having lot and its selected .

please advice. kindly find the screen shot..

 

transfer-error.jpg

*This post is locked for comments

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,195 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    yes there is no expired item. actually we can post most of the tranfers but only limited we cannot post its seems posting but still it is in unposted batch.

  • Rosemary Profile Picture
    Rosemary 2 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    Good day,

    Can you verify if the expiry date is accurate, just a thought?

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,195 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    yes i did the reconciliation and still my issue is not solving. when i check the lot balance and quantity on hand is accurate. please help me to solve this issue.

  • Tristan Clores Profile Picture
    Tristan Clores 2,812 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    Hi Rafeesh,

    I recommend running Reconcile against the following modules:

    1.  SOP

    2.  POP

    3.  INVENTORY

    Make sure it is in that order.

    Review the reports generated by each process and verify if it has something to do with the item in question.

    It is possible that the item quantity in question is allocated in SOP/POP hence the reason they are giving the error.

    One thing you can also try is delete the current transaction and then re-enter it.  The transaction itself may be corrupted and just needs to be refreshed.

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    you may have to review the posting accounts for the item...

    I have also had success with removing the line item and adding it back in..

  • Irfan.Rasheed Profile Picture
    Irfan.Rasheed 715 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    Hi Refeesh,

    It might be possible that quantities inside that lot might be allocated to somewhere; have you tried to investigate further and find out what kind of transactions are exist on the selected lot?

    Regards.

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,195 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    hi  Sandip Jadhav  & Tami Farrelly

    i did reconcilation and checklinks for inventory module . still the same i cannot able to post such transaction. i am not facing for all posting in inventory transaction. its few entry only.please advice a solution to fix it

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    Hi Refeesh,

    First check enough quantity is available or not.  You can check Inquiry-->Inventory --> Lot. If you expect quantity for specif lot (s) and it showing incorrect then checklink and Reconciliation need to be done.

    Let us know how it goes.

    Thanks Much
    Sandip Jadhav

  • Tami Farrelly Profile Picture
    Tami Farrelly 5,080 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    You can try doing a Inventory Reconcile on the part

    this usually fixes it

    You can open up the Item Inquiry and see where the item is allocated to?

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,195 on at
    RE: Transaction Cannot be posted.line items contains errors.A qty's not avilable to sell for this lot

    kindly advice

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans