Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How do I get Sales Invoices to post to GL and Receivables Management (AR sub-ledger)?

(0) ShareShare
ReportReport
Posted on by 35

I'm new to GP 10.0 and am trying to figure out the best way to set up AR Invoicing so we can send professional looking invoices for services (non-inventory items) we provide to customers. From other postings it looks like SOP is the preferred method but all the examples are geared more towards companies that sell inventory and not services.

 

In testing I've created invoices both through SOP Sales Process and Invoice Entry and been able to print the invoice without issue. When I Post from SOP(Sales Batches) or Invoice Batches nothing goes to the GL or to Receivables Management to update the customers AR account on the AR sub-ledger.

 

When I post I get a report: Sales (or Invoice) Posting Journal that shows the invoice details including the GL account distribution. Then I also get a Distribution Breakdown report for Summary and Detail and it is always blank  with no transaction data.

 

I also tested creating a Sales/Invoice entry through the Receivables Transaction Entry form and that does correctly post to the Customers AR account on the AR sub-ledger and to the GL. But the invoice does not look professional and it won’t let me enter multiple items – for when I need to invoice for several services that we provide – it just lets me enter in 1 total sales amount.

 

I’ve gone through the user guide on setting up Posting and I think I’ve got it correct. I selected “Customer” option under “Posting Accounts From”, as we don’t have Inventory items. I’ve made sure the test Customer has a Sales & AR GL account assigned and that under Posting Accounts I set up an account for AR and Sales.  The Posting set up seems very similar to how AP is set up and AP correctly posts to the AP sub-ledger and the GL.

 

I’ve obviously missed something and was wondering if anyone had tips on where I should look?  Thank you for the help.

 

Megan

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    Re: How do I get Sales Invoices to post to GL and Receivables Management (AR sub-ledger)?

    For starters, if you want truly professional looking invoices you need to upgrade to GP2010 so you can use templates. If that is not an option, you are correct in that AR invoices only allows you to enter a customer number, date, dollar amount. There are no details on an AR Invoice so that leaves you with using the Invoicing module. If all of you want are to list services as items, then setup all of your items as service items. Make sure you set at least the sales, inventory and cost of sales GL accunts on each item. You also set a universal AR GL account under Tools->Setup->Posting->Posting Accounts. Finally, under Tools->Setup->Posting->Posting choose the Sales module and make sure you have the correct posting setting for Invoice Entry. You want the setting to be Post To GL and then Post Through GL to be off. Once you get used to posting then you can switch Post Through GL also to be on, unless you want someone to review the GL batches prior to posting. It sounds like the setting to Post to GL is unchecked.

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: How do I get Sales Invoices to post to GL and Receivables Management (AR sub-ledger)?

    It is difficult to see how you tested, but there are different document types (quote, order, invoice, and return) in SOP.   Invoice and Returns are the only ones that will post.   You can use inventory items there for service items and may consider setting them up as 'service' type items.   You do not need to track quantities then.   In SOP setup, you can select to pul GL from the item or the customer, which would allow the different types of services go to different GL codes (if it applies).   But based on you example, I would double check the doc type to make sure it was not quote or order.   In User Preferences, you can enter a default doc type and can change it to invoice in your scenario.  

    Dan Liebl | Senior Consultant | OTT,Inc | dliebl@OTT-inc.com

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans