Please enable JavaScript to view this site.

 

Navigation: Zetadocs Expenses Help > Quick Start Guides > Exporting Expenses to Business Central

Export Errors

Scroll Prev Top Next More

Export Errors

Relevant to the hmtoggle_arrow0Processor role.


This topic is designed to assist you in resolving issued when exporting your Expense Reports to Business Central.

note_image Note:

Expenses will only show in your ERP system if your System Settings > Integration > ERP Connection > ERP Integration is {Enabled} and configured correctly. Please refer to Zetadocs Expenses Installation Guides for more details.

Only Approved Expense Reports will be exported.

If your System Settings > Integration > Export Settings is set to {Manual}, you will need to manually export your expenses before they appear in your ERP system. Please refer to Exporting Expenses to Business Central for more details.

If your System Settings > Integration > Export Settings is set to {Automatic}, expense records on the Expense Report will be exported immediately after it has been approved. Please allow a little time for the export process to complete..

If you've followed the above instructions and your expenses are still not showing in Business Central, please check the Expense Report 'History' as this will give details why the expenses have failed.

The following section explains the export errors you are likely to see in the 'History', and ways to correct them.

Error

Notes

...Blocked must be equal to 'No' 

in G/L Account: No.=xxxx...

Reason: The G/L Account Code has a blocked flag set against it in Business Central

Resolution:

1.Open Business Central.

2.Navigate to General Posting Setup.

3.Find the G/L Account Code xxxx.

4.Remove the 'blocked' status on the G/L Account Code.

Export of reimbursable expenses failed.
Details: Vendor number xxxx not found.

[ERR_InvalidDataNoSuchVendor]

 

Reason: Incorrect Vendor Number specified against Zetadocs Expenses user.

Resolution:

1.Within Zetadocs Expenses, determine which expense record is failing to export to Business Central.

2.Note the staff member the expense relates to.

3.Take a note of the Vendor Code recorded against this staff member's user record.

4.Add this Vendor Code in Business Central.

Export of reimbursable expenses failed.
Details: Error exporting expense ID xxxx

Expense type {Expense Type Name} does not have a valid GL Code. 

[ERR_InvalidDataExpTypHasNoGl]

 

Reason: Incorrect G/L Account Number set on the Expense Type (i.e. one that does not exist in BC).

Resolution:

1.Within Zetadocs Expenses, determine which expense record is failing to export to Business Central. Use the Expense ID detailed in the error message text to assist you.

2.Note the {Expense Type Name} on the expense.

3.Take a note of the G/L Account Number recorded against this {Expense Type Name}.

4.Add this G/L Account Number as a General Ledger Account in Business Central.

Export of reimbursable expenses failed.
Details: Error exporting expense ID xxxx.

"Account Type must be equal to 'Posting' in G/L Account: No.=xxxx

Current value is 'Begin-Total'." [ERP_InvalidGlAccountType]

 

Reason: The G/L Account Number specified on the Expense Type relates to a General Ledger Account which cannot be posted to. The “Account Type” setting needs changing.

Resolution:

1.Within Zetadocs Expenses, determine which expense record is failing to export to Business Central. Use the Expense ID detailed in the error message text to assist you.

2.Note the {Expense Type Name} on the expense.

3.Take a note of the Export Code recorded against this {Expense Type Name}.

4.Add this Export Code as a General Ledger Code???? in Business Central.