Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Saturday, March 29, 2014

Fiscal Period Setup – SQL Script

 

In this post, SQL Script for the Fiscal Period Setup is provided, you might just need to publish this through Smart List designer to your Dynamics GP and enjoy inquiring your fiscal periods more quickly. The details are shown below;

Untitled

 

Tables Included:

·         SY40100 | Period Setup

 

SELECT  Year1 AS Fiscal_Year ,

        [PERNAME] AS Fiscal_Period ,

        CASE WHEN [PSERIES_1] = 0 THEN 'Yes'

             ELSE 'No'

        END AS Financial ,

        CASE WHEN [PSERIES_2] = 0 THEN 'Yes'

             ELSE 'No'

        END AS Sales ,

        CASE WHEN [PSERIES_3] = 0 THEN 'Yes'

             ELSE 'No'

        END AS Purchasing ,

        CASE WHEN [PSERIES_4] = 0 THEN 'Yes'

             ELSE 'No'

        END AS Inventory ,

        CASE WHEN [PSERIES_5] = 0 THEN 'Yes'

             ELSE 'No'

        END AS Payroll ,

        CASE WHEN [PSERIES_6] = 0 THEN 'Yes'

             ELSE 'No'

        END AS Project

FROM    SY40100

 

Best Regards,
Mahmoud M. AlSaadi

39 comments:

  1. Noodles are Chinese food but become favorite food in all other different areas of the world. Our packaging boxes give the original touch of the food. If you want a Chinese Noodle Box without any delivery charges contact at GoToBoxes.
    Chinese Noodle Box
    Pen Boxes
    French Fry Boxes
    Bath Bomb Packaging
    Pre Roll Packaging

    ReplyDelete
  2. It is an informative article and it would be useful for readers and optimum solution provided in this article.Here i want to show you my business which is about Pillow Boxes.You can customize and print pillow boxes with GoToBoxes easy box. Smoothly modify the dimensions to match your specific requirements. The pillow box form is perfect for transferring exhibition cases, watches, jewelry, and assistants, and further! Pillow Boxes from GoToBoxes lightboxes are the classic product packaging and gift packaging.
    Soap Boxes
    Custom Popcorn Boxes
    Hot Dog Boxes
    custom paper boxes
    Paper Cigarette Boxes

    ReplyDelete
  3. It is an informational article and it would be beneficial for users and the best solution presented in this article. Here I want to show you my business which is about Bath Bomb Packaging. We make high-quality Bath Bomb Packaging Wholesale give quality services to our customers. We do not compromise on our quality rules as compared to our opponents. We also offer free delivery services around the UK.
    Bath Bomb Boxes
    Pre Roll Packaging
    French Fry Boxes
    Noodle Boxes
    Paper Cigarette Boxes

    ReplyDelete
  4. Packaging of anything is the first impression of every brand which it puts on its customers. As we all know the first impression is the last impression so it must be long-lasting in a positive way. While choosing a packaging company for your products, you need a specialist so that your brand’s image does not get ruined, in fact improves a lot. For your Eyeshadow Boxes, you require the help of a specialist so that your brand’s first image does not get spoiled.
    Hair Extension Boxes
    Cream Boxes
    Do not waste your time searching around, select PackagingNinjas for your Custom Boxes.

    ReplyDelete
  5. Make your own particular request by essentially shopping on our site RushPackaging and adding snack items to your truck. You have the adaptability of looking for your #1 brands or for explicit kinds of snak. These containers help in advancing their snack just as a brand with their uniqueness and styles. These Custom Boxes are accessible on the whole custom shapes and measures and can be imprinted as per the tidbit stuffed inside them.RushPackaging is giving Customized snack Boxes taking all things together sizes, shadings, and shapes. We are fabricating discount bundling boxes so to get the best quality printed snack Boxes visit our website.
    Custom Coffee Boxes
    Cereal Box Blank

    ReplyDelete
  6. Hi, You are doing Great I saw your Post I have Offer for all of you pre-rolled-joints-packaging
    We are offering incredibly designed Custom Pillow Boxes with free shipping services. We give wholesale discounts on these amazing sturdy boxes perfect for shipments and order Custom Boxes USA from all over the world.
    pre-rolled-joints-packaging
    Custom t-shirt Boxes
    Custom Boxes USA

    ReplyDelete
  7. RushPackaging provides the best quality packaging in the USA. There are numerous styles of Custom Popcorn Boxes that stay possible in various situations. We like to plan all these Packaging Boxes in appealing styles. Each packaging has its own particular qualities like popcorn cups are helpful and you can without much of a stretch take them with you anyplace. They look praiseworthy in shifted colors with the brand logo. In the film we more often see cardboard paper popcorn boxes bundling. To get Custom Boxes in all various sizes, shapes, and styles visit RushPackaging. We like to assist you with wholesaling bundling boxes.

    ReplyDelete
  8. RushPackaging provides you best quality custom boxes in the USA. we provide you best packaging according to your desire. Get Your Custom Donut Boxes - Wholesale Donut Packaging Boxes with Logo Made in Custom Shapes, sizes, and formats. We offer quality bundling services with free transportation in the whole USA. Being the best provider of bundling with printing, RushPackaging is committed to giving surprising alternatives to envelop your mouth-watering donuts by stunning box pressing. Get the Creative plans you request with a wide range of customizations.Go and Order Custom Boxes according you want with wholesale rate.Don't waste your time visit our website we are one step away to help you.

    ReplyDelete
  9. Enchanting color scheme, vibrant and embellishing designs with elegant graphic designs came in one package and provided the best solution to the eye shadow packaging. Eye Shadow Box with logo is available in various styles such as sleeve packaging for gifting it to your loved ones or window die cut with PVC to display the inside product’s quality and material and making it more attention captivating.

    ReplyDelete
  10. Get aesthetically designed eye makeup box at affordable rates. We are offering huge discounts and insane offers on custom boxes to our valued customers. Truly, eye shadows are a beauty product. Therefore, the packaging of eye shadow must be designed accordingly. Besides, lavish and luxurious designs for eye shadow packaging are available free of cost. Also, you can avail free design support for the colorful eye shadow box. further, we are offering a bundle of designs for personalization. It is purely up to the customer for which option he goes. Moreover, the design of the eye shadow box is available with various printing options.

    ReplyDelete
  11. I think that informational articles should be more like yours. By that I mean they should have character. Your article had character and is persuasive. Your views are very interesting. Custom Burger Boxes

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Soap boxes. We offer aesthetically designed custom Soap boxes at discounted rates. Along with that we are not costing you shipping charges. Avail unbelievable offers at
    Custom Soap Boxes.We will love to collaborate with you.

    Sleeve Boxes
    Shirt Boxes

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Presentation boxes. We offer aesthetically designed custom Presentation boxes at discounted rates. Along with that we are not costing you shipping charges. Avail unbelievable offers at
    Custom Presentation Boxes.We will love to collaborate with you.

    Soap Boxes
    Sleeve Boxes

    ReplyDelete
  16. Many famous brands today have been using the playing card boxes wholesale along with the logo of the playing card boxes
    of their company. These boxes are a smarter approach to promote your brand without investing a heavy budget in advertisements on TV or in newspapers.

    ReplyDelete
  17. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Corrugated Boxes. We offer aesthetically designed custom Corrugated Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Corrugated Boxes.We will love to collaborate with you.

    Window Boxes
    Pencil Boxes
    Gift Boxes

    ReplyDelete
  18. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Bath Bombs Boxes. We offer aesthetically designed custom Bath Bombs Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Bath Bombs Boxes.We will love to collaborate with you.

    corrugated Boxes
    Pencil Boxes
    Gift Boxes

    ReplyDelete
  19. This comment has been removed by the author.

    ReplyDelete
  20. I saw your post you are doing such great work. Now I am telling you about my business.I offered for all of you best Custom Bakery Boxes. There are numerous plans and designs of bakery Boxes that you can choose from Rush Packaging. We offer a free planning and delivery services around the world.
    Popcorn Boxes Wholesale
    Cupcake Boxes Wholesale
    Custom Burger Boxes
    Custom Bakery Boxes

    ReplyDelete
  21. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Cigarette Boxes. We offer aesthetically designed custom Cigarette Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Cigarette Boxes.We will love to collaborate with you.

    corrugated Boxes
    Pencil Boxes
    Gift Boxes

    ReplyDelete
  22. This comment has been removed by the author.

    ReplyDelete
  23. This comment has been removed by the author.

    ReplyDelete
  24. This comment has been removed by the author.

    ReplyDelete
  25. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Pillow Boxes. We offer aesthetically designed custom Pillow Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Pillow Boxes.We will love to collaborate with you.

    Cigarette Boxes
    Bath Bomb Boxes
    Paper Boxes

    ReplyDelete
  26. This comment has been removed by the author.

    ReplyDelete
  27. This comment has been removed by the author.

    ReplyDelete
  28. This comment has been removed by the author.

    ReplyDelete
  29. This comment has been removed by the author.

    ReplyDelete
  30. This comment has been removed by the author.

    ReplyDelete
  31. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Box Sleeves. We offer aesthetically designed custom Box Sleeves at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Box Sleeves.We will love to collaborate with you.

    Custom Pre Roll Boxes
    Bath Bomb Boxes
    Custom Toy Boxes

    ReplyDelete
  32. This comment has been removed by the author.

    ReplyDelete
  33. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Presentation Boxes. We offer aesthetically designed custom Presentation Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Presentation Boxes.We will love to collaborate with you.

    Custom Shirt Boxes
    Bath Bomb Boxes
    Custom Toy Boxes

    ReplyDelete
  34. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Pre Roll Boxes. We offer aesthetically designed Custom Pre Roll Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Pre Roll Boxes.We will love to collaborate with you.

    Custom Shirt Boxes
    Custom Presentation Boxes
    Custom Toy Boxes

    ReplyDelete
  35. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Window Boxes. We offer aesthetically designed Custom Window Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Window Boxes.We will love to collaborate with you.

    Custom Shirt Boxes
    Custom Pencil Box
    Custom Pre Roll Boxes

    ReplyDelete
  36. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Product Box. We offer aesthetically designed Custom Product Box at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Product Box.We will love to collaborate with you.

    Custom Shirt Boxes
    Custom Pencil Box
    Custom Window Boxes

    ReplyDelete
  37. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Bath Bomb Boxes. We offer aesthetically designed Custom Bath Bomb Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers at
    Custom Bath Bomb Boxes.We will love to collaborate with you.

    Custom Shirt Boxes
    Custom Product Box
    Custom Window Boxes

    ReplyDelete
  38. I recently visit your site and read your blog. It is well equipped and perfect. well done! you are dedicated and determined toward your work. let me tell you about my wholesale business of Custom Gift Boxes. We offer aesthetically designed Custom Gift Boxes at discounted rates. Along with that, we are not costing you shipping charges. Avail unbelievable offers atCustom Gift Boxes.We will love to collaborate with you.

    Custom Bath Bomb Boxes
    Custom Product Box
    Custom Window Boxes

    ReplyDelete
  39. Crypto InvestingWhat are cryptocurrencies? How do they work, and what should you know about them before purchasing them? Hello and welcome to today’s post in which I will be taking you through a couple of interesting concepts about

    ReplyDelete