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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / issue with closing sal...
Microsoft Dynamics GP (Archived)

issue with closing sales transactions

(0) ShareShare
ReportReport
Posted on by Ebram Ishak 106

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 

*This post is locked for comments

  • LuHao Profile Picture
    LuHao 40,892 on at
    [deleted]
  • Ebram Ishak Profile Picture
    Ebram Ishak 106 on at

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

    Thanks 

  • LuHao Profile Picture
    LuHao 40,892 on at

    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 106 on at

    yes i am using dynamics GP

    Thank you 

  • Tim Wappat Profile Picture
    Tim Wappat 5,721 on at

    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 106 on at

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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans