Whether you are making out a cheque, or recording a payment, have all invoices and credit notes on the same screen to check the boxes of the items that you want paid. Currently, Great Plains has credit notes on a separate screen two or three clicks away from the invoices. Keep it simple, and have everything on the same screen. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.public.greatplains
One reason, I guess, for this is because people typically want to apply a certain credit document(s) to certain debit document(s). So if you had a window that you could pick 5 credit documents and 9 debit docuemnts how would you be assured what credit goes to what debit? You wouldn't really be able to. That said, actually I've recently written just such a window for a large customer. Basically you can check off and select the amount to apply/be applied to for the debits & credits and then goes through and assigns them in document order I think. The only drawback that I can see is they wanted a lot of columns to be displayed so the window is pretty big but that's how they wanted it. It was pretty complex to write to get the base functionality down as well as their specific features. I could send you the readme and a demo version that works in Fabrikam if you want to take a look at it. Email me at mbstools@microsoft.com. patrick mbs dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "JD" <JD@discussions.microsoft.com> wrote in message news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > Whether you are making out a cheque, or recording a payment, have all > invoices and credit notes on the same screen to check the boxes of the items > that you want paid. Currently, Great Plains has credit notes on a separate > screen two or three clicks away from the invoices. Keep it simple, and have > everything on the same screen. > > ---------------- > This post is a suggestion for Microsoft, and Microsoft responds to the > suggestions with the most votes. To vote for this suggestion, click the "I > Agree" button in the message pane. If you do not see the button, follow this > link to open the suggestion in the Microsoft Web-based Newsreader and then > click "I Agree" in the message pane. > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi c.greatplains
I have credit notes that have nothing to do with any invoices. I occasionally have one that is related, though I prefer the AccPac approach (that program allows the same number to be issued as an invoice and credit note - that way, there is a direct relationship between the credit note and invoice - and no, manually checking and unchecking a posting box in GP is asking for problems). Great Plains forces a marriage of credit notes to invoices, whether there is a relationship or not. And that makes no sense to me. The option I am looking for, is simply have all the credit notes and all the invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE SCREEN whatever is applicable to the cheque. This would require the credit notes to be married to the cheque (not an unsuspecting invoice). That is a fundamental programming issue. Having 5 credit memos pay an invoice (and not a cheque) is not useful information. Does that make sense? "Patrick [MSFT]" wrote: > One reason, I guess, for this is because people typically want to apply a > certain credit document(s) to certain debit document(s). So if you had a > window that you could pick 5 credit documents and 9 debit docuemnts how > would you be assured what credit goes to what debit? You wouldn't really be > able to. > > That said, actually I've recently written just such a window for a large > customer. Basically you can check off and select the amount to apply/be > applied to for the debits & credits and then goes through and assigns them > in document order I think. The only drawback that I can see is they wanted > a lot of columns to be displayed so the window is pretty big but that's how > they wanted it. > > It was pretty complex to write to get the base functionality down as well as > their specific features. I could send you the readme and a demo version > that works in Fabrikam if you want to take a look at it. Email me at > mbstools@microsoft.com. > > patrick > mbs dev support > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "JD" <JD@discussions.microsoft.com> wrote in message > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > Whether you are making out a cheque, or recording a payment, have all > > invoices and credit notes on the same screen to check the boxes of the > items > > that you want paid. Currently, Great Plains has credit notes on a > separate > > screen two or three clicks away from the invoices. Keep it simple, and > have > > everything on the same screen. > > > > ---------------- > > This post is a suggestion for Microsoft, and Microsoft responds to the > > suggestions with the most votes. To vote for this suggestion, click the "I > > Agree" button in the message pane. If you do not see the button, follow > this > > link to open the suggestion in the Microsoft Web-based Newsreader and then > > click "I Agree" in the message pane. > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > c.greatplains > > >
occasionally have one that is related, though I prefer the AccPac approach > (that program allows the same number to be issued as an invoice and credit > note - that way, there is a direct relationship between the credit note and > invoice - and no, manually checking and unchecking a posting box in GP is > asking for problems). In Great Plains, you also can have duplicate document numbers. The primary key on the table for RM is Document Number/RM Document Type All. > Great Plains forces a marriage of credit notes to invoices, whether there is > a relationship or not. And that makes no sense to me. > A document has to be "applied" to something. While a credit memo does affect your balance if you print a RM Statement with a $100 invoice and $100 credit memo, it'll print out the same way the next month unless you apply to them which reduces the remaining amount for each. Then a paid transaction removal puts them to history. > The option I am looking for, is simply have all the credit notes and all the > invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE > SCREEN whatever is applicable to the cheque. Well, we weren't (well, I wasn't) talking about vendors at all. I know the Consolidations module you define a customer/vendor relationship and you can provide refund checks for your customer credits or you can use Consolidations to take all the invoices/credits and make them one big lump amount. So when you say, "I want a screen where I can see all the debit docs & credit docs for a customer at once" then that is what I did. However note that this isn't anything at all to do with a check. > Having 5 credit memos pay an invoice (and not a cheque) is not useful > information. Perhaps for your business but I guess I can't see why it wouldn't be. Remembering that I don't use this application in "real life", I could see that I would have perhaps an outstanding invoice (as a customer) for $1000. And because it's my birthday the vendor issues me a credit memo for $100. And then I find a problem with his product and to make me happy he issues another credit memo for $100. And then I return $800 of merchandise from last month but they don't issue cash refunds and so I get another $800 credit. So this isn't typical, I know as there would typically be me sending the vendor (you) some money to pay things off. Either way, however, you're still going to have to apply these records. In the RM Apply you'd have to pull up the credit documents one by one and apply them. In the window that I did, you would see them all like you asked. Or I thought you asked. Now if you were thinking that you want a window that shows PM/RM stuff together, that sounds a lot like the consolidations module. patrick mbs dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "JD" <JD@discussions.microsoft.com> wrote in message news:7CFF4A4B-CEB3-419B-8A9A-2794A36ADF14@microsoft.com... > I have credit notes that have nothing to do with any invoices. I > occasionally have one that is related, though I prefer the AccPac approach > (that program allows the same number to be issued as an invoice and credit > note - that way, there is a direct relationship between the credit note and > invoice - and no, manually checking and unchecking a posting box in GP is > asking for problems). > > Great Plains forces a marriage of credit notes to invoices, whether there is > a relationship or not. And that makes no sense to me. > > The option I am looking for, is simply have all the credit notes and all the > invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE > SCREEN whatever is applicable to the cheque. > > This would require the credit notes to be married to the cheque (not an > unsuspecting invoice). That is a fundamental programming issue. > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > information. > > Does that make sense? > > > > "Patrick [MSFT]" wrote: > > > One reason, I guess, for this is because people typically want to apply a > > certain credit document(s) to certain debit document(s). So if you had a > > window that you could pick 5 credit documents and 9 debit docuemnts how > > would you be assured what credit goes to what debit? You wouldn't really be > > able to. > > > > That said, actually I've recently written just such a window for a large > > customer. Basically you can check off and select the amount to apply/be > > applied to for the debits & credits and then goes through and assigns them > > in document order I think. The only drawback that I can see is they wanted > > a lot of columns to be displayed so the window is pretty big but that's how > > they wanted it. > > > > It was pretty complex to write to get the base functionality down as well as > > their specific features. I could send you the readme and a demo version > > that works in Fabrikam if you want to take a look at it. Email me at > > mbstools@microsoft.com. > > > > patrick > > mbs dev support > > > > -- > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > > Whether you are making out a cheque, or recording a payment, have all > > > invoices and credit notes on the same screen to check the boxes of the > > items > > > that you want paid. Currently, Great Plains has credit notes on a > > separate > > > screen two or three clicks away from the invoices. Keep it simple, and > > have > > > everything on the same screen. > > > > > > ---------------- > > > This post is a suggestion for Microsoft, and Microsoft responds to the > > > suggestions with the most votes. To vote for this suggestion, click the "I > > > Agree" button in the message pane. If you do not see the button, follow > > this > > > link to open the suggestion in the Microsoft Web-based Newsreader and then > > > click "I Agree" in the message pane. > > > > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > > c.greatplains > > > > > >
Oh boy. I have not made myself clear. I apoligize for not being more succinct. I have no desire to have the AR and AP in the same window (your last sentence about PM/RM stuff together). No. What I meant was, that the credit note issue I have exists in AR and it exists in AP. When in GP AR, credit notes marry themselves to invoices. When in GP AP, credit notes marry themselves to invoices. In my business, credit notes (for the most part), have nothing to do with any specific invoice. I reinterate, in my business, having 5 credit memos pay an invoice is completely useless (and frustrating) information. I agree with you wholeheartedly about "A document has to be applied to something". However, I want the credit note to be applied to a cheque (check in the US), be it a customer cheque in AR, or a cheque that I am paying to a vendor. That will resolve my problem with credit notes right there. Having credit notes applied to a cheque, means that you can have one window listing all the outstanding invoices and credit notes ON ONE SCREEN. It also means that you can simply check off each box that represents what invoices and what credit notes that you want to apply to that particular cheque. To me, that means "PROBLEM SOLVED". I don't want a credit note applied to any invoice; be it in AR or AP. I want the credit note applied to a cheque. Did I do a better job this time? JD "Patrick [MSFT]" wrote: > > occasionally have one that is related, though I prefer the AccPac approach > > (that program allows the same number to be issued as an invoice and credit > > note - that way, there is a direct relationship between the credit note > and > > invoice - and no, manually checking and unchecking a posting box in GP is > > asking for problems). > > In Great Plains, you also can have duplicate document numbers. The primary > key on the table for RM is Document Number/RM Document Type All. > > > > Great Plains forces a marriage of credit notes to invoices, whether there > is > > a relationship or not. And that makes no sense to me. > > > > A document has to be "applied" to something. While a credit memo does > affect your balance if you print a RM Statement with a $100 invoice and $100 > credit memo, it'll print out the same way the next month unless you apply to > them which reduces the remaining amount for each. Then a paid transaction > removal puts them to history. > > > > The option I am looking for, is simply have all the credit notes and all > the > > invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE > > SCREEN whatever is applicable to the cheque. > > Well, we weren't (well, I wasn't) talking about vendors at all. I know the > Consolidations module you define a customer/vendor relationship and you can > provide refund checks for your customer credits or you can use > Consolidations to take all the invoices/credits and make them one big lump > amount. > > So when you say, "I want a screen where I can see all the debit docs & > credit docs for a customer at once" then that is what I did. However note > that this isn't anything at all to do with a check. > > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > > information. > > Perhaps for your business but I guess I can't see why it wouldn't be. > Remembering that I don't use this application in "real life", I could see > that I would have perhaps an outstanding invoice (as a customer) for $1000. > And because it's my birthday the vendor issues me a credit memo for $100. > And then I find a problem with his product and to make me happy he issues > another credit memo for $100. And then I return $800 of merchandise from > last month but they don't issue cash refunds and so I get another $800 > credit. So this isn't typical, I know as there would typically be me > sending the vendor (you) some money to pay things off. > > Either way, however, you're still going to have to apply these records. In > the RM Apply you'd have to pull up the credit documents one by one and apply > them. In the window that I did, you would see them all like you asked. Or > I thought you asked. > > Now if you were thinking that you want a window that shows PM/RM stuff > together, that sounds a lot like the consolidations module. > > patrick > mbs dev support > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "JD" <JD@discussions.microsoft.com> wrote in message > news:7CFF4A4B-CEB3-419B-8A9A-2794A36ADF14@microsoft.com... > > I have credit notes that have nothing to do with any invoices. I > > occasionally have one that is related, though I prefer the AccPac approach > > (that program allows the same number to be issued as an invoice and credit > > note - that way, there is a direct relationship between the credit note > and > > invoice - and no, manually checking and unchecking a posting box in GP is > > asking for problems). > > > > Great Plains forces a marriage of credit notes to invoices, whether there > is > > a relationship or not. And that makes no sense to me. > > > > The option I am looking for, is simply have all the credit notes and all > the > > invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE > > SCREEN whatever is applicable to the cheque. > > > > This would require the credit notes to be married to the cheque (not an > > unsuspecting invoice). That is a fundamental programming issue. > > > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > > information. > > > > Does that make sense? > > > > > > > > "Patrick [MSFT]" wrote: > > > > > One reason, I guess, for this is because people typically want to apply > a > > > certain credit document(s) to certain debit document(s). So if you had > a > > > window that you could pick 5 credit documents and 9 debit docuemnts how > > > would you be assured what credit goes to what debit? You wouldn't > really be > > > able to. > > > > > > That said, actually I've recently written just such a window for a large > > > customer. Basically you can check off and select the amount to apply/be > > > applied to for the debits & credits and then goes through and assigns > them > > > in document order I think. The only drawback that I can see is they > wanted > > > a lot of columns to be displayed so the window is pretty big but that's > how > > > they wanted it. > > > > > > It was pretty complex to write to get the base functionality down as > well as > > > their specific features. I could send you the readme and a demo version > > > that works in Fabrikam if you want to take a look at it. Email me at > > > mbstools@microsoft.com. > > > > > > patrick > > > mbs dev support > > > > > > -- > > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > > > Whether you are making out a cheque, or recording a payment, have all > > > > invoices and credit notes on the same screen to check the boxes of the > > > items > > > > that you want paid. Currently, Great Plains has credit notes on a > > > separate > > > > screen two or three clicks away from the invoices. Keep it simple, > and > > > have > > > > everything on the same screen. > > > > > > > > ---------------- > > > > This post is a suggestion for Microsoft, and Microsoft responds to the > > > > suggestions with the most votes. To vote for this suggestion, click > the "I > > > > Agree" button in the message pane. If you do not see the button, > follow > > > this > > > > link to open the suggestion in the Microsoft Web-based Newsreader and > then > > > > click "I Agree" in the message pane. > > > > > > > > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > > > c.greatplains > > > > > > > > > > > > >
JD, > When in GP AR, credit notes marry themselves to invoices. When in GP AP, > credit notes marry themselves to invoices. In my business, credit notes (for > the most part), have nothing to do with any specific invoice. If I recall, when you build your checks and choose to auto-apply credits at that time, the checks built seem to show that the credit is applied to the check. I haven't looked at that in a while and might be mis-remembering. From AR, that doesn't happen of course. As of now, there isn't any possible way to do what you are asking. Basically what you are saying is that you have a $200 payment and a $100 credit memo and then a $300 invoice. I would "apply" the credit memo to the cash receipt and so now the cash receipt has a $300 amount remaining. And now I can apply the $300 that is remaining on the cash receipt to the $300 invoice and it's all paid off. I'm pretty sure the apply API that is built into GP won't let that happen as I'm pretty sure it checks the apply to document type and won't let that happen. ANd if you can trick it into doing that then it's going to _reduce_ your amount remaining on the check when you apply the credit (because that is what typically should happen) so you'd have to work around that (increase the amount remaining not decrease it). And then assuming you can get that all to happen (likely with your own apply logic written from scratch) then my next thought is that if you reconcile your RM documents that it'll "fix" them all up again because this isn't supposed to be- from a GP perspective. So this likely isn't going to happen unless there is a major rewrite of RM in Great Plains- and I don't see that happening realistically. patrick mbs dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "JD" <JD@discussions.microsoft.com> wrote in message news:A1130469-6566-4036-A906-4051CF5A5FE7@microsoft.com... > Oh boy. I have not made myself clear. I apoligize for not being more > succinct. > > I have no desire to have the AR and AP in the same window (your last > sentence about PM/RM stuff together). No. What I meant was, that the credit > note issue I have exists in AR and it exists in AP. > > When in GP AR, credit notes marry themselves to invoices. When in GP AP, > credit notes marry themselves to invoices. In my business, credit notes (for > the most part), have nothing to do with any specific invoice. > > I reinterate, in my business, having 5 credit memos pay an invoice is > completely useless (and frustrating) information. > > I agree with you wholeheartedly about "A document has to be applied to > something". However, I want the credit note to be applied to a cheque (check > in the US), be it a customer cheque in AR, or a cheque that I am paying to a > vendor. > > That will resolve my problem with credit notes right there. Having credit > notes applied to a cheque, means that you can have one window listing all the > outstanding invoices and credit notes ON ONE SCREEN. It also means that you > can simply check off each box that represents what invoices and what credit > notes that you want to apply to that particular cheque. > > To me, that means "PROBLEM SOLVED". > > I don't want a credit note applied to any invoice; be it in AR or AP. I > want the credit note applied to a cheque. > > Did I do a better job this time? > > JD > > > > > "Patrick [MSFT]" wrote: > > > > > occasionally have one that is related, though I prefer the AccPac approach > > > (that program allows the same number to be issued as an invoice and credit > > > note - that way, there is a direct relationship between the credit note > > and > > > invoice - and no, manually checking and unchecking a posting box in GP is > > > asking for problems). > > > > In Great Plains, you also can have duplicate document numbers. The primary > > key on the table for RM is Document Number/RM Document Type All. > > > > > > > Great Plains forces a marriage of credit notes to invoices, whether there > > is > > > a relationship or not. And that makes no sense to me. > > > > > > > A document has to be "applied" to something. While a credit memo does > > affect your balance if you print a RM Statement with a $100 invoice and $100 > > credit memo, it'll print out the same way the next month unless you apply to > > them which reduces the remaining amount for each. Then a paid transaction > > removal puts them to history. > > > > > > > The option I am looking for, is simply have all the credit notes and all > > the > > > invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE > > > SCREEN whatever is applicable to the cheque. > > > > Well, we weren't (well, I wasn't) talking about vendors at all. I know the > > Consolidations module you define a customer/vendor relationship and you can > > provide refund checks for your customer credits or you can use > > Consolidations to take all the invoices/credits and make them one big lump > > amount. > > > > So when you say, "I want a screen where I can see all the debit docs & > > credit docs for a customer at once" then that is what I did. However note > > that this isn't anything at all to do with a check. > > > > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > > > information. > > > > Perhaps for your business but I guess I can't see why it wouldn't be. > > Remembering that I don't use this application in "real life", I could see > > that I would have perhaps an outstanding invoice (as a customer) for $1000. > > And because it's my birthday the vendor issues me a credit memo for $100. > > And then I find a problem with his product and to make me happy he issues > > another credit memo for $100. And then I return $800 of merchandise from > > last month but they don't issue cash refunds and so I get another $800 > > credit. So this isn't typical, I know as there would typically be me > > sending the vendor (you) some money to pay things off. > > > > Either way, however, you're still going to have to apply these records. In > > the RM Apply you'd have to pull up the credit documents one by one and apply > > them. In the window that I did, you would see them all like you asked. Or > > I thought you asked. > > > > Now if you were thinking that you want a window that shows PM/RM stuff > > together, that sounds a lot like the consolidations module. > > > > patrick > > mbs dev support > > > > -- > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > news:7CFF4A4B-CEB3-419B-8A9A-2794A36ADF14@microsoft.com... > > > I have credit notes that have nothing to do with any invoices. I > > > occasionally have one that is related, though I prefer the AccPac approach > > > (that program allows the same number to be issued as an invoice and credit > > > note - that way, there is a direct relationship between the credit note > > and > > > invoice - and no, manually checking and unchecking a posting box in GP is > > > asking for problems). > > > > > > Great Plains forces a marriage of credit notes to invoices, whether there > > is > > > a relationship or not. And that makes no sense to me. > > > > > > The option I am looking for, is simply have all the credit notes and all > > the > > > invoices outstanding for a customer (AR) or vendor (AP), and apply ON ONE > > > SCREEN whatever is applicable to the cheque. > > > > > > This would require the credit notes to be married to the cheque (not an > > > unsuspecting invoice). That is a fundamental programming issue. > > > > > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > > > information. > > > > > > Does that make sense? > > > > > > > > > > > > "Patrick [MSFT]" wrote: > > > > > > > One reason, I guess, for this is because people typically want to apply > > a > > > > certain credit document(s) to certain debit document(s). So if you had > > a > > > > window that you could pick 5 credit documents and 9 debit docuemnts how > > > > would you be assured what credit goes to what debit? You wouldn't > > really be > > > > able to. > > > > > > > > That said, actually I've recently written just such a window for a large > > > > customer. Basically you can check off and select the amount to apply/be > > > > applied to for the debits & credits and then goes through and assigns > > them > > > > in document order I think. The only drawback that I can see is they > > wanted > > > > a lot of columns to be displayed so the window is pretty big but that's > > how > > > > they wanted it. > > > > > > > > It was pretty complex to write to get the base functionality down as > > well as > > > > their specific features. I could send you the readme and a demo version > > > > that works in Fabrikam if you want to take a look at it. Email me at > > > > mbstools@microsoft.com. > > > > > > > > patrick > > > > mbs dev support > > > > > > > > -- > > > > This posting is provided "AS IS" with no warranties, and confers no > > rights. > > > > > > > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > > > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > > > > Whether you are making out a cheque, or recording a payment, have all > > > > > invoices and credit notes on the same screen to check the boxes of the > > > > items > > > > > that you want paid. Currently, Great Plains has credit notes on a > > > > separate > > > > > screen two or three clicks away from the invoices. Keep it simple, > > and > > > > have > > > > > everything on the same screen. > > > > > > > > > > ---------------- > > > > > This post is a suggestion for Microsoft, and Microsoft responds to the > > > > > suggestions with the most votes. To vote for this suggestion, click > > the "I > > > > > Agree" button in the message pane. If you do not see the button, > > follow > > > > this > > > > > link to open the suggestion in the Microsoft Web-based Newsreader and > > then > > > > > click "I Agree" in the message pane. > > > > > > > > > > > > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > > > > c.greatplains > > > > > > > > > > > > > > > > > > > >
Oh well. I guess the only thing that I can hope for, is when Microsoft amalgamates the programming language of Great Plains with Navison with Solomon and with whatever programs, that credit notes will be greatly simplified and be attached to cheques. That's my suggestion for Version 10. JD "Patrick [MSFT]" wrote: > JD, > > > > When in GP AR, credit notes marry themselves to invoices. When in GP AP, > > credit notes marry themselves to invoices. In my business, credit notes > (for > > the most part), have nothing to do with any specific invoice. > > If I recall, when you build your checks and choose to auto-apply credits at > that time, the checks built seem to show that the credit is applied to the > check. I haven't looked at that in a while and might be mis-remembering. > > From AR, that doesn't happen of course. > > As of now, there isn't any possible way to do what you are asking. > Basically what you are saying is that you have a $200 payment and a $100 > credit memo and then a $300 invoice. I would "apply" the credit memo to the > cash receipt and so now the cash receipt has a $300 amount remaining. And > now I can apply the $300 that is remaining on the cash receipt to the $300 > invoice and it's all paid off. > > I'm pretty sure the apply API that is built into GP won't let that happen as > I'm pretty sure it checks the apply to document type and won't let that > happen. ANd if you can trick it into doing that then it's going to _reduce_ > your amount remaining on the check when you apply the credit (because that > is what typically should happen) so you'd have to work around that (increase > the amount remaining not decrease it). And then assuming you can get that > all to happen (likely with your own apply logic written from scratch) then > my next thought is that if you reconcile your RM documents that it'll "fix" > them all up again because this isn't supposed to be- from a GP perspective. > > So this likely isn't going to happen unless there is a major rewrite of RM > in Great Plains- and I don't see that happening realistically. > > patrick > mbs dev support > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "JD" <JD@discussions.microsoft.com> wrote in message > news:A1130469-6566-4036-A906-4051CF5A5FE7@microsoft.com... > > Oh boy. I have not made myself clear. I apoligize for not being more > > succinct. > > > > I have no desire to have the AR and AP in the same window (your last > > sentence about PM/RM stuff together). No. What I meant was, that the > credit > > note issue I have exists in AR and it exists in AP. > > > > When in GP AR, credit notes marry themselves to invoices. When in GP AP, > > credit notes marry themselves to invoices. In my business, credit notes > (for > > the most part), have nothing to do with any specific invoice. > > > > I reinterate, in my business, having 5 credit memos pay an invoice is > > completely useless (and frustrating) information. > > > > I agree with you wholeheartedly about "A document has to be applied to > > something". However, I want the credit note to be applied to a cheque > (check > > in the US), be it a customer cheque in AR, or a cheque that I am paying to > a > > vendor. > > > > That will resolve my problem with credit notes right there. Having credit > > notes applied to a cheque, means that you can have one window listing all > the > > outstanding invoices and credit notes ON ONE SCREEN. It also means that > you > > can simply check off each box that represents what invoices and what > credit > > notes that you want to apply to that particular cheque. > > > > To me, that means "PROBLEM SOLVED". > > > > I don't want a credit note applied to any invoice; be it in AR or AP. I > > want the credit note applied to a cheque. > > > > Did I do a better job this time? > > > > JD > > > > > > > > > > "Patrick [MSFT]" wrote: > > > > > > > > occasionally have one that is related, though I prefer the AccPac > approach > > > > (that program allows the same number to be issued as an invoice and > credit > > > > note - that way, there is a direct relationship between the credit > note > > > and > > > > invoice - and no, manually checking and unchecking a posting box in GP > is > > > > asking for problems). > > > > > > In Great Plains, you also can have duplicate document numbers. The > primary > > > key on the table for RM is Document Number/RM Document Type All. > > > > > > > > > > Great Plains forces a marriage of credit notes to invoices, whether > there > > > is > > > > a relationship or not. And that makes no sense to me. > > > > > > > > > > A document has to be "applied" to something. While a credit memo does > > > affect your balance if you print a RM Statement with a $100 invoice and > $100 > > > credit memo, it'll print out the same way the next month unless you > apply to > > > them which reduces the remaining amount for each. Then a paid > transaction > > > removal puts them to history. > > > > > > > > > > The option I am looking for, is simply have all the credit notes and > all > > > the > > > > invoices outstanding for a customer (AR) or vendor (AP), and apply ON > ONE > > > > SCREEN whatever is applicable to the cheque. > > > > > > Well, we weren't (well, I wasn't) talking about vendors at all. I know > the > > > Consolidations module you define a customer/vendor relationship and you > can > > > provide refund checks for your customer credits or you can use > > > Consolidations to take all the invoices/credits and make them one big > lump > > > amount. > > > > > > So when you say, "I want a screen where I can see all the debit docs & > > > credit docs for a customer at once" then that is what I did. However > note > > > that this isn't anything at all to do with a check. > > > > > > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > > > > information. > > > > > > Perhaps for your business but I guess I can't see why it wouldn't be. > > > Remembering that I don't use this application in "real life", I could > see > > > that I would have perhaps an outstanding invoice (as a customer) for > $1000. > > > And because it's my birthday the vendor issues me a credit memo for > $100. > > > And then I find a problem with his product and to make me happy he > issues > > > another credit memo for $100. And then I return $800 of merchandise > from > > > last month but they don't issue cash refunds and so I get another $800 > > > credit. So this isn't typical, I know as there would typically be me > > > sending the vendor (you) some money to pay things off. > > > > > > Either way, however, you're still going to have to apply these records. > In > > > the RM Apply you'd have to pull up the credit documents one by one and > apply > > > them. In the window that I did, you would see them all like you asked. > Or > > > I thought you asked. > > > > > > Now if you were thinking that you want a window that shows PM/RM stuff > > > together, that sounds a lot like the consolidations module. > > > > > > patrick > > > mbs dev support > > > > > > -- > > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > > news:7CFF4A4B-CEB3-419B-8A9A-2794A36ADF14@microsoft.com... > > > > I have credit notes that have nothing to do with any invoices. I > > > > occasionally have one that is related, though I prefer the AccPac > approach > > > > (that program allows the same number to be issued as an invoice and > credit > > > > note - that way, there is a direct relationship between the credit > note > > > and > > > > invoice - and no, manually checking and unchecking a posting box in GP > is > > > > asking for problems). > > > > > > > > Great Plains forces a marriage of credit notes to invoices, whether > there > > > is > > > > a relationship or not. And that makes no sense to me. > > > > > > > > The option I am looking for, is simply have all the credit notes and > all > > > the > > > > invoices outstanding for a customer (AR) or vendor (AP), and apply ON > ONE > > > > SCREEN whatever is applicable to the cheque. > > > > > > > > This would require the credit notes to be married to the cheque (not > an > > > > unsuspecting invoice). That is a fundamental programming issue. > > > > > > > > Having 5 credit memos pay an invoice (and not a cheque) is not useful > > > > information. > > > > > > > > Does that make sense? > > > > > > > > > > > > > > > > "Patrick [MSFT]" wrote: > > > > > > > > > One reason, I guess, for this is because people typically want to > apply > > > a > > > > > certain credit document(s) to certain debit document(s). So if you > had > > > a > > > > > window that you could pick 5 credit documents and 9 debit docuemnts > how > > > > > would you be assured what credit goes to what debit? You wouldn't > > > really be > > > > > able to. > > > > > > > > > > That said, actually I've recently written just such a window for a > large > > > > > customer. Basically you can check off and select the amount to > apply/be > > > > > applied to for the debits & credits and then goes through and > assigns > > > them > > > > > in document order I think. The only drawback that I can see is they > > > wanted > > > > > a lot of columns to be displayed so the window is pretty big but > that's > > > how > > > > > they wanted it. > > > > > > > > > > It was pretty complex to write to get the base functionality down as > > > well as > > > > > their specific features. I could send you the readme and a demo > version > > > > > that works in Fabrikam if you want to take a look at it. Email me > at > > > > > mbstools@microsoft.com. > > > > > > > > > > patrick > > > > > mbs dev support > > > > > > > > > > -- > > > > > This posting is provided "AS IS" with no warranties, and confers no > > > rights. > > > > > > > > > > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > > > > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > > > > > Whether you are making out a cheque, or recording a payment, have > all > > > > > > invoices and credit notes on the same screen to check the boxes of > the > > > > > items > > > > > > that you want paid. Currently, Great Plains has credit notes on a > > > > > separate > > > > > > screen two or three clicks away from the invoices. Keep it > simple, > > > and > > > > > have > > > > > > everything on the same screen. > > > > > > > > > > > > ---------------- > > > > > > This post is a suggestion for Microsoft, and Microsoft responds to > the > > > > > > suggestions with the most votes. To vote for this suggestion, > click > > > the "I > > > > > > Agree" button in the message pane. If you do not see the button, > > > follow > > > > > this > > > > > > link to open the suggestion in the Microsoft Web-based Newsreader > and > > > then > > > > > > click "I Agree" in the message pane. > > > > > > > > > > > > > > > > > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > > > > > c.greatplains > > > > > > > > > > > > > > > > > > > > >
I would be very interest in this as well Thanks. Tom A. "Patrick [MSFT]" wrote: > One reason, I guess, for this is because people typically want to apply a > certain credit document(s) to certain debit document(s). So if you had a > window that you could pick 5 credit documents and 9 debit docuemnts how > would you be assured what credit goes to what debit? You wouldn't really be > able to. > > That said, actually I've recently written just such a window for a large > customer. Basically you can check off and select the amount to apply/be > applied to for the debits & credits and then goes through and assigns them > in document order I think. The only drawback that I can see is they wanted > a lot of columns to be displayed so the window is pretty big but that's how > they wanted it. > > It was pretty complex to write to get the base functionality down as well as > their specific features. I could send you the readme and a demo version > that works in Fabrikam if you want to take a look at it. Email me at > mbstools@microsoft.com. > > patrick > mbs dev support > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "JD" <JD@discussions.microsoft.com> wrote in message > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > Whether you are making out a cheque, or recording a payment, have all > > invoices and credit notes on the same screen to check the boxes of the > items > > that you want paid. Currently, Great Plains has credit notes on a > separate > > screen two or three clicks away from the invoices. Keep it simple, and > have > > everything on the same screen. > > > > ---------------- > > This post is a suggestion for Microsoft, and Microsoft responds to the > > suggestions with the most votes. To vote for this suggestion, click the "I > > Agree" button in the message pane. If you do not see the button, follow > this > > link to open the suggestion in the Microsoft Web-based Newsreader and then > > click "I Agree" in the message pane. > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > c.greatplains > > >
Thank you for your support ! I waste a lot time following up on supplier requests about invoices that were "paid" by credit notes, when what I am looking for is a cheque number for the supplier to reconcile their records. Even DOS Bedford from 25 years ago or DOS AccPac from 17 years ago had that figured out, why Microsoft today can't ... is a mystery. JD "Tom A" wrote: > > I would be very interest in this as well > > Thanks. > > Tom A. > > > "Patrick [MSFT]" wrote: > > > One reason, I guess, for this is because people typically want to apply a > > certain credit document(s) to certain debit document(s). So if you had a > > window that you could pick 5 credit documents and 9 debit docuemnts how > > would you be assured what credit goes to what debit? You wouldn't really be > > able to. > > > > That said, actually I've recently written just such a window for a large > > customer. Basically you can check off and select the amount to apply/be > > applied to for the debits & credits and then goes through and assigns them > > in document order I think. The only drawback that I can see is they wanted > > a lot of columns to be displayed so the window is pretty big but that's how > > they wanted it. > > > > It was pretty complex to write to get the base functionality down as well as > > their specific features. I could send you the readme and a demo version > > that works in Fabrikam if you want to take a look at it. Email me at > > mbstools@microsoft.com. > > > > patrick > > mbs dev support > > > > -- > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > > "JD" <JD@discussions.microsoft.com> wrote in message > > news:8B42979C-FF91-4F5B-A0A1-C7CD8D0A7379@microsoft.com... > > > Whether you are making out a cheque, or recording a payment, have all > > > invoices and credit notes on the same screen to check the boxes of the > > items > > > that you want paid. Currently, Great Plains has credit notes on a > > separate > > > screen two or three clicks away from the invoices. Keep it simple, and > > have > > > everything on the same screen. > > > > > > ---------------- > > > This post is a suggestion for Microsoft, and Microsoft responds to the > > > suggestions with the most votes. To vote for this suggestion, click the "I > > > Agree" button in the message pane. If you do not see the button, follow > > this > > > link to open the suggestion in the Microsoft Web-based Newsreader and then > > > click "I Agree" in the message pane. > > > > > > > > http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=8b42979c-ff91-4f5b-a0a1-c7cd8d0a7379&dg=microsoft.publi > > c.greatplains > > > > > >
I would love this functionality...
For PM or RM? A window so that you could see all the RM debits/credits on one screen? patrick dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "Bradley" <Bradley@discussions.microsoft.com> wrote in message news:7B4A4FFD-FF47-4728-B81C-FB91BA7BD85D@microsoft.com... >I would love this functionality...
Hi Patrick, AP ... Basically a way to set a due date for Credit Memo's so that all CM's are not applied when selecting to auto apply CM's when doing check runs. Imaging 100 invoices and 100 credit memo's. Each invoice has a credit memo. Only 20 of the invoices are due this month. A check run to pay anything due this month would apply all 100 credit memo's against the first 20 invoices. Imagine what the vendor will say when they receive a check that has 100 credit memo's applied to it and only 20 of the invoices due. They are going to go crazy and why are you deducting all the credit memo's without making payment on the corresponding invoices. Now imagine that this process is always in motion and there are 400 credit memos and about 500 invoices per week. There's no way for a clerk to apply creidt memo's to invoices one-by-one. That would be a full time resource. AccPac (yeah I know, super old system) lets you do negative invoices with due dates, that works the best in my opinion. Thanks, "Patrick [MSFT]" wrote: > For PM or RM? A window so that you could see all the RM debits/credits on > one screen? > > patrick > dev support > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Bradley" <Bradley@discussions.microsoft.com> wrote in message > news:7B4A4FFD-FF47-4728-B81C-FB91BA7BD85D@microsoft.com... > >I would love this functionality... > > >
We would like that for AR. Thank you "Patrick [MSFT]" wrote: > For PM or RM? A window so that you could see all the RM debits/credits on > one screen? > > patrick > dev support > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Bradley" <Bradley@discussions.microsoft.com> wrote in message > news:7B4A4FFD-FF47-4728-B81C-FB91BA7BD85D@microsoft.com... > >I would love this functionality... > > >
Bradley, I'm trying to think if I've done this as a customization before or not. Or just talked about doing it. Or looked at it? Hard to say anymore as we've done so many projects. But it sounds familiar. I guess the first thing I'd look at was maybe testing in Fabrikam. After you post your credit memo, go into the back end in SQL and set the Due Date to what you want it to be (if the ui would let you). Now go into the select checks window and set your due date restriction. The theory is that IF you could set this field then this process would happily work and respect your Due Date cutoff. If so, then potentially you could do a customization to allow this Due Date to be entered by the user. Or if not, then run something on the back end in SQL to modify the data at some point it is how you want it. And then the select checks apply credits would do what you wanted. If however this doesn't work, then it means that since it is a credit doc our code doesn't look at that. On one hand it would make sense it does not since we didn't expect this. On the other hand, you never know - it might work. patrick dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "Bradley" <Bradley@discussions.microsoft.com> wrote in message news:DB276867-E3C1-4F1C-84BA-2D39A7633E69@microsoft.com... > Hi Patrick, > > AP ... Basically a way to set a due date for Credit Memo's so that all > CM's > are not applied when selecting to auto apply CM's when doing check runs. > Imaging 100 invoices and 100 credit memo's. Each invoice has a credit > memo. > Only 20 of the invoices are due this month. A check run to pay anything > due > this month would apply all 100 credit memo's against the first 20 > invoices. > > Imagine what the vendor will say when they receive a check that has 100 > credit memo's applied to it and only 20 of the invoices due. They are > going > to go crazy and why are you deducting all the credit memo's without making > payment on the corresponding invoices. > > Now imagine that this process is always in motion and there are 400 credit > memos and about 500 invoices per week. There's no way for a clerk to > apply > creidt memo's to invoices one-by-one. That would be a full time resource. > > AccPac (yeah I know, super old system) lets you do negative invoices with > due dates, that works the best in my opinion. > > Thanks, > > "Patrick [MSFT]" wrote: > >> For PM or RM? A window so that you could see all the RM debits/credits >> on >> one screen? >> >> patrick >> dev support >> >> -- >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Bradley" <Bradley@discussions.microsoft.com> wrote in message >> news:7B4A4FFD-FF47-4728-B81C-FB91BA7BD85D@microsoft.com... >> >I would love this functionality... >> >> >>
As it turns out, I have created this solution created already a few years ago. In it, you can choose your customer and see the list of all open debit/credit documents. You mark the ones to apply and the amounts you want to apply (it defaults to full when you click the checkbox) and press the button and the app spins through the credits and applies them in some order to the selected debits up the amount specified. Then you get a report showing the results. As this was a customization created for a customer I couldn't give it away but could offer it as a customizaton to you as well. You could email mbsprosv@microsoft.com if you have an interest. They'll pass it along to me and I could send you the demo version that works in Fabrikam. patrick dev support -- This posting is provided "AS IS" with no warranties, and confers no rights. "Terry" <Terry@discussions.microsoft.com> wrote in message news:10226185-59CC-44E4-8A9F-7B56D4793485@microsoft.com... > We would like that for AR. > > Thank you > > "Patrick [MSFT]" wrote: > >> For PM or RM? A window so that you could see all the RM debits/credits >> on >> one screen? >> >> patrick >> dev support >> >> -- >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Bradley" <Bradley@discussions.microsoft.com> wrote in message >> news:7B4A4FFD-FF47-4728-B81C-FB91BA7BD85D@microsoft.com... >> >I would love this functionality... >> >> >>
Kind of addressing this to Patrick, but to everyone else as well that can help: Just scrolling through and found this thread very interesting. I to as a partner am working with a client that is looking for functionality with in the AP side as follows: They deal with vendors that they issue a lot of credit memos for, and at the same time have invoices for as well. I a specific pay run they want to deduct specific credit memos from invoices that they know are due, in my case those I can't use due date because credit memos on account are really tied to specifc invoices that will be posted. So currently the only way for the client to apply these credit memos is during the check process they go and edit a check and then manually pull up each credit memo and apply it to invoices that should be paid on that check. After they have manually selected each credit memo they then can click of the remaining invoices to pay to create a final check amount to cut. What the client is asking for is really the same thing that it sounds like you have created on the A/R side. They would like to have a screen that would list all deduction type documents (credit memos, returns.....) in a screen and on the same screen list all positive type documents (Invoices, Debit Memos.....) for the vendor that they wish to create a check for. They would go through and select what documents they would like to include on this check, (credit memos and Invoices) and then the final result would create a check for the remaining amount left on the invoices after the deductions have been taken. Have you created something like this Patrick or not, and do you think it is even possible since it is a little different from the A/R side. Any input would be greatly appreciated. Thanks Joel