Inventory Adjustment Description

Mapping inventory adjustment note to the GL note:

Yet another new issue in Inventory! Here in the Middle East, managers are looking for descriptions for every single transaction, while Inventory Transaction Entry DOES NOT HAVE DESCRIPTION FIELD.

Financial controller is posting GL Transactions that generated by Inventory people, while they are issuing the items by using “Transaction Entry” form –> Adjustment Transaction.

When they create allot of transaction using inventory adjustment form, the financial controller will have a big issue identifying the transaction caused to generate the journal and also the reason of that transaction.

To avoid this miss, I have created a database trigger that links “Transaction Entry” NOTE with the GL Voucher NOTE.

Below is the script I used:

CREATE TRIGGER [UPDATENOTE] ON [dbo].[IV30200]

FOR INSERT, UPDATE

AS

DECLARE @DTAControlNum varchar(500)

DECLARE @JRNENTRY varchar(500)

DECLARE @NOTEINDX varchar(500)

SELECT @DTAControlNum = DOCNUMBR, @NOTEINDX = NOTEINDX From INSERTED

SELECT @JRNENTRY = JRNENTRY From GL10000 WHERE DTAControlNum = @DTAControlNum

UPDATE GL10000 SET NOTEINDX = @NOTEINDX WHERE JRNENTRY = @JRNENTRY

Regards,

Mohammad R. Daoud
MCP, MCBMSP, MCTS, MCBMSS
Software Development Manager
+962 – 79 – 999 65 85
Great Package For Business Solutions
daoudm@greatpbs.com
http://www.greatpbs.com/
http://mohdaoud.blogspot.com/

Advertisements

About Mohammad R. Daoud
Mohammad R. Daoud has been working as a Microsoft Dynamics GP consultant since 2004. His career path started with version 7.5; he studied every single tip of the application technicalities and did allot of successful implementations that includes functional consultations, analysis, and custom development projects. He holds a graduate degree in Computer Science and currently he is pursuing MBA degree in Accounting. In January 2007 he was nominated to the Microsoft Most Valuable Professional (MVP) certificate and was certified in April 2008 due to his online contributions in the Dynamics Community (Dynamics GP Newsgroups, Forums, User Groups and his blog: http://mohdaoud.blogspot.com). Worth to mention that he was also listed as one of the Microsoft Dynamics Top 100 Most Influential People in 2009 by DynamicsWorld. And more... • Demonstrated Passion for MS Products through participating in beta testing for some product versions, an effective member of Microsoft Connect. • Talented in securing strong high quality relationships with premier customers, partners and sales teams passionately and profitably. • Dedicated to meeting the expectations and requirements of internal and/or external customers • Problem Solver – Uses systematic approach to uncover true problem(s) and practical solution and can marshal resources to solve problem! • Proven record of effective account management, including Account Planning, Opportunity Management, and Business Management Excellence and working as part of a larger virtual team • Successful in delivering high quality technical engagements in the enterprise Dynamics GP implementations area according to customer requirements. • Dedicated, Committed, Self Motivated, Creative and highly focused with excellent communication, Negotiation, presentation, Active Listening and Objection Handling skills. • Experienced in Profitable researches and studies including white papers and technical presentations.

3 Responses to Inventory Adjustment Description

  1. web says:

    There is a lot of competition in outsourcing software development, as there are many firms across the globe catering to clients looking for outsourcing their work. What is good is that the takers can choose the best from the lot.< HREF="http://www.infysolutions.com" REL="nofollow"> http://www.infysolutions.com<>.

  2. seo.media says:

    Ecommerce and offshore software development are burgeoning trends these days and several India-based offshore software development companies have gained reputation for offering excellent services to the clientele throughout the world. However, it would be extremely advantageous for you to assign your software development project to one of the popular India-based company because services offered by Indian software companies are cost-effective and flexible that ensure future growth and transparency.http://www.eberrymedia.com

  3. 123 123 says:

    Nice post you got here. I’d like to read more about this topic.
    By the way look at the design I’ve made myself Young escorts

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: