Inventory numbers not transferring to POS Lite

  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi guys, having problems transferring inventory numbers from Reckon Accounts Premier to POS Lite 2016. When entering an invoice into Accounts the numbers of stock will show in "Stock on Hand" in the Item List. However when transferring to Reckon Lite those numbers will not always show in Administrator or POS. Any tips out there? Thanks, Adam
Photo of ADAM MACGREGOR

ADAM MACGREGOR

  • 100 Points 100 badge 2x thumb

Posted 1 year ago

  • 1
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
Hello Adam,

Welcome to the Reckon Community.

In Reckon Accounts resort lists, rebuild and verify.
In POS Administrator, compact the database.
Does the transfer work properly now?
In POSadmin > Products, the On Hand column matches the Item List in Reckon Accounts?
In POSterminal > Product Number, does the On Hand match the POSadmin and Reckon Accounts?

You mentioned they show "not always".  Is there any pattern when they do show and when they do not?


regards,
John
Photo of ADAM MACGREGOR

ADAM MACGREGOR

  • 100 Points 100 badge 2x thumb
Thanks John. In Accounts is that File-Utilities-Rebuild Data? Is there any danger of losing information or damaging the inventory file through this process?
Cheers Adam
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
Hi Adam,

Rebuild is the function to correct low-level corruptions in the datafile. You can verify first and then continue to the Rebuild if an error is found.  A full guide is here.

Because the process is restructuring the database (just to return links to their correct alignment) there is an element of risk that damage may occur.  The process forces you to make a backup first before the rebuild process goes ahead.   

regards,
John
Photo of ADAM MACGREGOR

ADAM MACGREGOR

  • 100 Points 100 badge 2x thumb
Transfers still not "completely" working after following these steps. By "not always" I mean that some items/SOH are transferring while others (from the same invoice) are not. Have tried the rebuild and compact twice now with no luck - well about 20% luck (again, some items transferring, some not) . . . Anything else we could try?
(Edited)
Photo of John G

John G, Information Support Analyst

  • 27,280 Points 20k badge 2x thumb
Thanks Adam,

Next steps: 

Make sure all End of Day files are posted to Reckon Accounts. Then do a Compact and repair. You can do another Verify, Rebuild, Verify in Reckon Accounts and then do a fresh transfer from Reckon Accounts to POS.

If it's still an issue, compare the items that do work and those that do not - what is the difference?
If you adjust one to match the ones that work, does it transfer properly this time?

If the problem still persists then create a new POS Database file.
To create a new database file:
  1. Close POS Terminals and Administrator
  2. In Windows Explorer, rename the existing PDB file by adding .old
  3. Launch POS Admin and create a new database file.
  4. Restore a backup (you will not be able to change the name of the terminal.)

Hope these pointers help.
If not, call Technical Support for further one-to-one assistance


regards,
John
Photo of ADAM MACGREGOR

ADAM MACGREGOR

  • 100 Points 100 badge 2x thumb
Hi John thanks for all your help, the problem has now been resolved. Cheers, Adam