Sage 50c Pastel Partner Inventory Valuation Report by Group Error

**TauZee** · 29-Sep-23, 11:02 AM

Good day,

I am running Pastel Partner V19 and the inventory valuation report by group is producing a blank report. However, when I omit the first group (002) it will populate correctly. Most of the items are in this group (002). Have tried to create a new group (001) and the report is still blank. How do I fix this one?

**Kevin Smith** · 04-Oct-23, 02:27 PM

You will probably need a data-fix. There are 3 files for inventory - the Inventory Masterfile, The Inventory Link File and the Multi Store Transaction file. You either have blank codes or descriptions on one or more items, or they are present in the masterfile but not in the link file or vice versa. There is a "stock fixes" application, but it generally doesn't correct the problem you are having. You would need to export the 3 files in pervasive and them compare them in excel to see what is missing. Delete any blank code or description records and add in the missing records into the other files to correct your issue.

PM me if you would like me to assist remotely and I will arrange for one of our consultants to assist.

**clivecook** · 06-Oct-23, 10:18 AM

greetings,

does anyone have a spare pastel 19 training manual ?
regards
clive

**Alec Candiotes** · 14-Dec-23, 01:07 AM

Hi Clive

Each Pastel has a link to the PDF user manual in the HELP tab. This document is comprehensive, and my team and I often use it for training purposes.

Let me know if you cannot find it.

Kindest regards,
Alec