Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Posting Accounts

Posted on by 815

We've always had our posting accounts configured to use the Item card for the default information, but I suspect that this is giving us a skewed view of our profitability reporting, and I'm trying to figure out if we can't change that to report based on teh customer account information.  I know that it won't be as simply as switching the setting in the SOP setup. ;-)

I don't, however, want to account for inventory according to the customer that it was sold to.  I saw a post last month that  indicated that some accounts come from the item, regardless of the setting in the SOP setup.  Would I be correct in thinking that includes the inventory account?  The help doesn't appear to specify that.  To clarify, I'd liek to report Sales & Cost Of Sales according the the customer (territory) but still have the inventory accounted for by the inventory classifications that we currently use. (basically, groups of like products)

The other thing (that I should probably wait to ask) is the settings for different shipping adresses on one customer.  If the Sales & Cost Of Goods accounts come from the customer, but different addresses (that the customer has) should be credited as Revenue in different territories, can we do that?  (or will we have to set up entirely different accounts)?

Any input is greatly appreciated.

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Re: Re: Posting Accounts

    Hi D. Yep, understood.

    Analytical Accounting might be worth a look - but it will add a bit of complexity to data entry.

    Ian.

  • Dee Bee Profile Picture
    Dee Bee 815 on at
    Re: Re: Re: Re: Re: Re: Posting Accounts

     Ian-

    Thanks for your input - no worries about the late reply (as is apparent by my later response!)

    In fact, the way you're suggesting is the way we're doing it currently, however, the GL reports are easier to generate and, as they're the way we report in the GL, they're 'sanctioned' by accounting.  They are 'accounting' reports - the other reports were generated by the sales department, and therefore aren't a part of our periodic reporting.  I asked originally because it seems to me that we've been doing it backwards, and I wanted to challenge it to see what the best practices are.

    In reality, I think that we're going to have to simply make the Territorial reports 'more official', and keep the GL the way it is, as much as I don't like 'status quo' as a strategy.

    ;-D

     

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Re: Posting Accounts

    Hi,

    The Invoicing module is accessed via Sales>Invoicing. It was the predessecor to SOP. I tried changing the inventory account to the customer and I still could not get it to pull from the customer - it still pulled the inventory account from the item.

    Richard,

    Please tell me how to get the inventory account on the customer card to be used.

    Thanks!

    Leslie

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: Re: Re: Re: Posting Accounts

    Hi all, joining this post late but reading through it, something struck me.

    Why are you trying to get all your analysis from the GL? You speak of territories. Are these sales territories?  Could you use the salesperson ID and / or the Sales Territory ID to analyse your sales data? You post to common accounts in your GL, and get the analysis from the sub module - in this case the Sales Module...by using sales territories.

    Each Debtor Address ID can have a seperate Sales Territory ID, Salesperson ID, and User Defined 1 and 2. Any of these fields could be used to group and analyse your sales reports. Ok, its not on the fact of your P&L Account...but you do get the analysis you want without any user intervention (other than assigning Territories to Debtor Address ID's)

    Just another option to consider rather than trying to bend GP to your will, or investing in an add on 'GL Distributions' module.

    Best regards,

    Ian.

  • Dee Bee Profile Picture
    Dee Bee 815 on at
    Re: Re: Re: Re: Posting Accounts

    Leslie-

    I'm not sure what the answer is.  I know that the profitability detail that we're currently getting out of the financials gives me product line info, but we don't have product line management, we have territorial management, so it's difficult to slice the data into meaningful pieces.  (I've befriended Crystal Reports!)

    In reality, there are only a few accounts that straddle territories, but it's enough that it's a problem.  Seperate accounts may be the only option if I need to make this transition.

    My response to Richard (above) details our sales entry and invoicing process.

    ;-D

  • Dee Bee Profile Picture
    Dee Bee 815 on at
    Re: Re: Re: Re: Posting Accounts

    Richard-

    I'm not sure that I know the difference.  I'll describe the process that we go through, please understand that this certainly may not be the best practice (I'm online here to migrate our processes to a best practice!)

    We enter sales orders through Sales -> Transaction -> Sales Transaction Entry.  Once the order ships, it's added to a daily sales batch (of orders that shipped that day), and then that sales batch is transferered to invoices, where the freight (etc.) is added, and they're printed.

    I don't know if that's the "Invoicing Module".  I just checked with our A/R person, because I fully expected that she would use the Sales -> Transaction -> Invoice Entry, but I was wrong - she described the above batch process to me.

    Should I be considering another invoicing process?

    ;-D

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Posting Accounts

    Dee Bee -

    That's a tough one for 'out of the box'. So, do we essentially need a set of accounts for each address ID instead of just each customer? You could finesse this if you were importing the transactions - it wouldn't be that difficult using VB Script to adjust the account distributions. How are the sales being entered?

    Kind regards,

    Leslie

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Re: Posting Accounts

    The Inventory Account in the customer card is used ONLY for the invoicing module and not for SOP.  That module does not really track inventory but debits and credits this account for sales.

  • Dee Bee Profile Picture
    Dee Bee 815 on at
    Re: Re: Posting Accounts

    (P.S. Leslie: Yours was the earlier message to which I referred)

  • Dee Bee Profile Picture
    Dee Bee 815 on at
    Re: Re: Posting Accounts

    Leslie-

    Thanks for your reply - that's exactly what I was imagining, and hoping for.  (It does seem strange that the Inventory related posting accounts exist in the customer record, I'm glad I'm not alone in my suspicion of that)

    I'm going to set up some test configurations and varify that the "posting accounts by customer" gives us what we want.

    Any thoughts about how to handle addresses for a single customer that span territories (and hence need different Sales & CoGS posting accounts?)

    ;-D

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans