Multiply record by number in report [duplicate]
up vote
0
down vote
favorite
This question already has an answer here:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
1 answer
I have added a custom field 'Print Qty' in Purchase Receipt Document Details so that I can specify the number of Labels to print in Report based on the value.
And currently my report designer previews the labels like this:
Now, I want to multiple the label to the times of 'Print Qty' value for the same Inventory.
I looked over the Designer but couldn't find any place where I could put the formula to do so or write queries to pull up records in that way.
Thank you.
acumatica
marked as duplicate by Community♦ Nov 27 at 16:54
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
up vote
0
down vote
favorite
This question already has an answer here:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
1 answer
I have added a custom field 'Print Qty' in Purchase Receipt Document Details so that I can specify the number of Labels to print in Report based on the value.
And currently my report designer previews the labels like this:
Now, I want to multiple the label to the times of 'Print Qty' value for the same Inventory.
I looked over the Designer but couldn't find any place where I could put the formula to do so or write queries to pull up records in that way.
Thank you.
acumatica
marked as duplicate by Community♦ Nov 27 at 16:54
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
Hi. I did the exact thing and it was working great as well. But, all of sudden I start getting error about 'UsrNumbers' table not found. I can see that the table exists in database imgur.com/a/obsl8jX but I can't find the same table in Schema Builder in Report Designer. imgur.com/a/obsl8jX I even tried adding a different table. But it didn't work.
– Bikash Lama
Nov 23 at 15:58
You need a DAC (data access class) for it and it has to be published on your site. Adding table to DB is not enough.
– Gabriel
Nov 23 at 19:02
Hi! I have already had DAC. I still don't understand the reason but once I published the customization again, it worked.
– Bikash Lama
Nov 27 at 16:54
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
This question already has an answer here:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
1 answer
I have added a custom field 'Print Qty' in Purchase Receipt Document Details so that I can specify the number of Labels to print in Report based on the value.
And currently my report designer previews the labels like this:
Now, I want to multiple the label to the times of 'Print Qty' value for the same Inventory.
I looked over the Designer but couldn't find any place where I could put the formula to do so or write queries to pull up records in that way.
Thank you.
acumatica
This question already has an answer here:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
1 answer
I have added a custom field 'Print Qty' in Purchase Receipt Document Details so that I can specify the number of Labels to print in Report based on the value.
And currently my report designer previews the labels like this:
Now, I want to multiple the label to the times of 'Print Qty' value for the same Inventory.
I looked over the Designer but couldn't find any place where I could put the formula to do so or write queries to pull up records in that way.
Thank you.
This question already has an answer here:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
1 answer
acumatica
acumatica
asked Nov 21 at 17:22
Bikash Lama
648
648
marked as duplicate by Community♦ Nov 27 at 16:54
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Community♦ Nov 27 at 16:54
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
Hi. I did the exact thing and it was working great as well. But, all of sudden I start getting error about 'UsrNumbers' table not found. I can see that the table exists in database imgur.com/a/obsl8jX but I can't find the same table in Schema Builder in Report Designer. imgur.com/a/obsl8jX I even tried adding a different table. But it didn't work.
– Bikash Lama
Nov 23 at 15:58
You need a DAC (data access class) for it and it has to be published on your site. Adding table to DB is not enough.
– Gabriel
Nov 23 at 19:02
Hi! I have already had DAC. I still don't understand the reason but once I published the customization again, it worked.
– Bikash Lama
Nov 27 at 16:54
add a comment |
Hi. I did the exact thing and it was working great as well. But, all of sudden I start getting error about 'UsrNumbers' table not found. I can see that the table exists in database imgur.com/a/obsl8jX but I can't find the same table in Schema Builder in Report Designer. imgur.com/a/obsl8jX I even tried adding a different table. But it didn't work.
– Bikash Lama
Nov 23 at 15:58
You need a DAC (data access class) for it and it has to be published on your site. Adding table to DB is not enough.
– Gabriel
Nov 23 at 19:02
Hi! I have already had DAC. I still don't understand the reason but once I published the customization again, it worked.
– Bikash Lama
Nov 27 at 16:54
Hi. I did the exact thing and it was working great as well. But, all of sudden I start getting error about 'UsrNumbers' table not found. I can see that the table exists in database imgur.com/a/obsl8jX but I can't find the same table in Schema Builder in Report Designer. imgur.com/a/obsl8jX I even tried adding a different table. But it didn't work.
– Bikash Lama
Nov 23 at 15:58
Hi. I did the exact thing and it was working great as well. But, all of sudden I start getting error about 'UsrNumbers' table not found. I can see that the table exists in database imgur.com/a/obsl8jX but I can't find the same table in Schema Builder in Report Designer. imgur.com/a/obsl8jX I even tried adding a different table. But it didn't work.
– Bikash Lama
Nov 23 at 15:58
You need a DAC (data access class) for it and it has to be published on your site. Adding table to DB is not enough.
– Gabriel
Nov 23 at 19:02
You need a DAC (data access class) for it and it has to be published on your site. Adding table to DB is not enough.
– Gabriel
Nov 23 at 19:02
Hi! I have already had DAC. I still don't understand the reason but once I published the customization again, it worked.
– Bikash Lama
Nov 27 at 16:54
Hi! I have already had DAC. I still don't understand the reason but once I published the customization again, it worked.
– Bikash Lama
Nov 27 at 16:54
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
EDIT:
Same principle applies but answer linked by Gabriel in comments has a much better way to define the join relationship than what I suggested below:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
UI Controls can't be added by formula, only hidden. The schema builder Relationships tab defines what is a Detail record. I suppose you have 1 label in the Detail section and that the Detail record is POReceiptLine. With that setup you'll get: 1 Label * number of POReceiptLine records. You can't get 1 label * formula/field value.
If Print Qty equals 10 and you want to have 10 labels printed for the same POReceiptLine, you would have to craft a query in the Schema Builder that returns 10 times the same POReceiptLine. This could be achieved by creating a new custom table that links to POReceiptLine. You could insert 10 records in that table that links to a single POReceiptLine. In the schema builder you add a Left join link between POReceiptLine and that custom table, when the report is rendered it will duplicate the labels because you duplicated the number of detail records.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
EDIT:
Same principle applies but answer linked by Gabriel in comments has a much better way to define the join relationship than what I suggested below:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
UI Controls can't be added by formula, only hidden. The schema builder Relationships tab defines what is a Detail record. I suppose you have 1 label in the Detail section and that the Detail record is POReceiptLine. With that setup you'll get: 1 Label * number of POReceiptLine records. You can't get 1 label * formula/field value.
If Print Qty equals 10 and you want to have 10 labels printed for the same POReceiptLine, you would have to craft a query in the Schema Builder that returns 10 times the same POReceiptLine. This could be achieved by creating a new custom table that links to POReceiptLine. You could insert 10 records in that table that links to a single POReceiptLine. In the schema builder you add a Left join link between POReceiptLine and that custom table, when the report is rendered it will duplicate the labels because you duplicated the number of detail records.
add a comment |
up vote
1
down vote
EDIT:
Same principle applies but answer linked by Gabriel in comments has a much better way to define the join relationship than what I suggested below:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
UI Controls can't be added by formula, only hidden. The schema builder Relationships tab defines what is a Detail record. I suppose you have 1 label in the Detail section and that the Detail record is POReceiptLine. With that setup you'll get: 1 Label * number of POReceiptLine records. You can't get 1 label * formula/field value.
If Print Qty equals 10 and you want to have 10 labels printed for the same POReceiptLine, you would have to craft a query in the Schema Builder that returns 10 times the same POReceiptLine. This could be achieved by creating a new custom table that links to POReceiptLine. You could insert 10 records in that table that links to a single POReceiptLine. In the schema builder you add a Left join link between POReceiptLine and that custom table, when the report is rendered it will duplicate the labels because you duplicated the number of detail records.
add a comment |
up vote
1
down vote
up vote
1
down vote
EDIT:
Same principle applies but answer linked by Gabriel in comments has a much better way to define the join relationship than what I suggested below:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
UI Controls can't be added by formula, only hidden. The schema builder Relationships tab defines what is a Detail record. I suppose you have 1 label in the Detail section and that the Detail record is POReceiptLine. With that setup you'll get: 1 Label * number of POReceiptLine records. You can't get 1 label * formula/field value.
If Print Qty equals 10 and you want to have 10 labels printed for the same POReceiptLine, you would have to craft a query in the Schema Builder that returns 10 times the same POReceiptLine. This could be achieved by creating a new custom table that links to POReceiptLine. You could insert 10 records in that table that links to a single POReceiptLine. In the schema builder you add a Left join link between POReceiptLine and that custom table, when the report is rendered it will duplicate the labels because you duplicated the number of detail records.
EDIT:
Same principle applies but answer linked by Gabriel in comments has a much better way to define the join relationship than what I suggested below:
How to make the Inventory Item Label (IN619200) to print one label per unit of each item received?
UI Controls can't be added by formula, only hidden. The schema builder Relationships tab defines what is a Detail record. I suppose you have 1 label in the Detail section and that the Detail record is POReceiptLine. With that setup you'll get: 1 Label * number of POReceiptLine records. You can't get 1 label * formula/field value.
If Print Qty equals 10 and you want to have 10 labels printed for the same POReceiptLine, you would have to craft a query in the Schema Builder that returns 10 times the same POReceiptLine. This could be achieved by creating a new custom table that links to POReceiptLine. You could insert 10 records in that table that links to a single POReceiptLine. In the schema builder you add a Left join link between POReceiptLine and that custom table, when the report is rendered it will duplicate the labels because you duplicated the number of detail records.
edited Nov 22 at 15:37
answered Nov 21 at 18:43
HB_ACUMATICA
3,5901312
3,5901312
add a comment |
add a comment |
Hi. I did the exact thing and it was working great as well. But, all of sudden I start getting error about 'UsrNumbers' table not found. I can see that the table exists in database imgur.com/a/obsl8jX but I can't find the same table in Schema Builder in Report Designer. imgur.com/a/obsl8jX I even tried adding a different table. But it didn't work.
– Bikash Lama
Nov 23 at 15:58
You need a DAC (data access class) for it and it has to be published on your site. Adding table to DB is not enough.
– Gabriel
Nov 23 at 19:02
Hi! I have already had DAC. I still don't understand the reason but once I published the customization again, it worked.
– Bikash Lama
Nov 27 at 16:54