Versions Compared

Old Version 31

changes.mady.by.user P Sawkins (Unlicensed)

Saved on

compared with

New Version 32

changes.mady.by.user P Sawkins (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Table of Contents

...

Check some of the transactions you expect to make - sales orders, etc.

More than 7,000 rows (depending on the number of columns) may time out - so aim for about 3,500 at a time

How to import

To import Articles to the system - note you will need the Secure Feature "Is Stock Manager"

...

Note

Columns that do not match up with one of the import names will be ignored and the first line on the import result will be a list of the ignored columns

Useful Google Sheet calculations:

  1. Look for a material in the suppliers name (use named ranges) =INDEX(Materialresultlist,MATCH(TRUE,ISNUMBER(SEARCH(Materiallist,B2)),0))
    1. Note ensure the list of materials is sorted longest at the top - then "Shiny Red" will be found before "Red"
    2. Export from the item Profile for Material to find a list of possible values for that material
  2. If the supplier provides the name all in caps = Proper(a2)
    1. may need to adjust Ml to ml etc after

...