How to display cost price ?

Finance and Operations/AX User Forum
1

Hi,

In \Forms*PSAProjTable*\Designs\Design[Group:RelatedRecordsGroup][Tab:RelatedRecordsTab]**[TabPage:TransactionsTabPage**][Tab:TransactionsTab][TabPage:TransEmplTabPage][Grid:TransEmplGrid]

I want to dispaly the “Empl_CostPriceGrid” field from “\Data Dictionary\Tables*HRMPayrollLine\Fields\CostPerHr*”.This CostPerHr is a calculated field {(( (HRMPayrollLine.Amount)/12)/22)/8)}.

I’ve linked the field in the form HRMPayrollLine field in Datasource.But it just fetches all the values without checking the ‘EmplId’,

Please help.

Regards,

Rajee

2

Sorry - Can you explain it clearly?

3

In PSAProjTable Form–>Transactions tab—>Hour Transcations tab —> Cost Price Field I want to get the Value of this Cost Price Field from the HRMPayrollLine Table,and the field from the HRMPayrollLine table will be CostPerHr.

4

But i’m not getting the value CostPerHr acc to the Emplid… Do i need to give any relation? or any method has to be used???

5

Hope the two tables have EmplId as common.

The simple way is to write a display method and adding it to the form…

6

display HRMPayrollAmount CostperHr() { if(HRMPayrollLine.emplId == ProjEmplTransDS.EmplId) { return HRMPayrollLine.CostPerHr; } }

7

i have written this display method in “ProjEmplTransDS” datasource of the form

8

try to debug it - whether it is really going into the if condition.

9

No kranthi, it is not going into the condition.

10

Hi Rajee,

Please Tell me after writing this display() what is the output you are getting on form field…?

11

The o/p is tht, If i’m say 5 clos in HRMPayrollLine Table and ther are 3 recs in the PSAProjTable Form,then i’m getting the values of the 1st 3 recs from the HRMPayrollLine Table .

12

I’ve Displayed the Cost Price using the display method ,but now when i open the ProjTable—>transactions—>Hour transactions tab and whn i clik on the values…the values changes (i.e) thy become 0 and again apper aft 2 or 3 clicks ??? why this happens …

please help

regards,

Rajee

13

I’ve Displayed the Cost Price using the display method ,but now when i open the ProjTable—>transactions—>Hour transactions tab and whn i clik on the values…the values changes (i.e) thy become 0 and again apper aft 2 or 3 clicks ??? why this happens …

Can anybody help me in this issue

Regards,

Rajee

14

It might be a problem with your placement of code…

15

But i’ve written the display method in the form’s datasource from where the value is displayed…

is there any other thing which can be done to resolve?

-rajee

16

I’ve written dispaly method in the ‘ProjEmplTransDS’ table in the PSAProj Table form… and the values are coming correctly :slight_smile:

17

Hi All,

Please help me out.

About Inventory closing Error, Problem is:

When I run Inventory Closing I get error message.
My Costing method for item is “Weighted Avg. date”.

Following is the error:

Error message:
Close inventory
Item number: FCG42042 (Group Finish Good)
Transaction: Transaction 1I04000215, lot ID 1I02000545
Unit cost price 0 can be wrong as the transaction cannot be
fully settled

My question is:
Why is this error message? What does it mean?
What impact it will have on inventory closing?
Is there any way to fix this problem?

Regards
Toms