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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Adding a message to body of SOP Blank Order Form

(0) ShareShare
ReportReport
Posted on by 2

Dynamics GP 2010

We use Dynamics GP slightly different when it comes to entering orders.  

We create an ORDER for the customer's material and a 2nd ORDER for the order that will be turned into an invoice.  This is so that the customer will receive an invoice that looks identical to the order they send in.

When we create the ORDER for material in the system, we do not include any pricing.  When we create the 2nd order for the billing we use the same ORD# as the first order and add a "B" suffix to it. (ie. ORD95123 will have the material, ORD95123B will be the billing document to match the cusotmer's PO).

My question:

We use the billing document to fax/email as the order acknowledgement.  Currently order processing enters the billing SOP, prints it out and then stamps it with "ORDER ACKNOWLEDGMENT ONLY" and then faxes to the customer.   We would like to be able to just have Dynamics all a comment to be printed when the ORDER has a "B" suffix.

Is this possible?  We are not currently using WORD templates, just the predefined reports.

Thank you,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    L Vail Profile Picture
    65,271 on at

    Hi Pam,

    You could put a conditional calculated field in the header that will only print if the end letter is a B. Do all of your orders have the same number of characters. I would make the font on the calc field big so that it is easy to spot.

    Leslie

  • baxter05 Profile Picture
    2 on at

    Leslie,

    That is exactly what I had in mind but for some reason I couldn't figure out the proper steps.  I am not very good at calculated fields - how would I set this up?

    Thanks in advance for your assistance - and yes, the majority of our order numbers have the same number of characters.

  • Suggested answer
    L Vail Profile Picture
    65,271 on at

    Your conditional field would look like this:

    Conditional Expression:  FUNCTION_SCRIPT(RW_Right SOP_HDR_WORK.SOP Number 1) = “B”

    True Case: “ORDER ACKNOWLEDGMENT ONLY”

    False Case: “”

    You wouldn't type in the " marks, Report Writer will do it for you automatically.

    The User Defined function named RW_Right is in the System Series.

    Let me know if this is what you were looking for.

    Kind regards,

    Leslie

  • baxter05 Profile Picture
    2 on at

    Leslie,

    Thank you for taking the time to answer my question and provide a script.  I will test it out in the morning as our system has just gone down ( and it wasn't me).

    I will let you know how it works.

    Pam

  • baxter05 Profile Picture
    2 on at

    Leslie - it worked and is awesome.

    Thank you again for taking the time to assist me.

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 Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans