Hello all, I recently used this awesome video by Jose to get a BAQView into the Part Transaction History grid, using C#. And I know there’s probably a better way to link to it so forgive me but… https://www.youtube.com/watch?v=FYLPgCbQSDc I thought I had everything set up properly, and I can se…

Turns out my syntax was not quite right. Subscribe function works using: SUM(SignTran) OVER (PARTITION BY PartTran.PartNum ORDER BY PartTran.TranNum) Thank you all.

And if anyone can guide me as to how to format my code better for forum - I think i may have it all distorted.

It’s just 3 backticks (the key to the left of the 1 on the keyboard) before and after your code. [image] I updated your post for you, if you go to edit it, you can see where I added the 3 ticks. One line before your code started, and one line after your code started.

[image] Alice_Elizabeth: Part.PartNum Are you sure there is a view called Part.PartNum in PartTransactionHistory? (I haven’t looked) now I looked… hmm yes there is.

The grid function (w/ subscribe) worked for a bit. But then I went back to make some changes to BAQ since I was struggling with Running Total. Got that figured out and when I went back to the customization, I see the grid but no subscribe. Here is my query… select [PartTran].[TranDate] as [Par…

I figured out my issue but can’t seem to resolve it - It is this calculated field in the BAQ that prevents subscribe function from working correctly: [image] I have the baq sorted by TranNum: [image] So I went and changed calculated field to order by TranNum DESC: [image] Now is hangs up an…

Here is the approach I used to calculate the Running Total: [image] PartTran BAQ: Calculating the "Running Total" of the History Tracker ERP 10 Ignore the Before and After Qty’s. You’ll have to use some moderately tricky techniques in the BAQ to make a running sum. Some…

BAQ View in Grid - Issue with Subscribe

Epicor ERP 10

Alice_Elizabeth (Alice Elizabeth Smith) April 13, 2020, 2:04pm 7

Here is the approach I used to calculate the Running Total:

Topic		Replies	Views
BAQ Dataview Example Video Experts' Corner e10 , customization	39	11723	September 9, 2024
PartTran BAQ: Calculating the "Running Total" of the History Tracker Epicor ERP 10 e10 , epicor , baq	25	9555	April 14, 2020
BAQDataView not pulling data Epicor ERP 10 customization , baq	7	1407	August 28, 2020
Replacing Ultragrid, C code not compiling Epicor ERP 10 baq	4	1016	March 23, 2022
Part Advisor Custom Grid Views Epicor ERP 10	7	1860	October 18, 2018

BAQ View in Grid - Issue with Subscribe

Related topics