Skip to Content

Changes for page Checkin Data Import Tool

Last modified by David Muszynski on 2025/04/11 18:21
From version 3.2
edited by David Muszynski
on 2025/04/11 18:15
Change comment: There is no comment for this version
To version 4.2
edited by David Muszynski
on 2025/04/11 18:16
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -36,4 +36,12 @@
36 36  
37 37  **Products **- This is one of the more complicated ones. Sometimes the field mapping gets messed up on this. Still unsure what the best practices are for item ID. When doing a Invoice Line Item import, you NEED to import their Product ID into our _Item_ID. However, in general it is best to let CheckIn create our own Item IDs and then have their Product IDs (particularly if they have duplicates) import into the Old_Barcode field.
38 38  
39 -[[image:Screenshot%202024-11-15%20at%201.40.08%20PM.png]]
39 +[[image:Screenshot%202024-11-15%20at%201.40.08%20PM.png||height="668" width="1000"]]
40 +
41 +**Inventory Location - **Super simple and this happens after the Inventory one, its literally three fields and auto enter options can be left on. This one also needs the auto mapping fixed.
42 +
43 +[[image:Screenshot%202024-11-15%20at%203.12.00%20PM.png||height="667" width="1000"]]
44 +
45 +**Invoices/Invoices Line Items -** The Line Items transaction is used to generate Invoices. So, when importing Line Items you need to place it in the Invoices box on the import layout. This is a pretty complicated one and can vary depending on where the data came from.
46 +
47 +* **POSIM -** We have a POSIM reports template that Trish from Silk Road helped us generate. Using that report, we get the following data (which we're not using all of it)
Screenshot%202024-11-15%20at%203.12.00%20PM.png
Author
... ... @@ -1,0 +1,1 @@
1 +xwiki:XWiki.tknospdr
Size
... ... @@ -1,0 +1,1 @@
1 +556.2 KB
Content