Home » Listing Details
Top Websites
  1. Dynamics GP Help
    Over 6300 resources listed.
  2. Mark Polino's DynamicAccounting.net
    Over 5100 resources listed.
  3. Rose Business Solutions Blog New
    Over 2200 resources listed.
  4. Developing for Dynamics GP - By David Musgrave and the MS GP Dev Support Team
    Over 1100 resources listed.
  5. Mariano Gomez at The Dynamics GP Blogster
    Over 1000 resources listed.
  6. Microsoft Dynamics Partner Community Blog
    Over 900 resources listed.
  7. Christina Phillips, Steve Endow & Lorren Zemke at Dynamics GP Land
    Over 700 resources listed.
  8. Mohammad Daoud's Dynamics GP Blog
    Over 600 resources listed.
  9. Vaidy Mohan at Dynamics GP - Learn & Discuss
    Over 500 resources listed.
  10. Inside Microsoft Dynamics GP Official Blog
    Over 500 resources listed.
  11. eOne Business Solutions Blog
    Over 400 resources listed.
  12. About Dynamics, Development and Life
    Over 300 resources listed.
  13. Frank Hamelly at GP2theMax
    Over 300 resources listed.
  14. Dynamics CPM
    Over 300 resources listed.
  15. BKD Dynamics GP Insights Blog
    Over 200 resources listed.
  16. Leslie Vail at Dynamics Confessor Blogspot
    Over 200 resources listed.
  17. Victoria Yudin's Dynamics GP Website
    Over 200 resources listed.
    Victoria Yudin
  18. Janakiram M.P. at DynamicsBlogger
    Over 100 resources listed.
  19. VS Tools Forum
    Over 100 resources listed.
    Your Resource for Visual Studio Tools for Dynamics GP
  20. Inside Microsoft Dynamics GP Official Blog
    Over 100 resources listed.
  21. US Dynamics GP Field Team Blog
    Over 100 resources listed.
  22. Catherine Eibner MBS Developer Evangelist
    Over 100 resources listed.
  23. Sivakumar Venkataraman at Interesting Findings & Knowledge Sharing
    Over 100 resources listed.
  24. Dynamics Small Business
    Over 100 resources listed.
  25. Belinda, The GP CSI
    Over 100 resources listed.

Title:SCM Metrics – I: Back Orders

Some organizations would not just want to use Dynamics GP for their Financial Reporting purposes. They would also want the Dynamics GP to meet their Operational Reporting needs. Among those Operational reporting needs is the most important chunk, Supply Chain Management (SCM). Dynamics GP offers several reporting features to accomplish these needs. One such feature is Smartlist. I’d discuss several SCM metrics in my upcoming posts and I’ll discuss about Back Orders in this post. 

Back orders: Back order can be defined as an unfulfilled customer order. Back orders are created when a SKU(s) whose current inventory level is insufficient to meet the demand. The more the back orders pile up over a period of time, be it in a manufacturing company or a Trading company, implicates that the company is not able to meet the demand on time with its current available inventory. Tracking backorders efficiently ensures an adequate supply of inventory in time equivalent to the current and future demand of the SKU. So, How should we be tracking it in Dynamics GP is the question.

1.Back orders can be tracked by each customer, division and Total company as a whole.
2. Aged Back orders that went past due the Requested Ship Date

This can be easily achieved in Dynamics GP using the Smart list Builder using Sales Transaction Work Table, adding a restriction to return only back orders as well a Calculated field to return days past due from the current date and Requested Ship Date.

If we need to track the back orders by each SKU, their QTY or value, the same smartlist can be built using Sales Transaction Amounts Work Table. I built two sample smartlists for the same that can be downloaded here.

Remember that the the way backorders are tracked vary from company to company. Some companies might just count items that are not confirmed and past the requested delivery date while some companies may also count those items with inventory confirmed, but past due.

Link Owner:
Date Added:June 17, 2010 02:05:34 AM
Number Hits:21
RatingsAverage rating: (0 votes)

No Reviews Yet.


Thank you for your support for GPWindow. It helps us cover part of the hosting costs for GPWindow.