Skip to main content

Third Party Import

Mamee​

Is External Shareware Program which to import Mamee Text or CSV file to

  • Sales Invoice
  • Sales Credit Note
  • Sales Debit Note (Non Product Related Only)

Limitation (Mamee)​

  • Fixed Tax Code SR (i.e. all transaction is SR)
  • Only support Mamee Product Related file (i.e. file with end HDR or DTL eg INVHDR or INVDTL)

Mamee Specification​

Format 1 (Mamee)​

Format 2 (Mamee)​

Import Program (Mamee)​

History New/Update/Changes (Mamee)​

--Build 5--

  • Upgrade to Version 2.4.

  • Upgrade to New Compiler.

  • Add Format 2 import. --Build 4--

  • Upgrade to Version 1.3.

  • Add Maintain Non-Product GL Function.

  • Enable Import Non-Product Sales CN & DN Import --Build 3--

  • Upgrade to Version 1.2.

  • Error in matching Agent

  • Amount not excluding Disc Amount after Import.

  • Add Link to SQL Acc. File | Run.

  • Rearrange Detail column

  • Fix Detail not Sort by Seq

  • Set Disc to 2 Decimal Point. --Build 2--

  • Error on Maintain Agent if Record More then 1 --Build 1--

  • Upgrade to Version 1.1

  • Add Maintain Agent Function.

  • Enable Use Census Number field as SQL Acc Customer Code.

Field Mapping - Header (Mamee)​

Produc Related - Format 1 (Mamee Header)​

21

Product Related - Format 2 (Mamee Header)​

22

Field Mapping - Detail (Mamee)​

Product Related - Format 1 (Mamee Detail)​

23

Product Related - Format 2 (Mamee Detail)​

24

25

Setting (Mamee)​

In SQL Accounting (Mamee)​

Make sure this option is Tick under Tools | Options | Customer

  • One Cent Different Rounding (Local Currency Fields) for all AR/SL Documents (Recommended)

In Mamee Import​

Menu : Tools | Options...

OptionsDescription
MameeCustomerCodeAsCode0 : Mamee Census Number check against SQLAcc Customer Code Field
1 : Mamee Customer Code same as SQLAcc Customer Code Field (Recommended)
MameeSalesmanCodeAsAgent0 : Mamee Salesman Code will use Mamee Import Agent List
1 : Mamee Salesman Code same as SQLAcc Agent Code (Recommended)
FormatType1 : Format 1
2 : Format 2

Menu : Tools | Maintain Agent...

1

OptionsDescription
Saleman CodeMamee Salesman Code
AgentSQL Accounting Agent Code
  1. Click the + button
  2. Enter the Mamee Salesman Code
  3. Select the SQL Accounting Agent Code
  4. Click Tick to Save Menu : Tools | Maintain Non-Product GL...

2

OptionsDescription
Mamee Reason CodeMamee Reason Code
Reason Desc.Mamee Reason Description
GL Acc. Debit NoteSQL Accounting GL Account Code for Debit Note
GL Acc. Credit NoteSQL Accounting GL Account Code for Credit Note
  1. Select the record
  2. Click Edit (the up arrow)
  3. Select the GL Code for Debit Note
  4. Select the GL Code for Credit Note
  5. Click Tick to Save

Steps (Mamee)​

Below steps is example to import Sales Invoice

  1. Click Product | Invoice...

    3

  2. Click Get File button & system will prompt 2 dialog like below

    4

  3. Select the Mamee Invoice Text/CSV Header File

  4. Click Open

    5

  5. Select the Mamee Invoice Text/CSV Detail File

  6. Click Open

  7. Click Verify button to check the data with SQL Accounting Data

  8. Click Post To A/c button if confirm all is ok to post to SQL Accounting

info

Record(s) will only Post if the Check Box is Tick & Status is Ok

Below steps is example to import Sales Credit Note

  1. Click Non-Product | Credit Note...

    6

  2. Click Get File button & system will prompt dialog like below

    7

  3. Select the Mamee Non Product Credit Note Text/CSV File

  4. Click Open

  5. Click Verify button to check the data with SQL Accounting Data

  6. Click Post To A/c button if confirm all is ok to post to SQL Accounting

F&N​

Is External Shareware Program which to import F&N Text file to

  • Sales Invoice

  • Sales Credit Note Export E-Invoice to F&N - Available in Build 18 & Above

  • Sales Invoice

  • Sales Credit Note

Limitation (F&N)​

  • TaxCode with DS will not import.

F&N Specification​

Import Program (F&N)​

  • Version (3.5.0.23) - 18 Dec 2024
  • Evaluation Limit : 50 Records per file
  • SQL Account F&N Import Setup
  • MD5 : F8114AE694FB966D93082A3FEC57D17C

History New/Update/Changes (F&N)​

--Build 23--

  • Remove Check UOM from Option.

  • Add check UOM base on FnN UOM. --Build 22--

  • Fix partly support Version 860 & above.

  • Add show Outlet Name. --Build 21--

  • Enable support Version 858 for Export E-IV.

  • Enable support Version 860 & above. --Build 20--

  • Fixed Export E-IV for CN apply error.

  • Fixed Export E-IV dateTimeValidated formatting not correct. --Build 19--

  • Enable Import E-Invoice Info from FnN.

  • Fixed Export E-IV header delimiter not correct. --Build 18--

  • Upgrade to Version 3.6.

  • Add FnN to Header Field CC as indicator Import from FnN.

  • Remove L tax code from import.

  • Set Default Open FnN ESD Online Files format.

  • Add E-Invoicing Export function. --Build 17--

  • Fixed Use UOMList not working. --Build 16--

  • Add Import Remark to DeliveryTerm Field for CSV format. --Build 15--

  • Add Auto Set to Outlet_ID2 if Debtor_Code2 is empty for CSV format.

  • Add Get User Guide Option. --Build 14--

  • Upgrade to Version 3.5.

  • Enable support Running In Windows Limited User.

  • Fixed Verify Detail Error not untick the Master when itemcode not found.

  • Fixed Verify Not Check Item Code UOM.

  • Fixed Scrollbar not visible. --Build 13--

  • Upgrade to Version 3.4.

  • Add Project & Location Lookup for Posting. --Build 12--

  • Add Outlet_ID2 to shown in Grid. --Build 11--

  • Upgrade to D25 Compiler.

  • Upgrade to Version 3.3.

  • Remove Import Debtor_Name2. --Build 10--

  • Upgrade to XE10 Compiler.

  • Upgrade to Version 3.2

  • Add Link to SQL Acc. File | Run.

  • Add OutletID=Maintain Customer Code

  • Add ESD Online - CSV Format --Build 9--

  • Fix unable to import docamt is 0 even is no DS Code.

  • Fix Status no dropdown list.

  • Fix Detail not Verify. --Build 8--

  • Fix Get File Error when record is without tax code. --Build 7--

  • Fix CN Get File Error.

Field Mapping - Header (F&N)​

  • As at 17 Jun 2015 - ESD soft-drink - Fixed Length Format
FnN FieldField PositionField SizeSQL Accounting Field
Invoice_Date110DocDate
Invoice_ID1110DocNo
Gross Amount4110DocAmt
Outlet_ID7110Maintain Customer Remark or Code
  • As at 15 Aug 2016 - ESD Online - CSV Format
FnN FieldField PositionField SizeSQL Accounting Field
Invoice_Date010DocDate
Invoice_ID115DocNo
Total_Gross_Amount410DocAmt
Debtor_Code2910Customer Code
Debtor_Name210150Customer Name
Not valid for Build 11 & above
Outlet_ID21110Display Only
Remark12200Delivery Term
Available in Build 16 & above

Field Mapping - Detail​

  • As at 17 Jun 2015 - ESD soft-drink - Fixed Length Format

26

  • As at 15 Aug 2016 - ESD Online - CSV Format

27

Setting (F&N)​

In SQL Accounting (F&N)​

  1. May refer to Point 2 at Things To Consider Before Import/Post
  2. Make sure this option is Tick under Tools | Options | Customer
  • Perform Tax/Local Amount Rounding

In F&N Import​

OptionsDescription
UOMListList of UOM available in F&N (Normally is CTN & PCS)
DocNoAsDocNo0 : F&N DocNo will post to SQLAcc DocNoEx Field
1 : F&N DocNo will post to SQLAcc DocNo Field (Recommended)
FNCodeAsItemCode0 : F&N ItemCode will check against SQL Accounting | Maintain Item | Note Field
1 : F&N Itemcode same as SQL Accounting Itemcode (Recommended)
FNUOMAsUOM0 : F&N ItemCode will check against UOMList
1 : F&N Itemcode UOM same as SQLAcc Itemcode UOM (Recommended)
OutletIDAsCompCodeFor ESD soft-drink – Fixed Length Format Only
0 : F&N Outlet ID will check against SQL Accounting | Maintain Customer | Remark Field
1 : F&N Outlet ID same as SQLAcc Customer Code (Recommended)

Steps (F&N)​

Import Invoice/Credit Note (F&N)​

Below steps is example to import Sales Invoice 01. Click Sales | Invoice... 02. Click Get File button & system will prompt 2 dialog like below

8

  1. Click Files of Type & select the FnN File Format type

  2. Select the F&N Invoice Text Header File

    9

  3. Select the F&N Invoice Text Detail File

    10

  4. Click Verify button to check the data with SQL Accounting Data

  5. Select Project & Location (if Required)

  6. Click Post To A/c button if confirm all is ok to post to SQL Accounting

caution

Remember to check the data with Has Deemed Supplies column which is Tick as system will by pass posting

Export E Invoice/Credit Note (F&N)​

11

  1. Click Export E-Invoice Status...
  2. Select Range Date (E-Invoice Submission date)
  3. Select DocType (eg Invoice)
  4. Click Apply
  5. Click Export

Unilever​

Is External Shareware Program which to import Unilever CSV file to

  • Sales Order
  • Sales Invoice
  • Sales Credit Note

Unilever Specification​

Import Program (Unilever)​

  • Version (1.3.0.12) - 05 Apr 2025
  • Evaluation Limit : 100 Records per file
  • SQLAccUnileverImp-setup.exe
  • MD5 : 44F7A21D88D3EA4F4C1D7CF0571FFD5D

History New/Update/Changes (Unilever)​

--Build 12--

  • Fixed Get SO for Old Format no data. --Build 11--

  • Upgrade to Version 1.3.

  • Add Option to Import as Sales Order.

  • Add Get User Guide option. --Build 10--

  • Enable Support Version 860 & above. --Build 9--

  • Add Copy Cell Value Function.

  • Add Auto Add Rounding for DocAmt <&gt Total Detail Amount. --Build 8--

  • Fixed Find Company Code not Correct if almost same Retail Code.

  • Fixed Setting loss after uninstall. --Build 7--

  • Upgrade to Version 1.2.

  • Enable Support if Unilever using Both Cases and Pieces for 1 row by Convert to Smallest UOM for Cases. --Build 6--

  • Add ZRL & SR TaxCode Option --Build 5--

  • Fix Header DocNo not match with Detail DocNo --Build 4--

  • Verify DocNo not correct for Old Format import

  • Amount should deduct Discount before append --Build 3--

  • Upgrade to Version 1.1.

  • Add back Old Format Import with auto add 00 in-front of DocNo before Post to Account. --Build 2--

  • Fixed UnitPrice 0 when After Post to Account. --Build 1--

  • Update New Format. --Build 0--

Field Mapping - Header (Unilever)​

  • 25 Sep 2017
Unilever FieldField PositionField SizeSQL Accounting Field
INVH_Type1201 – Sales Invoice
02 – Sales Credit Note
INVH_No310DocNo
INVH_Retailer178Code or Maintain Customer Remark
INVH_Date2619DocDate
INVH_Total14121Amount Before Discount
INVH_Discount16221Discount Amount
  • 07 Feb 2018
Unilever FieldField PositionField SizeSQL Accounting Field
INVH_Type1201 – Sales Invoice
02 – Sales Credit Note
INVH_No312DocNo
INVH_Retailer198Code or Maintain Customer Remark
INVH_Date2819DocDate
INVH_Total14321Amount Before Discount
INVH_Discount16421Discount Amount

Field Mapping - Detail (Unilever)​

  • 25 Sep 2017
Unilever FieldField PositionField SizeSQL Accounting Field
INVR_No310DocNo
INVR_Product138Item Code or
Maintain Item Code Note
INVR_Cases2622Qty (UOM = CA)
INVR_Pieces4822Qty (UOM = PCS)
INVR_Amount7021Amount
INVR_Discount9121Discount
INVR_TAXRate133220 Tax Code = ZRL
6 Tax Code = SR
INVR_TAXTotal15521GST Amount
  • 07 Feb 2018
Unilever FieldField PositionField SizeSQL Accounting Field
INVR_No312DocNo
INVR_Product158Item Code or
Maintain Item Code Note
INVR_Cases2822Qty (UOM = CA)
INVR_Pieces5022Qty (UOM = PCS)
INVR_Amount7221Amount
INVR_Discount9321Discount
INVR_TAXRate135220 Tax Code = ZRL
6 Tax Code = SR
INVR_TAXTotal15721GST Amount
  • Unit Price will not import & will auto Assign by SQL Accounting due to Unilever file don't had Pieces Price & UOM Rate

Setting (Unilever)​

In SQL Accounting (Unilever)​

  1. May refer to Point 2 at Things To Consider Before Import/Post

  2. Make sure this option is Tick under Tools | Options | Customer

    • Perform Tax/Local Amount Rounding

  3. Menu: Stock | Maintain Stock Item...

  • Item Code to be create
    • Rounding

In Unilever Import (Unilever)​

This can be see under Tools | Options

OptionsDescription
UOM_CasesUOM for Cases in SQL Accounting
Default is CA
UOM_PiecesUOM for Pieces in SQL Accounting
Default is PCS
RetailAsCompCode0 : Unilever Retail Code will check against SQL Accounting | Maintain Customer | Remark Field
1 : Unilever Retail Code same as SQL Accounting Customer Code (Recommended)
UnileverCodeAsItemCode0 : Unilever Item Code will check against SQL Accounting | Maintain Item | Note Field
1 : Unilever Item Code same as SQL Accounting Item Code (Recommended)
TaxCodeZRLTax code for 0%
TaxCodeSRTax Code other than 0%

Steps (Unilever)​

Below steps is example to import Sales Invoice

  1. Click Sales | Invoice...

  2. Click Get File button & system will prompt 2 dialog like below

    12

  3. Select the Unilever Invoice Text Header File

    13

  4. Select the Unilever Invoice Text Detail File

    14

  5. Click Verify button to check the data with SQL Accounting Data

  6. Select Project & Location (if Required)

  7. Click Post To A/c button if confirm all is ok to post to SQL Accounting

Dryper​

Is External Shareware Program which to import & Export Dryper excel file to

Import

  • Sales Order or Sales Invoice
  • Purchase Order or Purchase Invoice Export
  • Sales Credit Note

Dryper Specification​

Import Program (Dryper)​

  • Version (1.1.0.3) - 29 Jan 2021
  • Evaluation Limit : 100 Records per file
  • SQLAccDryperImp-setup
  • MD5 : 5D18B0207C9C12168D0394855EA378ED

History New/Update/Changes (Dryper)​

--Build 3--

  • Enable Support Version 782 & above (New ROC).

  • Fixed DocNo Not able to select.

  • Fixed Unable to Batch Highlight DocNo.

  • Fixed Import Prompt Date Error.

  • Add Shortcut Get User Guide. --Build 2--

  • Add Option SL-UseDryperItemDesc & PH-UseDryperItemDesc.

  • Add Option SL-UseDocNoEx & PH-UseDocNoEx.

  • Fixed Setting will loss on Uninstall. --Build 1--

  • Upgrade to Version 1.1.

  • Add Option for use CustomerCode or ExternalReferenceNo2 for SQL Accounting Customer Code.

  • Add Check Box at DocNo & remove Check Box in Data Grid

  • Add Import PO & PI.

  • Add Checking for BizNature & CompanyName2 field for Customer/Supplier Code

  • Remove Import DocNoEx for ExternalReferenceNo2

  • Add Checking for Description2 & Note field for Item Code.

  • Fixed unable to register. --Build 0--

Field Mapping (Dryper)​

Sales Order or Sales Invoice (Dryper Mapping)​

Dryper Field – SODryper Field – IVSQL Accounting Field
SalesOrderCodeSalesInvoiceCodeDocNo
Either 1 belowEither 1 below
CustomerCodeCustomerCodeCode
ExternalReferenceNo2ExternalReferenceNo2RegisterNo / GSTNo / Remark / CompanyName2
OrderDateInvoiceDateDocDate
ItemCodeItemCodeEither 1 below
Code
Remark1
Remark2
Shelf
Barcode
ItemNameItemNameItem Description
QuantityQuantityQty
UOMUOMUOM
UnitPriceUnitPriceUnitPrice
DiscountRate
where LineType = 1		DiscountRate
where LineType = 1		Disc
TotalTaxAmountTotalTaxAmountTaxAmt
NetAmountNetAmountAmount
RoundingAmountRoundingAmountWill Append as New itemcode RTN5Cents

Purchase Order or Purchase Invoice (Dryper Mapping)​

Dryper Field – PODryper Field – PISQL Accounting Field
PurchaseOrderNoInvoiceNoDocNo
Either 1 belowEither 1 below
CreditorCodeCreditorCodeCode
SupplierCodeSupplierCodeRegisterNo / GSTNo / Remark / CompanyName2
ItemCodeItemCodeEither 1 below
Code
Remark1
Remark2
Shelf
Barcode
ItemNameItemNameItem Description
POQuantityQuantityQty
UOMUOMUOM
UnitCostUnitPriceUnitPrice
NetAmountNetAmountAmount
OrderDateGRNDateDocDate

Customer Credit Note - Export (Dryper Mapping)​

Dryper FieldSQL Accounting Field
CompanyCodeHard Coded as 1
DistributorCodeField To Enter in Export Program
BranchCodeField To Enter in Export Program
CustomerCodeCustomer Code
DocumentNoDocNo
DocumentDateDocDate
TotalAmountDocAmt
PaidAmountDocAmt
StatusHard Coded as 1
CreatedByHard Coded as SYSTEM
CreatedTimestampDocDate

Setting (Dryper)​

In SQL Accounting (Dryper Setting)​

  1. May refer to Point 2 at Things To Consider Before Import/Post

In Dryper Import (Dryper Setting)​

This can be see under Tools | Options

OptionsDescription
UseCustomerCode0 : Import will use Dryper ExternalReferenceNo2 Field as Customer Code
1 : Import will use Dryper CustomerCode Field as Customer Code
UseSupplierCode0 : Import will use Dryper CreditorCode Field as Supplier Code
1 : Import will use Dryper SupplierCode Field as Supplier Code
SL-UseDryperItemDesc0 : Import will use SQL Accounting Item Description For Sales Import
1 : Import will use Dryper Item Description For Sales Import
PH-UseDryperItemDesc0 : Import will use SQL Accounting Item Description For Purchase Import
1 : Import will use Dryper Item Description For Purchase Import
SL-UseDocNoEx0 : Import will Map Dryper DocNo to SQL Accounting DocNo For Sales Import
1 : Import will Map Dryper DocNo to SQL Accounting DocNoEx For Sales Import
PH-UseDocNoEx0 : Import will Map Dryper DocNo to SQL Accounting DocNo For Purchase Import
1 : Import will Map Dryper DocNo to SQL Accounting DocNoEx For Purchase Import

Sales Order or Sales Invoice (Dryper Setting)​

Below is example for import Sales Invoice... Menu: Sales | Invoice...

  1. Click 1. Get File button

    15

  2. Select the File file wanted to import

  3. Click Open

    16

  4. Select the Excel Sheet (if more then 1)

  5. Set No of record to Load (only available for Registered user)

  6. Click 2. Get Data button

  7. Click 3. Verify button

  8. Click 4. Post To A/c button

Customer Credit Note - Export (Dryper Setting)​

Menu: Customer | Customer Credit Note - Export... 17

  1. Enter the Distributor Code (Provided by Dryper)
  2. Enter the Branch Code (Provided by Dryper)
  3. Select Range Date To export
  4. Click Get Data... to get the Data from SQL Accounting
  5. Click Export to xlsx to export out

FAQ (Dryper)​

How it look like if Dryper had 3 level of discount?​

Once Import it will look like below

18

SLPH​

Is External Shareware Program which Convert Sales to Purchase Module or vice versa which exported from SQL Accounting Normally is use to Export Data From SQL Accounting Database A from Document Type A (Eg Sales Invoice) & Import to SQL Accounting Database B as other Document Type (Eg Purchase Invoice)

Limitation (SLPH)​

  • Only support 1 Company Code (i.e. 1 batch 1 Company Code)
  • Both Source & Target must had Same Itemcode

Import Program (SLPH)​

  • Version (5.2.1.10) - 20 Aug 2025
  • Download Link
  • MD5 : 7ECC58CCBA8B04A00E2F5582D234CE14

History New/Update/Changes (SLPH)​

--Build 10--

  • Fixed Tax Code empty after verify.

  • Fixed TaxInclusive not Import. --Build 9--

  • Fixed Get File no records when in SQL Connect. --Build 8--

  • Fixed Get File Error due to SEQ field. Add Get User Guide... Option. --Build 7--

  • Upgrade to Version 5.2.1.

  • Enable Quick Customise Layout for Grid.

  • Empty Item Code should by pass from Verify.

  • Allow User Override Header Description.

  • Enable Support Unicode --Build 6--

  • Fixed Import Sales/Purchase CN & DN Error. --Build 5--

  • Upgrade to Version 5.2.

  • Add Option Use My Maintain Supplier/Customer Information for Sales/Purchase Import.

  • Enable support Running In Windows Limited User. --Build 4--

  • Fixed Shown TaxCode Even Original no TaxCode. --Build 3--

  • Fix TaxRate Not Import

  • Fixed Import Customer/Supplier prompt bad variance type. --Build 2--

  • Enable Support Version 5 SQL Accounting

  • Add Maintain Tax --Build 1--

  • Fix unable to register Database

Setting (SLPH)​

In SQL Accounting (SLPH)​

  1. May refer to Point 2 at Things To Consider Before Import/Post
  2. Make sure this option is Tick under Tools | Options | Customer
    • Perform Tax/Local Amount Rounding

In SLPH Import​

Menu : Tools | Maintain Tax

19

  1. Click New/Edit to Insert or update
  2. Select Sales Tax Code
  3. Select Purchase Tax Code
  4. Click Post/Save

Steps (SLPH)​

Menu : Purchase | Purchase Invoice... Below steps is example to import Purchase Invoice

20

  1. Click Get File button
  2. Select Supplier Code to update
  3. Click Change Button
  4. Click Verify button
  5. Click Post to A/c Button
OptionDescription
Use Supplier Document NoTick : Will follow DocNo in the XML
UnTick : Auto Assign New Document Number In SQL Accounting
Use My Maintain Supplier InformationTick : Will follow Maintain Supplier Information
UnTick : Will follow Document Supplier Information
Purchase Invoice (Below Use My Maintain Supplier Information Option)Empty it : Will follow Document Header Description
With Value : Will follow the value entered in this field for Header Description