cancel
Showing results for 
Search instead for 
Did you mean: 

'Document Type' doesn't match for Crystal Report Layout

Mina_K
Explorer
0 Kudos
399

Hello experts.

I have created a crystal report layout for my A/R correction invoices, it looks fine in the crystal report app and it is properly imported and assigned on my SAP B1.

Report and Layout ManagerReport and Layout Manager

 

 

 

 

 

 

As you can see in the above photo, the layout IDs for A/R Correction Invoice layouts start with 'CSI4'.

Also I can see the expected entries in the RTYP(Document Type list) and RDOC(Document) tables:

RTYPRTYP

RDOCRDOC

However, when I open an already existing A/R correction invoice and click on 'Preview' to view the report, I get these error messages:

No matching records found 'Document Type List' (RTYP) (ODBC -2028) [Message 131-183]
No matching records found 'Document' (RDOC) (ODBC -2028) [Message 131-183]

I've noticed that when I have the A/R correction invoice window open and I click on 'Layout designer' the 'Document Type' is automatically set as 'CSI2' in the dropdown list. However when I open the dropdown list, no 'CSI2' exists!

3d9f715a-1252-4139-9f39-7f010a5a2719.png

The exact same thing happens even when I set SAP B1's own PLD layout as the default layout. 

Where is this 'CSI2' coming from and how can I change it? Is there another way I can have my crystal report layout for A/R correction invoices?

Thank you in advance for any help you can offer.

View Entire Topic
williamwachholz
Participant

Hello,

Open the screen "Report and Layout Manager":

williamwachholz_0-1737550787436.png

Search for "Sales -> AR Invoice" and check if the layout status is "Active" on this field:

williamwachholz_1-1737550848160.png

 

 

Mina_K
Explorer
0 Kudos

Hi.
The status is 'Active'.
The same thing happens when I try to preview the system's PLD which is active by default and can't be set to 'Inactive'.