"System Error: Error getting returns" when opening Lodgment Manager

This support note applies to:

AE Tax Series 6 & 8 (AU)

Article ID: 38751

When opening Lodgment Manager, you might see the error "System Error: Error getting returns".

This issue occurs where there's duplicate return codes in MYOB Tax – for example, ABC2019T and Abc2019T.

To fix this issue, contact us and quote KB 38751.

MYOB INTERNAL STAFF ONLY

Run the following query in SQL Server Management Studio:
WITH LodgementHomepage as
(
SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2008
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2009
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2010
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2011
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2012
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2013
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2014
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2015
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2016
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2017
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2018
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2019
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2020
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2021
WHERE [State] <> 'L'
UNION ALL SELECT clientcode,formid, returncode, returnyear FROM dbo.vw_TaxSbrSender_LodgmentHomepage2022
WHERE [State] <> 'L' )

select ClientCode, ReturnCode, FormID, returnyear from LodgementHomepage
group by ClientCode, ReturnCode, FormID, returnyear
having COUNT(ReturnCode) >1
Delete the duplicate returns.
Close and reopen Lodgment Manager.