The logic for Shipment matching with Sub-Order Id will attempt to find Sub-Order Ids which are on the Sales Shipment documents (brought over from Sales Orders). If a match is found it will create a Sales Shipment Line with that Import Record.


7ZrdeqM2EIavxofhAYQwPkycn213t0njptkc9ZFBNiSAqBAxztVXAmHAwrE3ixuyrQ9iGAkBr74ZjSYegWmUX1GU+F+Jh8ORqXv5CJyPTNNwDJN/Ccu6tIwhKA1LGniyU22YBS9YGnVpzQIPp62OjJCQBUnb6JI4xi5r2RClZNXutiBh+64JWmLFMHNRqFrvA4/50mrret3wCQdLX956UjVEqOosDamPPLJqmMDFCEwpIaw8ivIpDgW8ikt53eWO1s2DURyzQy64u/jz/rdT/TEHn76Ru4fP17fn6xM5yjMKM/nC8mHZuiJASRZ7WAyij8DZyg8YniXIFa0rPufc5rMo5GcGP1wEYTglIaHFtcBD2Fm43J4ySp5wo8V2HTxf8Bb1NapnwpThvGGSr3WFSYQZXfMustU2NSgvkiqzJPNVY8p0w9DscWn3GzO2mUokpbLc3KCmyQ8k0O+AaypwL3K38A+OCSug96Dl+klES5Qvhatpc5QGruYRN4sKdAp7iB3P6mLvmHNg2/2wh4ajAasF3+6Cr6vgjaOBBwr4G7QuKJn6L1FCKFPgl5AqFzdfR78Iycr1EWVayvjfv4wdjtEDX8uBmt4W9yaiNAHbdqe4j8fYUhjPeNBMBeH4mQSuqu+hIi7Ch15/2rQhGAJtuJP2lGIvEML+iiPyYZgDfQs6HCB0W4E+RanPLbfYxUEioP9KMhqj8MNwh0BZK4fB2lFYX1MPU65wOxSL25y2ANt/Z6RY80jMTtIiazzlHQwzyQtQVTs/WsrvPoY59R6zlImVJFWnXM7qIsT5qcg8eX8ce/Lw3A1RyhfsthLauRXOA/ZNHGtQnj3IfuL4PG90O19XJzGn37hInD402+rLirPWdTeYBnz6MJXGZgbh4QXKCmYhmuPwDLlPy+JxG4nEJf9Mp5KfzN0N8zWlptxfXAnsd+vL5Mm7enxJP9+Au+z+zgvuqpyJ+8ESs/3LD/Za6buq+4aoYUcOUtkoDhELnttJf5fI5R1uSFBkE1U4c3TNgXATzUDLw4C95TUlBTlGM2XfGtZ0xho0G1GynWiB8da4JTVl3MIhN0ze7qPVnqzhpH9QFKeLwk//d4d3dAf7v+AOBoSaY8Nd7gC3F6dju8MBm+cf94JuER6kqNc2pXsVBQalqI5tkDV5o4wgUMey/mXpqKWBKkMRseOgHMXhOYqaoETohcTVWPzZyuGqJGiHOhNKXJym+8s7803Yu85YGMRY2nvITCeOpRnOrl1YR0Fn0qE281jp6USZr8uz03Kvy1+ZFC9yiXFPaeYtXnDEPQ02w/S52I73+IDly/c33swPkiSIl439bC/jXjN/OLnJB0on4KCC/0+XTrw2N40Q84UshQqFwqu4rt8HTFQgCgfcUvWe2I3SpPwHySLIhY7PdkToDmXtLuNUcbkqTXbUEpwOYTg9xOlOiGrltwFRRBlZBY4Qc/0y4KxKorNsflKUHERU94YA1xkPDO6gSr4/htas61vvVQbrRNxR590SLVfXoZr9KZa5rTXobeseUNe93Qp/t2Vu0l7m2iVxpdjzXcuc1Vjm2ssnPN7WpxOxWugdiG7FyZErQIdoea9GzffUaLEP12sxWW2Rmm8V6diYaJNJPa7ZGvaI2/NOxOpu74gaNRoKrfU6aI3uLTIdGm/Be2rZhuIHIbvirZJGHVxecpRfRABD12wLWmNg2bqhw3FPauan9e+Hyu71r7DAxT8=1VdNc5swEP01PiYDCBzn2Dhpm5lmkqkPSY8K2oAaQIwQBvfXVzKSQXzEjicZtydrn7SL9un5IWZomdbfOM7jO0YgmXkOqWfoeuZ5roMC+aOQTYP4yGmAiFOiF7XAiv4Bk6nRkhIorIWCsUTQ3AZDlmUQCgvDnLPKXvbCEvupOY5gAKxCnAzRR0pE3KCLwGnx70Cj2DzZdfRMis1iDRQxJqzqQOhmhpacMdGM0noJiSLP8NLkfZ2Y3W2MQyYOSfDoY7WuourmiYn5b4Ffr1B6pquscVLqhley9UJC95wAn3nzRBa/elajSI3O5NSqfD7T084t0d2JjaFMNpqrIWFhmW43d1XFVMAqx6HCK6kUicUiTWTkqvKszAiQH88G0LsCLqCebNfdkSjVBywFwTdyiU641LRr3bkLHVftKbrmaOLOCZp1WAsn2lVuuZUDTe87qPYGVD+wQig6Y5pveZoi8iWB+ovSsmQGMqKH12GCi4KGNpW8oVJGzna13PmTCs4DE/7qzl3XVrQxUU1FJ01G26zzxYWJ20QVdPMegFPJmFRHgzVtARn8z3onKVtnJQ9hv1oF5hGIN9ahcWV0jj4YOXmDcUiwoGt7u2Ny0E94YFQdnhGe69vKQ6inqKZNndX9w/YLBb1CQa9Qw8Og0Fadu7aPFyya9IZWsf+tPQxOyT+1P/hDf8CbhmXnNs0ZV4OfEDJOiklSc85CKIoDOMXha7Q1i/tSJDSDj6MWOYFFrXcxRm0wpHb+WdTOB9TeYRHG+7U66raF/N+J40zYD+ZdG3bPHTTfZ8Uq6nuq8WdZwLUM2ncvT2nQ6ECD9k9p0DudmSupc6RBI/e0Bn0xkPWSAxbwqRcJ6xrR3ir2XCRslb59ifhAPfoH6nFxSj3uPok2PVm9V4/+wi40MNRP1uNi8sJwm60ZDaeF+S+8toLejWD8tTUigyNeWzJsP/wa+tvPZ3TzFw==" style="background-color: rgb(255, 255, 255);">
Sales Order
- Sub-Order Id
Sales Order...
Post Shipment
Post Shipm...
Sales Shipment
- Sub-Order Id
Sales Shipment...
Payment Import Records
Payment Import R...
Match Sub-Order Id
Match Sub-...
Create
Create
Sales Invoice
Sales Invoice
Text is not SVG - cannot display


Step-by-step guide


There are a few sections in the Configuration page.
In the General Section, the "Platform Code" and "No." is shown. Also, when the "Auto Post" feature is turned on, Invoices created will be automatically posted.


In the Import Master Setup section, the following fields can be amended:

  • "Import to Customer": This field should be filled with the intended Customer No. that the import should be related to. When records are being imported, it will search for Sales Orders with this Customer to create the associated Invoice.
  • "Parsing Logic": Different logics are implemented by the module's creator. E.g. Some platforms include monetary payments in their payment import fields and is treated differently besides creating invoices (Transactions are created in the cash receipt journal in this case).
  • "First Row Id": The first row where the data begins.
  • "Location Code": Select the location to fulfill shipments that are ship by Amazon/ other parties.
  • "Posting Date": System will create 1 Sales Invoice foreach Posting Date. e.g. if a separate Sales invoice is to be created on the next day, change this field to that date.


Next, Column mappings are defined in the Configure Excel Columns section. These settings help to map the data within the file to the fields in payment import records.

  • No labels