Inventory numbers not transferring to POS Lite

ADAM MACGREGOR
ADAM MACGREGOR Member Posts: 4
edited August 2017 in Point of Sale
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

Comments

  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2017
    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
  • ADAM MACGREGOR
    ADAM MACGREGOR Member Posts: 4
    edited July 2017
    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
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2017
    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
  • ADAM MACGREGOR
    ADAM MACGREGOR Member Posts: 4
    edited July 2017
    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?
  • John G
    John G Reckon Staff Posts: 1,570 Reckon Staff
    edited July 2017
    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
  • ADAM MACGREGOR
    ADAM MACGREGOR Member Posts: 4
    edited July 2017
    Hi John thanks for all your help, the problem has now been resolved. Cheers, Adam