| Author |
Message |
Donna @ petsplace
Guest
|
 Posted:
Sun Nov 06, 2005 1:02 am Post subject:
Batch Posting to Quickbooks - HELP |
|
|
In posting a closed batch to Quickbooks, I receive an error message
"Transaction split lines to AR must include a customer name on that split
line". The customer names exist in both Quickbooks and RMS and are the same.
I do not have more than one AR account assign in the GL. I noticed in
reviewing the batch that there was a sale made to a store account. I believe
this has something to do with the problem. However, I can not figure out
what is wrong. Has anyone received this message and how did you correct it?
Or does someone know how I can correct this error. Thank you.
|
|
| Back to top |
|
 |
GPL Integrated IT
Guest
|
| Posted:
Sun Nov 06, 2005 1:02 am Post subject:
RE: Batch Posting to Quickbooks - HELP |
|
|
Is this the first time you have connected to this version of Quickbooks? Have
you just upgraded Quickbooks? If this is, you can not use the default AR
account in Quickbooks. The default account requires more information than RMS
will supply. Create a new AR account in quickbooks for your RMS transactions
and you should be OK.
"Donna @ petsplace" wrote:
| Quote: | In posting a closed batch to Quickbooks, I receive an error message
"Transaction split lines to AR must include a customer name on that split
line". The customer names exist in both Quickbooks and RMS and are the same.
I do not have more than one AR account assign in the GL. I noticed in
reviewing the batch that there was a sale made to a store account. I believe
this has something to do with the problem. However, I can not figure out
what is wrong. Has anyone received this message and how did you correct it?
Or does someone know how I can correct this error. Thank you. |
|
|
| Back to top |
|
|
Donna @ petsplace
Guest
|
| Posted:
Mon Nov 07, 2005 7:24 am Post subject:
RE: Batch Posting to Quickbooks - HELP |
|
|
Thank you, thank you, thank you. This resolve the issue. to answer your
questions: Yes, this was the first time connecting to Quickbooks Pro 2003
and it was not an upgrade. Your solution has eliminated the error message.
Now, I am receiving the message that the batch is not in balance. I will
review the entries to see what is wrong. But, in the meantime, any hints on
resolving this error.
"GPL Integrated IT" wrote:
| Quote: | Is this the first time you have connected to this version of Quickbooks? Have
you just upgraded Quickbooks? If this is, you can not use the default AR
account in Quickbooks. The default account requires more information than RMS
will supply. Create a new AR account in quickbooks for your RMS transactions
and you should be OK.
"Donna @ petsplace" wrote:
In posting a closed batch to Quickbooks, I receive an error message
"Transaction split lines to AR must include a customer name on that split
line". The customer names exist in both Quickbooks and RMS and are the same.
I do not have more than one AR account assign in the GL. I noticed in
reviewing the batch that there was a sale made to a store account. I believe
this has something to do with the problem. However, I can not figure out
what is wrong. Has anyone received this message and how did you correct it?
Or does someone know how I can correct this error. Thank you. |
|
|
| Back to top |
|
|
GPL Integrated IT
Guest
|
| Posted:
Mon Nov 07, 2005 7:28 am Post subject:
RE: Batch Posting to Quickbooks - HELP |
|
|
Your doing the right thing...review the accounts make certain you aren't
depositing money by department and again in your new general AR account (this
would deposit the money twice) or commissions twice,etc.
Remember the best way to connect to Quickbooks is by keeping it simple.
Connect the most important accounts first and then build up. I normally tell
my clients to start by making a backup of Quickbooks, named RMSTest. Open
RMSTest in Quickbooks and import your batch file to the RMSTest company. When
you eventually have all of accounts transferring correctly go back and
transfer to your actual company account. Remember always have you accountant
double check your work. If you don't get it checked you could pay far more
than the cost of a single visit come tax time.
"Donna @ petsplace" wrote:
| Quote: | Thank you, thank you, thank you. This resolve the issue. to answer your
questions: Yes, this was the first time connecting to Quickbooks Pro 2003
and it was not an upgrade. Your solution has eliminated the error message.
Now, I am receiving the message that the batch is not in balance. I will
review the entries to see what is wrong. But, in the meantime, any hints on
resolving this error.
"GPL Integrated IT" wrote:
Is this the first time you have connected to this version of Quickbooks? Have
you just upgraded Quickbooks? If this is, you can not use the default AR
account in Quickbooks. The default account requires more information than RMS
will supply. Create a new AR account in quickbooks for your RMS transactions
and you should be OK.
"Donna @ petsplace" wrote:
In posting a closed batch to Quickbooks, I receive an error message
"Transaction split lines to AR must include a customer name on that split
line". The customer names exist in both Quickbooks and RMS and are the same.
I do not have more than one AR account assign in the GL. I noticed in
reviewing the batch that there was a sale made to a store account. I believe
this has something to do with the problem. However, I can not figure out
what is wrong. Has anyone received this message and how did you correct it?
Or does someone know how I can correct this error. Thank you. |
|
|
| Back to top |
|
|
Donna @ petsplace
Guest
|
| Posted:
Mon Nov 07, 2005 7:46 am Post subject:
RE: Batch Posting to Quickbooks - HELP |
|
|
Again, Thank you. Excellent idea with creating the RMSTest in Quickbooks.
This will be extremely helpful in building to Company Financials and ensuring
it is correct and adhering to GAAP rules. Thank you again for your help. It
is much appreciated.
"GPL Integrated IT" wrote:
| Quote: | Your doing the right thing...review the accounts make certain you aren't
depositing money by department and again in your new general AR account (this
would deposit the money twice) or commissions twice,etc.
Remember the best way to connect to Quickbooks is by keeping it simple.
Connect the most important accounts first and then build up. I normally tell
my clients to start by making a backup of Quickbooks, named RMSTest. Open
RMSTest in Quickbooks and import your batch file to the RMSTest company. When
you eventually have all of accounts transferring correctly go back and
transfer to your actual company account. Remember always have you accountant
double check your work. If you don't get it checked you could pay far more
than the cost of a single visit come tax time.
"Donna @ petsplace" wrote:
Thank you, thank you, thank you. This resolve the issue. to answer your
questions: Yes, this was the first time connecting to Quickbooks Pro 2003
and it was not an upgrade. Your solution has eliminated the error message.
Now, I am receiving the message that the batch is not in balance. I will
review the entries to see what is wrong. But, in the meantime, any hints on
resolving this error.
"GPL Integrated IT" wrote:
Is this the first time you have connected to this version of Quickbooks? Have
you just upgraded Quickbooks? If this is, you can not use the default AR
account in Quickbooks. The default account requires more information than RMS
will supply. Create a new AR account in quickbooks for your RMS transactions
and you should be OK.
"Donna @ petsplace" wrote:
In posting a closed batch to Quickbooks, I receive an error message
"Transaction split lines to AR must include a customer name on that split
line". The customer names exist in both Quickbooks and RMS and are the same.
I do not have more than one AR account assign in the GL. I noticed in
reviewing the batch that there was a sale made to a store account. I believe
this has something to do with the problem. However, I can not figure out
what is wrong. Has anyone received this message and how did you correct it?
Or does someone know how I can correct this error. Thank you. |
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in