Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

What is the difference between Financial/Transactions/Batch and a Sales/Transactions/Invoicing Batches ...

(0) ShareShare
ReportReport
Posted on by 545

What is the difference between Financial/Transactions/Batch and a Sales/Transactions/Invoicing Batches other than the Financial batch allowing a number of "Frequency" recursion options other than "Single Use" (of which is the only Frequency option available to an Invoicing Batch)?

The reason I ask is I am able to manually create a new Sales/Transactions/Invoicing Batch and modify it within the Financial/Transactions/Batch entry editor, and visa versa assuming I type in the Batch ID rather than selecting it from a list using the search magnifying glass. The only visual difference I can see is the "Origin:" value is displayed/saved differently depending on whcih entry editor is used to view/save the entry and, of course, the "Frequency:" value is always "Single Use" when the batch is viewed in the Invoice Batch entry editor (see below).  I have to presume the "Origin:" value is used for contextual entry filtering during magnifyingglass based searches.

I have been asked to write software of which will manage recurring Inovices in the hopes of reducing manual work-load and data entry errors.  Ultimately, I will be creating recurring Invoices progammatically and I would like to programmatically handle recurring invoices via these batches allowing GP to handle the Invoice process schedule.  Not all programmatically submitted invoices will be recurring.  Some will be handled via Single Use batches. And, not all invoices will be created programmatically. Quite often, there will be manual batch and invoice entry.

My concern is this:  "If" I am able to create the recurring batch as shown above on the left and programmatically stuff it with Invoices such that those invoices "join" the recurring schedule and are handled by GP, would this cause any "weirdness" in GP (Reporting wise, General Ledger wise, Manual Data Entry wise, etc..)?   I do understand if I create the Invoicing Batch on the left and manually edit and save it using the Sales/Invoicing Batch entry editor I will loose my Recursion and Origin attributes.

 

 

*This post is locked for comments

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: What is the difference between Financial/Transactions/Batch and a Sales/Transactions/Invoicing Batches ...

    Hi Donald,

    I may be misunderstanding but these are actually totally different, one is a GL specific batch and the other for Sales.  If a Sales Order Processing batch is created called "06/25/2012", a batch with the same name can be created in the Financial series.  These are totally unrelated batches at this point.

  • Donald Ashworth Profile Picture
    Donald Ashworth 545 on at
    Re: What is the difference between Financial/Transactions/Batch and a Sales/Transactions/Invoicing Batches ...

    That makes complete sense to me.  I'll research Repeating Documents in SOP.  Thanks!

    However, is is normal to be able to view and change a Single Use Invoice Batch entry within the Financial/Transactions/Batches/Batch Entry editor when an Invoice Batch Batch ID is typed into the Batch ID field and opened?  This goes the other way too.  Looks like the Origin: and Frequency: fields are modified when saved.

    Thanks again for Mike S and Mike Hamelly's recommendations.

    Don

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: What is the difference between Financial/Transactions/Batch and a Sales/Transactions/Invoicing Batches ...

    I’m in agreement with Frank, I would explore the use of the recurring/repeating order functionality within GP’s Sales Order Processing.

    The primary difference between the Financial Batches and Sales/Invoice Batches is that a transaction entered in a Financial level batch will be a GL only transaction, there is no insight into the customer or products sold for any transaction.  A transaction entered from Sales Transaction Entry allows your organization to track customer and item specific information as it ties to any transaction.  When a transaction is posted from the Sales series in GP, it will update the associated customer record for future collections, update inventory, track commissions, calculate sales tax, and other items.

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: What is the difference between Financial/Transactions/Batch and a Sales/Transactions/Invoicing Batches ...

    Donald, you might want to look at Repeating Documents in Sales Order Processing.  Orders with an SOP Order ID that allows repeating documents can be set to repeat for a specified number of times and frequency, just like a recurring batch.  See details on the Repeating Document in Chapter 3 of the Document Setup section of the Sales printable manual.

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans