| Exam Code/Number: | C_TB1200_07Join the discussion |
| Exam Name: | SAP Certified Implementation Consultant SAP Business One 2007 |
| Certification: | SAP |
| Question Number: | 152 |
| Publish Date: | May 29, 2026 |
|
Rating
100%
|
|
I want to create a query to display all the invoices over $1500 issued for a specific customer by one of my sales employees Sara Chang. How do I find which fields I should enter in the SQL query?
PKJ Ltd maintains its price list automatically based on last purchase price. When PKJ sells a product, they want to add their overhead of 40% to the sales price. How can they accomplish this?
When Joe from Jungle Gym Productions Ltd. issues invoices, he wants to have the customer order number (which he manually types in the 'Customer Ref. No.' field of the invoice) entered automatically in the Journal Remark field as a reference for journal posting. What should he define in SAP Business One to accomplish this?