355
Is there a way to apply payment to specific line items in AR? We have customers who will pay for specific line items on an invoice at a time instead of the whole thing. It makes it hard on our collections because they don't know which line items to discuss with the customer, but instead have to go through the whole invoice. We are using GP 10.
Thanks,
Jason
*This post is locked for comments
Leslie thanks for your reply on my another issue. But I want your help on this issue. As you mentioned "I have one client that needed this kind of thing too. They didn't want to change the way the SOP documents were entered, but they wanted to apply the cash receipts to the line item. Here's what I came up with. After the invoice was posted I used IM to read the SOP history tables and created an RM transaction for each line on the posted invoice.
The document numbers of the created RM transactions were derived from combining the SOP Doc Number + Line Sequence + Item Number. The line sequence number was converted to a two character digit. The original document created from the posted SOP document is written off in an imported cash receipt trx."
Will you please let me know while setting up Cash Apply Item wise which Destination you have selected 1)whther you have Selected Cash Receipt/Receivable Transactions/Sales Transactions (SOP)
2)Which Sources you have utillized for this Integration.
Your this information will helpful to me to set up a new Integration and I hope it will work.
Yes I want more information about your post. I want to know how you had set up integration for Cash Apply with item wise sales invoice. Please send me any documentation if you have with this so that i can set that integration at my end. please mail me on sanjay.parab@pathinfotech.com
is there any way in GP to Apply Sales invoice with Item No? I have a invoice which have multiple Items and the payment which i received is 15% advance and remaining at due date per Item. I want outstanding for itemwise also i want to apply payment itemwise. Please advise on this.
Thanks
Sanjay Parab.
If you create an RM document for each line item in SOP history, what about the RM doc that's already in RM? Doesn't it need to be removed, or credited, or voided? If it's allowed to remain you're double dipping, aren't you?
I have a client with the same issue, and we're looking for a solution. So far this seems like the most viable. I'd probably use SmartConnect and schedule it to run daily.
Thanks.
Chris Mast CPA
Grand Rapids MI
Thanks everyone for the quick answers. Leslie I am going to start looking into you suggestion.
Jason,
I have one client that needed this kind of thing too. They didn't want to change the way the SOP documents were entered, but they wanted to apply the cash receipts to the line item. Here's what I came up with. After the invoice was posted I used IM to read the SOP history tables and created an RM transaction for each line on the posted invoice.
The document numbers of the created RM transactions were derived from combining the SOP Doc Number + Line Sequence + Item Number. The line sequence number was converted to a two character digit. The original document created from the posted SOP document is written off in an imported cash receipt trx.
At the end of the day the original SOP Document is intact and can be reprinted. The line items appear on separate RM docs so that the items can be paid for separately. The RM docs are easily tied back to the original SOP doc because the RM doc number starts with the SOP doc number.
It may sound odd, but it was easy and it's working.
Kind regards,
Leslie
On a similar tone, we have a customer who produces a 'Statement/Invoice'. This lists all of the sales transactions on a customers account since the last statement was run.
At the bottom of the Statement/Invoice, the VAT for all of the invoices is summarised, and an 'Invoice' total is printed etc.
The top half displays the different invoices (each has only one line) - but the whole looks like a normal invoice. And each line gets paid seperately.
But it does mean putting only one line on each SOP invoice (or multiple lines if they are going to be paid together) as Victoria says.
Another customer prints their sales invoice lines to XL and stores it as an attachment in the document OLE container. When they receive cash, they update the relevant XL sheet. They do more in the XL file than just track the cash applies, so it makes sense for them to keep a file they can play around with.
Have you looked at Scheduled installments? Could this be of any use?
Ian.
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
