Showing posts with label INVENTTABLE. Show all posts
Showing posts with label INVENTTABLE. Show all posts

Monday, 7 December 2020

overdelivery underdelivery in transfer order Dynamics 365 AX

overdelivery or underdelivery on transfer order lines

When you update a picking list registration, the item quantity must match the quantity that is registered in the Transfer quantity field on the transfer order line. To deliver a quantity that differs from the quantity given on the transfer order line, you must enable a percentage of overdelivery or underdelivery for the product. The overdelivery and underdelivery settings can be enabled directly on the product or they can be enabled for individual transfer order lines: Mcrosoft Dynamics AX 2012

Enable overdeliver and underdelivery

The overdelivery and underdelivery percentage can be enabled directly on the product or it can be enabled for individual transfer order lines:

  • Enabled on the product – Click Product information management > Common > Released products. Select a product and then click Edit on the Action Pane. Then, on the Sell FastTab, enter a percentage in the Overdelivery and Underdelivery fields. The percentages of overdelivery and underdelivery that are specified are inherited by the transfer order line.
  • Enabled directly on the transfer order line – The overdelivery or underdelivery percentages can be set directly on the transfer order line or the percentages that are inherited from the product can be changed.

Specify overdelivery or underdelivery on a transfer order line

  • Follow the steps to create a transfer order line and, in the Transfer orders form, click the Setuptab in the lower pane of the form.
  • In the Overdelivery or the Underdelivery fields, enter a percentage.
  • Process the transfer order line.Set up transfer order lines

Set up transfer order lines

  1. Click Inventory management > Periodic > Transfer orders.
  2. In the upper pane, select a transfer order, or click New to create a transfer order.
  3. In the lower pane, select a transfer order line, or click Add to create a transfer order line.
  4. In the Ship date and Receipt date fields on the Lines tab, change both the shipment and receipt dates proposed on the transfer order lines, if appropriate.
  5. Click Inventory to view a menu from which you can also reserve or pick items from transfer order lines before transfer.
  6. Close the form to save your changes.
Thanks,
Vikas Mehta

Tuesday, 22 October 2019

how to get original value of a table in Dynamics D365 ,ax 2012

how to get original record of a table in Dynamics D365 ,ax 2012

Hi all,
So in order to get the original record while updating any record in a table you will need the original/previously unchanged record to compare in some scenarios.
In that case you can use the below code as shown.

    public void update()
    {
        InventTable     this_Orig           = this.orig();
      
        ttsbegin;

       super();

      
        if (this_Orig.SalesModel                       != this.SalesModel              ||
            this_Orig.SalesPriceModelBasic      != this.SalesPriceModelBasic    ||
            this_Orig.SalesContributionRatio    != this.SalesContributionRatio  ||
            this_Orig.SalesPercentMarkup        != this.SalesPercentMarkup)
        {
            InventTable::updateAutoSalesPrice(this.ItemId);
        }
        ttscommit;
    }
thanks,
Vikas Mehta.

Friday, 11 October 2019

METHOD TO LINK TO PARENT FORM IN D365

HOW TO CREATE A LINK TO ITEM FORM ON A FIELD.
public void jumpRef()
{
Args args;
MenuFunction menuFunction;
args = new args();
args.record(InventTable::find(this.valueStr()));
menuFunction = new MenuFunction(menuitemDisplayStr(EcoResProductDetailsExtended), MenuItemType::Display);
menuFunction.run(args);
}
THANKS,
Vikas Mehta

Saturday, 24 October 2015

INVENTTABLE AND ECORESPRODUCT RELATION JOIN QUERY LINK ECORESCATEGORY

INVENTTABLE AND ECORESPRODUCT RELATION 
JOIN QUERY LINK ECORESCATEGORY

InventTable and ECORESPRODUCT
select ecorescategorygroc where ecorescategorygroc.Name == catgnames;
    while select * from inventTable join product where inventTable.Product == product.RecId
                    join    productCat  where productCat.Product  == product.RecId
                    join    category    where   category.RecId      == productCat.Category && category.Name == catgnames//category.ParentCategory == ecorescategorygroc.RecId// && category.Name == catgnames
                    join catHierarchy   where   catHierarchy.RecId  == category.CategoryHierarchy//
                             && inventTable.itemid like


Blog Post 6: Bonus – Building Your First Custom Copilot Plugin in X++

Blog Post 6: Bonus – Building Your First Custom Copilot Plugin in X++  Introduction In our previous posts, we explored what Copilot can do o...