Opening Balances in Dynamics AX

Opening Balances in AX

Wednesday, October 03, 2007

11:42 PM

Inventory:

Journal Name: Movement

Module : Inventory Management

Tables:

InventJournalTrans

InventDim

Open an offset account in Coa and offset all the inventory transactions with
that account so it would not get double when we will load COA opening.

Customer/Vendor/Ledger/Bank:

Journal Type: Daily

Module : GL

Tables:

LedgerJournalTrans

Notes:

For Customer select Account type "Customer"

For Vendor select Account Type "Vendor"

For Bank select Account Type "Bank"

For Coa select Account Type "Ledger"

Open offset account in Coa and offset all transactions with that account so
it would not get double balance when we will load COA opening.

Created with Microsoft Office OneNote 2007
One place for all your notes and information

Accounts Reflection

Accounts Reflection

Sunday, September 23, 2007

6:24 PM

Module : Accounts Receivable

Packing Slip Stage: Item Status= Deducted Order Status= Delivered

Account Name

Dr / Cr

Account Type

Header

Offset Delivered Sales Un-Invoiced

Debit

Asset

FLOATING INVENTORY/

Goods in Transit

Delivered Sales Un-Invoiced

Credit

Asset

FLOATING INVENTORY/

Goods in Transit

Invoice: Order Status: Invoiced

Account Name

Dr/Cr

Account Type

Header

COGS

Debit

P&L

Cost of material

Sales

Credit

P&L

SALES

Trade Receivables

Debit

Asset

ACCOUNTS RECIEVABLE

Offset Delivered Sales Un-Invoiced

Credit

Asset

FLOATING INVENTORY/

Goods in Transit

Delivered Sales Un-Invoiced

Debit

Asset

FLOATING INVENTORY/

Goods in Transit

Inventory

Credit

Asset

CURRENT ASSETS/Warehouse

Module : Accounts Payable

Packing Slip:

Account Name

Dr/ Cr

Account Type

Header

Offset Received Purchased Un-Invoiced

Credit

Asset

FLOATING INVENTORY/

Goods in Transit

Received Purchased Un-Invoiced

Debit

Asset

FLOATING INVENTORY/

Goods in Transit

Invoice:

Account Name

Dr/ Cr

Account Type

Header

Trade payables

Credit

Liability

ACCOUNTS PAYABLE

Offset Received Purchased Un-Invoiced

Debit

Asset

Floating Inventory

Received Purchased Un-Invoiced

Credit

Asset

Floating Inventory

Inventory

Debit

Asset

CURRENT ASSETS/ ware house

Created with Microsoft Office OneNote 2007
One place for all your notes and information

Upgrading Business Portal 3.0 to 4.0

Since Microsoft has launched Microsoft Dynamics GP 10.0 and Business Portal 4.0, up gradation of Business Portal from version 3.0 to 4.0 has been an issue discussion. Questions are being raised that can Business Portal 3.0 be upgraded smoothly and efficiently to version 4.0. While contacting Microsoft the detail we get is like they just try to make us understand that soon Microsoft is launching an upgrade tool for Business Portal. Recently I with my team was engaged in up gradation task for one of our customer from GP9.0 to GP10.0 and BP3.0 to BP 4.0. Customer is extensively using Requisition management and can’t afford to loose and be in critical technical issue while upgrading. After some R&D and team effort we were able to do this and while executing this activity I found some answers which are creating issues in out minds related to Business Portal Up grade.

Is this an Issue? (What actually is the cause?)

To clarify the real problem lets first discuss some technical detail regarding Business Portal.

Business Portal uses following technologies to work

· Share point services

· Dot Net Framework

· IIS

· .NET

· Dynamics GP server database (SQL server)

Usually Share point service’s functionality with Business Portal creates ambiguity in our minds. We always relate issue of Share point services with Business Portal which is not fare. Point to understand is that Share point services is totally separate and independent product and so is Business Portal. Business Portal actually needs WSS platform to run and execute. Similarly Share point up gradation and BP up gradation both are independent. Here I would say once you get Share point at the point where it meets BP’s pre-requisite needs, then BP’s up gradation is as smooth as you update a virus definition in your antivirus software. Isn’t it great?.

What is upgraded and what is not?

Almost all the applications like Requisition management at BP are updated while up grading BP;

· All current data (new created requisitions, Approved Requisitions, Requisitions ready to be converted in PO’s) are up graded as it is. Which is greatJ

· Requisition Hierarchy is upgraded as it is.

· User’s permissions in requisition management are upgraded as it is.

Only thing that doesn’t up grade is Business Portal Security due to lot of changes in Share Point 3.0.

by Ali.jawad@m-consultants.com

Microsoft Dynamics GP Project Accounting Inquiries

Main Page

What a nice and plane sequence for accessing PA on a corporate, contracts,
Projects and Cost category Level!

Corporate Inquiry

Where to use?

Corporate Level estimated Revenue, Profits, Revenue Earned, Total Costs
Incurred, cost of Revenues, GP, Billed to date and Estimated Cost to
Complete

Customer wise estimated Revenue, Profits, Revenue Earned, Total Costs
Incurred, cost of Revenues, GP, Billed to date and Estimated Cost to
Complete

Runtime access of Only posted, only unposted, with either Estimate, open or
Close status....

Customer Inquiry:

Where to use?

Project Information by All contracts

Project information for any customer

Project Information for each contract

(unposted/Posted, with Estimate, open and close status)

Contract Inquiry

Where to use?

Project Information by all customers by all contracts

Project Information for any customer by all contracts

(unposted/Posted, with Estimate, open and close status)

Project Inquiry:

Where to use?

Project Wise detailed status with cost category (unposted/Posted, with
Estimate, open and close status)

Can only see by Timesheet or Equipment or mis log or purchase invoice or
employee expense and inventory

Project Detail Inquiry:

Where to use?

Cost Category by any Project

Cost Category by all projects

For comment and suggestions, please write to farhan.ahmad.cheema@gmail.com