Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Judi Gilliland]

HI

Our company is new to GP.  Once a batch is posted in AP do the transactions flow directly to the GL or do we need to do another step?

Thanks

——————————
Judi Gilliland
Powell Christensen inc
GRANDVIEW WA
——————————

[Frank Heslin]

Hi Judi,

It depends on how your Posting Setup was configured.  Here is a quick explanation for ‘Post To’ & ‘Post Through’ GL

Post To: will create a GL Batch that needs to manually posted in the Financial module.

Post Through: will create a GL Batch & post to the Financial module without the need for any further action.

These settings can be different for each Series, as well as, each Origin depending on your business rules/needs.

Check Series Post in the Financial module to see if there are any batches that need to be posted.

 Let us know if you need any further assistance.

——————————
Frank Heslin
Financial Systems Administrator
ExamWorks, Inc.
Atlanta GA

Member, GPUG Advisory Committee
Chairman, Georgia Regional GPUG Chapter
Summit 2016 Track Leader

GP2015 R2
MR CU14

Follow me on Twitter: @Automate_It

GPUGGA – http://www.gpug.com/Atlanta

*** Help Us, Help You…provide enough info so that we don’t have to ask for more:) ***
*** If you solve your issue please share the solution to assist others! ***
——————————
——————————————-

[Windi Epperson]

Judi,
Just a quick word of caution.  In the Posting setup window, when you choose a Series, there is an Origin of All that defaults in with base values set.  If you change settings at the All level, they will roll down to all the other Origins – but the next time you pull up the All option, it will show with the default settings again.  So it’s recommended that you don’t change at the All level, but change at each specific Origin level to ensure you have each option doing what you need it to.
Thanks
Windi

——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————-

[Amber Bell]

I wanted to add something to the discussion. If your users are posting without a batch (posting from the transaction screen without adding a Batch ID), the transaction will post in the Subledger (in this case AP) and will create an unposted batch in the GL. This is because basically, without a batch, the original transaction could not be reviewed (because you cannot print an Edit List without a batch).

Microsoft Dynamics GP is designed to “Protect” the GL. Skipping using a batch does not save time for your company…it just pushes the job to another person. I recommend using batches (even for 1 transaction) and disabling “Allow Transaction Posting” in the Admin > Setup > Posting > Posting window.

I have 2 more recommendations:

1. Create Journal Entry per TRANSACTION. If you do “Per Batch”, you cannot use the Financial > Routines > Reconcile to GL Report or “The Closer” from Reporting Central. The details of the transactions will not be stored on the normal tables…and you can’t do an easy report to say “What accounts did this vendor use this month?”.

2. If Existing Batch CREATE NEW. This will create a separate batch in the GL for each Subledger batch. Makes reprinting of reports easier…and if for some reason it didn’t post through, you will have separate batches in the GL vs. one giant mega batch with transactions in multiple dates (or possibly periods).

See attached screenshot.

Let me know if you have any questions,

——————————
Amber Bell
Owner
Training Dynamo LLC
Derby CT
——————————
——————————————-

[Bert Green]

Amber,
I have to disagree with your #1. We have the JE by batch and the Reconcile to GL works just fine. On the Account Maintenance card the level of posting from series is what controls if you can run by g/l to see what accounts a vendor was posted to for a period of time. If you post in Detail you would be able to run that report. If it was Summary then no you would not be able to.

How we are setup is all P&L accounts post in Detail and Balance Sheet accounts are a mixture of detail or summary.

——————————
Bert Green
GP Developer/GP Administrator
Berger Transfer & Storage, Inc.
Saint Paul MN
GP2015/MR CU11
——————————
——————————————-

[Amber Bell]

Hello Bert,

You are right, you can have a combination of Summary and Detail posting based on Account Maintenance settings. I did not include this in the original answer…thank you for adding this option.

Be advised that Reporting Central recommends detail posting for their tool “The Closer” and I would recommend testing “Summary” posting to make sure that you can get the reports you need and that all tools for reconciling work correctly. I have seen people change to “Summary” and not understand the options on the Account Maintenance screen.

If anyone is interested in making this change, please test and discuss with your partner.

——————————
Amber Bell
Owner
Training Dynamo LLC
Derby CT
——————————
——————————————-

[Leslie Vail]

Something else about making the settings on the Account Maintenance card to work is that you need to check the box on your posting setup window. You need to select Create Journal Entry per Batch and then mark the checkbox next to Use Account Settings.

Kind regards,

Leslie

——————————
Leslie Vail
Accounting Systems Consulting, Inc.
Dallas TX
——————————
——————————————-