Stock Take PDA DB Extraction

Stock Take PDA DB Extraction

The video below details the processes and steps needed to follow to extract a db, save it as a csv and upload it to Posibolt. This process will also expose the issue and direct you to resolving it.
https://meeting.zoho.com/meeting/public/videoprv?recordingId=bdea9ae2d0fdd7ac2710ea87f30f27c4ef30191c6b022d33e8615a45c5ec4fa7

1 - Download SQL Lite Browser
2 - Open DB using SQL Lite Browser
3 - Browse Stock Take Record to find the Record ID for the sheet names in question
4 - Export Stock Take Line and filter by the required Record IDS
5 - Prepare in POSibolt Import template and upload to expose issues, correct them and complete the stock take.

The above points are covered in detail in the video including how to go about navigating SQL lite browser, where to download it from and how to upload and complete

    • Related Articles

    • Quantity Values Returned Through Posibolt API's

      Three main configurations affect the returned stockQty from the Posibolt API 1 - Role Configuration To use the API calls, we need a set of credentials including a Posibolt user name. The role to which this username belongs has warehouse access ...

    • POSIBOLT ERP Release Notes - Posibolt Version: 8.4 (28032 - PT)

      NEWLY INTRODUCED FEATURES 1.1 ACCOUNTING AC-F-01: Made a few enhancements in the Bank Statement Import screen: Added the option to delete lines once they are uploaded into the Bank Statement Import Screen. Implemented the feature to load the Bpartner ...

    • POSIBOLT ERP Release Notes - Version 8.4.12

      1. NEWLY INTRODUCED FEATURES 1.1 ACCOUNTING AC-F-01: Introduced group-wise transactions for payments and receipts. a. CustomerMaster Screen Enhancements: i. Added 'isSummary' checkbox and Parent Customer filter. ii. Customers with 'isSummary' checked ...

    • POSIBOLT ERP Release Notes - Version 8.4.0

      1. NEWLY INTRODUCED FEATURES 1.1 APPS AP-F-01: Enhanced the API to transmit the ordered date and 'line' value for sorting the order lines. 1.2 GENERAL GN-F-01: Enhanced the GUI screen while running the RUN_Setup.sh to edit the jnp Port field. ...

    • POSIBOLT ERP Release Notes - Version 8.3.22

      1. NEWLY INTRODUCED FEATURES 1.1 ADMINISTRATION AD-F-01: Improved the overall performance of Price List Schema Run and additionally introduced a new rounding mode named 'Price Precision', formerly the price value was rounded off based on currency ...