Tracking documents created from Planning Worksheet

  • Tracking documents created from Planning Worksheet

    Posted by DSC Communities on October 27, 2017 at 6:34 pm
    • David Wheat

      Member

      October 27, 2017 at 6:34 PM

      Hey there NAVUG,Ā 

      We’re wondering if there’s a way to track which documents (specifically Purchase Orders) were created by accepting Action Messages via the Planning Worksheet vs. created manually from scratch.Ā  Anyone know of clever ways to track which way a PO was originally created?Ā 

      ——————————
      David Wheat
      Director of IT
      noosa yoghurt
      Bellvue CO
      ——————————

    • Paul Turner

      Member

      October 30, 2017 at 8:00 AM

      Not a super elegant suggestion but would not require any customization (if this is not possible with standard functionality; I could not find any standard identifier):

      You could check the Allow Manual Numbers option on the purchase orders number series.Ā  When you manually create a PO, use a unique prefix or suffix for the number so it can be identified from those created off of the worksheet.

      ——————————
      Paul Turner
      Liberty Mountain
      Sandy UT
      ——————————
      ——————————————-

    • Val Gameiro

      Member

      October 30, 2017 at 8:28 AM

      I was going to suggest pretty much what Paul said.

      You can have 2 numbering sequences, one for manual orders and one for planning worksheet.

      The planning worksheet would use the default numbers and the manual orders, you’d pick the alternate number series.

      You can also use a Dimension (Department Code, for instance) or even the Description or Description 2 field, because those should get pushed to the actual document.

      Dimension Code would give you visibility at the Chart of Accounts level, whereas the other options would be at the sub-ledgers level.

      ——————————
      Val Gameiro
      Senior NAV Analyst
      BPL Plasma
      Austin, Texas
      ——————————
      ——————————————-

    DSC Communities replied 8 years ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Tracking documents created from Planning Worksheet’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!