Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33  Location: Arcata, California Thanks: 2 times
|
We are importing receipts that include the customer check number using the Data Importer. When we look at the Receipts Journal (Detail), these check numbers appear. When we export the Invoice Receipts, these check numbers are missing. However, check numbers that are manually entered (not imported) do appear in the Invoice Receipts xml file. Thoughts?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/28/2018(UTC) Posts: 48 Location: Pennsylvani mostly Was thanked: 7 time(s) in 7 post(s)
|
OK, this is a little bit out of my area.
But in my testing, cash receipts don't show up on the Invoice Receipts report because that report shows payments made on invoices.
Could it be that the test data makes it look like you are seeing your imported cash receipts on the Invoice Receipts report?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33 Location: Arcata, California Thanks: 2 times
|
Yes, the imported cash receipts do not show up in Invoice Receipts until we go into Receipts>Apply to Open Invoices, check both the original invoice, and the imported offsetting receipt, and then OK and Save. After doing this, both the invoice and the receipt (without the check number) appear in the Invoice Receipts export. Obviously, this is far from ideal. The "cash" receipt we are importing has the Transaction Number as part of the record. How can we get the receipt to automatically apply to the invoice and close the invoice when they are equal? (Note: this is essentially the same question asked on the Data Importer topic on July 23 that no one responded to.)
I don't understand your "test data" question. We are now "live" in CenterPoint and have no test data.
|
|
|
|
|
|
Rank: Administration
Groups: Administrators, Moderator, Registered
Joined: 2/28/2018(UTC)
Posts: 50
Location: Red Wing, MN
Was thanked: 3 time(s) in 3 post(s)
|
Apologies for not answering your question in the "Data Importer" topic, it looks like we were waiting for a response to a question clarification.
In any event, unfortunately, there is currently no way to import a receipt into CenterPoint and have that receipt automatically applied to and potentially close an open AR Invoice using the import tools.
This is something we have discussed recently and may consider for a future update.
AR Invoices and receipts are imported as separate entities and need to be manually applied within CenterPoint.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33 Location: Arcata, California Thanks: 2 times
|
Thanks. We would certainly encourage this feature, since it would save us a lot of manual effort.
I now understand that both the invoice amount and the imported receipt amount are getting exported by Invoice receipts after they are applied. It would be easier to unravel this exported data if the check number on the imported receipts were not getting lost along the way. Can this be fixed?
|
|
|
|
|
|
Rank: Administration
Groups: Administrators, Moderator, Registered
Joined: 2/28/2018(UTC)
Posts: 50
Location: Red Wing, MN
Was thanked: 3 time(s) in 3 post(s)
|
The reason your "Check Number" data isn't coming through to the Invoice Receipts report is that you're seeing data for the Application of the Receipt to the Invoice and not the Imported Receipt itself.
So when you go into Processes > Sales > Receipts, the "Check / Ref #" field is blank - this is what's being reported.
Normally when you pay an Invoice in CenterPoint you'd enter the receipt in this screen and populate this field with the relevant data before selecting the invoice to apply the receipt to.
In your case, you're not really entering a receipt, you're using the new receipt as a mechanism to apply an existing receipt to an invoice.
If you want your imported receipt "Check Number" to come through to this report, I think you would have to import that data to the "TransNumber" field instead of the "CheckNumber" field.
This would populate on the Invoice Receipts report under the "Invoice Number" column for the Receipt that's applied.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33 Location: Arcata, California Thanks: 2 times
|
Yes, the TransNumber does come through, but we use that to hold the invoice number, which is far more critical to us than the check number. I'll live without the check number until you can make the receipts import work better for us. Thanks for looking into it.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The Red Wing Software Developer Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
