Hi @tahayabali ,
Are you prompting for both the InventoryID and the bAccountID? You can use a cross join to relate two tables that don't have a natural relationship, but without some conditions you will end up with duplicates. Also, the INUnit table should be joined to InventoryID. You can use the DAC browser in Acumatica to explore the relationships between tables.
If your goal is to print sales order details, you might start with the tables SOOrder and SOLine. You can join SOOrder with Customer, and SOLine with InventoryItem. The standard sales order acknowledgement report is a good starting point.
I'm not quite following what you are trying to accomplish with the qty or the serial numbers. Please provide a little more explanation and I be able to assist further.
Laura
Hi @tahayabali ,
Click Show trace to view the error details.
Based on what you are describing, I'm not sure you need the INUnit table in your schema at all. You can configure a lookup for the Parameter from a table that isn't included in the schema. There are examples of this in the standard reports. Use the Parameter value itself in the formula for the report textfield value.
It will be awkward using parameters to populate more than one row of the grid. You would need one parameter for each column of each possible line. That's why a BOL report is often run off of SOShipment. This also makes for a more natural join to the customer and address. You can use the Shipment Confirmation report as a starting point.
Hope this helps!
Laura