How to create a Template/Report which will combine Parent and Child Purchase orders with inventory Id’s.
Page 1 / 1
Hi
To create a template or report combining parent and child purchase orders with inventory IDs in Acumatica, follow these steps:
- Access the Report Designer screen in Acumatica.
- Create a new report using the Purchase Orders data source.
- Design the report layout by adding headers, tables, and fields.
- Include data fields for purchase order numbers, inventory IDs, quantities, dates, etc.
- Configure the data source and establish relationships between parent and child records.
a. Select the Purchase Orders data source.
b. Establish relationships between the parent and child tables.
c. Identify the primary table (parent) and related table (child).
d. Use the Relationships tab to define the relationship.
e. Specify join conditions based on common fields. - Apply filters and sorting options based on criteria such as status or date range.
- Preview and test the report to ensure accurate data display.
- Save and publish the report for user access in Acumatica.
By following these steps, you can create a comprehensive report that combines parent and child purchase orders with inventory IDs in Acumatica.
Hope, it helps!
Regards,
Sweta
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.