I have been trying to get a report from ReportWriter to show my open items with their Price Level 1 "value".
I am now looking at Smart List to do this. I have gathered all the fields I need but I cannot get the dollar value for Price Level 1. Where is this located? It sems all the fields are availeable but this one.
What do you mean by 'Open Items'?
Leslie Vail, CPA, MVP, MCT, MCITP, MCP, MCITSASCI, Inc. * PO Box 600965 * Dallas, TX 75360 * 972-814-8550 * email@example.com
Discontinued items not included in the list.
Leslie - I previously sent you the report I was trying to create and never heard from you. I am now trying to get this info via Smart List
Try the 'Item Sales Prices' smartlist under Inventory.
You will need to restrict the smartlist to some value that is unique in your List Prices - Price Level or Currency, or maybe Units of Measure. Or export to XL and cut and dice it there.
However, you won't have access to the 'Discontinued' field on the Item Master table.
Eithre export two spreadsheets and use VLOOKUP in XL....or build your own smartlist using Smartlist Builder that links the Item Master table with the Item Price table (use Item Price as the main table).
Ian Stewart MVP - International support for Dynamics GP. Local knowledge, local timelines, local GP talent. Genesys Financial Systems (Europe) Microsoft Gold Certified Partner http://dynamicsgp.wordpress.com/
I have no Smart List Report called Item Sales Prices under Inventory.
Every time I try to use the Price List option in Smart List I get the Level Number, NOT the dollar value.
Export two spread sheets kind of defeats the purpose of Reports, no?
Smartlist Builder is a verrrry nice add-on but it is too expensive for us at theis time.
I quess I will have to continue with the inputting of the Level 1 selling price into the "Item Short Name" field. At least I can pull this field into the report correctly., plus it shows up on the Inventory Inquiry screen which is helpful. Just AT LOT OF WORK !!!!
Yes Mary - you're right!! There is no standard smartlist called 'Item Sales Prices' - its one I created myself using Smartlist Builder ..D'oh - Apologies for that - I should have checked before I posted.
Do you use SQL Server Reporting Services?
You could also modify a standard GP report? Click on Reports >> Inventroy >> Item >> Item Price List. If you don't find a filter to suit - you could insert a restriction in Report Writer. You could also edit the report format to make it XL friendly. On this report there is a tick box to exclude Discontinued Items.
Hope this helps.
I get big red X with message: Canot access this report because the dictionary containing it is not loaded. !!??
This is a standard report based on the standard Inventory module - so the cause of the error is most likely that the report was modified at some stage, rolled out to your user ID, and then the modified report was deleted. So when you try and print - its looking for he modified version, but cannot find it.
What you need to do as a first step is go to GP User Security and take rights away from this report for your user ID. (Tools >> Setup >> System ...and then its eithre 'Security' or 'Alternative Modified Forms and Reports' depending on what version of GP you are using). This will give you back access to the original version of the report.
Is this process something you are experienced with? If not, can you talk to someone internally about doing it? It really needs 'eyes on' to ensure the correct steps are taken.
Again, there is NO listing for Item Price List
Hi Mary - Maybe we are at odds. When I print the report I get the sales price for items based on what is entered in he Cards >> Inventory >> Item >> Price List window.
Are we talking about the same piece of data?
Could you post a screen shot of the window where the data you want on the report / smartlist is displayed?
Here is a link to the pics
My apologies. I have re-sent the package file I created in response to your original question. It's a modified version of the Item Price List. Please let me know if it is anything like what you need.
The report includes the following restrictions:
Qty Type (for the item qty mstr)
U of M
The following tables
---Item Qty Mstr
----Item Currency Mstr
-----Item Price List Options
------Item Price List
The additional headers are:
Item Generic Description
The report looks like this for Fabrikam for the RETAIL price level:
System: 12/16/2011 1:07:00 PM Fabrikam, Inc. Page: 1
User Date: 4/12/2017 ITEM PRICE LIST User ID: sa
Item Number Description Price Level Price U of M QTY on Hand
ANSW-ATT-1000 Attractive Answering System 1000 RETAIL $119.95 Each 2.00
ANSW-PAN-1450 Panache KX-T1450 answer RETAIL $109.95 Each (22.00)
ANSW-PAN-2460 Panache KX-T2460 answer RETAIL $149.95 Each 38.00
BA100G Base Assembly RETAIL $29.95 Each 10.00
A100 Audio System RETAIL $39.95 Each 10.00
BELL100 Phone Bellisimo RETAIL $9.95 Each 10.00
COMPBOOK Computers Explained RETAIL $7.50 Each 10.00
PHON-BUS-1244 Handset, 4-line Desk RETAIL $259.95 Each 26.00
PHON-BUS-1250 Handset,multi-line RETAIL $359.95 Each 267.00