How to access data form Pervasive SQL in SQL Management Studio

Create Linked Server PERVASIVE using OLEDB Provider for ODBC 

 SELECT * FROM OPENQUERY(PERVASIVE,'SELECT * FROM mytable')

Business Central - EXEID Buffer index out of range

 Rebuild your package, re-export a new excel

Check your data and confirm it's all valid data for each field you're trying to import

Disable the table triggers in the config package

LS Statements

Create missing accounting periods. This can prevent posting from completing.

Problem originates from too many transaction existing in the buffer entry.

Split up the statement into smaller time periods and post each out separately, every hour or 15 mins.

Try Post sales first, then post statement after

Try Disable cost posting, then post costs after

LS Retail Hardware station - Service starts then stops

 Check logs in 

C:\ProgramData\LS Retail\LS Hardware Station 

 

Uninstall hardware station

Delete C:\PRogramData\LS Retail\Hardware Station 

Restart machine to clear any hardware claims 

 

Reinstall Hardware station 

Start service

master.$ndo.$srvproperty missing

Related errors: Cannot install licence, cannot find license file 

Run BC install

Select your BC instance

Install SQL Server components

Business Central - Extensions - Write to Odata

•  Create custom page with modifyallowed = true in page properties
• This allows odata to write to the page

Business Central - General Journal - Posting Dates are the same for all lines, even though different dates were copied or imported

 Change the view from "Show fewer columns" to "Show More".

The "Show Fewer" view uses a batch date for the entire journal and ignores the actual posting date field on the lines.

Ls Retail - Retail Receiving - Item ledger entries are not generated after posting retail receiving. Retail receiving does not post.

• Go to Inventory Management setup
• Change the  Receiving Posting to "Full Posting" (Generates invoice) or "Received Qty Only" (Stock only)