web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Apply AR payments to l...
Microsoft Dynamics GP (Archived)

Apply AR payments to line item detail

(0) ShareShare
ReportReport
Posted on by Ladd Sustar 815

All,

Does anyone know of a third-party app that allows you to apply AR payments to line item detail (either receivables or SOP) vs the total invoice?Or has anyone done a customization to allow for this? If so, what issues did you encounter?Can this be done?This is a Pharmacutical company that gets their payments from third parties.

Any information would be helpful

Ladd Sustar

*This post is locked for comments

I have the same question (0)
  • Jeff Petersen Profile Picture
    Jeff Petersen 20 on at
    Re: Apply AR payments to line item detail

    Ladd

    Did you find a solution for this?

    Jeff

  • Community Member Profile Picture
    Community Member on at
    Re: Apply AR payments to line item detail

    Hi Ladd,

    We have completed a customisation for this for one of our customers.

    It is very complex since you can unapply / void / delete / re-apply documents etc., and you have to accept a few limitations, but it works well for the purposes of our customer.

    If you want to discuss drop me a mail.

    Best regards,

    Ian.

  • Ladd Sustar Profile Picture
    Ladd Sustar 815 on at
    Re: Re: Apply AR payments to line item detail

    No, we never did.

    Ladd

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: Apply AR payments to line item detail

    One way I have seen this addressed is to create a separate GP 'invoice' for each line item.  Then, based on some business rules these GP 'invoices' would get grouped into a customer invoice (a custom report typically in Crystal or SQL Reporting Services)...so what your customer would get is a multi line invoice, but in reality it's made up of as many GP invoices as there are lines.  With this setup, customer payments can be applied to each individual 'line item' since each is really a separate transaction.  No customization needed except the customer facing invoice report.  This won't work for every situation, but we have several customers that this works for very well.

  • Majid_rs Profile Picture
    Majid_rs 70 on at
    Re: Re: Apply AR payments to line item detail

    Yes, I agree with Victoria, its better to not to customize GP.

    Instead of that you can create the Sales Order for all the line items as is, then for each and every line transfer the SO to Sales Invoice, by this your customer can acheive his need and we can deliver the solution without any customization done specially on SOP, which will create obstacles during upgrade.

     

    Regards

    Mohammed Majid Ahmed 

     

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Apply AR payments to line item detail

    Victoria's and Mohammad's solutions are good solutions, however Mohammed's comment that you shouldn't customise GP is a bit harsh. I wouldn't like users to get the wrong idea that customising GP is not a valid way to add functionality or that it is always inadvisable to go down this road.

    For sure both workarounds (entering individual SOP invoices, or transferring orders line by line) are valid and good. However this will not always be feasible or desirable, for example where the volume of line items is large. If you have a SOP invoice with 200 line items, there will be a considerable overhead involved in manually entering each one onto its own invoice, or transferring each one from a SOP Order individually.

    It is also worng to say that customising SOP will cause problems at upgrade. For sure, SOP is a complicated module, but it is a good candidate for customisation once you are experienced and understand how it hangs together. Most of our customers have modifications to SOP and upgrades have never been an issue. Having said that, we have come across some terrible SOP customisations over the years, but it is always down to the original developer making assumptions and not having enough experience with the module.

    Our customisation mentioned above is to RM and not to SOP, specifically the RM apply routines. It builds a seperate Line Apply table and is independent of SOP. Its probably worth noting that the Apply routines are complex when you consider all of the actions that can happen a SOP invoice, return, rm invoice, rm credit note, payment, voids, NSF's etc.. I would therefore agree somewhat with Mohammad, if a manual workaround works for you, then its always best to maybe re-consider going down the development route.

    Best regards,

    Ian.

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,768 on at
    Re: Re: Re: Re: Apply AR payments to line item detail

    I think Ian makes some excellent points and I agree wholeheartedly with what he is saying.

  • Ladd Sustar Profile Picture
    Ladd Sustar 815 on at
    Re: Re: Re: Re: Re: Apply AR payments to line item detail

    Thanks for all the suggestions.  I am going to give Ian's suggestions a try. I will update this message and let everyone know how I make out.

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Apply AR payments to line item detail

    Hi Ian

    I have a very peculiar request. We are using GP 10.0 with SP3. Our co. wishes to use the SOP invoice module only to record the inventory trx and that too only to update the stocks. Basically when i post the Invoice from SOP module, i do not want it to create records in Receivables tables or in GL. For GL,i know its quite simple by unmarking the posting option. But to prevent in AR am not sure. I have customised by zeroising the extended prices and all values except the costs in the SOP tables b4 posting and also deleting the SOP10102 records. I attained almost what was required, except that when it posts, it picks the cost from somewhere and creates AR records for the cogs and inv and also in GL. Can anyone help me with this customisation. Basically, when posting from SOP invoice, i want recs in SOP30200 tables and IV30300 tables and also stocks to be updated in IV00102 tables. But i do not want any recs in AR tables and GL tables. The posting for sales & recv are blocked by my customisation, bcos of the event that i mentioned b4. But the distri for inv and cogs happens during posting and it picks the cost of the products from somewhere. As a  test case, i even wrote codes to temporarily make current cost of the product to zero in the item master, but even then, it has picked the cost from somewhere and created distri for inv and cogs. Pls help someone as i am really desperate and need to close this issue by tomorrow.

  • Majid_rs Profile Picture
    Majid_rs 70 on at
    Re: Re: Re: Re: Re: Apply AR payments to line item detail

    Hi,

    Sorry for my interruption Ian, Manicut is expecting the reply from you.

    Manikut, as I understand that you don't want to update GL nor AR, you just want to raise the invoice to customer and update Inventory balance.

    If this is correct then you can modify the Sales Order and name it as Sales Invoice, and transfer the quote to Sales Order so you can print the Sales Order (as Sales Invoice), then go to Item Fulfillment to dispatch the quantity so your Inventory will be deducted. I think this will solve your purpose, if not then Ian can help you with some customization tips

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans