TPAR file lodgement failed

[CathInnova]

Hi 

File error when lodge TPAR file today. Not sure how to fix it.

Please contact your software developer. The file size is not a correct multiple of the record length.

Regards

Cath

[CathInnova]

File size (bytes): 109124 

This the file size

[gavin12345]

Hi @CathInnova 

Are you lodging the TPAR.C01 file that MYOB generated during the process? The file size suggests you are lodging the wrong file (unless you have over 1000 contractors you are reporting on).

Regards

Gavin

[CathInnova]

Yes, TPAR.C01. 

Over 100+ suppliers

[gavin12345]

Hi @CathInnova 

Yes, sorry, my post should have read over 100. The length of each record should be 996 characters. There are 6 mandatory records plus the payee records, so if you have 103 payees your file size should be (103+6) * 996 = 108564, or if you have 104 = 109560 - your file size is in between.

What MYOB product and version are you using to generate the TPAR.C01 file? - see Help > About.

If you are using a version several years old, the record sizes are different.

A common area that causes problems with TPAR.C01 file is the address field in MYOB. Suggest you export the Supplier cards to excel and see if the format messes up. If an Address field has more than one line, this will affect both the export file and the TPAR.C01 file. For example some users enter the Address as:

23 Smith Street

Smithtown NSW 2222

Australia

instead of :

23 Smith Street

with the Suburb Postcode and State etc in the separate fields.

Fix these and try to generate the TPAR.C01 file again and see if that resolves.

Unfortunately MYOB developers often do not enforce ATO specifications and validity tests during the process of building the lodgment file, and rely instead on the ATO returning error codes and messages for the user to deal with. This same thing happens with STP reports with ATO returning 'invalid character' errors.

Regards

Gavin