Posting to Quick book.

[Deleted User]
[Deleted User] Posts: 0
edited August 2016 in Point of Sale
Hi,

I been having problems with posting data from POS Admin to Quickbooks. I will get all these different warnings.

1)PROBLEM: Another invoice or adjustment note already has number 012345.      
SOLUTION: You can keep the number but this may couse you confusion in the futur.


2)WARNING: Error on line 14: Cant record invalid transaction.

- This warning comes up with different numbers a couple of times. What does it mean?


3) WARNING: One of your items does not have an account associated with it. Go to item list to make sure all items have accounts associated with them.

- I have done this and all items have accounts!


4) ERROR DURING POST TRANSACTION: Error code: -13- General importline problem.


All of this started after having the system down for a couple of weeks, on returne it refuses to post. What should I do?

Comments

  • Palak
    Palak Alumni Posts: 37
    edited January 2015

    Hi,  
    Welcome to Reckon Community!

    Regards to your Query, would you follow the steps from below please.
    1. Reckon Accounts  already has the transaction number. so change the transaction no to something really in a further range than Reckon Accounts in Terminal (Tools>Options) and when you do an EOD(End of Day), tick "Reset transaction" so all new transactions done after this EOD will start from that particular number.
    2. Open up EOD in Excel where you will see "ENDTRNS" at line 14, then look for "TRANS" which could be few lines above. Look for the lines in between, can you see any issue? like it's not balancing the debit and credit? any invalid characters? GST not there if it should be? attach a screenshot of it by replying so we can see more in details.
    3. You might have fixed the item's setup in Reckon Accounts but in POS, it might not have updated that data if there was not Transfer done from POS Administrator, so open up EOD file  <QBPst-Terminal name-Date-time>.pos from where your database file is located, generally it should be at C:\Reckon\Point of Sale Professional 2013 Administrator, look for account column and see if any missing account next to item column. Update it manually then save it to same format and POST again from POS Administrator when posted successfully to Reckon Accounts , do a "Transfer" of everything in POS Administrator from Reckon Accounts  so POS knows all the latest data.

    4. This error and other errors from above could have been caused by sudden system crash which might have caused POS Database corruption (system crash mostly corrupts files if they were open at that time). You might want to start with a new Database file and export out the Keyboard layout (if you have a customized one). You lose Laybys and transactions history (if you have posted to RA, it's already there). It's your choice. Let me know if you require more details on this.

    We hope the above helps. Let us know how you go! 

    Thank you

    Palak