In CustCreditLimit class need to check the salesqty to be not more than as given in custom table

In CustCreditLimit class need to check the salesqty to be not more than as given in custom table:



static void main(Args _args)
{
    INC_Customercredit      customerCredit;
    SalesLine               salesLineQty,salesLinesum;

while select salesLineQty
                group by salesLineQty.ItemGroupId,salesLineQty.CustAccount
                where salesLineQty.SalesId          == salestableloc.SalesId
    {
        select customerCredit
                where customerCredit.CustAccount    == salesLineQty.CustAccount
                &&    customerCredit.ItemGroupId    == salesLineQty.ItemGroupId;

        select sum(SalesQty) from salesLinesum
                where salesLinesum.SalesId          == salestableloc.SalesId
                &&    salesLinesum.ItemGroupId      == salesLineQty.ItemGroupId;

        if(customerCredit.SalesQty < salesLinesum.SalesQty)
        {
            throw error("custom table qty is less.");
        }
       
    }
}

Comments

Post a Comment

Popular posts from this blog

We will follow the following steps in the AX development.

We will follow the following steps in the AX development. 1. Follow the naming convention: - All new objects will start with a prefix ‘INC_ModuleNameofObject’ - Adding a new field to an existing table should be prefixed with ‘INC_ModuleNameofObject’ - Created Extended Data Types for any new fields you create. - Follow the rest of the standard processes for methods, relations, indexes, delete actions. 2. Label file: - Create a new label file or use an existing for your customization. - Label file will have the 1st 3 digits of the Customer Name (Functional consultant can help         to identify the names.) 3. Please maintain a XPO for the customization, we will use it for the deployment.         Please maintain a backup and forward it to me end of the day. 4. The customization will be done on the test environment. It will be tested by the functional consultant         and then by the end user. ...
Read more

Need to provide “ItemId lookup” based on "ItemType" field, which selected while creating SalesOrder

In SalesTable form – Need to provide “ItemId lookup” based on "ItemType" field,  which selected while creating SalesOrder In SalesTable Form -> Datasource -> Salesines -> Fields -> ItemID -> Lookup( )     SysTableLookup          sysTableLookup = SysTableLookup::newParameters(tableNum(InventTable),_formControl);     Query                   query = new Query();     QueryBuildDataSource    queryBuildDataSource = query.addDataSource(tableNum(InventTable));         queryBuildDataSource.addRange(fieldNum(InventTable, ItemType)).value(queryValue(salesTable.ItemType));     sysTableLookup.addLookupfield(fieldNum(InventTable,ItemId));     sysTableLookup.addLookupMethod(tableMethodStr(InventTable,defaultProductName));     sysTableLookup.addLookupMethod(tableMethodStr(InventTable,itemGroupId));   ...
Read more

How to retrieve multiple selected records from Grid using X++

Image
How to retrieve multiple selected records from Grid using X++: In this post, we discuss how we can retrieve all selected(marked) records of a datasource or retrieve marked records form Grid. For this purpose follow the steps listed below. Create a new table named " Student " that contains two string fields i.e. Name & ID. Create a new form and add the newly created "Student" table in the datasource node. Next create a new button on the form, set its multiselect property to " Yes " . Now override the clicked method of the button and add the following code. Code snippet     int             recordsCount;     Student     studentLocal;     super();          recordsCount = student_ds.recordsMarked().lastIndex();  // Total number of marked records.     studentLocal = student_ds.getFirst(1);          while (studentLocal)     {   ...
Read more