Questions Enforce a formatting from Acumatica

Posted by: Saiful Murad

Hi,

Was wondering if any of you encounter this issue.  I pulled out TimeCardSummary namely WeekID and HoursSpent to Generic Inquiry and then extract the data using Excel and PowerBI. 

I noticed that :

1.  WeekID becomes a SUM in PowerBI automatically (in Excel, the week is displayed as YYYY,WW.  eg 2018,01) and

2.  I cannot sum HoursSpent - sum will always be zero either in Excel or PowerBI. 

I had to manually change the format in Excel so WeekID becomes text and HoursSpent become Number. 

My questions: 

1.  Can we enforce formatting in Acumatica before it is exported out? 

2.  How do I enforce the format change in PowerBI? 

Am I missing something here?  Thanks in advance.

Colleague suggested to change the Data Field column in Results Grid for WeekID to =CStr([EPTimeCard.WeekID]) , converting WeekID to string and it works. 

Good move. Just curious, did you also have to set the Schema Field column to something that is a string?

Also, are you looking to translate WeekID into a date before exporting it out?

I was thinking to turn YYYYWW into the last date in the week, but then I had a the same "good enough" thought as you. Extra work for something that maybe isn't any better.

True indeed.  If it ain't broke, don't fix it.