Is there a way to reverse or undo an incorrect lost sale entry with the ADP system?
Lost Sales and ADP
-
ferris
Lost Sales and ADP
Yes, but only if you are still in the month where that Lost Sale was recorded. You simply enter an equal negative value in the Lost Sale field of that part number. If it was entered last month though you are out of luck.
-
Chuck Hartle
Lost Sales and ADP
Let's say that you have a lost sales posting for 50 of part number 12345 from December. You are now in January and you want to fix that lost sale posting because it is trying to order 30 each time you run a stock order.
Go into Function Code DS or PS for manually posting sales. Use function "T" for the transaction;
Type 12345 -50 DEC
This will correct your history in December, but it will also increase your on hand quantity to 50 plus whatever you had before. Staying in the DS or PS program
Type 12345 0 C
This will now validate your on hand count to zero. Enter the actual onhand quantity after the part number above and a C to validate it to the correct quantity. I used zero as an example.
There is only one caution that you should be aware of when you make a posting like this. While it is necessary to correct it, it does put a minus adjustment for your month end MGR report for Appreciation in the Benchmark report. Thus, if you credit and adjust the history for part 12345 for 50 and the cost is $100.00 dealer net, your appreciation report will show a $-5,000 depreciation or minus value when this is done. As long as you know this and understand it, short of calling ADP to edit the history entry, this is the best way to fix the problem.
Chuck Hartle'
Go into Function Code DS or PS for manually posting sales. Use function "T" for the transaction;
Type 12345 -50 DEC
This will correct your history in December, but it will also increase your on hand quantity to 50 plus whatever you had before. Staying in the DS or PS program
Type 12345 0 C
This will now validate your on hand count to zero. Enter the actual onhand quantity after the part number above and a C to validate it to the correct quantity. I used zero as an example.
There is only one caution that you should be aware of when you make a posting like this. While it is necessary to correct it, it does put a minus adjustment for your month end MGR report for Appreciation in the Benchmark report. Thus, if you credit and adjust the history for part 12345 for 50 and the cost is $100.00 dealer net, your appreciation report will show a $-5,000 depreciation or minus value when this is done. As long as you know this and understand it, short of calling ADP to edit the history entry, this is the best way to fix the problem.
Chuck Hartle'
-
twfin
Lost Sales and ADP
You can do as stated above only instead of a 0 C transaction, tou could use an 'N' for no history
-
Rhyno
Lost Sales and ADP
Correction: ADP's 'T' function in PS/DS was for Total, not Transaction.
Seems like alot of steps to complete. Might be easier to review just your Lost Sales data prior to Month-End processing. Create a RPG that just looks at Lost Sales with quantities over "1". You can then use PDA to investigate who has the large fingers or at least which port they are using.
Seems like alot of steps to complete. Might be easier to review just your Lost Sales data prior to Month-End processing. Create a RPG that just looks at Lost Sales with quantities over "1". You can then use PDA to investigate who has the large fingers or at least which port they are using.
-
eweirick
Lost Sales and ADP
A couple of years ago we setup a lost sales report in RPG and activated a new job stack to run it daily (before the DAILY job stack). It was a real eye opener. Over of our lost sales were posting errors where we either had confirmed stock on hand or the part had been special ordered. After monitoring it for a few weeks we took the results to our counter sales staff and discussed the problem. We discovered two primary reasons for the mistakes;
a)leaving the terminal at the lost sale prompt
b)not paying attention to the lost prompt when modifying an invoice (when reducing the qty. sold, it defaults to LOST 1)
If youd like to try it set up a RPG report using the TRANS file, selecting on WITH TRAN EQ L and define your output fields. Then go into JOB function P and define SGR (it will ask you to identify the RPG reports you want to run). Next run JOB function SP for SGR and select opt 3, setup in an alternative stack. Name the stack and set it to run before the DAILY stack (DND clears the TRANS file).
------------------
Ed Weirick
a)leaving the terminal at the lost sale prompt
b)not paying attention to the lost prompt when modifying an invoice (when reducing the qty. sold, it defaults to LOST 1)
If youd like to try it set up a RPG report using the TRANS file, selecting on WITH TRAN EQ L and define your output fields. Then go into JOB function P and define SGR (it will ask you to identify the RPG reports you want to run). Next run JOB function SP for SGR and select opt 3, setup in an alternative stack. Name the stack and set it to run before the DAILY stack (DND clears the TRANS file).
------------------
Ed Weirick
-
Bob Ross
Lost Sales and ADP
Does anyone have a list of all of these ADP unpublished "little tricks" that that makes life so much easier?
-
eweirick
Lost Sales and ADP
Bob,
Get hold of your SA and have them give you a logon for ADPs Dealersuite.com. Once you have it, click on ADP Support Login on the left side of the screen. Once youve logged on there will be a series of dropdown menus on the left. Click on Support Menu. Here you will have access to Users Guides and the Solution Database. Users Guides contains the publications for all ADP products. The Solution Database is a searchable database that has the answers (fixes) for the most common questions and problems that their support people run into. You can search by keywords, applications, or function code. There is a wealth of information in this database.
Dealersuite.com also has some online training and up-to-date schedules for classroom and internet based training (most of the internet based training is free with classes running 1 to 2 hours long).
------------------
Ed Weirick
Get hold of your SA and have them give you a logon for ADPs Dealersuite.com. Once you have it, click on ADP Support Login on the left side of the screen. Once youve logged on there will be a series of dropdown menus on the left. Click on Support Menu. Here you will have access to Users Guides and the Solution Database. Users Guides contains the publications for all ADP products. The Solution Database is a searchable database that has the answers (fixes) for the most common questions and problems that their support people run into. You can search by keywords, applications, or function code. There is a wealth of information in this database.
Dealersuite.com also has some online training and up-to-date schedules for classroom and internet based training (most of the internet based training is free with classes running 1 to 2 hours long).
------------------
Ed Weirick