Microsoft,Business,Portal,for, computer Microsoft Business Portal for Dynamics GP custom reporting
----------------------------------------------------------Permission is granted for the below article to forward,reprint, distribute, use for ezine, newsletter, website,offer as free bonus or part of a product for sale as longas no changes a Gone are those times when the companies and the organisations didn't need a hi-tech system to handle them. Owing to the considerable increase in the business sector and thus, an enormous increase in the complexity of the organisational struc
Good example would be the following life cycle of purchase request, which originates in Business Portal Requisition Management module and then, when approved is moved to Purchase Order in Microsoft Dynamics GP purchase order processing module. The reporting tool selection in our opinion is the secondary question both popular tools: Crystal Reports and Microsoft SQL Server Reporting Services (SRS) will do the job as soon as you could trust your view or stored procedure. Lets try to create cross-product query in Requisition Management linking to GP Purchase Order ProcessingReqMgmtDocument table. This table stores all your purchase requests created, submitted and approved in BP Requisition Management module, also you should be aware that this table resides in DYNAMICS database and so it has CompanyID field. You should compare company ID with GP SY01500 table, which also resides in Dynamics database, but it is Microsoft Dexterity table and it is within GP architecture realm.POP tables. In Microsoft Dynamics GP you should know the posting workflow. For the most of transaction types GP is batch processing system, however Purchase Order is an exception it has statuses and PO lifecycle is the change of statuses. However when you receive against purchase orde purchase receipt transaction is batch oriented and you can post either individual transaction (in this case the batch number will be your user id) or the whole butch upon the approval. Tools->Resource Description->Tables in GOP workstation will give you the names of the tables in POP, if you switch series to Purchasing. More likely you will need to research the following tables: POP10100 Purchase Order Work, POP30100 Purchase Order History (it goes to history when all the lines are received), POP10300 Purchase Receipt Work, POP30300 Purchase Receipt HistorySQL View or Stored Procs creation. As you can mention, both products Microsoft Great Plains and Business Portal for GP reside in the same SQL server and even share former Microsoft Great Plains databases: Dynamics and company DB. This makes view or sp creation and easy task, as you dont really need to create something like linked server and pass it as a parameter to the query
Microsoft,Business,Portal,for,