|
Caption
|
Help
|
Picture
|
|
|
|
Clear all records from the tblSupplierInventory
table. WARNING: Only the records for the Supplier selected below are visible
in the list below BUT ALL RECORDS FOR ALL SUPPLIERS WILL BE CLEARED.
|
|
|
|
|
Click here to browse to your supplier product
tables. You must name them by their supplier code. EG 069.csv for Power
Sales. The file you select will be imported and displayed below.
|
|
|
|
|
This will display the location of the supplier
products import file being imported.
|
|
|
|
Top,
Next |
Pick a supplier (*=All) from Supplier table. Only
products from this supplier will be visible in the list below. There may be
multiple supplier products in tblSupplierInventory at the same time but only
the selected supplier's products will be visible.
|
|
|
|
|
Supplier
|
|
|
|
|
Select the 'Inventory' G/L Account to post into
the selected records below when 'GL accounts' is check and you click 'Do It'.
|
|
|
|
Sales:
|
Select the 'Sales' G/L Account to post into the
selected records below when 'GL accounts' is check and you click 'Do It'.
|
|
|
|
|
Select the 'Cost of Goods' G/L Account to post
into the selected records below when 'GL accounts' is check and you click 'Do It'.
|
|
|
|
Top,
Next |
Pick a field and fill in the data below. When you
click 'Do It' this value will be posted to all of the records you've selected
below.
|
|
|
|
|
Data to be posted into selected field for all records Picked. Use -1
for True, 0 for False.
|
 
|
|
|
|
Enter greater than 100 for markup. Enter less
than 100 for discounts. Select 'Price Calc' at the right and click 'Do it'.
All selected items will be updated.
|
|
|
Round to
|
If checked all newly calculated prices will be
rounded up or down to the nearest dollar and then reduced to the amount you
enter here.. If this is more than 25c below the
unrounded markup $1.00 is added.
|
|
|
|
Top,
Next,
Newest full screens
and details |
MarkUp % Calculator: Decide whether you want to
increase or decrease your price, click Up or Down and fill in your original
and new price. When you click 'Calc %' it will be filled in above.
'Enter the current / original price.
Enter the new price, the price you want to get to. The idea is that you can
calculate these prices manually, fill them in and the whole group will have
their prices changed accordingly.
Calculate and fill in the 'Markup %' field above based on the % Up/Down
variance between the above 'Orig Price' and 'New Price'. You can then use
this to recalculate prices for all of this group of
items.
|
|
|
|
|
Select an option,
perform any necessary setup (like selecting the appropriate inventory items).
Clicking Do It below will perform the action selected. EG. If you've selected
'Import/update to YIC', all items that have BOTH 'Pick' and 'Import' column
checkboxes checked will be updated / appended into your master WSA inventory.
|
|
|
|
|
Pull all YIC inventory for this (or All) Supplier
into this program for clean up and work.
|
|
|
|
|
Pick All or None. Use this with the 'filter by
selection' to limit the records and then select them. You can then modify
groups of items for Price, GL, or any field in the 'Field' list.
|
|
|
|
|
Switches 'Pick All' to 'Pick None' for easier
selecting / deselecting of items.
|
|
|
|
Top,
Next,
Newest full screens
and details
|
Deselect selected items and select unselected
items.
***********
|
|
|
|
|
De-selects the items picked below AFTER updating
them. This saves time and confusion when you're updating multiple groups of
items with data unique to that group. For example, to post Manufacturer you
would filter down to items with a specific Manufacturer, PICK only those
items and post the manufacturer AUTOMATICALLY UNPICKING THESE ITEMS. You'd
then proceed on to the next group, PICK only those and post the Mfg.
|
|
|
|
|
Set the 'Import into YIC' checkbox equal to the
'Pick' Checkbox as these 'Pick' items are what I want to import into YIC.
Only items with 'Import' checked will be posted to YIC when you check
'Export/Update to YIC'.
|
 
|
|
|
|
Calculate price as cost times percent markup
entered. If checked then round to value entered in 'Round to'. Post this to
either Price or nTemp based on 'Price to:' selection.
|
|
|
|
|
Calculate price as old price times percent markup
entered. If checked
then round to value entered in 'Round to'.
|
 
|
|
|
Top,
Next,
Newest full screens
and details
|
Post the value in the 'Price' or nTemp column to
'Retail' for import into YIC. With these three options you can calculate and
replace any of your price fields. For example, if your supplier has provided
you with Retail or Cost you can move Retail to Price, use 'Markup Price'
option to Mark it down by 20% (put 80 in 'Markup %') and round to .95.
|
 
|
|
|
|
Post the value in the 'Retail' or nTemp column to
Price for import into YIC.
|
 
|
|
|
|
Post the value in the 'Price' or nTemp column to
'Cost' for import into YIC.
If, for example, your YIC inventory is missing your supplier cost but you
know you set up your 'Sale Price' based on 20% markup, you can mark down
Price and move it to Cost. Using the Markup calculator you'd put your current
price of $11.99 ($10 cost marked up 20% and rounded to .99). You'd then put
your known supplier cost of $10 in New Price and, after checking UP click
Calc%. Your Markup % will displayed as 83.40284 which you can use to
calculate cost from sale price under these circumstances.
|
|
|
Price To
|
You can Move or Calculate into the NORMAL column or to the TEMP column. As
you select either Normal or Temp the labels for the price options change accordingly.
|
 
|
|
|
Top,
Next |
You would use the nTemp column to avoid loosing
your original value.
EG Calculate Sale Price into TEMP.
Mark it down using 83.4.
Then MOVE this value to your COST column.
|
 
|
|
|
|
Check each item and mark whether it is in the YIC
Inventory. When you import items from a supplier file many of them may
already be in your YIC inventory. If you import from YIC then all of them
will be in YIC.
|
|
|
|
|
Extract the 'Import Desc' from the records
selected below and post them into the Category Field of the same record.
|
|
|
|
|
Extract the first Path segment from the records
selected below and post them into the Category Field of the same record.
|
|
|
|
|
Extract the last Path segment from the records
selected below and post them into the Sub-Category Field of the same record.
|
|
|
|
|
Extract the 'Import Desc' from the records
selected below and post them into the Category Field of the same record.
|
|
|
|
|
Post the GL Accounts selected at the far left
into the records picked below.
|
 
|
|
|
Top,
Next,
Newest full screens
and details
|
Post data entered in the big box at left into the field
displayed in the 'Field' dropdown list above it into that field in all selected records below.
The 'Label' of the big box changes as you select the field from the Dropdown
list.
|
|
|
|
|
Verify that Description, Retail, GL, Path, Weight
aren't empty for items with the IMPORT checked below. Add new items to YIC
and Update changes made to existing items.
|
|
|
|
|
Disregard required *columns and export data to
YIC main inventory tables even though not all required columns contain data.
NOTE: You will be warned and allowed to over-ride.
|
|
|
|
|
Show a list of Inventory Items where the
Description/Name is identical on 2 or more products. Choose and populate
important fields for one and delete the others.
|
|
|
|
|
Open the 'Export For Upload To Yahoo' form.
|
|
|
|
|
How many items below have PICK checked. These are
the items to which your selected action will be applied when you click 'Do
it'.
|
|
|
|
Top,
Next |
How many items below have IMPORT checked. These
are the only items that will be imported into YIC when you select 'Export/Update
to YIC' and click 'Do It'.
|
|
|
|
|
Columns with Asterisks are REQUIRED. You can open the inventory form or the
'Path Builder' form by double clicking an item in those columns.
|
 
|
|
and clicking 
as a batch or one by one.
from the 
.
button (top left corner of ‘Supplier Inventory
screen).
.
:
.
