Sage 50
Customer Sync
Sage Field | Service Geeni Field |
Reference | Account Number |
Name | Account Name |
Address Line 1 | Address1 |
Address Line 2 | Address2 |
Address Line 3 | Address2 (Concatenated with Accounts package Address Line 2) |
Address Line 4 | County |
Postcode | Postcode |
City | <NOT USED> |
County | <NOT USED> |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
Currency Code (ISO Code) | Currency (Matching on country name, fall back to GBP if no match) |
VAT Code | VAT Code (based on TPLCode on VAT matching the VAT Code from Accounts) |
Main Telephone | Telephone |
Main Fax | Fax |
Payment Terms Days | Payment Terms Days Required |
Payment Terms Text | Payment Terms Text |
On Hold |
|
‘All Branches’ | Branch (only applied to new records) |
A site will also be created for any customers that don’t have a site Once a customer import has run, the address and telephone no are copied from the customer record.
Code References
1. Pulled from Sage
/Services/AccountBridge/AccountsPackage.Sage.Line50/Data/Customer/SageCustomerRepository.cs
2. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
3. Saved to SG by
/Service Manager/WebUI/Controllers/API/AccountsController.cs
4. Merged to SG by sproc
spSyncOfflineTPLCustomers
Supplier Sync
Sage Field | Service Geeni Field |
Reference | Account Number |
Name | Account Name |
Address Line 1 | Address1 |
Address Line 2 | Address2 |
Address Line 3 | <NOT USED> |
Address Line 4 | <NOT USED> |
Postcode | PostCode |
City | City |
County | County |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
Currency Code (ISO Code) | Currency (Matching on country name, fall back to GBP if no match) |
VAT Code | VAT Code (based on TPLCode on VAT matching the VAT Code from Accounts) |
Main Telephone | Telephone |
Main Fax | Fax |
Code References
1. Pulled from Sage
/Services/AccountBridge/AccountsPackage.Sage.Line50/Data/ Supplier/SageSupplierRepository.cs
2. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
3. Saved to SG by
/Service Manager/WebUI/Controllers/API/AccountsController.cs
4. Merged to SG by
sproc spSyncOfflineTPLSuppliers
Sales Ledger
Service Geeni Field | Sage Field |
Account Number | Account Ref |
Invoice Date | Transaction Date |
<Current Date Time> | Posted Date |
First name and Last name of use who created the invoice | Username |
Transaction Type | Details (Limited / truncated to 60 characters) (Details from first Line) |
Invoice Number | Invoice Reference |
Foreign Rate | <Only on Forex> ExchangeRate |
Currency | <Only on Forex> Currency Code (Matched to Sage Currency record based on Currency Code) |
An invoice will post a ‘Split’ for each nominal code used in the invoice:
Service Geeni Field | Sage Field |
NominalCode | NominalCode |
TaxCode | TaxCode |
NetAmount | NetAmount |
TaxAmount | TaxAmount |
ForeignNetAmount | <Only on Forex> ForeignNetAmount |
ForeignTaxAmount | <Only on Forex> ForeignTaxAmount |
{Invoice Type} {Ref field} | Details (Limited / truncated to 60 characters) |
Invoice Date | Date |
<Current Date Time> | PostedDate |
First name and Last name of user who created the invoice | UserName |
Department Code | DeptNumber |
Code References
1. Sproc
[spGetOfflineTPLSalesNominals]
2. Processed by
/Service Manager/WebUI/Controllers/API/SalesController.cs
3. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
4. Mapped to Sage by
/Services/AccountBridge/AccountsPackage.Sage.Line50/Handlers/SalesNominalPoster.cs
Purchase Ledger
Service Geeni Field | Sage Field |
Account Number | Account Ref |
Invoice Date | Transaction Date |
<Current Date Time> | Posted Date |
First name and Last name of user who created the invoice | User name |
Transaction Type | Details (Limited / truncated to 60 characters) (Details from first Line) |
Invoice Number | Invoice Reference |
ForeignRate | <Only on Forex> ExchangeRate |
Currency | <Only on Forex> Currency Code (Matched to Sage Currency record based on Currency Code) |
An invoice will post a ‘Split’ for each nominal code used in the invoice:
Service Geeni Field | Sage Field |
NominalCode | NominalCode |
TaxCode | TaxCode |
NetAmount | NetAmount |
TaxAmount | TaxAmount |
ForeignNetAmount | <Only on Forex> ForeignNetAmount |
ForeignTaxAmount | <Only on Forex> ForeignTaxAmount |
{Invoice Type} {Invoice Reference} | Details (Limited / truncated to 60 characters) |
Invoice Date | Date |
<Current Date Time> | PostedDate |
First name and Last name of user who created the invoice | UserName |
Department Code | DeptNumer |
Code References
see original document for numbering - is it correct??
5. or 1. Sproc:
[spGetOfflineTPLPurchaseNominals]
26. 0r . Processed by:
/Service Manager/WebUI/Controllers/API/PurchaseController.cs
7 or 3. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
8 or 4. Mapped to Sage by
/Services/AccountBridge/AccountsPackage.Sage.Line50/Handlers/PurchaseNominalPoster.cs
Journals
A separate Header and Split will be posted for each side of the Journal
Header:
Service Geeni Field | Sage Field |
Nominal Code | Bank Code |
<Current Date Time> | Date |
<Current Date Time> | Posted Date |
Transaction Number | Details |
Transaction Number | Invoice Ref |
Journal Value | Net Amount |
0 | Tax Amount |
Split:
Service Geeni Field | Sage Field |
Nominal Code | Nominal Code |
Journal Value | Net Amount |
0 | Tax Amount |
Transaction Number | Details |
<Current Date Time> | Date |
<Current Date Time> | Posted Date |
Department Code | DeptNumber |
Code References
1. Sproc
[spGetOfflineTPLJournalNominals]
2. Processed by
/Service Manager/WebUI/Controllers/API/StockController.cs
3. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
4. Mapped to Sage by
/Services/AccountBridge/AccountsPackage.Sage.Line50/Handlers/StockNominalPoster.cs
Sage 200
Customer Sync
Sage Field | Service Geeni Field |
Reference | Account Number |
Name | Account Name |
Address Line 1 | Address1 |
Address Line 2 | Address2 |
Address Line 3 | Address2 (Concatenated with Accounts package Address Line 2) |
Address Line 4 | County |
Postcode | Postcode |
City | <NOT USED> |
County | <NOT USED> |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
Currency Code (ISO Code) | Currency (Matching on country name, fall back to GBP if no match) |
VAT Code | VAT Code (based on TPLCode on VAT matching the VAT Code from Accounts) |
Main Telephone | Telephone |
Main Fax | Fax |
Payment Terms Days | Payment Terms Days Required |
Payment Terms Text | Payment Terms Text |
On Hold |
|
‘All Branches’ | Branch (only applied to new records) |
A site will also be created for any customers that don’t have a site Once a customer import has run, the address and telephone no are copied from the customer record.
Code References
1. Pulled from Sage:
/Services/AccountBridge/AccountsPackage.Sage.Line200/Handlers/CustomersProvider.cs
2. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
3. Saved to SG by:
/Service Manager/WebUI/Controllers/API/AccountsController.cs
4. Merged to SG by sproc
spSyncOfflineTPLCustomers
Supplier Sync
Sage Field | Service Geeni Field |
Reference | Account Number |
Name | Account Name |
Address Line 1 | Address1 |
Address Line 2 | Address2 |
Address Line 3 | <NOT USED> |
Address Line 4 | <NOT USED> |
Postcode | PostCode |
City | City |
County | County |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
Currency Code (ISO Code) | Currency (Matching on country name, fall back to GBP if no match) |
VAT Code | VAT Code (based on TPLCode on VAT matching the VAT Code from Accounts) |
Main Telephone | Telephone |
Main Fax | Fax |
Code References
1. Pulled from Sage
/Services/AccountBridge/AccountsPackage.Sage.Line200/Handlers/SuppliersProvider.cs
2. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
3. Saved to SG by:
/Service Manager/WebUI/Controllers/API/AccountsController.cs
4. Merged to SG by sproc
spSyncOfflineTPLSuppliers
Sales Ledger
Service Geeni Field | Sage Field |
Customer Account No | Customer |
Invoice Number | InstrumentNo |
Reference | SecondReferenceNo |
Transaction Date | InstrumentDate |
<Current Date Time> | PostedDate |
0 | DiscountPercent |
NetCurrencyValue | NetValue |
TotalCurrencyVat | TaxValue |
ExchangeRate | <Only on Forex> CurrencyRate |
An invoice will post a line for each nominal code used in the invoice:
Service Geeni Field | Sage Field |
NominalCode | GoodsValue |
taxValue | taxValue |
NetAmount | NetAmount |
TaxAmount | TaxAmount |
Nominal Code + Department Code + Cost Centre | NominalSpecification |
ItemDetail | Narrative |
VatTplCode | TaxCode (Matched on VAT TPL Code) |
Code References
1. Sproc
[spGetOfflineTPLSalesNominals]
2. Processed by
/Service Manager/WebUI/Controllers/API/SalesController.cs
3. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
4. Mapped to Sage by
/Services/AccountBridge/AccountsPackage.Sage.Line200/Handlers/SalesNominalPoster.cs
Purchase Ledger
Service Geeni Field | Sage Field |
Supplier Account No | Supplier |
Invoice Number | InstrumentNo |
Reference | SecondReferenceNo |
Transaction Date | InstrumentDate |
<Current Date Time> | PostedDate |
0 | DiscountPercent |
NetCurrencyValue | NetValue |
TotalCurrencyVat | TaxValue |
ExchangeRate | <Only on Forex> CurrencyRate |
An invoice will post a line for each nominal code used in the invoice:
Service Geeni Field | Sage Field |
NominalCode | GoodsValue |
TaxValue | TaxValue |
NetAmount | NetAmount |
TaxAmount | TaxAmount |
Nominal Code + Department Code + Cost Centre | NominalSpecification |
ItemDetail | Narrative |
VatTplCode | TaxCode (Matched on VAT TPL Code) |
Code References
1. Sproc
[spGetOfflineTPLPurchaseNominals]
2. Processed by
/Service Manager/WebUI/Controllers/API/PurchaseController.cs
3. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
4. Mapped to Sage by
/Services/AccountBridge/AccountsPackage.Sage.Line200/Handlers/PurchaseNominalPoster.cs
Journals
Service Geeni Field | Sage Field |
Transaction Number | InstrumentNo |
Details (Reference Description) | InstrumentItemNarrative |
TransactionDate | InstrumentDate |
<Current Date Time> | PostedDate |
A line will be posted for each side of the journal
Service Geeni Field | Sage Field |
FROM Nominal Code + Department Code + Cost Centre | NominalSpecification |
Details (Reference Description) | Narrative |
DebitAmount | Value |
Service Geeni Field | Sage Field |
TO Nominal Code + Department Code + Cost Centre | NominalSpecification |
Details (Reference Description) | Narrative |
CreditAmount | Value |
Code References
1. Sproc
[spGetOfflineTPLJournalNominals]
2. Processed by
/Service Manager/WebUI/Controllers/API/StockController.cs
3. Mapped to AccBridge by
/Services/AccountBridge/ServiceGeeni.AccountsBridge.BusinessLogic/Mapping/MappingConfig.cs
4. Mapped to Sage by
/Services/AccountBridge/AccountsPackage.Sage.Line200/Handlers/StockNominalPoster.cs
Xero v2
Customer Sync
Customer Account
Xero Field | Service Geeni Field |
AccountNumber / ContactID | Account Number |
Name | Account Name |
AttentionTo + AddressLine1 (POBOX) | Address1 |
AddressLine3 + AddressLine4 (POBOX) | Address2 |
PostalCode (POBOX) | Postcode |
City (POBOX) | City |
Region (POBOX) | County |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
Currency Code (ISO Code) | Currency (Matching on country name, fall back to GBP if no match) |
PhoneCountryCode + PhoneNumber (DEFAULT) | Telephone |
Main Fax | Fax |
PaymentTerms.Sales.Day | Payment Terms Days Required |
PaymentTerms.Sales.Type | Payment Terms Text |
Website | Website |
PhoneCountryCode + PhoneNumber (FAX) | Fax |
EmailAddress | EmailId |
customerContactName | ContactName |
‘All Branches’ | Branch (only applied to new records) |
Customer Site
Xero Field | Service Geeni Field |
AccountNumber / ContactID | CustomerAccountNumber |
AttentionTo + AddressLine1 (STREET) / AttentionTo + AddressLine1 (POBOX) / Name | CustomerSiteDescription |
AttentionTo + AddressLine1 (STREET) | Address1 |
AddressLine3 + AddressLine4 (STREET) | Address2 |
PostalCode (STREET) / PostalCode (POBOX) | Postcode |
City (STREET) / City (POBOX) | City |
Region (STREET) / Region (POBOX) | County |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
PhoneCountryCode + PhoneNumber (DEFAULT) | Telephone |
PhoneCountryCode + PhoneNumber (FAX) | Fax |
EmailAddress | EmailId |
Customer Site Contact
Xero Field | Service Geeni Field |
AccountNumber / ContactID | CustomerAccountNumber |
AttentionTo + AddressLine1 (STREET) / AttentionTo + AddressLine1 (POBOX) / Name | CustomerSiteID |
FirstName + LastName (For Each Contact Person) | ContactName |
EmailAddress | EmailID |
PhoneCountryCode + PhoneNumber (DEFAULT) | TelephoneNo |
PhoneCountryCode + PhoneNumber (MOBILE) | MobileNo |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
PhoneCountryCode + PhoneNumber (DEFAULT) | Fax |
Code References
1. Pulled from Xero
Services\AccountsAPIIntegrationService\AccountsAPIIntegrationService\AccountsAPIIntegrationService\XeroOA2\ XeroOA2SyncEngine.cs - ImportContacts
2. Mapped to OfflineTPL Tables by
GetOfflineTPLCustomerDetails
3. Saved to Offline TPL
SaveOfflineTPLData
4. Merged to SG by method
MergeContacts sproc spSyncOfflineTPLCustomers, spSyncOfflineTPLCustomerSiteContacts
Supplier Sync
Xero Field | Service Geeni Field |
AccountNumber / ContactID | Account Number |
Name | Account Name |
AttentionTo + AddressLine1 (POBOX) | Address1 |
AddressLine3 + AddressLine4 (POBOX) | Address2 |
PostalCode (POBOX) | PostCode |
City (POBOX) | City |
Region (POBOX) | County |
Country | Country (Matching on country name, fall back to United Kingdom if no match) |
Currency Code (ISO Code) | Currency (Matching on country name, fall back to GBP if no match) |
PhoneCountryCode + PhoneNumber (DEFAULT) | Telephone |
Code References
1. Pulled from Xero
Services\AccountsAPIIntegrationService\AccountsAPIIntegrationService\AccountsAPIIntegrationService\XeroOA2\ XeroOA2SyncEngine.cs - ImportSuppliers
2. Mapped to OfflineTPL Tables by
GetOfflineTPLSuppliers
3. Saved to Offline TPL
SaveOfflineTPLData
4. Merged to SG by method
MergeContacts sproc spSyncOfflineTPLSuppliers
Purchase Nominal Push
Purchase Invoice
Xero Field | Service Geeni Field |
Type | “ACCPAY” |
InvoiceNumber | SupplierInvoiceNumber |
Date | InvoiceDate |
Contact | XeroID of - supplierAccountRecordNo |
Status | “AUTHORISED” |
DueDate | DueDate – calculated based on InvoiceDate and payment terms |
LineItems | Refer Line Table |
Purchase Invoice Credit
Xero Field | Service Geeni Field |
Type | “ACCPAYCREDIT” |
InvoiceNumber | SupplierInvoiceNumber |
Date | InvoiceDate |
Contact | XeroID of - supplierAccountRecordNo |
Status | “AUTHORISED” |
DueDate | dueDate – calculated based on InvoiceDate and payment terms |
LineItems | Refer Line Table |
Line Items (Purchase Invoice / Purchase Invoice Credit)
Xero Field | Service Geeni Field |
Quantity | ReceivedQuantity |
UnitAmount | CostCurrency |
AccountCode | NominalCode |
Description | TransactionType + Description |
TaxType | TaxType From Xero for the VatCodeRecordNo Used in the Purchase Invoice / Credit Transaction |
TaxAmount | VatCurrency |