Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

(0) Share

Report

Posted on by Community Member

Hi ,

In project mangement and accounting ->project invoices-> project invoice proposals

when we add new , a dialog will appear , in which we have end date and invoice date set to default current date..

here the customisation is we have add a new field in project accounting parameters, that will be no of days

isuppose no of days we hv entered as 15 and our current date is 13 /may then it should reflect the end date and invoice date should be last month last date that will be updated with 30/ april.

But if we have entered no of days as 10 but our current date is 13 may , in this case there must be no updating in the end date and invoice date.

Can anyone help me out how to achieve this??

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Hi,

If this is a modification that has been implemented then I would suggest that you talk to the one that created this modification.

He/she should be able to explain what this modification is doing and how it behaves.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Its not been implemented, ..

I just wanna know how to counter this and what kinda code to be written to achieve this scenario and how??

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

try date functions and datevalue to validate

docs.microsoft.com/.../xpp-date-run-time-functions

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Hi nil,

I see.

What is it exactly that you expect from the community?

Do you expect a code sample how to achieve what you describe above?

Would be great if you could clarify.

Many thanks and best regards,

Ludwig

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report
RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Hi nil,

You could use prevMth() method to get last month and use endmth() to get the last day of previous month.

Please put your codes in the onmodified event of your new field.

static void LastOfprevMonth(Args _args) { Date TransDate=today(); Date LastOfMth; Date prevdate=prevMth(TransDate); LastOfMth=endmth(prevdate); info(date2str(LastOfMth,123,2,2,2,2,4)); }

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Yes , Dr .Ludwig Reinhard could you please help me out with code?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Hi, Mr Will Wu could you please explain the last line of code

(LastOfMth,123,2,2,2,2,4).

Whats that numbers indicate?

Was this reply helpful? Yes No
WillWU 22,361 on at

Like (0)

Report

RE: Integration in project invoice proposals and project accounting parameters , based upon no of days added in parameters , the end date and invoice date should be updated? Please refer the description below for clear understanding!!

Hi nil,

This is the parameter of the date2str method.

https://docs.microsoft.com/en-us/previous-versions/dynamics/ax-2012/reference/aa857241(v=ax.60)?redirectedfrom=MSDN

Was this reply helpful? Yes No