I am looking to create a Posting Code customization and was going to use a BAQ to get some extra information for a Document Line. Since I am multi-company, I put a parameter on the BAQ for Company and when I went to map it in the posting code, there is no Company field?
Really Epicor, everywhere I look I find Company. But when I want it, it is not there??
Anyone know where to look?
Session context? A posting rule will only execute within the current company context anyway right? So if you just don’t make the baq cross company then isn’t the company already enforced?
If there is no company field, how will it know?
Because by default everything runs in the current company context?
Hmmm let me just that 1300 page posting engine doc…
I get that, but I am adding a BAQ and need to wire it up to the GL Transaction Type. If I don’t specifically state what Company it is for, how will it know? I am reaching outside of the posting logic and saying get this data from a BAQ. If I don’t tell it what Company, it will potentially pull back the same record for every company if it exists. Like PONum.
BAQs will only run for the current company unless you have marked the cross company checkbox. So if you just don’t check that box you should be fine.
Are you using the PostingRulesPackage table? Can you link that to GLBook where Package = DefaultPackage?
Then you can get Company off of the GLBook table’s company column?
I state again… If the table being referenced, has no company column, the baq cannot know which company to pull. It’ll be wide open for that table.
What table doesn’t have a company column?
Whichever one @jkane was linking lol.
I guess that is my confusion . . . what is the baq looking at?
This is where I am at. GL Transaction Type Maintenance.
I did not expand any of the nodes, but under all of those, there is no field that stores Company.
I think most of that info is in the Erp.ABTXXXX tables.
Also look at the Erp.ACTType and Erp.ACTRevision
It is against the POHeader. There is a field I want available in the Incoming Document Line that is not there, so I created a BAQ that pulls that single field.
Now I see what you are saying @aosemwengie1 , it seems that when you mark a BAQ as All Companies, it creates a parameter in the background that is handled by the system. I never knew this.
If you create a BAQ and mark it All Companies, then create two parameters for Company and PONum, you will get an error when you try to run it stating that the Company column is already there.
