Notifications
Announcements
No record found.
Dear Experts,
The amount of COGS in trial balance is not matching with the details in sales reports. Please check in the above image. Help!
Thanks and Regards,
Shabir Ahmad
*This post is locked for comments
Hi,
Have you already tried running the standard reconciliation reports that are available in GL? The show you whether differences between GL and the subledgers exist and what vouchers caused the difference. I would expect that you get some variances displayed in those reports.
Best regards
Ludwig
Dear Dr.Ludwig Reindhard,
I have run this report but the value of cost is not reconciled.But what i found one sales invoice is duplicated with other.For example A1 and A1 2 sales invoices so The report show first invioce data infront of other invoice data. I hope you got my point.
Hello Shabir Ahmad,
I had a look at the two reports and recalculated the values.
Based on that calculation, I believe that everything is ok.
Please note that I calculated the orange and yellow highlighted fields myself as they are not provided in the reports.
To me, things seem to match except for the rounding difference of 0.01 :-)
Best regards,
Did that answer your question?
Dear Doctor,
The value of cost is not reconcile as i run the report as you recommend me ,still watching for solution.This is Year closing.
Hi Shabir,
According to my calculations the cost prices in both reports match.
Can you elaborate what does not match exactly?
Many thanks and best regards,
Doctor,
I appreciate your prompt Response, can you tell me or give full name of that report or reports which you talked in above of your comment please.That report or reports as you said in GL reconciliation there are some reports??Tell me full name of that report or Reports because i already run all reports.
Thanks and best Regards,
Again thank you so much for your valuable response
Good Morning,
Your initial question was on the customer item statistics and the sales analysis by invoice report and here I would say that everything is ok.
If you want to reconcile GL and AR then you can use a GL reconciliation report that compares the GL and customer transactions made. Many companies also use a customer balance report in addition and try to match this balance with the one that they see on the AR summary ledger account.
Sorry for late reply, The Cost Value of Trial Balance is ok, but only issue is (Cost Value Column) of The (sales analysis By invoice Report) is not matching.
Shabir Ahmad.
Hello Shabir,
Can you provide details where you see the issue with the cost amount that does not match.
When adding the data to excel and doing the cogs calculation, I cannot see an issue.
Would be great if you could provide some additional screenprints and a brief description where you see the issue.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
