Tuesday, August 25, 2009

Inventory Batch Entry and Post to GL Check Box option

When batch is created in Inventory (Transaction-->Inventory-->Batches) user must check mark the option “Post to General Ledger” if user forget to mark check box the Journal Entry will not create in General Journal .

It’s usually possible that user forget / ignore to mark check option, is it possible to make the default check marked on “Post to General Ledger” check box ?

It is through the one line VBA code.

Steps :

1) Open the Inventory Batch Entry (Transaction --> Inventory --> Batches)
2) Add the Inventory Batch Entry screen to Visual Basic ( Tools-->Customize-->Add Current Window to Visual Basic)
3) Goto Tools--> Customize--> Add Fields to Visual Basic and click on Post to General Ledger Check Box.
4) Goto Tools-->Customize-->Visual Basic editor to do the coding
5) Select the “InventoryBatchEntry(Window) from Project explore (Microsoft_Dynamics_GP --> Microsoft Dynamics GP Objects --> InventoryBatchEntry(Window)
6) And on “ Window_AfterActivate” event add the following code

PosttoGeneralLedger.Value = 1

Your code should look like below screen :

If it’s difficult for you to do the VBA modification please do not hesitate to mail me for above customization file.

Sunday, August 23, 2009

Post To General Ledger and Post Through General Ledger

Post to General Ledger and Post Through General Ledger what is difference and which option should I used for my organisation ?

In Posting setup (Tools-->setup-->Posting-->Posting) Dynamics GP have two posting option for each series. When transaction are posted in subsidiary modules, the information should also update General Ledger accounts. How and when this information flow to General Ledger is defined in Posting setup window.

Post To General Ledger :

When Post To General Ledger is selected and Post Through General Ledger is not select and any transaction is posted from Subsidiary module it will create the Journal Entry in General Ledger. Transaction can be edited using General Ledger’s Transaction Entry window before posting permanent to General Ledger.

Post Through General Ledger :
When transaction posted from subsidiary module , instead of creating Journal Entry into General Ledger system will automatically update the General Ledger A/c. User can ‘t verify / Edit the GL Transaction using General Ledger Transaction Entry window as already GL A/c is updated.

Its depend upon the organization which Posting Option they need.

Hint: Even though if you activate the “Post Through General Ledger” option and if you post the Transaction without creating Batch i.e. Transaction Level Posting it will create the GL Batch into General Ledger. To directly hit the General Ledger A/c user must do the Batch Posting from subsidiary module

Hint : When entering Beginning Balance in Subsidiary Modules, the "PostTo General Ledger" option can be cleared. Make sure to reselect option before starting entering your regular transactions.

Hint : Another option is available when entering beginning balances to leave “Post to General Ledger” selected, do not select “Post through General Ledger” option and Delete the Batches created in General Ledger that contain the Beginning Balances.

How to email Dynamics GP Invoice/Report

Instead of printing the invoice , Statement of Account how can I directly email it to my customer ? Or is it possible to mail any report as attachment ?

When you print your report --> Print on screen --> Click on Sent To Button . You will find two option Mail Recipient (Text) i.e. Emailing txt attachment and another one is Mail Recipient (PDF) enclosed the report in PDF format.

For better result select PDF format Mail Recipient , make sure you have Adobe Acrobat PDF writer installed in GP client computer otherwise the Mail Receipent (PDF) format option is disable.

Thursday, August 20, 2009

Subsidary Module posting total of GL Distribution is not matching with GL Batch Total

One day user called GL Distribution total mismatch - when they posted the Batch from Subsidiary (Receivable Transaction Batch) Module posting total of GL Distribution is not matching with GL Batch.

$ 1563 is your Receivable Transaction total, Once you post the Batch and Print Distribution Breakdown Register-Detailed or SummaryDetail Report

Detail Register :

Summary :

GL Batch -

The GL Summary /Detail Grand Total are not matched with GL Batch total why ??? The GL Batch Total show $3214.2.60 its really confuse the end user.

There is way to quick verify - you need to divide the GL Batch Total by 2 and your Subsidiary GL Distribution Total will match with GL Batch Total. ($3214.20/2= $1607.10).
Another way you need to post the GL Batch and verify the Individual GL A/c total with your subsidiary GL Breakdown summary total.