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

Notifications

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) / SOP implementation pla...
Microsoft Dynamics GP (Archived)

SOP implementation planning

(0) ShareShare
ReportReport
Posted on by Davinder Singh 165

Hi,

This is my first post here- please be gentle :-).

We are trying to implement SOP. One of the requirements is to track order cancellations. So, we get an order that is recorded as such and counts against Gross Orders. If and when that order is cancelled (will not be a part cancellation but a full cancellation), we would like to be able to deduct the order value to arrive at Net Orders. I tried saving an order with a negative total but SOP would not save anything with a negative total "You cannot save or post a document with a negative total". Is there any other way we can record an order cancellation and be able to report against that? Any thoughts and pointers welcome !

Just to add- all our items are non-inventory.

 

 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    There are at least two ways to do this.

    1) Void the order. This will leave the line detail intact and you could sum up the quanties on voided orders

    2) Cancel the quantities ordered on each line.\

    So now it becomes simply a question of which quantities on the lines you need to add into the aggregate total.

    You will pull this detail from a union of the SOP10200 and SOP30300 tables.

    Cancelling the lines allows you to do partials as opped to voiding the order whioch voids the entire order.

    Since your items are non-inventory you will not have to worry about stock quantities.

  • Davinder Singh Profile Picture
    Davinder Singh 165 on at

    Thanks Richard. Voiding the Order makes sense and will work for future cancellations. As Void date will be the current user date- it will not allow for adding historical cancelations. Any thoughts ?

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    What do you mean by historical cancellations? The unique key will be SOPNUMBE and SOPTYPE. So you can void all the sales orders you want on any given day and they will all go into history.

  • Davinder Singh Profile Picture
    Davinder Singh 165 on at

    I should have explained better. Apologies.

    What we are trying to do is to bring in data from previous years so that we can compare Gross vs Net Orders with past data. So, if there was an order received in June 2011, but cancelled in September 2011, voiding it now will not allow for storing the date of September 2011. It wil show us as voided in feb 2013. Unless there is an Integration that will update Void date to September 2011.......just thinking our loud.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,850 Moderator on at

    One possibility I see here is to change the GP system data prior to voiding. If you do the field called SOP30200.GLPOSTDT will have that date not today's date.

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans