When posting an End of Day file, some inventory items are duplicated and their Type is set as Servic

Legacy KB ID: 3969

Question

Why do some inventory items get duplicated and set as type Service when importing an end of day file from Point of Sale?

Answer

If an Item has the quotation mark (“) in its name, then on import Reckon Accounts will create it as another item.  When new items are imported, Reckon Accounts automatically sets them as a type of Service.  The Type cannot be changed.

This problem is common with items that include the inches measurement in their name, using the quotation mark as an abbreviation for inches.  For example:  Monitor 17”.

 

 

Workaround

Replace the quotation mark (“) with another abbreviation like - in. -. 

Rename the Inventory Item without using “.  For example: rename Monitor 17” to Monitor 17in:

o    Lists > Item List;

o    Left click on the item and select Edit Item;

o    Modify the name and click OK to save.

 

Then, either:

Modify each affected transaction, replacing the service item the import created with the correct inventory item. 

 

Or, if the number of changes is too many,

Restore a backup of the company file made before importing the End of Day file (EOD).

CARE:  if you restore a backup that was made some time before the EOD file was imported, then the entries and changes made since the backup was created will have to be re-entered.

Restore the processed EOD file:

  • On your Desktop, click on the Recycle Bin;

·         Find the recently processed EOD file – it has the structure:

QBPst – – – 001.pos;

·         Right click it and select restore – it will be restored to its original location.

The default location for EOD files are:

C:\Reckon\Retail Point of Sale Administrator Professional (or Lite) 200xx-xx;

  • Copy the file.
  • Open the EOD file copy with Excel and modify the item names with the quotation marks to their new names - use Excel’s Find & Replace function.  Save and Close.
  • Delete the original EOD file.
  • Post the EOD file copy to Reckon Accounts.

When completed delete the duplicate items of type Service created by the original importing of the EOD file. 

Transfer the Item List to Point of Sale. 



Need more help?

Ask the Reckon Community at: https://community.reckon.com/categories/reckonaccounts

Or Log a Support Ticket: https://www.reckon.com/au/support/

 

How did we do?

Cannot assign a Class to a POS Refund in QuickBooks

Related Articles

Inventory Items are duplicated and their Type is set as Service when posting an End of Day file
Runtime error 53, file is not found when posting the End Of Day transactions
The transaction is not in balance warning when posting End-of-Day files to Reckon Accounts
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)