Hi, All, today I have to modify the report. Interestingly this report was built on AOT Query, instead of Data provider class. Current Scenario I was working on Worker Report. The requirement was to show’s primary position and department. HCMWorker table has two display method returns these values.
We can add these display methods into reports by following way.
For example I am modify the out of the box HCMWorkersHiredInPeriod Report.
Now Problem appears, we need different values then provided by out of the box display methods. For example we need Position Title instead of Primary Position Id. for this Add new display method that will return the Position Title instead of Position Id, compile table synchronize table, restore the AOT Query and refresh the report data Set. If there is no error in your working environment you will find required methods in report Data set.
For creating new exchange rate type click on top menu and click on ledger.
From detail menu click on Exchange Rate Type
Click on new button from exchange rate types list page
Enter PkR and detail about it and click on save.
Click on General ledger from Ax menu.
When currency exchange rates page opens, it load default rate change. Select required rate exchange type.
From currency select dollar and to currency Pkr and set conversion factor to 100.
Also save and then add effective dates.
Login in to Ax
On successful login dashboard page is open in web browser.
Change legal entity from top menu to USMF
We can create sales order from either Sales and marketing and Account Receivable module
Click on top menu.
Select Account Receivable menu
Or Sales and Marketing
Click on account receivable
Click on All customers
Customer list page opens. Now click on new button to open customer form.
Enter Customer account for example I Added “MVP0007” as customer account And Name as Ali Raza Zaidi, select 80 in Customer Group.
In Address just select any Zip code for current article I Select 00210.
Click on Save button, If you want to create Sales order directly click on Save and open then click on Sales Order.
Either you create new customer and then click on Save and open. Otherwise click on new Sales Order and select customer.
Select Customer selection for Sale order.
Select customer and save.
As we create very simple sale order so we select only one Item D0001 and set quantity 10 and also select change warehouse to 11.
Save the sale order
When the sales order is saved. The go to Sales Order tab => Generate=> Confirm Sales Order is enable. Click on it
Click on Ok.
You can find that status of Sales order is Open.
When Sale order is confirm. Select pick and Pack => Generate => Generate picking list.
Click on Ok.
After pick list Generation, Click on Pick and Pack => Generate => Picking list registration
Click on Updates => Update All.
After that click on end of form click x to close.
Then Click on Pick and Pack => Generate => Post Packing Slip.
Click ok, You find that Sale order status is now update to Delivered.