510
Hi All
I think that's a silly question .. !
Actually .. i often using Reconcile especially to reconcile the Item Stock
but i just want to know much more what Reconcile really is,
the functionality of the Reconcile on GP such when we used it and when we are not.
Such in Finance, Sales, Purchasing, etc
Anyone can explain or maybe some link for me to learn much more.
Thanks in advance
Dedy
*This post is locked for comments
Hello Dedy,
Glad to hear that this information was helpful for you. If you have any other questions please let us know.
Best regards,
Brad G
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
community.dynamics.com/.../default.aspx
This posting is provided AS IS with no warranties, and confers no rights
Hi Bradley
Great answer .. and thank you very-very much for your complete explanations
Now i am much more deeply understand what Reconcile do on GP.
Regard
Dedy
Hello Dedy,
Thank you for using Microsoft Online Communities. I understand that you are wondering what the purpose of the reconcile utility in each module. Ian did give some very good information related to the reconcile process. Each module will have its own reconcile that can be run and based on the what the module does will determine what the reconcile will do. The overall general purpose is to verify the transaction level transactions either related a document for PM or RM to the lines if you are running it in SOP or POP to update the Summary or Header records.
When you run the reconcile in SOP and POP, you can reconcile actual documents where the lines totals might not match the invoice document. When you get into PM, RM and even Payroll the reconcile will look at the documents for the vendor or customer or in payroll the checks and update summary information. Note of there are records missing or not updated in GP correctly the system will adjust the summary numbers which may cause them to be incorrect, but it would show the totals for what is in the system.
The inventory would look through and check records to give you the quantity on hand based on what has been received and sold.
The GL reconcile will check the account detail with the summary as well.
As Ian mentioned there is also batch reconcile which would update the batch totals based on the records in the batch.
But I would not say that it corrects issues caused by network fail. It will update the header or summary based on lines or documents that exist in the system. So if the table or column did not get updated and you run the reconcile the system maybe over or understated. If the summary or header or batch totals are off and the lines, documents or records in the batches are correct then reconcile would correct the issue.
Check Links is more of a check for the system to verify if there are orphaned records caused by posting issues and will in some cases remove these records.
If you have any other questions please let me know.
Best regards,
Brad G
Microsoft Dynamics GP
We hope you get value from our new forums platform! Tell us what you think
community.dynamics.com/.../default.aspx
This posting is provided AS IS with no warranties, and confers no rights
Thanks for the answer Ian
I thought Reconcile feature more than like 'Tools that help correct crap when networks fail'.
I think everything that already you said it should be done with feature "Transaction" that should be built in in ERP software.
I mean if everything goes wrong GP should cancel all transaction.(CMIIW)
Is GP have feature Transaction ? i think not (CMIIW).. at least when i trace using sql trace, GP execute the code with no Transaction feature .. ! because after the network failure and the GP up again .. the block of transaction sometimes not completed successfully .. Is it true GP have not Transaction feature ? or maybe i am wrong
No such thing as a silly question...just an irrelevant one, and this one is not irrelevant!
The reconcile feature is part of what I call 'Tools that help correct crap when networks fail'. Networks fail because of dropped connectons, power failures, or kicking the network cable with your foot. :) Normally this isn't an issue, untill you're saving a master record or posting a transaction. For Master Records - you have Check Links - this checks each transactional record that references a master table and ensures the master record exists. For transactional type records, that update Summary information, you have Reconcile.
So - a power failure during entering transacions in a batch or posting a batch could cause the Batch totals to be incorrect, or could cause summary data to be out of synch with the underlying transactions. An example is the summary data displayed in Enquiry >> Inventory. The Quantity on Hand field - may not agree with the sum of the underlying transactions....The reconcile feature fixes this issue. It re-calculates the Qty on Hand based on the items transactional history. It could have gone out of synch because of a network glitch as someone was posting an Inventory transaction - and so you have a partial posting - that bit of the posting process that updates the Qty on Hand summary information just didn't happen.
The same could happen with a sales invoice - and the Customer summary data ('Sales Year to Date' for example) didn't get updated. Again, the reconcile recalculates this summary data based on the underlying transaction values.
Frank Hammelly has details in the following post of the sequence to run the reconciles...
community.dynamics.com/.../146353.aspx
Best regards,
Ian.
#1
André Arnaud de Cal...
292,575
Super User 2025 Season 1
#2
Martin Dráb
231,493
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
