Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

issue with closing sales transactions

Posted on by 80

i got  sales transaction lines aren’t allowing me to close/ cancel. – The orders don’t reference a customer, or a user to enter either. When I attempt to open the sales document it notes them as history, but when searching sales transaction inquiry, they’re in the unposted area. any ideas on how to close them please ??

Thanks 

Categories:
  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: issue with closing sales transactions

    can you please let me know how i can remove ORD sale document from SQL ??

  • Tim Wappat Profile Picture
    Tim Wappat 5,701 on at
    RE: issue with closing sales transactions

    I think you are saying that you have a SOP document that is showing in work not history when you search for it or items on it. However when you try to actually go into the order to edit it, the order complains that it is already posted. You are also noting that the header record has missing key fields.

    This happens when a client machine crashes or disconnects after creating an order and lines but before saving the full header record. It is now a corrupted order.

    You may choose another header record and copy the information using SQL from a good header record in to the fields of the bad header record, this will allow you to access the  order in order to delete the items, then void or delete the order.

    I do not recommend processing that order any further as it has been damaged and will be unpredictable.

    Alternatively you can delete the order using SQL but you will need to reconcile your inventory to correct the qtys for the deleted records.

    Tim.

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: issue with closing sales transactions

    yes i am using dynamics GP

    Thank you 

  • LuHao Profile Picture
    LuHao 40,866 on at
    RE: issue with closing sales transactions

    Hi partner,

    Are you using Dynamics GP?

    Please note that forums for different application modules have their corresponding experts, so if it is Dynamics GP I will move this post to the Dynamics GP forum.

  • Ebram Ishak Profile Picture
    Ebram Ishak 80 on at
    RE: issue with closing sales transactions

    what do you mean by which application ? those sales orders are appearing on the smartlist 

    Thanks 

  • LuHao Profile Picture
    LuHao 40,866 on at
    RE: issue with closing sales transactions
    [deleted]

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans