It is said that “no two warehouses are alike” which very well attributes to the nature, type and the sector of the business the warehouse is dealing with.  Warehouse Management Solutions designed through Microsoft Dynamics GP can give customers a way to implement new technology tools to support business growth at a pace and budget their organization is most comfortable with. With the flexibility to purchase products which include only the functions required by their […]

Read More →

  We have always received requests from clients about historical inventory aging report, unfortunately, this report is not available in the system as a standard report, and thus requires customizations. We’ve illustrated in a previous post on GPUG how to calculate the inventory turn over analysis as part of the inventory reporting. On this article, we will dig deeper into the aging report. Such as receivables and payables, aging buckets should be predefined for the […]

Read More →

The following reports retrieve data from the manufacturing order closing file, it illustrates the following details for every single MO per item number: Material Cost Material Fixed Overhead Material Variable Overhead Labor Cost Labor Fixed Overhead Labor Variable Overhead Machine Machine Fixed Overhead Machine Variable Overhead Total MO cost   SELECT ITEMNMBR, DATEPART(yy, COMPLETECLOSEDATE) AS RecYear, DATEPART(mm, COMPLETECLOSEDATE) AS RecMonth, SUM(ENDQTY_I) AS RecQTY, BASEUOFM, SUM(ITEM_COSTS_ARRAY_I_1) AS [Material_Costs], SUM(ITEM_COSTS_ARRAY_I_2) AS [Material_Fixed_Overhead], SUM(ITEM_COSTS_ARRAY_I_3) AS [Material_Variable_Overhead], SUM(ITEM_COSTS_ARRAY_I_4) AS […]

Read More →

In Transit transfer in Dynamics GP is a way to transfer items from one site to another via a specific site, through which landed cost function can be used in order to allocated further cost factors on the transferred items such as freight, shipping cost, packaging costs …etc.   This functionality is quite effective in GP, and it might be used basically when products are shipped from one location to another via a vehicle or […]

Read More →

The apply process in Dynamics GP is different between the receivable and the payable modules when payable transactions are fully applied they are “automatically” moved to history which means that the data is migrated from the open tables into the history tables. On the other hand, this is not the same behavior of the receivable module, in which fully applied documents are not moved to history at all unless a specific routine in the system […]

Read More →

SIROCo is an American multinational technology solution provider focused on rapidly growing areas in today’s knowledge and services economy. Leveraging fully on the strong proprietary technology base, company has three strategic technology verticals – Software Orchestration, Infrastructure Management and Quality Control.


Siroco Corporate Office:

6800 Weiskopf Avenue, Suite 150 McKinney, TX 75070 USA

   (844) 708-0008


Development Innovation Center:

Module 12, Thejeswini Building, Technopark, Karyavattom - 695581 Kerala, INDIA


   +91 80868 00199