Important Notes for Microsoft Dynamics GP

• All un posted transactions mostly goes to 10000 series table in every module
• All un posted transactions mostly detail/line times goes to 10001 tables
• All posted transactions mostly goes to 20000 series table in every module
• All posted transactions mostly detail/line times goes to 20001 tables
• All history transactions mostly goes to 30000 tables
• 40000 series tables are mostly related to setups
• Two types of posting setups for every module as follows:

• Post to General Ledger (Transactions posted from module reside in GL as un posted Batch)
• Post Through General Ledger (Transactions posted from module also posted in GL)

• If using transaction posting then every transaction goes to GL as un posted regardless of post TO and Through
• Cash Receipts Updated AR Module and GL Module but not updated Bank/Checkbook
• Bank Deposit then update checkbook/bank and have no effect on GL
• One of the method to call Crystal report in GP is through Dexterity/VBA Code
• Through Business Portal we can generate and process Purchase Requisition and then converted into GP as Purchase Order, But in GP 10 we can utilize Work Flows to directly create purchase order and to manage hierarchy and approvals without using Business Portal
• VBA, Modifier, Dexterity and .Net are used for GP Customization
• FRx is Reporting tool that can be utilized for financial reporting
• Financial Reporting are namely (Balance Sheet, P&L, Income Statement, Cash Flow, etc)
• From GP we can use, Smart List, Inquiry and Report for viewing data
• Two types of posting mostly follows in GP:
• Transaction Posting (User who enter transaction can immediately post it and it will reside in GL as un posted regardless of posting setup POST TO or POST THROUGH
• Batch Posting (one users make X No. of transactions in one batch, another user review that batch and then post that batch and in batch posting system take care of POST TO and POST THROUGH
• Debit memo will increase customer balance in Account receivable (mean we have to take more from customer)
• Credit Memo will decrease customer balance in Accounts Receivable (mean we have to take less from customer)
• Credit Memo will decrease supplier/vendor balance in Accounts Payable (Mean we have to pay less to Vendor)
• No Debit memo available in Accounts Payable
• National Accounts are utilized in sale/Accounts receivable as Distributor/Retailer or Parent/child relationship