How are you
1- There is a problem in the summary regarding the inventory, as the inventory is not shown at the actual value, but is shown at the value of the beginning of the period.
2- There is a problem with the inventory profit margin in the reports
3- There is a problem with the inventory value summary report, as the cost of the goods does not appear
4- There is a problem with shipping costs in sales invoices, as they appear in pending, unposted accounts
You need to show screen images to explain the problems - no one here can see your accounts
If entries end up in the Suspense account, then the transactions have incorrect entries
There are transactions that took place in previous months and on which days they appeared in the suspense account
I think it’s a problem with the program and not an input problem
Secondly, I think screenshots will not help because the inventory cost is not actual. This is something that does not require a screenshot. Things were going well until a week ago, things changed completely. I did not do anything new.
Knowing that there are different control accounts for types of goods
Please edit your title to something informative such as “Inventory reporting problem”
Please change Manager’s language to English before making the screenshots.
Neither is true. Inventory value is shown at current average weighted value, which depends on your purchase and sales history for an item.
You describe no problem. Do you expect other forum members to guess?
Cost of goods normally refers to cost of goods sold, which is not applicable for the Inventory Value Summary. If you are referring to your costs to acquire goods during a reporting period, that is included under the heading Purchases.
You need to show the Edit screen of a sales invoice you think is being handled incorrectly, plus English screen shots of any place you believe it is showing up wrong.
I apologize, but I made it clear that I am not good at expressing in English, and yet I try
The problem is that the mead was working smoothly and in another facility it was working well, but in the current facility there are inventory control accounts, so it does not give any adjustment to the inventory balance. I hope that the screenshots are sufficient, and I repeat my apologies for my inability to explain accurately.
I am sorry, but so much of your data was entered in Arabic that I cannot understand your screen shots. (Content you enter is not translated when you switch language. Only predefined content is translated.) Perhaps @Ealfardan can help.
What I can tell you is that nothing can be fixed until you identify why there is a balance of -70.00 in your Suspense account. Anything in Suspense indicates that something was omitted or was wrong. Manager puts transactions into suspense awaiting your correction. Drill down on the blue -70.00 figure to see what transactions contribute to that balance. If you cannot determine what is wrong with them, post screen shots of the Edit screens of those transactions.
One thing I can say is that it looks like you have entered a “Freight-in” item for 70.00 without selecting a posting account. This would definitely cause it to post to Suspense. But Freight-in is an automatic item that cannot be used on sales invoices, only on purchase invoices. So you must have created this item yourself, which you should not have done.
When you post a screen shot, post the entire screen, including the links at the top that reveal how you got to the screen you are showing. (These are the breadcrumbs.) We have no idea what the transactions you show are. So we cannot tell is anything is wrong with them.
Hi @Mahmoud_Anis,
How are you too?
This thread is very complex and it’s distracting. In your original post, you mentioned 4 different problems. Problems 1, 2 &3 seem to be related so let’s address them here.
For problem 4, please create a separate topic.
Before going into the details we also need to know the version and edition of Manager you are using.
To examine that we need to focus on one inventory item only that’s affected (e.g. أوكسميك بلص 30
).
This item was sold during last month as shown in the reports you provided, but it has Zero cost. We need to see the movement of cost and quantity for this item.
To do that, let’s start be examining the drill down from Inventory Items tab into Total Cost
(إجمالي التكلفة
in Arabic) as indicated in the screenshot below.
Click on the link highlighted in green and you should get the required report as follows:
Important: make sure you get the report to show all transaction types used for this item (i.e. Sales Invoices, Credit Notes, Purchase Invoices, Production Orders, Journal Entries … whatever). You can take multiple screenshots of the same report if one screenshot isn’t enough.
Once we have this report, only then we can have an idea of how and where the problem started and we can then go into transaction details.
With the inventory value report, you notice that no movement occurred on all items, and this is not true. All items have been bought and sold. Hopefully the problem will become clear.
Unfortunately, it’s not clear yet.
These are not the reports that I asked for.
If you want to diagnose the issue, you need to start here:
Also, for this purchase invoice,
please click on Journal on top of the invoice and share a screenshot.
Uploading: لقطة الشاشة 2023-09-02 في 4.48.58 م.png…
Uploading: لقطة الشاشة 2023-09-02 في 4.50.39 م.png…
Uploading: لقطة الشاشة 2023-09-02 في 4.50.49 م.png…
The total cost for all inventory is zero, except for items that have beginning inventory. Knowing that this problem is recent, I think from August 20 before this date, the total cost was correct, and I am using the cloud version.