Print Friendly

The following errors may occur when importing data in to Restaurant365.  Click here for an Overview of EDI Vendor Integrations.

Review error types for troubleshooting tips and steps to error resolution

 

Revision Date: 3/9/2017

 

Closed Period

Cause:

Journal Entries cannot be imported in to a Closed Period.  If the date of the Journal Entry falls in a Closed Period for the Legal Entity (by way of the Location), the system will not allow the Journal Entry to be posted in the Closed Period.  Click here for more information on Closed Periods

Resolution:

If the date on the Journal Entry falls in a period that has been closed on the Legal Entity Record in Restaurant365, the import will continue to fail.  To resolve the issue, the date of the Journal Entry must be changed, or the closed date on the Legal Entity Record must be changed

 

Date Missing

Cause: 

The Date value is either missing or has been entered in an unrecognizable format

Resolution:

Add, or update the Date value to adhere to acceptable formatting:

MM/DD/YYYY or MM/DD/YY

 

Detail not in Balance

Cause:

This error occurs on AP Invoice by GL Account imports only.  The cause of the error is when the Detail Amounts do not equal the Total Amount of the invoice, therefore the Detail is not Balanced

Resolution:

Update the Detail Amount or the Total Amount on the import file to be in balance

 

Duplicate Invoice Number

Cause:

The invoice number on the import file already exists within Restaurant365 for that particular Vendor

Resolution:

Invoices with duplicate numbers cannot be imported.  However, they can be entered in to the system.  If the invoice on the file represents a different invoice than the invoice that is currently in Restaurant365, change the invoice number on either the existing invoice, or the invoice on the import file.  This will allow the User to import the file.  Once in the system, depending on set System Preferences surrounding duplicate invoices, the invoice number could then be restored to their original value

 

Legal Entity Not in Balance

Cause:

This error occurs on Beginning Balance JEs only.  The cause of the error is when Detail Locations that do not belong to the same Legal Entity are entered on detail lines within the Journal Entry.  Due to the Beginning Balance nature of the JE, Restaurant365 cannot/will not create inter-company entries on the JE.  Therefore the Legal Entity would be out of balance for this transaction

Resolution:

Update the import file to contain Location Details that all belong to the same Legal Entity

 

Journal Entry Not in Balance

Cause:

The sum total of all Debit values does not equal the sum total of all Credit values entered on Detail Lines within the specific Journal Entry

Resolution:

Update the import file so that Debits = Credits

 

Missing Detail Location

Cause:

The Location (Name or Number) entered on the Detail line of the AP Transaction / Journal Entry does not exist

Resolution:

Update the import file to contain a Location Name or Location Number representative of an existing record within Restaurant365.  Or, if necessary, create a new Location Record for the new Location on the detail of the transaction

 

Missing GL Account

Cause:

The GL Account (Name or Number) entered on the Detail line of the AP Transaction / Journal Entry does not exist

Resolution:

Update the import file to contain GL Account Name or GL Account Number representative of an existing record within Restaurant365.  Or, if necessary, create a new GL Account for the new Account on the detail of the transaction

 

Missing Location

Cause:

The Location (Name or Number) entered on the Detail line of the AP Transaction / Journal Entry does not exist

Resolution:

Update the import file to contain a Location Name or Location Number representative of an existing record within Restaurant365.  Or, if necessary, create a new Location Record for the new Location on the detail of the transaction

 

Missing Payment Terms

Cause:

The Payment Terms listed on the AP Transaction do not exist within Restaurant365

Resolution:

Create the Payment Terms in Restaurant365 or change the Payment Terms value on the import file to match an existing record within Restaurant365

 

Missing Vendor

Cause:

The Vendor listed on the AP Transaction does not exist within Restaurant365

Resolution:

Verify that the Vendor Name is spelled identical to the existing Vendor Record in Restaurant365.  If no record for that Vendor exists, create the Vendor Record

Was this article helpful to you?

Comments are closed.