# Inventory reporting problem

**URL:** <https://forum.manager.io/t/inventory-reporting-problem/48722>\
**Category:** Uncategorized\
**Created:** [August 31, 2023, 6:35am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722 "2023-08-31T06:35:09Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [August 31, 2023, 6:35am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/1 "2023-08-31T06:35:09Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [August 31, 2023, 7:10am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/2 "2023-08-31T07:10:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [August 31, 2023, 7:21am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/3 "2023-08-31T07:21:53Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [August 31, 2023, 7:23am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/4 "2023-08-31T07:23:48Z")

</div>

![‏لقطة الشاشة 2023-08-31 في 10.22.52 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/3/837c79b7fe574c828c634f5540703f5a94765731.jpeg)  
 ![‏لقطة الشاشة 2023-08-31 في 10.23.09 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/d/3d921934de394483c65c396f9c1441ccef98f052.jpeg)  
 ![‏لقطة الشاشة 2023-08-31 في 10.23.18 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/e/9ecaf85ba433d429da8a0c816160b7505b34b462.jpeg)

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [August 31, 2023, 7:28am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/5 "2023-08-31T07:28:45Z")

</div>

Knowing that there are different control accounts for types of goods

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [August 31, 2023, 7:33am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/6 "2023-08-31T07:33:37Z")

</div>

Please edit your title to something informative such as “Inventory reporting problem”

---

<div class="post-metadata">

**Author:** ![Mark](https://avatars.discourse-cdn.com/v4/letter/m/e9c0ed/32.png) [@Mark](https://forum.manager.io/u/Mark)\
**Post date:** [August 31, 2023, 6:00pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/7 "2023-08-31T18:00:00Z")

</div>

Please change Manager’s language to English before making the screenshots.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [August 31, 2023, 6:31pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/8 "2023-08-31T18:31:15Z")

</div>

> [@Mahmoud\_Anis](#):
>
> inventory is not shown at the actual value, but is shown at the value of the beginning of the period.

Neither is true. Inventory value is shown at current average weighted value, which depends on your purchase and sales history for an item.

> [@Mahmoud\_Anis](#):
>
> There is a problem with the inventory profit margin in the reports

You describe no problem. Do you expect other forum members to guess?

> [@Mahmoud\_Anis](#):
>
> There is a problem with the inventory value summary report, as the cost of the goods does not appear

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.

> [@Mahmoud\_Anis](#):
>
> There is a problem with shipping costs in sales invoices, as they appear in pending, unposted accounts

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.

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 1, 2023, 6:01pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/9 "2023-09-01T18:01:50Z")

</div>

![‏لقطة الشاشة 2023-09-01 في 8.56.11 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/1/51c893e9558566da4f245121d6b03735e5384b9c.png)  
 ![‏لقطة الشاشة 2023-09-01 في 8.56.22 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/1/f1e53bd7f636096f0857b1f3355694efb1cf6af2.jpeg)  
 ![‏لقطة الشاشة 2023-09-01 في 8.59.17 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/4/544ba74fa7cb1b870eecc97313e0b3f59a579601.png)  
 ![‏لقطة الشاشة 2023-09-01 في 8.59.37 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/6/26108e9e08b837c41988f36e596f760a7b251a3a.png)  
 ![‏لقطة الشاشة 2023-09-01 في 9.00.01 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/b/5bec2019b0198ac6377cd4ab434c59f667e92298.png)

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 1, 2023, 6:02pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/10 "2023-09-01T18:02:27Z")

</div>

![‏لقطة الشاشة 2023-09-01 في 8.54.02 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/b/fb4234041252f6460219a87b932e571511c28cef.png)  
 ![‏لقطة الشاشة 2023-09-01 في 8.54.20 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/8/3/839eb1d1871ba392573b029728f16bda6e1f7be2.png)  
 ![‏لقطة الشاشة 2023-09-01 في 8.55.46 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/6/56343b57bec883c686c170fc462b93e67f6655a4.png)

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 1, 2023, 6:05pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/11 "2023-09-01T18:05:34Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [September 1, 2023, 7:43pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/12 "2023-09-01T19:43:12Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 2, 2023, 4:33am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/13 "2023-09-02T04:33:55Z")

</div>

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.

 ![Screenshot 2023-09-02 071829](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/6/668a28cda1bf4bf3857cadf4632cf9ad129c9b1a.png)

Click on the link highlighted in green and you should get the required report as follows:

 ![Screenshot 2023-09-02 072142](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/1/51fd61007b7dd09e34ba2b79cecb6d4c2af1cca5.png)

> **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.

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 2, 2023, 6:40am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/14 "2023-09-02T06:40:03Z")

</div>

![‏لقطة الشاشة 2023-09-02 في 9.20.29 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/2/02016d918b096b9b2be04e8123dc4e38c7eb4e71.jpeg)  
 ![‏لقطة الشاشة 2023-09-02 في 9.20.42 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/4/74ac064592606a430f11efb96d484e22ef5206d7.png)  
 ![‏لقطة الشاشة 2023-09-02 في 9.23.26 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/f/cf1657f991adac8f121d99fe3bbe413c491a4329.png)  
 ![‏لقطة الشاشة 2023-09-02 في 9.23.46 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/e/de90ca79b930890c6807e72b0708e8dcafa745fc.jpeg)

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 2, 2023, 7:54am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/15 "2023-09-02T07:54:59Z")

</div>

![‏لقطة الشاشة 2023-09-02 في 10.52.41 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/3/7/378fa40653b4f637166ed1b25c7892c1c8f474f3.jpeg)  
 ![‏لقطة الشاشة 2023-09-02 في 10.52.49 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/f/9f1d5d028484e3a611a96b13a958bf4c5c4ed5f0.jpeg)  
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.

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 2, 2023, 7:57am UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/16 "2023-09-02T07:57:47Z")

</div>

![‏لقطة الشاشة 2023-09-02 في 10.56.23 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/6/069b872b4ebfad334613f1b2425acf21211ca002.jpeg)  
 ![‏لقطة الشاشة 2023-09-02 في 10.56.30 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/0/d/0deaeff8b9cfc06be176f2b7f15bb9f3173bf659.jpeg)  
 ![‏لقطة الشاشة 2023-09-02 في 10.56.38 ص](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/3/f3b367ed599bec3283b9b608afdff1fd982fea1f.jpeg)  
These movements are for one of the items, yet the report does not give any movement

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 2, 2023, 12:36pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/17 "2023-09-02T12:36:40Z")

</div>

> [@Mahmoud\_Anis](#):
>
> 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:

> [@Ealfardan](#):
>
> 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.
> 
> ![Screenshot 2023-09-02 071829](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/6/668a28cda1bf4bf3857cadf4632cf9ad129c9b1a.png)
> 
> Click on the link highlighted in green and you should get the required report as follows:
> 
> ![Screenshot 2023-09-02 072142](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/5/1/51fd61007b7dd09e34ba2b79cecb6d4c2af1cca5.png)

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [September 2, 2023, 12:41pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/18 "2023-09-02T12:41:23Z")

</div>

Also, for this purchase invoice,

[![](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/f/cf1657f991adac8f121d99fe3bbe413c491a4329.png) ](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/c/f/cf1657f991adac8f121d99fe3bbe413c491a4329.png)

please click on Journal on top of the invoice and share a screenshot.

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 2, 2023, 1:56pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/19 "2023-09-02T13:56:53Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Mahmoud\_Anis](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/mahmoud_anis/32/37942_2.png) [@Mahmoud\_Anis](https://forum.manager.io/u/Mahmoud_Anis)\
**Post date:** [September 2, 2023, 1:57pm UTC](https://forum.manager.io/t/inventory-reporting-problem/48722/20 "2023-09-02T13:57:38Z")

</div>

![‏لقطة الشاشة 2023-09-02 في 4.48.58 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/6/3/63bcdf937304985f33407909f919d1d71ef11061.png)  
 ![‏لقطة الشاشة 2023-09-02 في 4.50.39 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/4/f4214d67f04df5ed6cebf40394f625914a0ef605.png)  
 ![‏لقطة الشاشة 2023-09-02 في 4.50.49 م](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/5/f57bc22a8357fcdad200654a34acef68bc00a73d.jpeg)  
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.

[Next page](https://forum.manager.io/t/inventory-reporting-problem/48722.md?page=2)
