Alfasith AX

Alfasith AX
اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا

Saturday, January 24, 2015

Relation between InventTable & InventDim table in AX 2012

Hi,

static void AlfasithInventDimInventTableRelation(Args _args)
{
    InventTable             InventTable;
    InventDim               InventDim;
    InventDimCombination    InventDimCombination;
    PriceDiscTable          PriceDiscTable;

    while select InventDimId from InventDim where InventDim.InventColorId == " "
                       &&   InventDim.InventStyleId == " "
                       &&   InventDim.configId == " "
                       &&   InventDim.InventSizeId == " "
        {
            select InventDimCombination where InventDimCombination.InventDimId == InventDim.inventDimId
                                        && InventDimCombination.ItemId == "1035";
            if(InventDimCombination)
            {
                print InventDimCombination.ItemId;
                print InventDimCombination.InventDimId;
            }
        }
Pause;
}

Regards,

Wednesday, December 24, 2014

nbtstat commands for windows.

Hi,

MS-DOS utility that displays protocol statistics and current TCP/IP connections using NBT (NetBIOS over TCP/IP), which allow the user to troubleshoot NetBIOS name resolution issues. Normally, name resolution is done when NetBIOS over TCP/IP is functioning correctly. It does this through local cache lookup, WINS or DNS server query or through LMHOSTS or Hosts lookup.
Availability

NBTSTAT [ [-a RemoteName] [-A IP address] [-c] [-n] [-r] [-R] [-RR] [-s] [-S] [interval] ]
-a (adapter status) Lists the remote machine's name table given its name
-A (Adapter status) Lists the remote machine's name table given its IP address.
-c (cache) Lists NBT's cache of remote [machine] names and their IP addresses
-n (names) Lists local NetBIOS names.
-r (resolved) Lists names resolved by broadcast and via WINS
-R (Reload) Purges and reloads the remote cache name table
-S (Sessions) Lists sessions table with the destination IP addresses
-s (sessions) Lists sessions table converting destination IP addresses to computer NETBIOS names.
-RR (ReleaseRefresh) Sends Name Release packets to WINs and then, starts Refresh
RemoteName Remote host machine name.
IP address Dotted decimal representation of the IP address.
interval Redisplays selected statistics, pausing interval seconds between each display. Press Ctrl+C to stop redisplaying statistics.
Examples

nbtstat -A 204.224.150.3

REF : http://www.computerhope.com/

Regards,

SQL code to upate one Legal entity banner to all the legal entity in D365

 Hi, update companyimage set  companyimage.Image  = companyimageA.Image  from  ( select Image from companyimage where dataAreaid = 'USF...