hey mate do you any freelance work ? we have the standard customer aging report in sap b1 sql v10, pld which needs a field added to it from OINV (comments field) for each transaction. our sap consultant cant seem to get this to work and we are at a loss
Hello kul! Unfortunately I do not. To be fair, those PLD converted CR layout are nasty to work with. You could probably do an SQL VIEW and join it to the INV XXXXX document number if you cast the value first with just the comments column there. If you get them to reach out to me on LinkedIn, I can help for free. linkedin.battleshipcobra.com/
Hi Michael, Thanks for this tip, is very usefull for me. I have an issue maybe you can help me. The layout imported on SAP B1 for invoices (INV2) only get and show DocKey value. all other fields, Customer name, doc date and invoice details remain empty. Any solution to that ? thanks
For invoices you need to link to OINV and INV1 which might be why you aren't getting any data. For the main form layouts, just start with the system default CR (there is always one built into all databases) then work from there.
We would like to convert PLD to Crystal report. We are using sap b1 10. We would like to payment tems and document reference. Or advice to create new statement.
hey Michael why you don't use add-in tab in the SAP crystal reports application to save the Layout report Into SAP business one Directly? instead of importing it through report and Layout import wizard?
