Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Order did not transfer...
Microsoft Dynamics GP (Archived)

Order did not transfer to Inv completely

(0) ShareShare
ReportReport
Posted on by MRushing 140

Hello,

I have a users that has completed the process to transfer an order to an invoice. The process appears to have completed correctly, and an invocie number was generated. The order is now in history, however, when a sales document inquiery is ran the Invoice does not appear.

It appears the the process did not finish completely. Is there a way to move the order out of history or re run the transfer to invocie?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Order did not transfer to Inv completely

    Hopefully you have master number tracking turned on. Find the MSTRNMBR value from the original sales order and then run this script.

    select * from SOP10100 where MSTRNMBR = 'xxx'

    select * from SOP10200 where MSTRNMBR = 'xxx'

    select * from SOP30200 where MSTRNMBR = 'xxx'

    select * from SOP30300 where MSTRNMBR = 'xxx'

  • soma Profile Picture
    soma 24,408 on at
    RE: Order did not transfer to Inv completely

    Mahmoud, thanks for the update and corrected as below.

    MRUSHING, run Check Links(Tools-->Maintenance-->Check Links) for Sales History and Work.

    Hope this helps!!!

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Order did not transfer to Inv completely

    There would be no problem at all with choosing all the selection, take a backup just in case.

  • MRushing Profile Picture
    MRushing 140 on at
    RE: Order did not transfer to Inv completely

    When I am in the check links window I have a drop down for Series: with Sales, Purchasing, inventory, etc...

    Under each of those selections ther is a selection for logical tables.

    To run the checklink which Series should I select and what tables from that selection

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Order did not transfer to Inv completely

    keep us updated with the results.

  • MRushing Profile Picture
    MRushing 140 on at
    RE: Order did not transfer to Inv completely

    I have found an artilce at support.microsoft.com/.../en-us

    and running a queery for the invoice number that the users says was shown gives no results

    select * from SOP10100 where SOPNUMBE = 'xxx'

    select * from SOP10200 where SOPNUMBE = 'xxx'

    select * from SOP30200 where SOPNUMBE = 'xxx'

    select * from SOP30300 where SOPNUMBE = 'xxx'

    (sorry for the multiple posts trying to make sure it is replying to your post)

  • MRushing Profile Picture
    MRushing 140 on at
    RE: Order did not transfer to Inv completely

    I have found an artilce at support.microsoft.com/.../en-us

    and running a queery for the invoice number that the users says was shown gives no results

    select * from SOP10100 where SOPNUMBE = 'xxx'
select * from SOP10200 where SOPNUMBE = 'xxx'
select * from SOP30200 where SOPNUMBE = 'xxx'
select * from SOP30300 where SOPNUMBE = 'xxx'

     
     
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Order did not transfer to Inv completely

    I believe there is a bit of typo in here,

    Soma meant to run the check links for sales module not purchasing.

    Your feedback is highly appreciated,

  • Suggested answer
    soma Profile Picture
    soma 24,408 on at
    RE: Order did not transfer to Inv completely

    How did you identify whether the order is not finish completely?

    Anyway, try to run Check Links(Tools-->Maintenance-->Check Links) for Purchasing History and Transactions.

    Hope this helps!!!

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans