This page is for MYOB Acumatica consultants
Check all changes in a test environment before taking them live. Make sure all related features still work as expected and that your data is unaffected.
The following logic can be used in the report designer to convert a date into the week number it is asscoiated to, for example 1st June belongs to week 22 whereas the 1st January belongs to week 1.
The example below is taking the TranDate field from the table INKitRegister
=Ceiling(DayOfYear( [INKitRegister.TranDate])/7.0)