Monday 24 March 2014

Creating Default dimension to Customer /Vendor using Job

User below code to assign default Dimension to Customer/Vendor
static void setDefaultDimensionToCustomer(Args _args)
{
    CustTable custTable;
    VendTable vendTable;
    Struct struct = new Struct();
    container ledgerDimension;
    DimensionDefault DimensionDefault;
    ;
 

    while  select forUpdate vendTable
    {
        struct.remove("Vendor");
        ledgerDimension= conNull();
        struct.add('Vendor', vendTable.AccountNum);  
        //struct.add('Kostenstellen', '00200');
        ledgerDimension += struct.fields();
        ledgerDimension += struct.fieldName(1);
        ledgerDimension += struct.valueIndex(1);
        //ledgerDimension += struct.fieldName(2);
        //ledgerDimension += struct.valueIndex(2);


        ttsBegin;
        DimensionDefault = AxdDimensionUtil::getDimensionAttributeValueSetId(ledgerDimension);
        //vendTable = CustTable::find("22027", true);
        vendTable.DefaultDimension = DimensionDefault;
        vendTable.update();
        ttsCommit;
    }
    info("Done");

No comments:

Post a Comment