Few of the table name changes in ax 2009 to ax 2012

InventSize       : EcoResSize, EcoResProductMasterSize

InventColor    :  EcoResColor, EcoResProductMasterColor

ConfigTable    : EcoResConfiguration,
                         EcoResProductMasterConfiguration,

InventDim (InventColorId, InventSizeId, ConfigIdfields)        : EcoResProductDimensionAttribute


InventDimCombination :  EcoResProductVariantSize ,
                                       EcoResProductVariantColor,
                                       EcoResProductVariantConfiguration

LedgerTable and LedgerTrans table name changes in ax 2012

LedgerTable To MainAccounts in ax 2012

LedgerTrans to General Journal Tables in ax 2012

GeneralJOurnalAccountEntry
GeneralJournalEntry
SubledgerVoucherGeneralJournalEntry
LedgerEntry(Optional)
LedgerEntryJournal(Optional)
LedgerEntryJournalizing(Optional)

Complete select statement
This pattern and example demonstrate how to select the general journal records that replace a single
LedgerTrans record.

Example
select RecId from generalJournalAccountEntry
join RecId from generalJournalEntry
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
join RecId from subledgerVoucherGeneralJournalEntry
where subledgerVoucherGeneralJournalEntry.GeneralJournalEntry ==
generalJournalEntry.RecId
outer join RecId from ledgerEntry
where ledgerEntry.GeneralJournalAccountEntry == generalJournalAccountEntry.RecId
outer join RecId from ledgerEntryJournal
where ledgerEntryJournal.RecId == generalJournalEntry.LedgerEntryJournal
outer join RecId from ledgerEntryJournalizing
where ledgerEntryJournalizing.GeneralJournalAccountEntry ==
generalJournalAccountEntry.RecId

Select for a specific transaction date
This pattern and example demonstrate how to select the general journal records for a specific
transaction date.

Example
select RecId from generalJournalAccountEntry
join RecId from generalJournalEntry
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
&& generalJournalEntry.AccountingDate == <transaction date input>

Select for a specific voucher and transaction date 
This pattern and example demonstrate how to select the general journal records for a specific voucher
and transaction date

Example
select RecId from generalJournalAccountEntry
join RecId from generalJournalEntry
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
join RecId from subledgerVoucherGeneralJournalEntry
where subledgerVoucherGeneralJournalEntry.GeneralJournalEntry ==
generalJournalEntry.RecId
&& subledgerVoucherGeneralJournalEntry.Voucher == <voucher input>
&& subledgerVoucherGeneralJournalEntry.VoucherDataAreaId == <voucher data area ID
input>
&& subledgerVoucherGeneralJournalEntry.AccountingDate == <transaction date input>

Tuesday, 30 July 2013

Trade and Logistics:--Product information management:

Trade and Logistics:

         Trade and logistics including 4 modules

1. Product information management- material ,stock product,Non-stok products(direct orders)

2.procurement and sourcing-purchase orders,vendors,Trade(Purchase) agreements

3.sales and marketing- sales orders, customers, Trade( sales ) Agreements

4.inventory and warehouse management- site, warehouse, location ,pallet, on hand inventory, stock calculation

Ex:

Site-chennai

Warehouse- tnagar,adyar,chrompet,nungambakkam

Diagram:

Site-warehouse-location-aisle-shelf-rack-bin

1.     Product information management:

Path: Pim-setup-dimension group

This module having 3 dimension groups

1.Product Dimension Group

2.Storage Dimension Group

3.Tracking Dimension Group

1.Product Dimension Group:

1.configuration

2.size

3.colour

4.style

2.Storage Dimension Group:

1.site(M)

2.warehouse(M)

3.location

4.palletId

3.Tracking Dimension Group:

1.Batch Number(M)

2.serial number

Products 2 types:

1.      Products- no product dimension group

2.      Product master-product + storage + tracking dimension group

For purchase:

Product receipt-physiacl

Invoice-financial

For sales:

 Packing slip-physical

Invoice-financial

Item delivery:

FIFO- first in first out (date)

FEFO-first expiry first out

Weighted sum- sum of avg of all items of unit price

Witout releasing product, up to it is a general product with doesn’t having any transactions

If we release the product then that product or item having transactions related to financial and physical

When we relaseing the products we can give the company name