Excel Report Builder

Suggested Outsourcing Purchase Orders SmartList Builder Template

The Suggested Outsourcing Purchase Orders SmartList Builder setup is built to mimic the default Suggested Outsourcing Purchase Orders SmartList/Excel Report in the Manufacturing Series. ID: MFG_SUG_OS_PO Name: Suggested Outsourcing Purchase Orders Tables Involved: EXP_SuggestedOSRCPO  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder. Note:These templates are designed to be a…

[Read More]

Receivables Transactions SmartList Builder Template

The Receivables Transactions SmartList Builder setup is built to mimic the default Receivables Transactions SmartList/Excel Report in the Sales Series. ID: RM_TRX Name: Receivables Transactions Tables Involved: RM Sales Work File RM Open File RM History File Customer Master Summary RM National Accounts Master Multicurrency Receivables Transactions RM Key File Posting Definitions Master  Screen shots…

[Read More]

Payroll Historical Trx SmartList Builder Template

The Payroll Historical Trx SmartList Builder setup is built to mimic the default Payroll Historical Trx SmartList/Excel Report in the Payroll Series. ID: PAY_TRX_HIST Name: Payroll Historical Trx Tables Involved: Payroll Transaction History Payroll Master Payroll Address Master Payroll Tax Information Master  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List…

[Read More]

PA Timesheet Transactions SmartList Builder Template

The PA Timesheet Transactions SmartList Builder setup is built to mimic the default PA Timesheet Transactions SmartList/Excel Report in the Project Accounting Series. ID: PA_TIMESHEET Name: PA Timesheet Transactions Tables Involved: PA Timesheet Header File  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder. Note:These templates are designed to be…

[Read More]

PA Equipment Log Historical Transactions SmartList Builder Template

The PA Equipment Log Historical Transactions SmartList Builder setup is built to mimic the default PA Equipment Log Historical Transactions SmartList/Excel Report in the Project Accounting Series. ID: PA_EQUIP_LOG_HST Name: PA Equipment Log Historical Transactions Tables Involved: PA Equipment Log Header History File  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation…

[Read More]

PA Equipment SmartList Builder Template

The PA Equipment SmartList Builder setup is built to mimic the default PA Equipment SmartList/Excel Report in the Project Accounting Series. ID: PA_EQUIPMENT Name: PA Equipment Tables Involved: PA Equipment Master File PA Equipment Class Setup File  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.    Note:These templates are…

[Read More]

PA Billing Work Transactions SmartList Builder Template

The PA Billing Work Transactions SmartList Builder setup is built to mimic the default PA Billing Work Transactions SmartList/Excel Report in the Project Accounting Series. ID: PA_BILL_WORK Name: PA Billing Work Transactions Tables Involved: PA Billing Header WORK RM Customer MSTR  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.…

[Read More]

PA Billing Historical Transactions SmartList Builder Template

The PA Billing Historical Transactions SmartList Builder setup is built to mimic the default PA Billing Historical Transactions SmartList/Excel Report in the Project Accounting Series. ID: PA_BILL_HIST Name: PA Billing Historical Transactions Tables Involved: PA Billing Header HIST RM Customer MSTR  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder.…

[Read More]

PA IV Transfer Historical Transactions SmartList Builder Template

The PA IV Transfer Historical Transactions SmartList Builder setup is built to mimic the default PA IV Transfer Historical Transactions SmartList/Excel Report in the Project Accoungting Series. ID: PA_IV_TRNF_HIST Name: PA IV Transfer Historical Transactions Tables Involved: PA Inventory Transfer History Header  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List…

[Read More]

Vendor Addresses SmartList Builder Template

The Vendor Addresses SmartList Builder setup is built to mimic the default Vendor Addresses SmartList/Excel Report in the Purchasing Series. ID: VEND_ADD Name: Vendor Addresses Tables Involved: PM Address MSTR PM Vendor Master File Internet Addresses  Screen shots of Setup in SmartList Builder, Excel Report Builder, and Navigation List Builder. Note:These templates are designed to…

[Read More]

RECENT POSTS


Use the REST Connector to parse nested Value Arrays
SmartConnect email task fails with error: An invalid character was found in the email header
Does SmartConnect import into Avalara Avatax software
Could not initialize a collection when launching SmartConnect
ERROR [HY000] [Microsoft][ODBC Excel Driver]General error Unable to open registry key when you open a SmartConnect map.

POPULAR POSTS


SSL Security error using OLEDB Connection
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site

CATEGORIES

ARCHIVES

open all | close all

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock release Reporting SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training