Activity Slips - Import Error - Warning 600: Payroll category requires a non-zero unit; ignored.

[CloudMindAcc]

Hi MYOB,

Please explain what this means.   The only issue I can identify compared to other activity slips I imported is this one has a decimal in the unit? i.e. 2.5   Where am I going wrong surely you can import decimal points?

Have attached log and import txt file.

0 records imported without errors.
1 records imported with warnings.
0 records skipped.

Summary of errors
Warning 600: Payroll category requires a non-zero unit; ignored.

600 STARTER New 2/08/2020 H601 TACK Bell 2.5 H601 TAC - TACK Bell 8

Please help... @Mike_James  you probably know the answer as you are so good with this sort of stuff

[Mike_James]

Hi @CloudMindAcc , appreciate the shout-out, but I don't know this one! The help documentation suggests that units allow 2 decimal places, so you could try writing 2.50 instead of 2.5. 

Can you attach the source text file with a few rows including the one that gives the warning?

[Komal_S]

Hi @CloudMindAcc , @Mike_James 

This is a known issue in the system whereby activities which are set up with the type Hourly, are imported with a Warning : Payroll category requires a non-zero unit; ignored, if decimals are entered in the Payroll category field.

If a whole number is entered, the import works fine, however, this has been raised with the product development team already for a permanent fix. 

In the meantime, if the activities are set up as Non Hourly and hours are written in the Unit field, they can be imported successfully without any warnings or errors. 

[Mike_James]

Thanks @Komal_S , I presume you mean "if decimals are entered in the Unit field"

[Komal_S]

Hi @Mike_James 

Sorry, my bad. Yes, I meant the Units field. 

[Paul_SHF]

Hi @Komal_S 

Thank you for rasing this to the product development team already for a permanent fix. Given this is a known issue and the fact that you can manually enter a decimal of an hour ie 1.5 and it will accept for Payroll however when you attempt an import with a decimal Warning : Payroll category requires a non-zero unit; ignored, appears! Fixing this anomaly so that Activity Slips Import "Units" field to be able to accept decimal would be fantastic.  

With respect to the interim /workaround solution  "activities are set up as Non Hourly and hours are written in the Unit field" this doesnt work as imports reslts in Error -5051: ActivitySlip_ActivityIsNotHourly.

[Komal_S]

Hi @Paul_SHF 

For the import to work, you will have to ensure that the activity itself is setup as non-hourly first by going to Lists>>Activities. Can you please change that and confirm if it still doesn't work. 

[Paul_SHF]

Hi Komal_S

I can confrim I changed activities to non-hourly and tested it before my response yesterday.

Dev Team fixing the Units to accept a decimal solves everything! - Just saying and I know you are aware :-)

[Komal_S]

Thank you for that feedback again @Paul_SHF . I will let the development team know of this issue as well. 

[Steven_M · Accepted solution]

Hi @CloudMindAcc  @Paul_SHF 

This particular warning has been resolved in AccountRight 2020.4, with importing activity slips with a decimal in the unit column allowing a payroll category to be added.