Small and medium business | Business Central, N...

Vendor 1099 Information Access From an Extension

(3) Share

Report

Posted on by Kevin Fernandez

Hello,

We are creating an extension with AL in Visual Studio Code for Business Central. A requirement for the customer is that we need to be able to change the 1099 information for any given vendor from within the extension.

We assume this data it stored in the IRS Forms app, but we cannot get access to these tables. How can we get access to a vendor's 1099 information?

Thanks!

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Suresh Kulla 49,956 Super User 2025 Season 2 on at

Like (1)

Report

Vendor 1099 Information Access From an Extension

Although FieldRef and RecordRef help retrieve data from any table, I don't prefer them only if you have access to the extension. That scenario is usually used for ISVs, where you don't have access, or if there is only a scenario of reading limited data values, but not for the entire extension objects. In my opinion, it would be an awful design to use RecRef for all objects.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 91,978 Super User 2025 Season 2 on at

Like (0)

Report

Vendor 1099 Information Access From an Extension

Hi, hope the following can give you some hints.

How to get field values from other extensions/apps in Business Central without adding dependencies property

https://yzhums.com/31555/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 29,236 Super User 2025 Season 2 on at

Like (1)

Report

Vendor 1099 Information Access From an Extension

Hope this helps as well - Work with multiple projects and project references - Business Central | Microsoft Learn

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,956 Super User 2025 Season 2 on at

Like (1)

Report
Vendor 1099 Information Access From an Extension

Those tables are not part of the base extension; you need to add the dependency below in app.json, based on the version you have in your extension management. Always check the extensions tab on the Page Inspection to check which extension the table is part of

"dependencies": [ { "id": "b696b4c9-637c-49d1-a806-763ff8f0a20e", "name": "IRS Forms", "publisher": "Microsoft", "version": "27.0.38460.39615" } ],

Was this reply helpful? Yes No
Kevin Fernandez 28 on at

Like (1)

Report

Vendor 1099 Information Access From an Extension

Hi Suresh,

Thanks for the response. Basically, I am trying to edit the data in the page IRS 1099 Vendor Form Box Setup.

From doing a page inspection, it appears this data is in table IRS 1099 Vendor Form Box Setup (10034)

However, when I try to access this table in code, I get the message

Table 'IRS 1099 Vendor Form Box Setup' is missingALAL0185

Here's the AL code trying to declare it

Thanks!

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,956 Super User 2025 Season 2 on at

Like (2)

Report

Vendor 1099 Information Access From an Extension

What do you mean by the 1099 data? The IRS Form data uses Vendor Ledger Entries and Purchase Cr. Memo or Invoices for that Vendor to pull the data. Those tables are posted tables. Are you trying to update the data in those tables? If not, please provide us with an example or a screenshot of what you would like to edit.

1 people found this reply helpful.

Was this reply helpful? Yes No