Payment Import allows user to import excel files provided by each Ecommerce platform.

Each Ecommerce platform will have different logics, which is identified by the developer, to determine which Document or function the imported records shall be diverted to.

Currently two logics are available:

  1. Payment files from Amazon that includes FBA and other account type
  2. Payment files which include a Sub-Order Id to be matched with shipment document.

Below is a diagram of how we delegate each logic within the Payment Import file to Business Central functions.


7Zpde6I4FMc/jZflAUIQL619md2Z2Xbrup1e7RMhCi0QNsSK/fSbQBAwWJ0ObunselHhJAT45X9OTk4dgEmUXVOU+F+Jh8OBqXvZAFwMTNNwDJN/CcumsAwhKAxLGniyU2WYBi9YGnVpXQUeThsdGSEhC5Km0SVxjF3WsCFKybrZbUHC5l0TtMSKYeqiULXeBx7zpdXW9arhEw6Wvrz1qGyIUNlZGlIfeWRdM4HLAZhQQlhxFGUTHAp4JZfiuqs9rdsHozhmx1wwu/zz/rex/piBT9/I7OHzzd3F5kyO8ozClXxh+bBsUxKgZBV7WAyiD8D52g8YnibIFa1rPufc5rMo5GcGP1wEYTghIaH5tcBD2Fm43J4ySp5wrcV2HTxf8Bb1NcpnwpThrGaSr3WNSYQZ3fAustU2NSgvkiqzJPN1bcp0w9DsYWH3azO2nUokpbLc3qCiyQ8k0O+AaypwLzM39w+OCSugD6Dl+klES5Qthatpc5QGruYRdxXl6BT2EDue1cbeMefAtrthDw1HA1YDvt0GX1fBGycDDxTwt2iTUzL1X6KEUKbALyCVLm6+jn4RkrXrI8q0lPG/fxl7HKMDvpYDNb0p7m1EqQO27VZxn46xpTCe8qCZCsLxMwlcVd99RZyHD736NGlD0AfacC/tCcVeIIT9FUfkwzAH+g502EPotgJ9glKfW+6wi4NEQP+VrGiMwg/DHQJlrewHa0dhfUM9TLnC7VAsbnPaAGz/vSL5mkdidpbmWeOYdzDMJMtBle38aCm/uxhm7D2uUiZWklSdcjmrixBnY5F58v449uThhRuilC/YTSU0cyucBeybONagPHuQ/cTxRVbrdrEpT2JOv3aROH2ot1WX5WeN624xDfj0YSqN9QzCwwu0ypmFaI7Dc+Q+LfPHrSUSV/wzmUh+Mnc3zNeUmnJ/cSWw360voyfv+vEl/XwLZqv7mRfMypyJ+8ESs8PLD/Ya6buq+5qoYUsOUtooDhELnptJf5vI5R1uSZBnE2U4c3TNgXAbzUDDw4C94zUFBTlGPWXfGdZ0hho0a1GymWiB4c64BTVl3Nwht0ze7qPlnqzmpH9QFKeL3E//d4d3dAf7v+AOBoSaY8N97gB3F6dTu8MRm+cf94J2ER6lqNc2pQcVBXqlqJZtkDV6o4wgUMey/mXpqKWBMkMRseOoHMXhOYqSoKj7XFvq5aoYuEyH9ug0ocTFaXq40DPfBsCbFQuDGEt7BznqtoT2SjFnaGmGo6rNPFV6OlLm6+p8XOx1+YuS/PGvMO4ozbzDCw62o8GmmD7n2/EOH7B4+e7Gm/pBkgTxsraf7WTcG+b3Jzf5QOkE7FXw/+nSidfmphZivpClUKFQ+DhCLyTmB/cBExWI3AF3VH0gYqM0Kf5BsggyoePzPXG5RVn7yzhWM1SbLbUEp0UYTgdxuhWiWvmtQRRRRq6OEWKuXwScdUF0upqf5SUHEdW9PsB1hj2D26uS74+hNav61nuVwVoRt9R5d0TL1XWsZn+KZW5nDXrbugfUdW+/wt9tmRs1l7lmSVwp9nzXMmfVlrnm8glPt/VpRawWenuiW3Fy4grQMVo+qFHzPTWa78P1SkxWU6TmW0U6NEbaaFSNazaGPeH2vBWxuts7oUaNmkIrvfZaoweLTMfGW/CeWrah+EHIvnirpFFHl5cc5RcRwNA124LWEFi2buhw2JGa+Wn1+6Gie/UrLHD5Dw==1VdNc5swEP01PiYDCBzn2Dhpm5lmkqkPSY8K2oAaQIwQBvfXVzKSQXzEjicZtydrn7SL9un5IWZomdbfOM7jO0YgmXkOqWfoeuZ5roMC+aOQTYP4yGmAiFOiF7XAiv4Bk6nRkhIorIWCsUTQ3AZDlmUQCgvDnLPKXvbCEvupOY5gAKxCnAzRR0pE3KCLwGnx70Cj2DzZdfRMis1iDRQxJqzqQOhmhpacMdGM0noJiSLP8NLkfZ2Y3W2MQyYOSfDoY7WuourmiYn5b4Ffr1B6pquscVLqhley9UJC95wAn3nzRBa/elajSI3O5NSqfD7T084t0d2JjaFMNpqrIWFhmW43d1XFVMAqx6HCK6kUicUiTWTkqvKszAiQH88G0LsCLqCebNfdkSjVBywFwTdyiU641LRr3bkLHVftKbrmaOLOCZp1WAsn2lVuuZUDTe87qPYGVD+wQig6Y5pveZoi8iWB+ovSsmQGMqKH12GCi4KGNpW8oVJGzna13PmTCs4DE/7qzl3XVrQxUU1FJ01G26zzxYWJ20QVdPMegFPJmFRHgzVtARn8z3onKVtnJQ9hv1oF5hGIN9ahcWV0jj4YOXmDcUiwoGt7u2Ny0E94YFQdnhGe69vKQ6inqKZNndX9w/YLBb1CQa9Qw8Og0Fadu7aPFyya9IZWsf+tPQxOyT+1P/hDf8CbhmXnNs0ZV4OfEDJOiklSc85CKIoDOMXha7Q1i/tSJDSDj6MWOYFFrXcxRm0wpHb+WdTOB9TeYRHG+7U66raF/N+J40zYD+ZdG3bPHTTfZ8Uq6nuq8WdZwLUM2ncvT2nQ6ECD9k9p0DudmSupc6RBI/e0Bn0xkPWSAxbwqRcJ6xrR3ir2XCRslb59ifhAPfoH6nFxSj3uPok2PVm9V4/+wi40MNRP1uNi8sJwm60ZDaeF+S+8toLejWD8tTUigyNeWzJsP/wa+tvPZ3TzFw==" onclick="(function(svg){var src=window.event.target||window.event.srcElement;while (src!=null&&src.nodeName.toLowerCase()!='a'){src=src.parentNode;}if(src==null){if(svg.wnd!=null&&!svg.wnd.closed){svg.wnd.focus();}else{var r=function(evt){if(evt.data=='ready'&&evt.source==svg.wnd){svg.wnd.postMessage(decodeURIComponent(svg.getAttribute('content')),'*');window.removeEventListener('message',r);}};window.addEventListener('message',r);svg.wnd=window.open('https://viewer.diagrams.net/?client=1&page=0&edit=_blank');}}})(this);" style="cursor:pointer;max-width:100%;max-height:602px;">
Excel file
Excel file
Payment Import
Payment Import
Sales Invoice
Sales Invoice
Sales Credit Memo
Sales Credit Memo
Cash Receipt Journal
Cash Receipt Journal
Orders

Adjustments
Orders...
Transfers
Transfers
Payment Import
Payment Import
FBA Inventory Fee
Refund
Service Fee
FBA Fee
Shipping Credit
Others
FBA Inven...
Logic: Amazon With FBA
Logic: Amazon...
Logic: Shipment matching with Sub-Order Id
Logic: Shipme...
Sales Invoice
Sales Invoice
Shipment matched with Sub-Order Id
Shipment...
Text is not SVG - cannot display
  • No labels