Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SOP implementation planning

    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.

  • Davinder Singh Profile Picture
    Davinder Singh 165 on at
    RE: SOP implementation planning

    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,730 on at
    RE: SOP implementation planning

    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
    RE: SOP implementation planning

    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 ?

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SOP implementation planning

    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.

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