I noticed the sales revenue is posting negative, is that the way BC Dynamics 365 post sales? I posted few Purchase Invoices and few Sales Invoices, all my sales are with profit but my Gross Profit shows a Loss, does not make sense and wonder what is wrong.
Also my Inventory Opening Balance was $416,064 adding new purchases became $881,780 (GL 14500) before posting Sales Invoices and in the Trial Balance my $334,806 (GL 14500).
Can someone help? Thanks
Few minutes in the first video I managed to get the report correctly, thank you very much for your help
Much appreciated
Are you using Accounting Schedules / Financial Reports to analyze this data?
If not, you can use these links to learn and create your own reports from the front end and analyze data in a better way
learn.microsoft.com/.../bi-how-work-account-schedule
Please ensure the date filters you are putting on your TB v/s COA are the same
I appreciate that but what about the profit in this case how come it is loss?
Also how come the Inventory in the Trial Balance is different from the Chart of Account by nearly $565,000 where the sales were only $100,000 with nearly 50% Gross Profit
Thank you for your assistance
Well this is the way accounting works. Revenue is a credit transaction and credit transactions are represented as negative figures in all accounting systems.
Cost are debit transactions and represented as positive figures in the ledger entries.
This concept can be a bit unfamiliar to people that are not used to working in accounting.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156