Inventory Items are duplicated and their Type is set as Service when posting an End of Day file

Legacy KB ID: 5055

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

Replace Inventory Item Names that contain > “ < with other text.  For example, Monitor 17” can be renamed Monitor 17in.

 

The Issue

If an Item has the double quotation mark (“) in its name, then on import Accounts Business (previously QuickBooks) will replace it with a single quotation mark (‘).  If the item was originally entered into Accounts Business with a double quotation mark, when that item is included in an End of Day file from Retail POS, its name will be changed to a single quotation mark.  This new Item name is not in Accounts Business so the import process will create a new Item.  By this process the Item will be created as a Service Type and not the type it originally had. 

 

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 are 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 – computername – ddmmyy hhmmss – 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 QuickBooks.

 

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/reckon.

How did we do?

Price Level not applied to the Customer

Why are my items prices 4 decimal places long in QuickPOS?

Related Articles

When posting an End of Day file, some inventory items are duplicated and their Type is set as Servic
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)